General
cancel
Showing results for 
Search instead for 
Did you mean: 

How to tune the kernel Configurable Parameters for sybase 11?

SOLVED
Go to solution
MA Qiang
Regular Advisor

How to tune the kernel Configurable Parameters for sybase 11?

OS: HP 11iv1
Memory: 8GB
CPU: 4

Thanks!
23 REPLIES
harry d brown jr
Honored Contributor

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
Live Free or Die
Eric Antunes
Honored Contributor

Re: How to tune the kernel Configurable Parameters for sybase 11?

Hi Qiang,

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
Each and every day is a good day to learn.
Steven E. Protter
Exalted Contributor

Re: How to tune the kernel Configurable Parameters for sybase 11?

1) Go to the documentation for sybase.
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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Eric Antunes
Honored Contributor
Solution

Re: How to tune the kernel Configurable Parameters for sybase 11?

MA Qiang
Regular Advisor

Re: How to tune the kernel Configurable Parameters for sybase 11?

I got the following error when I issued the isql.
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)
Eric Antunes
Honored Contributor

Re: How to tune the kernel Configurable Parameters for sybase 11?

Hi,

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
Each and every day is a good day to learn.
MA Qiang
Regular Advisor

Re: How to tune the kernel Configurable Parameters for sybase 11?

I issued "chatr -M /opt/sybase/bin/dataserver", and let sybase fit on quadrant 2 of shared memory.
Then solved the problem.
Are there any disadvantages for sybase performance when it is running on quadrant 2?
Eric Antunes
Honored Contributor

Re: How to tune the kernel Configurable Parameters for sybase 11?

I don't know the answer to this question. What is quadrant 2 of shared memory??
Each and every day is a good day to learn.
MA Qiang
Regular Advisor

Re: How to tune the kernel Configurable Parameters for sybase 11?

My sybase is 32-bit version. Use chatr -M can fit the 32-bit application on Q2 of shared memory. You can man the chatr for SHMEM-MAGIC.
MA Qiang
Regular Advisor

Re: How to tune the kernel Configurable Parameters for sybase 11?

The clients complain that they retrieve data from SYBASE very slowly. What can I do to find the key to solve the problem?

Thanks.
T G Manikandan
Honored Contributor

Re: How to tune the kernel Configurable Parameters for sybase 11?

First check

1.your memory and CPU usage on the server

2.The i/o for the operations on the server.

If these things are fine then you can move down to the sybase level

then check

The amount of pool size available for the operations,temporary segment sizes,etc


This is where you can start with...
revert back on the findings so that we can find the cause for the performance problems..
MA Qiang
Regular Advisor

Re: How to tune the kernel Configurable Parameters for sybase 11?

I find the io, memery and CPU usage are normal. More infomation shoud I offer, what and how to get?
Thank you!

CPU USAGE(by top): SYS avg < 25%
MEMERY USAGE(by kmeminfo, shminfo and ipcs):
# kmeminfo
Kernel TEXT pages not requested in crashconf
Will use an artificial mapping from a.out TEXT pages
kmeminfo (3.99)
unix: /stand/vmunix 11.11 64bit PA2.0
core: /dev/kmem live
link: Mon Jan 24 11:11:33 GMT 2005
boot: Tue Mar 29 03:33:42 2005
dump: Tue Apr 26 08:15:10 2005

Note: resyncing "freemem" with freemem caches: was 645666, now 645481

----------------------------------------------------------------------
Pfdat processing:

Scanning 2042393 pfdat entries (be patient) ...


----------------------------------------------------------------------
Physical memory usage summary (in page/byte/percent):

Physmem = 2095104 8.0g 100% Physical memory
Freemem = 645481 2.5g 31% Free physical memory
Used = 1449623 5.5g 69% Used physical memory
System = 925516 3.5g 44% By kernel:
text = 2672 10.4m 0% text
data = 514 2.0m 0% data
bss = 1849 7.2m 0% bss
Static = 100740 393.5m 5% for text/static data
Dynamic = 296808 1.1g 14% for dynamic data
Bufcache = 523776 2.0g 25% for buffer cache
Eqmem = 46 184.0k 0% for equiv. mapped memory
SCmem = 4146 16.2m 0% for critical memory
User = 528324 2.0g 25% By user processes:
Uarea = 6264 24.5m 0% for thread uareas
Disowned = 8 32.0k 0% Disowned pages

