db2diag.log

 

2011-06-22-13.16.45.422983-240 I2G301             LEVEL: Event
PID     : 17187                TID  : 15541968    PROC : db2start
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:21
DATA #1 : <preformatted>
Single node instance [0] is starting

2011-06-22-13.16.45.434245-240 I304G1505          LEVEL: Event
PID     : 17187                TID  : 15541968    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
0xBFEB71A4 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73    /home/db2inst1/s
0xBFEB71B4 : 716C 6C69 622F 6164 6D2F 6462 3273 7461    qllib/adm/db2sta
0xBFEB71C4 : 7232 0000 0000 0000 0000 0000 0000 0000    r2..............
0xBFEB71D4 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFEB71E4 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFEB71F4 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFEB7204 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFEB7214 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFEB7224 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFEB7234 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFEB7244 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFEB7254 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFEB7264 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFEB7274 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFEB7284 : 0000 0000 0000 0000 0000 0000 0000 0000    ................
0xBFEB7294 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

2011-06-22-13.16.49.715253-240 E1810G1415         LEVEL: Event
PID     : 17219                TID  : 3052399504  PROC : db2syscr
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:1
START   : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "db2inst1" uses "32" bits and DB2 code release "SQL09074"
with level identifier "08050107".
Informational tokens are "DB2 v9.7.0.4", "s110330", "IP23242", Fix Pack "4".
DATA #2 : System Info, 436 bytes
System: Linux localhost.localdomain 6 2 i686
CPU: total:1 online:1 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:2027 free:935
Virtual  Memory(MB): total:6122 free:5030
Swap     Memory(MB): total:4095 free:4095
Kernel   Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:2048
                 msgNumberOfHeaders:65536 msgMaxQueueSize:65536
                 msgMaxSegmentSize:16 shmMax:4294967295 shmMin:1 shmIDs:4096
                 shmSegments:4096 semMap:256000 semIDs:1024 semNum:256000
                 semUndo:256000 semNumPerID:250 semOps:32 semUndoSize:20
                 semMaxVal:32767 semAdjustOnExit:32767
Cur cpu time limit (seconds)  = 0xFFFFFFFF
Cur file size limit (bytes) = 0xFFFFFFFF
Cur data size (bytes)  = 0xFFFFFFFF
Cur stack size (bytes)  = 0x00A00000
Cur core size (bytes)  = 0x00000000
Cur memory size (bytes) = 0xFFFFFFFF
nofiles (descriptors)  = 0x00000800

2011-06-22-13.16.49.719552-240 E3226G369          LEVEL: Info
PID     : 17219                TID  : 3052399504  PROC : db2syscr
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:0
MESSAGE : ADM0506I  DB2 has automatically updated the "kernel.sem" kernel
          parameter from "32000" to the recommended value "256000".

2011-06-22-13.16.49.751031-240 E3596G365          LEVEL: Info
PID     : 17219                TID  : 3052399504  PROC : db2syscr
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:0
MESSAGE : ADM0506I  DB2 has automatically updated the "kernel.sem" kernel
          parameter from "128" to the recommended value "1024".

2011-06-22-13.16.49.751319-240 E3962G367          LEVEL: Info
PID     : 17219                TID  : 3052399504  PROC : db2syscr
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:0
MESSAGE : ADM0506I  DB2 has automatically updated the "kernel.msgmni" kernel
          parameter from "16" to the recommended value "2048".

2011-06-22-13.16.50.544533-240 E4330G568          LEVEL: Warning
PID     : 17221                TID  : 3052399504  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000
EDUID   : 1                    EDUNAME: db2sysc
FUNCTION: DB2 UDB, oper system services, sqloSystemControllerMain, probe:100
DATA #1 : String, 242 bytes
Address Space Layout Randomization (ASLR) is enabled in this environment.
ASLR may cause intermittent failures in shmat() for any processes other than
db2sysc, and is recommended to be disabled.  To disable it, set
kernel.randomize_va_space=0

2011-06-22-13.16.53.240272-240 E4899G330          LEVEL: Warning
PID     : 17221                TID  : 2922376080  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:18
DATA #1 : String, 28 bytes
Memory usage is limited to:
DATA #2 : signed integer, 8 bytes
2147483648

2011-06-22-13.16.53.288866-240 I5230G527          LEVEL: Event
PID     : 17221                TID  : 2922376080  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000
EDUID   : 1                    EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfBufferManager::initBufferManager, probe:10
START   : Starting FCM Buffer Manager
1 resource group(s).
128 buffers allocated.
Maximum number of buffers supported is 8192.
Total buffer manager memory required for 1 logical and 0 fail-over partition(s) is 860172 bytes.

