Hi,

I am running DB2 V9.1 FP 5 on AIX 5.3 on a P-series server.

The server refused to accept telnet sessions and it was logging off users who tried to connect to telnet.

While checking the DB2 error logs in db2diag.log I found out the following...

************************************************** ******
2009-03-16-06.13.05.897429+000 E79926350A667 LEVEL: Warning
PID : 1163500 TID : 1 PROC : db2agent (DV01BRKR) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-984 APPID: *LOCAL.db2inst1.090316061307
AUTHID : MBADMIN
FUNCTION: DB2 UDB, Self tuning memory manager, stmmCalcAutoScaleFactor, probe:100
DATA #1 : String, 155 bytes
Current DB configuration exceeds free physical memory. Self-tuning
memory manager resetting automatic memory consumers to default values
to reduce paging.
DATA #2 : unsigned integer, 8 bytes
1179254784
DATA #3 : unsigned integer, 8 bytes
9887744
DATA #4 : unsigned integer, 8 bytes
0

2009-03-16-06.13.06.405032+000 E79927018A430 LEVEL: Severe (OS)
PID : 401660 TID : 1 PROC : db2gds 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloCreateEDU, probe:5
MESSAGE : ZRC=0x870F00F2=-2029059854=SQLO_NORES
"no resources to create process or thread"
CALLED : OS, -, fork
OSERR : ENOMEM (12) "There is not enough memory available now."

2009-03-16-06.13.06.405303+000 I79927449A438 LEVEL: Severe
PID : 1163500 TID : 1 PROC : db2agent (DV01BRKR) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-984 APPID: *LOCAL.db2inst1.090316061307
AUTHID : MBADMIN
FUNCTION: DB2 UDB, data protection services, sqlpgint, probe:9010
RETCODE : ZRC=0x870F00F2=-2029059854=SQLO_NORES
"no resources to create process or thread"

2009-03-16-06.13.06.405442+000 I79927888A438 LEVEL: Severe
PID : 1163500 TID : 1 PROC : db2agent (DV01BRKR) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-984 APPID: *LOCAL.db2inst1.090316061307
AUTHID : MBADMIN
FUNCTION: DB2 UDB, data protection services, sqlpgint, probe:3600
RETCODE : ZRC=0x870F00F2=-2029059854=SQLO_NORES
"no resources to create process or thread"

2009-03-16-06.13.06.405568+000 I79928327A426 LEVEL: Severe
PID : 1163500 TID : 1 PROC : db2agent (DV01BRKR) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-984 APPID: *LOCAL.db2inst1.090316061307
AUTHID : MBADMIN
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFF0D50 : 870F 00F2 ....

2009-03-16-06.13.06.405670+000 I79928754A425 LEVEL: Error
PID : 1163500 TID : 1 PROC : db2agent (DV01BRKR) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-984 APPID: *LOCAL.db2inst1.090316061307
AUTHID : MBADMIN
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120
DATA #2 : Hexdump, 4 bytes
0x0FFFFFFFFFFF0D50 : 870F 00F2 ....

2009-03-16-06.13.06.405914+000 E79929180A376 LEVEL: Severe
PID : 1163500 TID : 1 PROC : db2agent (DV01BRKR) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-984 APPID: *LOCAL.db2inst1.090316061307
AUTHID : MBADMIN
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10
MESSAGE : ADM7518C "DV01BRKR" marked bad.

2009-03-16-06.13.06.406092+000 I79929557A389 LEVEL: Severe
PID : 1163500 TID : 1 PROC : db2agent (DV01BRKR) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-984 APPID: *LOCAL.db2inst1.090316061307
AUTHID : MBADMIN
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:210
MESSAGE : Database logging stopped due to mark db bad.

2009-03-16-06.13.06.426856+000 I79929947A424 LEVEL: Severe
PID : 1163500 TID : 1 PROC : db2agent (DV01BRKR) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-984 APPID: *LOCAL.db2inst1.090316061307
AUTHID : MBADMIN
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:10
MESSAGE : DIA0505I Execution of a component signal handling function has begun.

2009-03-16-06.13.06.427054+000 I79930372A171 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: **** DRDA ASCB ****
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.427180+000 I79930544A176 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: **** DRDA CMNMGR CB ****
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.427290+000 I79930721A176 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: **** RECEIVE BUFFER ****
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.427401+000 I79930898A174 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: **** SEND BUFFERS ****
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.427519+000 I79931073A179 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: **** CONNECTION HANDLE ****
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.427630+000 I79931253A177 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: **** DRDA ATTRIBUTES ****
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.427740+000 I79931431A176 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: **** AS UCINTERFACE ****
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.427850+000 I79931608A437 LEVEL: Severe
PID : 1163500 TID : 1 PROC : db2agent (DV01BRKR) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-984 APPID: *LOCAL.db2inst1.090316061307
AUTHID : MBADMIN
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:20
MESSAGE : DIA0506I Execution of a component signal handling function is
complete.

2009-03-16-06.13.06.428057+000 I79932046A164 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: SQLE_AGENTCB
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.428176+000 I79932211A172 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: SQLE_AGENT_PRIVATECB
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.428287+000 I79932384A161 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: SQLE_DBCB
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.428447+000 I79932546A170 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: SQLE_MASTER_APP_CB
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.428560+000 I79932717A163 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: SQLE_APP_CB
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.428692+000 I79932881A171 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: SQLE_COORDINATOR_CB
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.428804+000 I79933053A166 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: REPLY_NODE_MAP
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.428915+000 I79933220A169 LEVEL: Severe
PID:1163500 TID:1 NODE:000 Title: SQLE_APP_GROUP_CB
Dump File:/home/db2inst1/sqllib/db2dump/11635001.000

2009-03-16-06.13.06.429046+000 I79933390A434 LEVEL: Severe
PID : 1163500 TID : 1 PROC : db2agent (DV01BRKR) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-984 APPID: *LOCAL.db2inst1.090316061307
AUTHID : MBADMIN
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:100
DATA #1 : Hexdump, 4 bytes
0x000000011081926C : FFFF FBEE ....


2009-03-16-06.42.21.348083+000 E79935459A1031 LEVEL: Event
PID : 409832 TID : 1 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 152 bytes
Instance "db2inst1" uses "64" bits and DB2 code release "SQL09015"
with level identifier "01060107".
Informational tokens are "DB2 v9.1.0.5", "s080512", "U815922", Fix Pack "5".
DATA #2 : System Info, 224 bytes
System: AIX ftpcfsserver 3 5 00C729E04C00
CPU: total:4 online:4 Threading degree per core:2
Physical Memory(MB): total:11840 free:9994
Virtual Memory(MB): total:12352 free:10500
Swap Memory(MB): total:512 free:506
Kernel Params: msgMaxMessageSize:4194304 msgMaxQueueSize:4194304
************************************************** ******

Any help on this would be highly appreciated.

Thanks,

Anibrata

looks like you are running out of memory and you cannot start a new process(telnet session). stop the database instance; edit the database configuration; set DATABASE MEMORY to 4 or 5 gig; also increase the swap space to some 5-6 gig;what are your current database settings?; if the server is dedicated to db2, you can allocate 30-40% of memory to databases;if you use CIO,(use FILE CACHING when creating tablespace) you can go upto 70%for database, about 10% for file caching and about 20% for OS and processes

Mota,

Thanks for the guidance...I am analyzing the problem the way you have directed...

We are running Oracle 10G as well as DB2 V9.1 FP5 in the same server on AIX 5.3.

As I am new to this DB2 stuff i want to know how do i set the Database memory?

Can anybody tell me the process to find out my current database settings?...

I have dynamically increased the paging space with 1 logical partition for testing purpose...

Thanks in advance guys.....