----------------------------------------------------------------------
Kernel dynamic memory usage (in page/byte/percent):

Dynamic = 296808 1.1g 14% Kernel dynamic memory
Arenas = 223871 874.5m 11% Kernel arenas
M_TEMP = 160960 628.8m 8%
ALLOCB_MBLK_LM = 24402 95.3m 1%
M_SPINLOCK = 17050 66.6m 1%
M_SWAP = 4208 16.4m 0%
M_IOSYS = 2508 9.8m 0%
M_KTHREAD = 1654 6.5m 0%
LVM_PBUF = 1585 6.2m 0%
VFD_BT_NODE = 1526 6.0m 0%
M_LVM = 1468 5.7m 0%
M_VXVM = 1367 5.3m 0%
M_REG = 1155 4.5m 0%
M_PREG = 1065 4.2m 0%
M_DYNAMIC = 719 2.8m 0%
KMEM_ALLOC = 537 2.1m 0%
VM MISC ARENA = 516 2.0m 0%
Other = 3151 12.3m 0% Other arenas...
Kalloc = 72887 284.7m 3% kalloc()
SuperPagePool = 21312 83.2m 1% Kernel superpage cache
BufcacheBufs = 45728 178.6m 2% Buffer cache bufs
BufcacheHash = 5120 20.0m 0% Buffer cache hash heads
Other = 727 2.8m 0% Other...
Eqalloc = 50 200.0k 0% eqalloc()


# shminfo
libp4 (9.41): Opening /stand/vmunix /dev/kmem

Loading symbols from /stand/vmunix
Kernel TEXT pages not requested in crashconf
Will use an artificial mapping from a.out TEXT pages
shminfo (3.13)

