Connect to database takes more time

[elza]

Hi,

I have installed DB2 V9. when I try to connect to a database its taking lot of time to connect.

DB2DIAG.log entry look like this......can anyone help me out for this...

2007-10-09-11.22.09.692726+360 I324115A374 LEVEL: Error
PID : 274822 TID : 258
FUNCTION: DB2 Tools, DB2 administration server, MDUtility::connectMD, probe:10
DATA #1 : Sint32, 4 bytes
1
DATA #2 : Sint32, 4 bytes
-443
DATA #3 : Sint32, 4 bytes
38553
DATA #4 : String, 7 bytes
TOOLSDB
DATA #5 : String, 8 bytes
SYSTOOLS
DATA #6 : String, 4 bytes
NULL

2007-10-09-11.22.18.896399+360 I324490A369 LEVEL: Error
PID : 274822 TID : 258
FUNCTION: DB2 Tools, DB2 administration server, MDUtility::connectMD, probe:10
DATA #1 : Sint32, 4 bytes
102
DATA #2 : Sint32, 4 bytes
0
DATA #3 : Sint32, 4 bytes
0
DATA #4 : String, 7 bytes
TOOLSDB
DATA #5 : String, 8 bytes
SYSTOOLS
DATA #6 : String, 4 bytes
NULL