2011-06-22-13.16.53.340785-240 I5758G536          LEVEL: Event
PID     : 17221                TID  : 2922376080  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000
EDUID   : 1                    EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfChannelManager::initChannelManager, probe:10
START   : Starting FCM Channel Manager
1 resource group(s).
1024 channels allocated.
Maximum number of channels supported is 8192.
Total channel manager memory required for 1 logical and 0 fail-over partitions(s) is 1093648 bytes.

2011-06-22-13.16.53.388406-240 I6295G533          LEVEL: Event
PID     : 17221                TID  : 2922376080  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000
EDUID   : 1                    EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfSessionManager::initSessionManager, probe:10
START   : Starting FCM Session Manager
1 resource group(s).
128 sessions allocated.
Maximum number of sessions supported is 64000.
Total session manager memory required for 1 logical and 0 fail-over partitions is 1404928 bytes.

2011-06-22-13.16.53.448192-240 I6829G414          LEVEL: Event
PID     : 17221                TID  : 2922376080  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000
EDUID   : 1                    EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqlkf_init_allocate_shared, probe:500
START   : FCM infrastructure started
FCM running in non-shared mode; FCM parallelism degree: 1; comm protocol: TCP/IPv4

2011-06-22-13.16.58.721003-240 E7244G302          LEVEL: Event
PID     : 17203                TID  : 7151920     PROC : db2star2
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W  Database manager has started.
START   : DB2 DBM

2011-06-22-13.18.55.972098-240 E7547G952          LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, Self tuning memory manager, stmmCalcAutoScaleFactor, probe:100
MESSAGE : Current DB configuration exceeds free physical memory. Self-tuning
          memory manager resetting automatic memory consumers to default
          values.
DATA #1 : unsigned integer, 4 bytes
3585081344
DATA #2 : unsigned integer, 4 bytes
3560439808
DATA #3 : unsigned integer, 8 bytes
1618149376
DATA #4 : unsigned integer, 8 bytes
1305654477
DATA #5 : unsigned integer, 8 bytes
1557069824
DATA #6 : unsigned integer, 8 bytes
41307976
DATA #7 : unsigned integer, 8 bytes
1264346501
DATA #8 : Decimal, 8 bytes
-1

2011-06-22-13.18.55.981262-240 I8500G945          LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::requestMemory, probe:50
MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available"
          DIA8300C A memory heap error has occurred.
DATA #1 : String, 28 bytes
Attempt to get memory failed
DATA #2 : unsigned integer, 4 bytes
3585081344
DATA #3 : unsigned integer, 4 bytes
0
DATA #4 : String, 11 bytes
DB-RORDB99
DATA #5 : unsigned integer, 4 bytes
0
DATA #6 : unsigned integer, 4 bytes
0
DATA #7 : unsigned integer, 4 bytes
107806720
DATA #8 : unsigned integer, 4 bytes
1618149376
DATA #9 : unsigned integer, 4 bytes
46530560

2011-06-22-13.18.56.025673-240 E9446G650          LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:10
DATA #1 : <preformatted>
Instance Memory Controller statistics.
Instance Memory Automatic: Yes.
Maximum size = 1580224 KB
Current size = 105280 KB
Usage HWM = 105280 KB
Cached memory = 45440 KB
Cached DB memory = 0 KB

2011-06-22-13.18.56.027754-240 I10097G534         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:11
DATA #1 : <preformatted>
APPL-RORDB99  - Current size : 40000 KB, HWM : 40000 KB, Reserved : 39872 KB

2011-06-22-13.18.56.028099-240 I10632G533         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:12
DATA #1 : <preformatted>
DBMS-db2inst1 - Current size : 39552 KB, HWM : 39552 KB, Reserved : 5376 KB

2011-06-22-13.18.56.028466-240 I11166G530         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:13
DATA #1 : <preformatted>
FMP_RESOURCES - Current size : 22528 KB, HWM : 22528 KB, Reserved : 0 KB

2011-06-22-13.18.56.028777-240 I11697G524         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:14
DATA #1 : <preformatted>
PRIVATE - Current size : 3200 KB, HWM : 3200 KB, Reserved : 192 KB

2011-06-22-13.18.56.029128-240 I12222G520         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:15
DATA #1 : <preformatted>
DB-RORDB99  - Current size : 0 KB, HWM : 0 KB, Reserved : 0 KB

2011-06-22-13.18.56.029526-240 I12743G951         LEVEL: Error
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::registerConsumer, probe:1000
MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available"
          DIA8300C A memory heap error has occurred.