Global 32-bit shared quadrants:
===============================
Space Start End Kbytes Usage
Q4 0x0fc8dc00.0xc0000000-0xc0006fff 28 OTHER
Q4 0x0fc8dc00.0xc0007000-0xc0007fff 4 SHMEM id=0
Q4 0x0fc8dc00.0xc0008000-0xc0078fff 452 OTHER
Q4 0x0fc8dc00.0xc0079000-0xc007afff 8 SHMEM id=2
Q4 0x0fc8dc00.0xc007b000-0xc0246fff 1840 OTHER
Q4 0x0fc8dc00.0xc0247000-0xc0247fff 4 SHMEM id=19971
Q4 0x0fc8dc00.0xc0248000-0xc030cfff 788 OTHER
Q4 0x0fc8dc00.0xc030d000-0xc031cfff 64 SHMEM id=1 locked
Q4 0x0fc8dc00.0xc031d000-0xc039afff 504 OTHER
Q4 0x0fc8dc00.0xc039b000-0xc039bfff 4 FREE
Q4 0x0fc8dc00.0xc039c000-0xc03eafff 316 OTHER
Q4 0x0fc8dc00.0xc03eb000-0xc03ebfff 4 FREE
Q4 0x0fc8dc00.0xc03ec000-0xc03fefff 76 OTHER
Q4 0x0fc8dc00.0xc03ff000-0xc03fffff 4 FREE
Q4 0x0fc8dc00.0xc0400000-0xc05aafff 1708 OTHER
Q4 0x0fc8dc00.0xc05ab000-0xc05abfff 4 FREE
Q4 0x0fc8dc00.0xc05ac000-0xc05edfff 264 OTHER
Q4 0x0fc8dc00.0xc05ee000-0xc05effff 8 FREE
Q4 0x0fc8dc00.0xc05f0000-0xc06bdfff 824 OTHER
Q4 0x0fc8dc00.0xc06be000-0xc06bffff 8 FREE
Q4 0x0fc8dc00.0xc06c0000-0xc06d5fff 88 OTHER
Q4 0x0fc8dc00.0xc06d6000-0xc06d7fff 8 FREE
Q4 0x0fc8dc00.0xc06d8000-0xc06ddfff 24 OTHER
Q4 0x0fc8dc00.0xc06de000-0xc06dffff 8 FREE
Q4 0x0fc8dc00.0xc06e0000-0xc0865fff 1560 OTHER
Q4 0x0fc8dc00.0xc0866000-0xc0867fff 8 FREE
Q4 0x0fc8dc00.0xc0868000-0xc0876fff 60 OTHER
Q4 0x0fc8dc00.0xc0877000-0xc0877fff 4 FREE
Q4 0x0fc8dc00.0xc0878000-0xc087dfff 24 OTHER
Q4 0x0fc8dc00.0xc087e000-0xc087ffff 8 FREE
Q4 0x0fc8dc00.0xc0880000-0xc08cefff 316 OTHER
Q4 0x0fc8dc00.0xc08cf000-0xc08cffff 4 FREE
Q4 0x0fc8dc00.0xc08d0000-0xc08f8fff 164 OTHER
Q4 0x0fc8dc00.0xc08f9000-0xc08fffff 28 FREE
Q4 0x0fc8dc00.0xc0900000-0xc0ce5fff 3992 OTHER
Q4 0x0fc8dc00.0xc0ce6000-0xc0ce7fff 8 FREE
Q4 0x0fc8dc00.0xc0ce8000-0xc0cfefff 92 OTHER
Q4 0x0fc8dc00.0xc0cff000-0xc0cfffff 4 FREE
Q4 0x0fc8dc00.0xc0d00000-0xc0d6cfff 436 OTHER
Q4 0x0fc8dc00.0xc0d6d000-0xc0d6ffff 12 FREE
Q4 0x0fc8dc00.0xc0d70000-0xc0d8cfff 116 OTHER
Q4 0x0fc8dc00.0xc0d8d000-0xc0d8ffff 12 FREE
Q4 0x0fc8dc00.0xc0d90000-0xc0dcefff 252 OTHER
Q4 0x0fc8dc00.0xc0dcf000-0xc0dcffff 4 FREE
Q4 0x0fc8dc00.0xc0dd0000-0xc0de5fff 88 OTHER
Q4 0x0fc8dc00.0xc0de6000-0xc0deffff 40 FREE
Q4 0x0fc8dc00.0xc0df0000-0xc1132fff 3340 OTHER
Q4 0x0fc8dc00.0xc1133000-0xc1133fff 4 FREE
Q4 0x0fc8dc00.0xc1134000-0xc113cfff 36 OTHER
Q4 0x0fc8dc00.0xc113d000-0xc113ffff 12 FREE
Q4 0x0fc8dc00.0xc1140000-0xc1180fff 260 OTHER
Q4 0x0fc8dc00.0xc1181000-0xc1183fff 12 FREE
Q4 0x0fc8dc00.0xc1184000-0xc118dfff 40 OTHER
Q4 0x0fc8dc00.0xc118e000-0xc118ffff 8 FREE
Q4 0x0fc8dc00.0xc1190000-0xc11c7fff 224 OTHER
Q4 0x0fc8dc00.0xc11c8000-0xc11cffff 32 FREE
Q4 0x0fc8dc00.0xc11d0000-0xc11fbfff 176 OTHER
Q4 0x0fc8dc00.0xc11fc000-0xc11fffff 16 FREE
Q4 0x0fc8dc00.0xc1200000-0xc1304fff 1044 OTHER
Q4 0x0fc8dc00.0xc1305000-0xc130ffff 44 FREE
Q4 0x0fc8dc00.0xc1310000-0xc1339fff 168 OTHER
Q4 0x0fc8dc00.0xc133a000-0xc133ffff 24 FREE
Q4 0x0fc8dc00.0xc1340000-0xc1386fff 284 OTHER
Q4 0x0fc8dc00.0xc1387000-0xc138ffff 36 FREE
Q4 0x0fc8dc00.0xc1390000-0xc13befff 188 OTHER
Q4 0x0fc8dc00.0xc13bf000-0xc13bffff 4 FREE
Q4 0x0fc8dc00.0xc13c0000-0xc1408fff 292 OTHER
Q4 0x0fc8dc00.0xc1409000-0xc140ffff 28 FREE
Q4 0x0fc8dc00.0xc1410000-0xc1439fff 168 OTHER
Q4 0x0fc8dc00.0xc143a000-0xc143ffff 24 FREE
Q4 0x0fc8dc00.0xc1440000-0xc14d2fff 588 OTHER
Q4 0x0fc8dc00.0xc14d3000-0xc14d3fff 4 FREE
Q4 0x0fc8dc00.0xc14d4000-0xc14fcfff 164 OTHER
Q4 0x0fc8dc00.0xc14fd000-0xc14fffff 12 FREE
Q4 0x0fc8dc00.0xc1500000-0xc154bfff 304 OTHER
Q4 0x0fc8dc00.0xc154c000-0xc154ffff 16 FREE
Q4 0x0fc8dc00.0xc1550000-0xc157cfff 180 OTHER
Q4 0x0fc8dc00.0xc157d000-0xc157ffff 12 FREE
Q4 0x0fc8dc00.0xc1580000-0xc161cfff 628 OTHER
Q4 0x0fc8dc00.0xc161d000-0xc161ffff 12 FREE
Q4 0x0fc8dc00.0xc1620000-0xc1651fff 200 OTHER
Q4 0x0fc8dc00.0xc1652000-0xc1653fff 8 FREE
Q4 0x0fc8dc00.0xc1654000-0xc165dfff 40 OTHER
Q4 0x0fc8dc00.0xc165e000-0xc165ffff 8 FREE
Q4 0x0fc8dc00.0xc1660000-0xc1696fff 220 OTHER
Q4 0x0fc8dc00.0xc1697000-0xc169ffff 36 FREE
Q4 0x0fc8dc00.0xc16a0000-0xc16dbfff 240 OTHER
Q4 0x0fc8dc00.0xc16dc000-0xc16dffff 16 FREE
Q4 0x0fc8dc00.0xc16e0000-0xc16f2fff 76 OTHER
Q4 0x0fc8dc00.0xc16f3000-0xc16f3fff 4 FREE
Q4 0x0fc8dc00.0xc16f4000-0xc16fdfff 40 OTHER
Q4 0x0fc8dc00.0xc16fe000-0xc16fffff 8 FREE
Q4 0x0fc8dc00.0xc1700000-0xc1af5fff 4056 OTHER
Q4 0x0fc8dc00.0xc1af6000-0xc1afffff 40 FREE
Q4 0x0fc8dc00.0xc1b00000-0xc1b7efff 508 OTHER
Q4 0x0fc8dc00.0xc1b7f000-0xc1b7ffff 4 FREE
Q4 0x0fc8dc00.0xc1b80000-0xc1c09fff 552 OTHER
Q4 0x0fc8dc00.0xc1c0a000-0xc1c0ffff 24 FREE
Q4 0x0fc8dc00.0xc1c10000-0xc1d88fff 1508 OTHER
Q4 0x0fc8dc00.0xc1d89000-0xc1d8bfff 12 FREE
Q4 0x0fc8dc00.0xc1d8c000-0xc1deefff 396 OTHER
Q4 0x0fc8dc00.0xc1def000-0xc1deffff 4 FREE
Q4 0x0fc8dc00.0xc1df0000-0xc21e5fff 4056 OTHER
Q4 0x0fc8dc00.0xc21e6000-0xc21e7fff 8 FREE
Q4 0x0fc8dc00.0xc21e8000-0xc21f6fff 60 OTHER
Q4 0x0fc8dc00.0xc21f7000-0xc21fffff 36 FREE
Q4 0x0fc8dc00.0xc2200000-0xc2273fff 464 OTHER
Q4 0x0fc8dc00.0xc2274000-0xc228ffff 112 FREE
Q4 0x0fc8dc00.0xc2290000-0xc22b5fff 152 OTHER
Q4 0x0fc8dc00.0xc22b6000-0xc22bffff 40 FREE
Q4 0x0fc8dc00.0xc22c0000-0xc22d5fff 88 OTHER
Q4 0x0fc8dc00.0xc22d6000-0xc22f2fff 116 FREE
Q4 0x0fc8dc00.0xc22f3000-0xc22fffff 52 SHMEM id=6
Q4 0x0fc8dc00.0xc2300000-0xc235cfff 372 OTHER
Q4 0x0fc8dc00.0xc235d000-0xc23bffff 396 FREE
Q4 0x0fc8dc00.0xc23c0000-0xc23defff 124 OTHER
Q4 0x0fc8dc00.0xc23df000-0xc23dffff 4 FREE
Q4 0x0fc8dc00.0xc23e0000-0xc4ef6fff 44124 OTHER
Q4 0x0fc8dc00.0xc4ef7000-0xc4efffff 36 FREE
Q4 0x0fc8dc00.0xc4f00000-0xc4ff1fff 968 OTHER
Q4 0x0fc8dc00.0xc4ff2000-0xc4ffffff 56 FREE
Q4 0x0fc8dc00.0xc5000000-0xc5040fff 260 OTHER
Q4 0x0fc8dc00.0xc5041000-0xc504ffff 60 SHMEM id=7
Q4 0x0fc8dc00.0xc5050000-0xc506ffff 128 FREE
Q4 0x0fc8dc00.0xc5070000-0xc50a2fff 204 OTHER
Q4 0x0fc8dc00.0xc50a3000-0xc50affff 52 FREE
Q4 0x0fc8dc00.0xc50b0000-0xc50cafff 108 OTHER
Q4 0x0fc8dc00.0xc50cb000-0xc50cffff 20 FREE
Q4 0x0fc8dc00.0xc50d0000-0xc50e5fff 88 OTHER
Q4 0x0fc8dc00.0xc50e6000-0xc50effff 40 FREE
Q4 0x0fc8dc00.0xc50f0000-0xc5275fff 1560 OTHER
Q4 0x0fc8dc00.0xc5276000-0xc527ffff 40 FREE
Q4 0x0fc8dc00.0xc5280000-0xc531cfff 628 OTHER
Q4 0x0fc8dc00.0xc531d000-0xc531ffff 12 FREE
Q4 0x0fc8dc00.0xc5320000-0xc5330fff 68 OTHER
Q4 0x0fc8dc00.0xc5331000-0xc533ffff 60 FREE
Q4 0x0fc8dc00.0xc5340000-0xc5383fff 272 OTHER
Q4 0x0fc8dc00.0xc5384000-0xc538ffff 48 FREE
Q4 0x0fc8dc00.0xc5390000-0xc53b7fff 160 OTHER
Q4 0x0fc8dc00.0xc53b8000-0xc53bffff 32 FREE
Q4 0x0fc8dc00.0xc53c0000-0xc53e1fff 136 OTHER
Q4 0x0fc8dc00.0xc53e2000-0xc53e3fff 8 FREE
Q4 0x0fc8dc00.0xc53e4000-0xc53f1fff 56 OTHER
Q4 0x0fc8dc00.0xc53f2000-0xc53fffff 56 FREE
Q4 0x0fc8dc00.0xc5400000-0xc5803fff 4112 OTHER
Q4 0x0fc8dc00.0xc5804000-0xc580ffff 48 FREE
Q4 0x0fc8dc00.0xc5810000-0xc5839fff 168 OTHER
Q4 0x0fc8dc00.0xc583a000-0xc583ffff 24 FREE
Q4 0x0fc8dc00.0xc5840000-0xc58d6fff 604 OTHER
Q4 0x0fc8dc00.0xc58d7000-0xc58fffff 164 FREE
Q4 0x0fc8dc00.0xc5900000-0xc5a26fff 1180 OTHER
Q4 0x0fc8dc00.0xc5a27000-0xc5a3ffff 100 FREE
Q4 0x0fc8dc00.0xc5a40000-0xc5a8afff 300 OTHER
Q4 0x0fc8dc00.0xc5a8b000-0xc5a8ffff 20 FREE
Q4 0x0fc8dc00.0xc5a90000-0xc5ac5fff 216 OTHER
Q4 0x0fc8dc00.0xc5ac6000-0xc5afffff 232 FREE
Q4 0x0fc8dc00.0xc5b00000-0xc5d34fff 2260 OTHER
Q4 0x0fc8dc00.0xc5d35000-0xc5d3ffff 44 FREE
Q4 0x0fc8dc00.0xc5d40000-0xc5d91fff 328 OTHER
Q4 0x0fc8dc00.0xc5d92000-0xc5dbffff 184 FREE
Q4 0x0fc8dc00.0xc5dc0000-0xc5e00fff 260 OTHER
Q4 0x0fc8dc00.0xc5e01000-0xc5e3ffff 252 FREE
Q4 0x0fc8dc00.0xc5e40000-0xc5ef4fff 724 OTHER
Q4 0x0fc8dc00.0xc5ef5000-0xc5efffff 44 FREE
Q4 0x0fc8dc00.0xc5f00000-0xc60a4fff 1684 OTHER
Q4 0x0fc8dc00.0xc60a5000-0xc60fffff 364 FREE
Q4 0x0fc8dc00.0xc6100000-0xc6212fff 1100 OTHER
Q4 0x0fc8dc00.0xc6213000-0xc623ffff 180 FREE
Q4 0x0fc8dc00.0xc6240000-0xca64cfff 69684 OTHER
Q4 0x0fc8dc00.0xca64d000-0xca9a4fff 3424 FREE
Q4 0x0fc8dc00.0xca9a5000-0xcb3a4fff 10240 OTHER
Q4 0x0fc8dc00.0xcb3a5000-0xefffffff 602476 FREE