2007-10-09-11.22.25.279993+360 I324860A428 LEVEL: Event
PID : 659552 TID : 1 PROC : db2agent (TOOLSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB
APPHDL : 0-660 APPID: *LOCAL.db2inst1.071009052223
AUTHID : DB2INST1
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB TOOLSDB: "App_ctl_heap_sz" From: "128" To: "1024"

2007-10-09-11.22.25.280281+360 I325289A423 LEVEL: Event
PID : 659552 TID : 1 PROC : db2agent (TOOLSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB
APPHDL : 0-660 APPID: *LOCAL.db2inst1.071009052223
AUTHID : DB2INST1
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB TOOLSDB: "Applheapsz" From: "256" To: "1024"

2007-10-09-11.22.25.418309+360 I325713A369 LEVEL: Error
PID : 274822 TID : 258
FUNCTION: DB2 Tools, DB2 administration server, MDUtility::connectMD, probe:10
DATA #1 : Sint32, 4 bytes
102
DATA #2 : Sint32, 4 bytes
0
DATA #3 : Sint32, 4 bytes
0
DATA #4 : String, 7 bytes
TOOLSDB
DATA #5 : String, 8 bytes
SYSTOOLS
DATA #6 : String, 4 bytes
NULL

2007-10-09-11.22.25.472259+360 I326083A420 LEVEL: Info
PID : 659552 TID : 1 PROC : db2agent (TOOLSDB) 0
INSTANCE: db2inst1 NODE : 000 DB : TOOLSDB
APPHDL : 0-661 APPID: *LOCAL.db2inst1.071009052229
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbCreateBufferPoolAct, probe:98
MESSAGE : Creating bufferpool "BP32K0000" Size: "250"

2007-10-09-11.22.35.551623+360 I326504A369 LEVEL: Error
PID : 274822 TID : 258
FUNCTION: DB2 Tools, DB2 administration server, MDUtility::connectMD, probe:10
DATA #1 : Sint32, 4 bytes
102
DATA #2 : Sint32, 4 bytes
0
DATA #3 : Sint32, 4 bytes
0
DATA #4 : String, 7 bytes
TOOLSDB
DATA #5 : String, 8 bytes
SYSTOOLS
DATA #6 : String, 4 bytes
NULL

2007-10-10-10.38.45.065408+360 I326874A1633 LEVEL: Event
PID : 115086 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0x0FFFFFFFFFFF9CF0 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0x0FFFFFFFFFFF9D00 : 716C 6C69 622F 6164 6D2F 6462 3273 7461 qllib/adm/db2sta
0x0FFFFFFFFFFF9D10 : 7232 004E 4F4D 5347 0000 0000 0000 0000 r2.NOMSG........
0x0FFFFFFFFFFF9D20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9D30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9D40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9D50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9D60 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9D70 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9D80 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9D90 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9DA0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9DB0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9DC0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9DD0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9DE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

2007-10-12-10.14.09.790856+360 I328508A1633 LEVEL: Event
PID : 688264 TID : 1 PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0x0FFFFFFFFFFF9CF0 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0x0FFFFFFFFFFF9D00 : 716C 6C69 622F 6164 6D2F 6462 3273 7461 qllib/adm/db2sta
0x0FFFFFFFFFFF9D10 : 7232 004E 4F4D 5347 0000 0000 0000 0000 r2.NOMSG........
0x0FFFFFFFFFFF9D20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9D30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9D40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9D50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9D60 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9D70 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9D80 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9D90 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9DA0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9DB0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9DC0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9DD0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x0FFFFFFFFFFF9DE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

2007-10-12-12.41.40.109137+360 E330142A704 LEVEL: Warning
PID : 508036 TID : 1 PROC : db2agent (TOOLSDB) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-26 APPID: *LOCAL.db2inst1.071012064139
AUTHID : DB2INST1
FUNCTION: DB2 UDB, Self tuning memory manager, stmmCalcAutoScaleFactor, probe:110
DATA #1 : String, 139 bytes
Current DB configuration exceeds free physical memory. Self-tuning memory
manager scaling back automatic memory consumers to avoid paging.
DATA #2 : unsigned integer, 8 bytes
5808848896
DATA #3 : unsigned integer, 8 bytes
4801388544
DATA #4 : unsigned integer, 8 bytes
4563428311
DATA #5 : Decimal, 8 bytes
0.719652878166

2007-10-12-12.41.40.233330+360 I330847A424 LEVEL: Event
PID : 508036 TID : 1 PROC : db2agent (TOOLSDB) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-26 APPID: *LOCAL.db2inst1.071012064139
AUTHID : DB2INST1
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB TOOLSDB : "Locklist" From: "3200" <automatic> To: "2302" <automatic>

2007-10-12-12.41.40.241331+360 I331272A426 LEVEL: Event
PID : 508036 TID : 1 PROC : db2agent (TOOLSDB) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-26 APPID: *LOCAL.db2inst1.071012064139
AUTHID : DB2INST1
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB TOOLSDB : "Pckcachesz" From: "1533" <automatic> To: "1103" <automatic>

2007-10-12-12.41.40.285286+360 I331699A424 LEVEL: Event
PID : 508036 TID : 1 PROC : db2agent (TOOLSDB) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-26 APPID: *LOCAL.db2inst1.071012064139
AUTHID : DB2INST1
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB TOOLSDB : "Sortheap" From: "3178" <automatic> To: "2287" <automatic>

2007-10-12-12.41.40.289331+360 I332124A432 LEVEL: Event
PID : 508036 TID : 1 PROC : db2agent (TOOLSDB) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-26 APPID: *LOCAL.db2inst1.071012064139
AUTHID : DB2INST1
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : CFG DB TOOLSDB : "Sheapthres_shr" From: "63564" <automatic> To: "45744" <automatic>

2007-10-12-12.51.10.071841+360 E332557A753 LEVEL: Warning
PID : 590152 TID : 1 PROC : db2evmgi (DB2DETAILDEADLOCK) 0
INSTANCE: db2inst1 NODE : 000 DB : TEST
APPHDL : 0-9 APPID: *LOCAL.DB2.071012065111
AUTHID : DB2INST1
FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:20
DATA #1 : <preformatted>
Reserved heap size exceeded for Database Monitor Heap (MON_HEAP_SZ) on node 0,
allocating additional unreserved memory.
Requested block size : 69632 bytes.
Physical heap size : 458752 bytes.
Configured heap size : 393216 bytes.
Unreserved memory used by heap : 65536 bytes.
Unreserved memory left in set : 10682368 bytes.

[Mark A]

Post by elza
Hi,
I have installed DB2 V9. when I try to connect to a database its taking
lot of time to connect.

DB2 allocates the database memory when a database is activated, which occurs
when it is explicitly activated or the first time there is a connection to
the database. In the case of V9, automatic memory is enabled which takes
longer to allocate.

If you don't have at least one application that is always connected, then
you can alleviate the problem by explicitly activating the database via the
following command:

db2 activate db db-name