DATA #1 : String, 60 bytes
Insufficient instance_memory to allocate new memory consumer
DATA #2 : String, 11 bytes
DB-RORDB99
DATA #3 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
3585081344
DATA #4 : Current instance_memory consumption in bytes, PD_TYPE_MEM_INSTANCE_CUR, 4 bytes
107806720
DATA #5 : Maximum allowed instance_memory in bytes, PD_TYPE_MEM_INSTANCE_MAX, 4 bytes
1618149376

2011-06-22-13.18.56.030521-240 I13695G729         LEVEL: Error
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, sqlogmshr, probe:149
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
          "No Storage Available for allocation"
          DIA8305C Memory allocation failure occurred.
DATA #1 : String, 8 bytes
RORDB99
DATA #2 : String, 56 bytes
Insufficient INSTANCE_MEMORY to allocate new memory set.
DATA #3 : numChunks, PD_TYPE_NUM_CHUNKS, 4 bytes
54704

2011-06-22-13.18.56.031227-240 E14425G950         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:100
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
          "No Storage Available for allocation"
          DIA8305C Memory allocation failure occurred.
DATA #1 : String, 299 bytes
Failed to allocate the desired database shared memory set.
The configured DATABASE_MEMORY plus desired overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with a smaller overflow allowance.
Desired database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
3585081344

2011-06-22-13.18.56.031703-240 I15376G945         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::requestMemory, probe:50
MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available"
          DIA8300C A memory heap error has occurred.
DATA #1 : String, 28 bytes
Attempt to get memory failed
DATA #2 : unsigned integer, 4 bytes
3136946176
DATA #3 : unsigned integer, 4 bytes
0
DATA #4 : String, 11 bytes
DB-RORDB99
DATA #5 : unsigned integer, 4 bytes
0
DATA #6 : unsigned integer, 4 bytes
0
DATA #7 : unsigned integer, 4 bytes
107806720
DATA #8 : unsigned integer, 4 bytes
1618149376
DATA #9 : unsigned integer, 4 bytes
46530560

2011-06-22-13.18.56.032498-240 E16322G650         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:10
DATA #1 : <preformatted>
Instance Memory Controller statistics.
Instance Memory Automatic: Yes.
Maximum size = 1580224 KB
Current size = 105280 KB
Usage HWM = 105280 KB
Cached memory = 45440 KB
Cached DB memory = 0 KB

2011-06-22-13.18.56.032930-240 I16973G534         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:11
DATA #1 : <preformatted>
APPL-RORDB99  - Current size : 40000 KB, HWM : 40000 KB, Reserved : 39872 KB

2011-06-22-13.18.56.033292-240 I17508G533         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:12
DATA #1 : <preformatted>
DBMS-db2inst1 - Current size : 39552 KB, HWM : 39552 KB, Reserved : 5376 KB

2011-06-22-13.18.56.033598-240 I18042G530         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:13
DATA #1 : <preformatted>
FMP_RESOURCES - Current size : 22528 KB, HWM : 22528 KB, Reserved : 0 KB

2011-06-22-13.18.56.033918-240 I18573G524         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:14
DATA #1 : <preformatted>
PRIVATE - Current size : 3200 KB, HWM : 3200 KB, Reserved : 192 KB

2011-06-22-13.18.56.034268-240 I19098G520         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::getPartitionStats, probe:15
DATA #1 : <preformatted>
DB-RORDB99  - Current size : 0 KB, HWM : 0 KB, Reserved : 0 KB

2011-06-22-13.18.56.034572-240 I19619G951         LEVEL: Error
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::registerConsumer, probe:1000
MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available"
          DIA8300C A memory heap error has occurred.
DATA #1 : String, 60 bytes
Insufficient instance_memory to allocate new memory consumer
DATA #2 : String, 11 bytes
DB-RORDB99
DATA #3 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
3136946176
DATA #4 : Current instance_memory consumption in bytes, PD_TYPE_MEM_INSTANCE_CUR, 4 bytes
107806720
DATA #5 : Maximum allowed instance_memory in bytes, PD_TYPE_MEM_INSTANCE_MAX, 4 bytes
1618149376

2011-06-22-13.18.56.035245-240 I20571G729         LEVEL: Error
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, SQO Memory Management, sqlogmshr, probe:149
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
          "No Storage Available for allocation"
          DIA8305C Memory allocation failure occurred.
DATA #1 : String, 8 bytes
RORDB99
DATA #2 : String, 56 bytes
Insufficient INSTANCE_MEMORY to allocate new memory set.
DATA #3 : numChunks, PD_TYPE_NUM_CHUNKS, 4 bytes
47866

