|
Hi,
we are using db2 9.5 in solaris 10. DB2 is clustered and we are using SAN as storage . We r facing a wierd problem with db2. The database takes a long time to connect (3-5 min and sometimes more than 5 hours )
We are having 3 databases of which 1 is connecting very fast (in secs ) .. we have tuned the kernel parameters also ... We have also kept most of the db cfg as AUTOMATIC ..
set msgsys:msginfo_msgmax=65535
set msgsys:msginfo_msgmni=3584
set semsys:seminfo_semmni=4096
set shmsys:shminfo_shmmax=15099494
set shmsys:shminfo_shmmni=4096
We have set the above by running "db2osconf -m 64 -n 4" ( memory = 64GB , cpu -4)
| 
