- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- How to tune the kernel Configurable Parameters for...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2005 01:08 AM
тАО01-20-2005 01:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2005 01:19 AM
тАО01-20-2005 01:19 AM
Re: How to tune the kernel Configurable Parameters for sybase 11?
You usually get this information from SYBASE, as we do for ALL other products (Oracle, Informix, BEA, ...).
Then once armed with that info, you can use "sam"->Kernel Configuration->configure kernel
live free or die
harry d brown jr
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2005 01:21 AM
тАО01-20-2005 01:21 AM
Re: How to tune the kernel Configurable Parameters for sybase 11?
You should have from 300-400 Mb buffer cache:
dbc_max_pct = 5
dbc_min_pct = 3
More things you can check with "sar -v 5 1000" (see if one of the following parameters overflows):
ninode = 2048 (2048 it's a good start)
nproc = 400 (an idea -> depends of db and apps)
nfile = (15*nproc+2048)
Kindest Regards,
Eric Antunes
swchunk = 4096
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2005 01:24 AM
тАО01-20-2005 01:24 AM
Re: How to tune the kernel Configurable Parameters for sybase 11?
2) Get the minimum kernel parameters for Sybase.
Use this methodology to set parameters and put a new kernel into production.
You can also use sam.
kmtune -s parameter=####
# use a real parameter and a real number based on your current kmtune output and the documentation on sybase.
#cd /stand
#cp vmunix vmunix.old
#cp system system.old
#cd build
#this is the changed line.
#/usr/lbin/sysadm/system_prep -s system
Edit system file and make changes here as per ur require ment. Imeand addition/Deletion of devices. Then
#mk_kernel -s system
For more information see the man page of mk_kernel
Now one new kernel will be created in /stand/build directory. Copy this to original location
#cd /stand/build
#cp vmunix_test /stand/vmunix
#cp system /stand
Sorry I can't help you with the Sybase doc, I'm assuming you can find that yourself.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2005 01:29 AM
тАО01-20-2005 01:29 AM
Solutionhttp://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=204085
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=77268
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-22-2005 11:55 PM
тАО01-22-2005 11:55 PM
Re: How to tune the kernel Configurable Parameters for sybase 11?
sybase@mercury2 [/opt/sybase/install]
> isql -Usa
/usr/lib/dld.sl: Call to mmap() failed - TEXT /usr/lib/libcl.1
/usr/lib/dld.sl: Not enough space
Abort(coredump)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2005 08:40 PM
тАО01-23-2005 08:40 PM
Re: How to tune the kernel Configurable Parameters for sybase 11?
I think you'll have to tune all the kernel.
Here are my tuned parameters (non default):
STRMSGSZ 65535
dbc_max_pct 15
dbc_min_pct 10
max_async_ports 206
max_thread_proc 256
maxdsiz 536870912
maxfiles 1024
maxssiz 134217728
maxssiz_64bit 1073741824
maxswapchunks 16384
maxtsiz 134217728
maxuprc (NPROC*9/10)
maxusers 150
msgmap (2+MSGMNI)
msgmni (NPROC)
msgseg 32767
msgtql (NPROC)
nfile (15*NPROC+2048)
nflocks 4096
ninode 2048
nproc 400
nstrpty 60
num_tachyon_adapters 5
semmni 4096
semmns (SEMMNI*2)
semmnu (NPROC-4)
shmmax 1073741824 (Max Shared Mem Segment (Bytes): this is a memory dependent parameter so, since you have 5 times the memory I've, you can multiply this value by 5: 5368709120
shmmni 512
swchunk 4096
vps_ceiling 64
See if you have big differences at those parameters values and try to approach to my values.
Finally, since you are on 11i v1 (I'm on 11.0) you may have to tune other new parameters (not present on 11.0)
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2005 10:30 PM
тАО01-23-2005 10:30 PM
Re: How to tune the kernel Configurable Parameters for sybase 11?
Then solved the problem.
Are there any disadvantages for sybase performance when it is running on quadrant 2?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2005 10:56 PM
тАО01-23-2005 10:56 PM
Re: How to tune the kernel Configurable Parameters for sybase 11?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-23-2005 11:34 PM
тАО01-23-2005 11:34 PM