2011-06-22-13.18.56.035705-240 E21301G933         LEVEL: Severe
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:110
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
          "No Storage Available for allocation"
          DIA8305C Memory allocation failure occurred.
DATA #1 : String, 283 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 4 bytes
3136900300

2011-06-22-13.18.56.906427-240 E22235G787         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "SYSCATSPACE" (ID "0") is configured to use
          buffer pool ID "1", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4096".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.56.910327-240 E23023G786         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "TEMPSPACE1" (ID "1") is configured to use
          buffer pool ID "1", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4096".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.57.021177-240 E23810G786         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "USERSPACE1" (ID "2") is configured to use
          buffer pool ID "1", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4096".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.57.128105-240 E24597G788         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "SYSTOOLSPACE" (ID "3") is configured to
          use buffer pool ID "1", but this buffer pool is not active at this
          time. In the interim the table space will use buffer pool ID "4096". 
          The inactive buffer pool should become available at next database
          startup provided that the required memory is available.

2011-06-22-13.18.57.169207-240 E25386G782         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "TEMP4K" (ID "4") is configured to use
          buffer pool ID "1", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4096".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.57.198255-240 E26169G782         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "TBS4K1" (ID "5") is configured to use
          buffer pool ID "8", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4096".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.57.285050-240 E26952G783         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "TBS32K2" (ID "6") is configured to use
          buffer pool ID "3", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4099".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.57.409795-240 E27736G782         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "TBS8K1" (ID "7") is configured to use
          buffer pool ID "4", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4097".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.57.525338-240 E28519G783         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "TBS16K1" (ID "8") is configured to use
          buffer pool ID "5", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4098".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.57.649786-240 E29303G783         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "IDX32K1" (ID "9") is configured to use
          buffer pool ID "6", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4099".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.57.793424-240 E30087G783         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "TMP32K" (ID "10") is configured to use
          buffer pool ID "7", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4099".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.57.807798-240 E30871G784         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "TMP32K2" (ID "11") is configured to use
          buffer pool ID "7", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4099".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.57.825513-240 E31656G784         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "TMP32K3" (ID "12") is configured to use
          buffer pool ID "7", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4099".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.57.840405-240 E32441G784         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "TBS32K1" (ID "13") is configured to use
          buffer pool ID "2", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4099".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.57.999653-240 E33226G793         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "SYSTOOLSTMPSPACE" (ID "14") is configured
          to use buffer pool ID "1", but this buffer pool is not active at this
          time. In the interim the table space will use buffer pool ID "4096". 
          The inactive buffer pool should become available at next database
          startup provided that the required memory is available.

2011-06-22-13.18.58.062756-240 E34020G782         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "TS4K" (ID "15") is configured to use
          buffer pool ID "12", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4096".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.58.089026-240 E34803G782         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "TS8K" (ID "16") is configured to use
          buffer pool ID "17", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4097".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.58.103007-240 E35586G783         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "TS16K" (ID "17") is configured to use
          buffer pool ID "18", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4098".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.58.111689-240 E36370G783         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W  The table space "TS32K" (ID "18") is configured to use
          buffer pool ID "19", but this buffer pool is not active at this time.
          In the interim the table space will use buffer pool ID "4099".  The
          inactive buffer pool should become available at next database startup
          provided that the required memory is available.

2011-06-22-13.18.58.169733-240 I37154G538         LEVEL: Severe
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:620
DATA #1 : String, 70 bytes
Database will come up with hidden buffer pools.
totalBufferPoolPages:
DATA #2 : signed integer, 8 bytes
64

2011-06-22-13.18.58.573812-240 E37693G468         LEVEL: Event
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
START   : DATABASE: RORDB99  : ACTIVATED: NO

2011-06-22-13.18.59.281527-240 E38162G471         LEVEL: Event
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, Self tuning memory manager, stmmLog, probe:1028
DATA #1 : <preformatted>
Starting STMM log from file number 0

2011-06-22-13.18.59.282018-240 I38634G653         LEVEL: Warning
PID     : 17221                TID  : 2945444752  PROC : db2sysc
INSTANCE: db2inst1             NODE : 000         DB   : RORDB99
APPHDL  : 0-7                  APPID: 10.88.144.37.49567.110622091926
AUTHID  : DB2INST1
EDUID   : 19                   EDUNAME: db2agent (RORDB99)
FUNCTION: DB2 UDB, Self tuning memory manager, stmmStartSTMMIfNecessary, probe:490
MESSAGE : ZRC=0x87AE015F=-2018639521=STMM_DAEMON_COULD_NOT_START
          "STMM Daemon could not be started"
DATA #1 : String, 89 bytes
The self tuning memory manager was not started because buffer pool initialization failed.