Private 32-bit shared quadrants:
================================

Shared space from Window id 0 (global):
Space Start End Kbytes Usage
Q2 0x0d2a0000.0x40000000-0x7ffe5fff 1048472 SHMEM id=34308
Q2 0x0d2a0000.0x7ffe6000-0x7fffffff 104 FREE
Q3 0x0fc8dc00.0x80000000-0xac436fff 725212 SHMEM id=1541
Q3 0x0fc8dc00.0xac437000-0xbfffffff 323364 FREE

Shared space from Window id 1 (q3private):
Space Start End Kbytes Usage
Q2 0xffffffff.0x40000000-0x7fffffff 1048576 OTHER
Q3 0xffffffff.0x80000000-0xbfffffff 1048576 OTHER

Limits for 32-bit SHMEM allocation:
===================================

Maximum shmem segment: 4000000 Kbytes (shmmax)
Largest free segment: 602476 Kbytes (Global 32-bit quadrant 4)
Max. shmem reduced to: 602476 Kbytes (largest free segment)
Available swap : 6161024 Kbytes (swapspc_cnt)
Available pseudo-swap: 3567812 Kbytes (swapmem_cnt)

Allocation policy for 32-bit shared segments
============================================

1. First-fit on quadrant 2 (SHMEM_MAGIC only)
2. First-fit on quadrant 4
3. First-fit on quadrant 3

