Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    8

    Red face Unanswered: Can anybody help me on DB2 V9.1 FP5 on AIX 5.3

    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

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    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

  3. #3
    Join Date
    Mar 2009
    Posts
    8

    How do i find out the database settings?

    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.....
    Last edited by anibchat; 03-18-09 at 04:58.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •