- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Sybase 11.9.2 and HPUX 11.0
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
тАО02-11-2002 08:45 AM
тАО02-11-2002 08:45 AM
Sybase 11.9.2 and HPUX 11.0
I am running Oracle 8.1.6 on an NClass, 3 360 MHz processors, 1GB RAM, 1.6 GB swap, HPUX 11.0. This is a much larger db that is running fine. I am including the differences between the kernel parms.
The parms are currently L1000 NClass
db_max_pct 50 20
ksi_alloc_max 2208 32928
max_thread_proc 256 64
maxfiles 60 2040
maxfiles_lim 1024 2047
maxswapchunks 512 832
maxuprc 75 150
maxusers 32 512
ncallout 2064 4132
nclist 612 8292
ncsize 1500 5820
nfile 910 7822
ninode 476 4796
nkthread 2048 7219
nproc 276 4116
semmap 66 72
semmni 64 70
semmns 128 640
shmmax 1000000000 1073741824
Should I change them to more closely match? I did get a file table full message in syslog. If I reboot the machine, preformance is better for a time, but degrades. Are there patches that I need? I would greatly appreciate any guidance. I have contacted the vendor and searched the Sybase and ITRC sites and have not found any concrete suggestions.
Thank you,
Robb Bailey
- Tags:
- Sybase
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-11-2002 09:16 AM
тАО02-11-2002 09:16 AM
Re: Sybase 11.9.2 and HPUX 11.0
The other parameters like nfiles,nproc,maxuprc and maxfiles needs to be change in the higher side. Look at sar -A or simply sar -v and accordingly change your parameters.
Sandip
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-11-2002 09:24 AM
тАО02-11-2002 09:24 AM
Re: Sybase 11.9.2 and HPUX 11.0
HTH
mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-11-2002 12:29 PM
тАО02-11-2002 12:29 PM
Re: Sybase 11.9.2 and HPUX 11.0
Good luck.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-13-2002 04:33 AM
тАО02-13-2002 04:33 AM
Re: Sybase 11.9.2 and HPUX 11.0
If your server is only a database server and Sybase is running on rawdisks you should be able to reduce the buffercache (db_max_pct) to 3-5%. The memory is better used by Sybase.
Also, if you have 99% utilization of the memory you might experience swapping from time to time? Do a 'ps -ef' and look for exessive runtime for the process vhand. Another point of directions could also be the "Global Waits" and the "System Table" view in Glance.
Regards
Johan Bergwitz