# swapinfo -mt
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 8192 0 8192 0% 0 - 1 /dev/vg00/lvol2
reserve - 2152 -2152
memory 6311 2827 3484 45%
total 14503 4979 9524 34% - 0 -

IO USAGE(by iostat):
# iostat 1 10

device bps sps msps

c0t0d0 0 0.0 1.0
c1t8d0 0 0.0 1.0
c0t1d0 0 0.0 1.0
c1t9d0 0 0.0 1.0
c11t0d3 0 0.0 1.0

c0t1d0 0 0.0 1.0
c1t9d0 0 0.0 1.0
c11t0d3 4 0.0 1.0

c0t0d0 36 7.9 1.0
c1t8d0 30 5.9 1.0
c0t1d0 0 0.0 1.0
c1t9d0 0 0.0 1.0
c11t0d3 4 1.0 1.0

c0t0d0 30 7.0 1.0
c1t8d0 26 4.0 1.0
c0t1d0 0 0.0 1.0
c1t9d0 0 0.0 1.0
c11t0d3 24 4.0 1.0

c0t0d0 2 1.0 1.0
c1t8d0 6 1.0 1.0
c0t1d0 0 0.0 1.0
c1t9d0 0 0.0 1.0
c11t0d3 0 0.0 1.0

c0t0d0 20 5.0 1.0
c1t8d0 14 4.0 1.0
c0t1d0 0 0.0 1.0
c1t9d0 0 0.0 1.0
c11t0d3 0 0.0 1.0

c0t0d0 20 4.9 1.0
c1t8d0 10 2.9 1.0
c0t1d0 0 0.0 1.0
c1t9d0 0 0.0 1.0
c11t0d3 0 0.0 1.0

c0t0d0 5 1.0 1.0
c1t8d0 3 1.0 1.0
c0t1d0 0 0.0 1.0
c1t9d0 0 0.0 1.0
c11t0d3 1 1.0 1.0

c0t0d0 5 2.0 1.0
c1t8d0 11 2.0 1.0
c0t1d0 0 0.0 1.0
c1t9d0 0 0.0 1.0
c11t0d3 0 1.0 1.0

c1t8d0 3 0.0 1.0
c0t1d0 0 0.0 1.0
c1t9d0 0 0.0 1.0
c11t0d3 4 2.0 1.0

T G Manikandan
Honored Contributor

Re: How to tune the kernel Configurable Parameters for sybase 11?

can you provide ,

sar -u ,sar -d , information from your system.
MA Qiang
Regular Advisor

Re: How to tune the kernel Configurable Parameters for sybase 11?

# sar -u 1 5

HP-UX mercury2 B.11.11 U 9000/800 04/26/05

23:35:36 %usr %sys %wio %idle
23:35:37 1 24 0 75
23:35:38 1 25 1 74
23:35:39 0 24 0 76
23:35:40 1 25 0 74
23:35:41 1 25 0 74

Average 1 25 0 75

# sar -d 1 5

HP-UX mercury2 B.11.11 U 9000/800 04/26/05

23:35:48 device %busy avque r+w/s blks/s avwait avserv
23:35:49
23:35:50 c0t0d0 1.98 0.50 1 8 8.96 11.15
c1t8d0 0.99 0.50 1 8 8.96 8.94
23:35:51 c0t0d0 1.98 0.50 3 14 6.19 7.46
c1t8d0 0.99 0.50 2 10 4.80 6.84
23:35:52 c0t0d0 1.00 0.50 1 2 9.26 4.80
c1t8d0 1.00 0.50 1 2 9.26 4.98
23:35:53 c0t0d0 3.00 0.50 5 38 7.04 6.63
c1t8d0 2.00 0.50 4 34 6.59 5.12

Average c0t0d0 1.59 0.50 2 12 7.20 7.14
Average c1t8d0 1.00 0.50 2 11 6.77 6.01
T G Manikandan
Honored Contributor

Re: How to tune the kernel Configurable Parameters for sybase 11?

Wanted to add these points,


The CPU system usage time (sys%) is more.Not sure as whether any backup or any kind of a process was running when you captured the output.
Make sure that the system processes are not carrying away the system.

Meanwhile,I dont see any application activity on the system.
What actions by the user claim the system to be slow!

Also,
I would not like to see a avwait being more than the avserv time.

The wait time should be very less than the service time.

Also,your shared memory usage is very high on the system.

you have defined a SHMMAX of 1gb on your kernel.

you should be able to increase this further up to 2GB.

MA Qiang
Regular Advisor

Re: How to tune the kernel Configurable Parameters for sybase 11?

The shmmax is 4gb:
# kmtune|grep -i shmmax
shmmax 4096000000 Y 4096000000

There are some error log of SYBASE:

00:00000:00016:2005/04/26 02:28:01.65 server Process id 14 killed by Hostname mercury2, Host process id 3076.
00:00000:00014:2005/04/26 02:32:32.18 kernel Cannot read, host process disconnected: HEWLETT-7E673F5 608 spid
: 14
00:00000:00015:2005/04/26 02:32:32.18 kernel Cannot read, host process disconnected: HEWLETT-7E673F5 608 spid
: 15
00:00000:00002:2005/04/26 03:53:07.09 kernel nopen: setsockopt, Interrupted system call
00:00000:00002:2005/04/26 03:53:07.10 server Error: 1605, Severity: 21, State: 1
00:00000:00002:2005/04/26 03:53:07.10 server Failed to open virtual socket for new connections
00:00000:00002:2005/04/26 09:53:02.03 kernel nopen: setsockopt, Interrupted system call
00:00000:00002:2005/04/26 09:53:02.05 server Error: 1605, Severity: 21, State: 1
T G Manikandan
Honored Contributor

Re: How to tune the kernel Configurable Parameters for sybase 11?

MA Qiang
Regular Advisor

Re: How to tune the kernel Configurable Parameters for sybase 11?

Which system parameter corresponds to the maximum number of file descriptors that the operating system allows for server's engine processes?

T G Manikandan
Honored Contributor

Re: How to tune the kernel Configurable Parameters for sybase 11?

MA Qiang
Regular Advisor

Re: How to tune the kernel Configurable Parameters for sybase 11?

# kmtune|grep nfile
nfile 40748 - (15*NPROC+2048)
T G Manikandan
Honored Contributor

Re: How to tune the kernel Configurable Parameters for sybase 11?

MA Qiang
Regular Advisor

Re: How to tune the kernel Configurable Parameters for sybase 11?

Sorry, I am a hp-ux administrator, and do not hava the sybase contract. I can not login to read the solved cases.
wm_shi
Occasional Advisor

Re: How to tune the kernel Configurable Parameters for sybase 11?

I found the memory used in M_TEMP is very large.
Does this look like some problem?
What is M_TEMP?
How to adject its size?

Thanks!