2008-08-13-10.44.37.140221+600 I995421E392 LEVEL: Info PID : 11723 TID : 46912912746816PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 21 EDUNAME: db2loggr (REX) FUNCTION: DB2 UDB, data protection services, sqlpghck, probe:1390 DATA #1 : ExtNum 6669 state 10101 baselsn 000000122EBA0000 nextlsn 000000122EDE5190 2008-08-13-10.44.37.252672+600 I995814E361 LEVEL: Warning PID : 11723 TID : 46912916941120PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 20 EDUNAME: db2logmgr (REX) FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108 MESSAGE : Started archive for log file S0006669.LOG. 2008-08-13-10.44.37.294934+600 I996176E465 LEVEL: Warning PID : 11723 TID : 46912916941120PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 20 EDUNAME: db2logmgr (REX) FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180 MESSAGE : Completed archive for log file S0006669.LOG to /archivelogs/rextest/rextest/REX/NODE0000/C0000004/ from /translogs/rextest/. 2008-08-13-11.35.13.288621+600 I996642E994 LEVEL: Error PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::registerConsumer, probe:1000 MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available (reason code is id of requested heap)" 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-REX DATA #3 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes 2262171648 DATA #4 : Current instance_memory consumption in bytes, PD_TYPE_MEM_INSTANCE_CUR, 8 bytes 70647808 DATA #5 : Maximum allowed instance_memory in bytes, PD_TYPE_MEM_INSTANCE_MAX, 8 bytes 1605382144 2008-08-13-11.35.13.290149+600 I997637E725 LEVEL: Error PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) 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 REX DATA #2 : String, 56 bytes Insufficient INSTANCE_MEMORY to allocate new memory set. DATA #3 : numChunks, PD_TYPE_NUM_CHUNKS, 4 bytes 34518 2008-08-13-11.35.13.290421+600 I998363E934 LEVEL: Warning PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1516 MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG "No Storage Available for allocation" DIA8305C Memory allocation failure occurred. DATA #1 : String, 286 bytes Failed to allocate the desired database shared memory set. Check to make sure the configured DATABASE_MEMORY + overflow does not exceed the maximum shared memory on the system. Attempting to start up with only the system buffer pools. Desired database shared memory set size is (bytes): DATA #2 : unsigned integer, 8 bytes 2262171648 2008-08-13-11.35.13.374142+600 E999298E392 LEVEL: Info PID : 11723 TID : 46912908552512PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 49 EDUNAME: db2loggr (REX) FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInitDelOldLog, probe:1440 DATA #1 : Cleaning up logs from RenameArchNum 6669 to delLimit 6670. 2008-08-13-11.35.13.675825+600 E999691E783 LEVEL: Warning PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) 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. 2008-08-13-11.35.13.677774+600 E1000475E782 LEVEL: Warning PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) 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. 2008-08-13-11.35.13.701987+600 E1001258E782 LEVEL: Warning PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) 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. 2008-08-13-11.35.13.707855+600 E1002041E782 LEVEL: Warning PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "DEFAULT_TS" (ID "3") 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 "4098". The inactive buffer pool should become available at next database startup provided that the required memory is available. 2008-08-13-11.35.13.714010+600 E1002824E781 LEVEL: Warning PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "LARGER_TS" (ID "4") 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 "4099". The inactive buffer pool should become available at next database startup provided that the required memory is available. 2008-08-13-11.35.13.724582+600 E1003606E784 LEVEL: Warning PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "TEMPORARY_TS" (ID "5") 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 "4096". The inactive buffer pool should become available at next database startup provided that the required memory is available. 2008-08-13-11.35.13.786745+600 E1004391E790 LEVEL: Warning PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "TEMPORARY_LARGE_TS" (ID "6") 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 "4099". The inactive buffer pool should become available at next database startup provided that the required memory is available. 2008-08-13-11.35.13.820645+600 E1005182E784 LEVEL: Warning PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "SYSTOOLSPACE" (ID "7") 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. 2008-08-13-11.35.13.822017+600 E1005967E788 LEVEL: Warning PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "SYSTOOLSTMPSPACE" (ID "8") 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. 2008-08-13-11.35.13.836535+600 E1006756E779 LEVEL: Warning PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "TSASNCA" (ID "9") 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. 2008-08-13-11.35.13.838097+600 E1007536E781 LEVEL: Warning PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "TSASNUOW" (ID "10") 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. 2008-08-13-11.35.13.863168+600 I1008318E534 LEVEL: Severe PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) 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 2008-08-13-11.35.14.437348+600 I1008853E649 LEVEL: Warning PID : 11723 TID : 46912925329728PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1250 APPID: 192.168.40.10.3077.080813014446 AUTHID : REXTEST EDUID : 18 EDUNAME: db2agent (REX) 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. 2008-08-13-11.37.17.997071+600 I1009503E392 LEVEL: Info PID : 11723 TID : 46912908552512PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 49 EDUNAME: db2loggr (REX) FUNCTION: DB2 UDB, data protection services, sqlpghck, probe:1390 DATA #1 : ExtNum 6670 state 10101 baselsn 000000122F3A0000 nextlsn 000000122F3A0A15 2008-08-13-11.37.17.999301+600 I1009896E361 LEVEL: Warning PID : 11723 TID : 46912904358208PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 48 EDUNAME: db2logmgr (REX) FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108 MESSAGE : Started archive for log file S0006670.LOG. 2008-08-13-11.37.18.002342+600 I1010258E465 LEVEL: Warning PID : 11723 TID : 46912904358208PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 48 EDUNAME: db2logmgr (REX) FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180 MESSAGE : Completed archive for log file S0006670.LOG to /archivelogs/rextest/rextest/REX/NODE0000/C0000004/ from /translogs/rextest/. 2008-08-13-11.37.19.228369+600 I1010724E994 LEVEL: Error PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::registerConsumer, probe:1000 MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available (reason code is id of requested heap)" 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-REX DATA #3 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes 2262171648 DATA #4 : Current instance_memory consumption in bytes, PD_TYPE_MEM_INSTANCE_CUR, 8 bytes 72810496 DATA #5 : Maximum allowed instance_memory in bytes, PD_TYPE_MEM_INSTANCE_MAX, 8 bytes 1605382144 2008-08-13-11.37.19.228771+600 I1011719E725 LEVEL: Error PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) 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 REX DATA #2 : String, 56 bytes Insufficient INSTANCE_MEMORY to allocate new memory set. DATA #3 : numChunks, PD_TYPE_NUM_CHUNKS, 4 bytes 34518 2008-08-13-11.37.19.228917+600 I1012445E934 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1516 MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG "No Storage Available for allocation" DIA8305C Memory allocation failure occurred. DATA #1 : String, 286 bytes Failed to allocate the desired database shared memory set. Check to make sure the configured DATABASE_MEMORY + overflow does not exceed the maximum shared memory on the system. Attempting to start up with only the system buffer pools. Desired database shared memory set size is (bytes): DATA #2 : unsigned integer, 8 bytes 2262171648 2008-08-13-11.37.19.246274+600 E1013380E392 LEVEL: Info PID : 11723 TID : 46912908552512PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 65 EDUNAME: db2loggr (REX) FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInitDelOldLog, probe:1440 DATA #1 : Cleaning up logs from RenameArchNum 6670 to delLimit 6671. 2008-08-13-11.37.19.356000+600 E1013773E783 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) 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. 2008-08-13-11.37.19.356795+600 E1014557E782 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) 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. 2008-08-13-11.37.19.367537+600 E1015340E782 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) 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. 2008-08-13-11.37.19.368526+600 E1016123E782 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "DEFAULT_TS" (ID "3") 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 "4098". The inactive buffer pool should become available at next database startup provided that the required memory is available. 2008-08-13-11.37.19.369403+600 E1016906E781 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "LARGER_TS" (ID "4") 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 "4099". The inactive buffer pool should become available at next database startup provided that the required memory is available. 2008-08-13-11.37.19.370799+600 E1017688E784 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "TEMPORARY_TS" (ID "5") 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 "4096". The inactive buffer pool should become available at next database startup provided that the required memory is available. 2008-08-13-11.37.19.378842+600 E1018473E790 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "TEMPORARY_LARGE_TS" (ID "6") 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 "4099". The inactive buffer pool should become available at next database startup provided that the required memory is available. 2008-08-13-11.37.19.386994+600 E1019264E784 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "SYSTOOLSPACE" (ID "7") 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. 2008-08-13-11.37.19.387821+600 E1020049E788 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "SYSTOOLSTMPSPACE" (ID "8") 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. 2008-08-13-11.37.19.395920+600 E1020838E779 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "TSASNCA" (ID "9") 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. 2008-08-13-11.37.19.396618+600 E1021618E781 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "TSASNUOW" (ID "10") 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. 2008-08-13-11.37.19.463264+600 I1022400E534 LEVEL: Severe PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) 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 2008-08-13-11.37.19.478937+600 I1022935E649 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1263 APPID: 192.168.40.10.4613.080813014652 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) 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. 2008-08-13-11.37.21.059481+600 I1023585E183 LEVEL: Severe PID:11723 TID:46912879192384 NODE:000 Title: PSM_PVMPROGRAM Dump File:/db/rextest/sqllib/db2dump/11723.57.000.dump.bin 2008-08-13-11.37.21.059947+600 I1023769E174 LEVEL: Severe PID:11723 TID:46912879192384 NODE:000 Title: SQLCA Dump File:/db/rextest/sqllib/db2dump/11723.57.000.dump.bin 2008-08-13-11.37.21.060060+600 I1023944E176 LEVEL: Severe PID:11723 TID:46912879192384 NODE:000 Title: PSM_PVM Dump File:/db/rextest/sqllib/db2dump/11723.57.000.dump.bin 2008-08-13-11.37.21.060173+600 I1024121E182 LEVEL: Severe PID:11723 TID:46912879192384 NODE:000 Title: PSM_PVMMEMORY Dump File:/db/rextest/sqllib/db2dump/11723.57.000.dump.bin 2008-08-13-11.37.21.060370+600 I1024304E185 LEVEL: Severe PID:11723 TID:46912879192384 NODE:000 Title: PVM PARAM ZVAL 0 Dump File:/db/rextest/sqllib/db2dump/11723.57.000.dump.bin 2008-08-13-11.37.21.060458+600 I1024490E185 LEVEL: Severe PID:11723 TID:46912879192384 NODE:000 Title: PVM PARAM DATA 0 Dump File:/db/rextest/sqllib/db2dump/11723.57.000.dump.bin 2008-08-13-11.39.24.985961+600 I1024676E392 LEVEL: Info PID : 11723 TID : 46912908552512PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 65 EDUNAME: db2loggr (REX) FUNCTION: DB2 UDB, data protection services, sqlpghck, probe:1390 DATA #1 : ExtNum 6671 state 10101 baselsn 000000122FBA0000 nextlsn 000000122FBA7B6D 2008-08-13-11.39.24.987958+600 I1025069E361 LEVEL: Warning PID : 11723 TID : 46912916941120PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 64 EDUNAME: db2logmgr (REX) FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108 MESSAGE : Started archive for log file S0006671.LOG. 2008-08-13-11.39.24.991150+600 I1025431E465 LEVEL: Warning PID : 11723 TID : 46912916941120PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 64 EDUNAME: db2logmgr (REX) FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180 MESSAGE : Completed archive for log file S0006671.LOG to /archivelogs/rextest/rextest/REX/NODE0000/C0000004/ from /translogs/rextest/. 2008-08-13-11.55.32.954321+600 I1025897E994 LEVEL: Error PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, SQO Memory Management, SqloMemController::registerConsumer, probe:1000 MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM "No Memory Available (reason code is id of requested heap)" 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-REX DATA #3 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes 2262171648 DATA #4 : Current instance_memory consumption in bytes, PD_TYPE_MEM_INSTANCE_CUR, 8 bytes 70647808 DATA #5 : Maximum allowed instance_memory in bytes, PD_TYPE_MEM_INSTANCE_MAX, 8 bytes 1605382144 2008-08-13-11.55.32.956225+600 I1026892E725 LEVEL: Error PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) 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 REX DATA #2 : String, 56 bytes Insufficient INSTANCE_MEMORY to allocate new memory set. DATA #3 : numChunks, PD_TYPE_NUM_CHUNKS, 4 bytes 34518 2008-08-13-11.55.32.956761+600 I1027618E934 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1516 MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG "No Storage Available for allocation" DIA8305C Memory allocation failure occurred. DATA #1 : String, 286 bytes Failed to allocate the desired database shared memory set. Check to make sure the configured DATABASE_MEMORY + overflow does not exceed the maximum shared memory on the system. Attempting to start up with only the system buffer pools. Desired database shared memory set size is (bytes): DATA #2 : unsigned integer, 8 bytes 2262171648 2008-08-13-11.55.33.033698+600 E1028553E392 LEVEL: Info PID : 11723 TID : 46912908552512PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 74 EDUNAME: db2loggr (REX) FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInitDelOldLog, probe:1440 DATA #1 : Cleaning up logs from RenameArchNum 6671 to delLimit 6672. 2008-08-13-11.55.33.212473+600 E1028946E783 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) 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. 2008-08-13-11.55.33.213858+600 E1029730E782 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) 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. 2008-08-13-11.55.33.226525+600 E1030513E782 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) 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. 2008-08-13-11.55.33.227780+600 E1031296E782 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "DEFAULT_TS" (ID "3") 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 "4098". The inactive buffer pool should become available at next database startup provided that the required memory is available. 2008-08-13-11.55.33.228766+600 E1032079E781 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "LARGER_TS" (ID "4") 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 "4099". The inactive buffer pool should become available at next database startup provided that the required memory is available. 2008-08-13-11.55.33.230605+600 E1032861E784 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "TEMPORARY_TS" (ID "5") 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 "4096". The inactive buffer pool should become available at next database startup provided that the required memory is available. 2008-08-13-11.55.33.241007+600 E1033646E790 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "TEMPORARY_LARGE_TS" (ID "6") 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 "4099". The inactive buffer pool should become available at next database startup provided that the required memory is available. 2008-08-13-11.55.33.251596+600 E1034437E784 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "SYSTOOLSPACE" (ID "7") 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. 2008-08-13-11.55.33.252449+600 E1035222E788 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "SYSTOOLSTMPSPACE" (ID "8") 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. 2008-08-13-11.55.33.263968+600 E1036011E779 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "TSASNCA" (ID "9") 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. 2008-08-13-11.55.33.265012+600 E1036791E781 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2 MESSAGE : ADM6073W The table space "TSASNUOW" (ID "10") 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. 2008-08-13-11.55.33.269018+600 I1037573E534 LEVEL: Severe PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) 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 2008-08-13-11.55.33.297828+600 I1038108E649 LEVEL: Warning PID : 11723 TID : 46912879192384PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-1272 APPID: 192.168.40.10.11525.08081302050 AUTHID : REXTEST EDUID : 57 EDUNAME: db2agent (REX) 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. 2008-08-13-12.23.37.167696+600 I1038758E290 LEVEL: Event PID : 4481 TID : 46912556495328PROC : db2set INSTANCE: rextest NODE : 000 FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40 CHANGE : CFG DB2SET: DB2AUTOSTART: From: "" To: "YES" 2008-08-13-12.23.54.108511+600 I1039049E1633 LEVEL: Event PID : 4483 TID : 46912687741632PROC : db2start INSTANCE: rextest NODE : 000 FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130 DATA #1 : String, 31 bytes /db/rextest/sqllib/adm/db2star2 DATA #2 : Hexdump, 256 bytes 0x00007FFF15C7E930 : 2F64 622F 7265 7874 6573 742F 7371 6C6C /db/rextest/sqll 0x00007FFF15C7E940 : 6962 2F61 646D 2F64 6232 7374 6172 3200 ib/adm/db2star2. 0x00007FFF15C7E950 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007FFF15C7E960 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007FFF15C7E970 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007FFF15C7E980 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007FFF15C7E990 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007FFF15C7E9A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007FFF15C7E9B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007FFF15C7E9C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007FFF15C7E9D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007FFF15C7E9E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007FFF15C7E9F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007FFF15C7EA00 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007FFF15C7EA10 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00007FFF15C7EA20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 2008-08-13-12.23.56.119049+600 I1040683E332 LEVEL: Event PID : 4501 TID : 46912687741632PROC : db2star2 INSTANCE: rextest NODE : 000 FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30 CHANGE : CFG DBM: "Instance_memory" From: "391939" To: "717795" 2008-08-13-12.23.56.225115+600 E1041016E399 LEVEL: Warning PID : 4501 TID : 46912687741632PROC : db2star2 INSTANCE: rextest NODE : 000 FUNCTION: DB2 UDB, license manager, sqllcLogDisplayMessage, probe:201 MESSAGE : ADM12026W The DB2 server has detected that a valid license for the product "DB2 Workgroup Server Edition" has not been registered. 2008-08-13-12.24.00.594105+600 I1041416E530 LEVEL: Event PID : 4507 TID : 46912694643008PROC : db2sysc INSTANCE: rextest 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 925712 bytes. 2008-08-13-12.24.00.713041+600 I1041947E539 LEVEL: Event PID : 4507 TID : 46912694643008PROC : db2sysc INSTANCE: rextest 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 1441816 bytes. 2008-08-13-12.24.00.764097+600 I1042487E536 LEVEL: Event PID : 4507 TID : 46912694643008PROC : db2sysc INSTANCE: rextest 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 1400832 bytes. 2008-08-13-12.24.00.809116+600 I1043024E417 LEVEL: Event PID : 4507 TID : 46912694643008PROC : db2sysc INSTANCE: rextest 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 2008-08-13-12.24.03.006568+600 E1043442E1212 LEVEL: Event PID : 4501 TID : 46912687741632PROC : db2star2 INSTANCE: rextest 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 "rextest" uses "64" bits and DB2 code release "SQL09051" with level identifier "03020107". Informational tokens are "DB2 v9.5.0.1", "s080328", "MI00225", Fix Pack "1". DATA #2 : System Info, 440 bytes System: Linux adachigahara.nbv.org.au 6 2 x86_64 CPU: total:1 online:1 Cores per socket:1 Threading degree per core:1 Physical Memory(MB): total:3538 free:2670 Virtual Memory(MB): total:5522 free:4654 Swap Memory(MB): total:1984 free:1984 Kernel Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:1024 msgNumberOfHeaders:65536 msgMaxQueueSize:65536 msgMaxSegmentSize:16 shmMax:1073741824 shmMin:1 shmIDs:4096 shmSegments:4096 semMap:256000 semIDs:1024 semNum:256000 semUndo:256000 semNumPerID:250 semOps:32 semUndoSize:20 semMaxVal:32767 semAdjustOnExit:32767 2008-08-13-12.24.33.965547+600 I1044655E501 LEVEL: Event PID : 4507 TID : 46912929524032PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-7 APPID: 192.168.40.10.14853.08081302243 AUTHID : REXTEST EDUID : 17 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB REX : "Database_memory" From: "184368" To: "552624" 2008-08-13-12.24.34.367082+600 I1045157E434 LEVEL: Warning PID : 4507 TID : 46912929524032PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-7 APPID: 192.168.40.10.14853.08081302243 AUTHID : REXTEST EDUID : 17 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30 MESSAGE : Crash Recovery is needed. 2008-08-13-12.25.20.524954+600 I1045592E497 LEVEL: Warning PID : 4507 TID : 46912929524032PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-7 APPID: 192.168.40.10.14853.08081302243 AUTHID : REXTEST EDUID : 17 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410 MESSAGE : Crash recovery started. LowtranLSN 00000012303A029A MinbuffLSN 00000012303A005F 2008-08-13-12.25.20.527815+600 E1046090E451 LEVEL: Warning PID : 4507 TID : 46912929524032PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-7 APPID: 192.168.40.10.14853.08081302243 AUTHID : REXTEST EDUID : 17 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410 MESSAGE : ADM1530E Crash recovery has been initiated. 2008-08-13-12.25.20.570859+600 I1046542E493 LEVEL: Warning PID : 4507 TID : 46912929524032PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-7 APPID: 192.168.40.10.14853.08081302243 AUTHID : REXTEST EDUID : 17 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000 DATA #1 : Using parallel recovery with 3 agents 11 QSets 33 queues and 10 chunks 2008-08-13-12.25.20.798900+600 I1047036E466 LEVEL: Warning PID : 4507 TID : 46912908552512PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 22 EDUNAME: db2lfr (REX) FUNCTION: DB2 UDB, recovery manager, sqlplfrFMReadLog, probe:5150 MESSAGE : Found a log on a newer chain. Updating chain number. extNum / chainId DATA #1 : unsigned integer, 4 bytes 6672 DATA #2 : unsigned integer, 4 bytes 4 2008-08-13-12.25.20.824751+600 I1047503E404 LEVEL: Info PID : 4507 TID : 46912908552512PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 22 EDUNAME: db2lfr (REX) FUNCTION: DB2 UDB, recovery manager, sqlplfrVerifyLogPages, probe:980 DATA #1 : Inform shredder to overwrite ping with pong page in buffer. pagelsn is 0012303A0299 2008-08-13-12.25.21.521728+600 I1047908E507 LEVEL: Warning PID : 4507 TID : 46912929524032PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-7 APPID: 192.168.40.10.14853.08081302243 AUTHID : REXTEST EDUID : 17 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4000 MESSAGE : DIA2051W Forward phase of crash recovery has completed. Next LSN is "00000012303A029A". 2008-08-13-12.25.21.559611+600 E1048416E460 LEVEL: Warning PID : 4507 TID : 46912929524032PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-7 APPID: 192.168.40.10.14853.08081302243 AUTHID : REXTEST EDUID : 17 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170 MESSAGE : ADM1531E Crash recovery has completed successfully. 2008-08-13-12.25.21.561740+600 I1048877E462 LEVEL: Warning PID : 4507 TID : 46912929524032PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-7 APPID: 192.168.40.10.14853.08081302243 AUTHID : REXTEST EDUID : 17 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170 MESSAGE : Crash recovery completed. Next LSN is 00000012303A029A 2008-08-13-12.25.23.318960+600 E1049340E458 LEVEL: Event PID : 4507 TID : 46912870803776PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-8 APPID: *LOCAL.DB2.080813022523 AUTHID : REXTEST EDUID : 31 EDUNAME: db2stmm (REX) FUNCTION: DB2 UDB, Self tuning memory manager, stmmLog, probe:1008 DATA #1 : Starting STMM log from file number 0 2008-08-13-12.26.43.415280+600 I1049799E181 LEVEL: Severe PID:4507 TID:46912929524032 NODE:000 Title: PSM_PVMPROGRAM Dump File:/db/rextest/sqllib/db2dump/4507.17.000.dump.bin 2008-08-13-12.26.43.423383+600 I1049981E172 LEVEL: Severe PID:4507 TID:46912929524032 NODE:000 Title: SQLCA Dump File:/db/rextest/sqllib/db2dump/4507.17.000.dump.bin 2008-08-13-12.26.43.423492+600 I1050154E174 LEVEL: Severe PID:4507 TID:46912929524032 NODE:000 Title: PSM_PVM Dump File:/db/rextest/sqllib/db2dump/4507.17.000.dump.bin 2008-08-13-12.26.43.423578+600 I1050329E180 LEVEL: Severe PID:4507 TID:46912929524032 NODE:000 Title: PSM_PVMMEMORY Dump File:/db/rextest/sqllib/db2dump/4507.17.000.dump.bin 2008-08-13-12.26.43.423959+600 I1050510E183 LEVEL: Severe PID:4507 TID:46912929524032 NODE:000 Title: PVM PARAM ZVAL 0 Dump File:/db/rextest/sqllib/db2dump/4507.17.000.dump.bin 2008-08-13-12.26.43.424102+600 I1050694E183 LEVEL: Severe PID:4507 TID:46912929524032 NODE:000 Title: PVM PARAM DATA 0 Dump File:/db/rextest/sqllib/db2dump/4507.17.000.dump.bin 2008-08-13-12.27.46.675690+600 I1050878E392 LEVEL: Info PID : 4507 TID : 46912916941120PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 20 EDUNAME: db2loggr (REX) FUNCTION: DB2 UDB, data protection services, sqlpghck, probe:1390 DATA #1 : ExtNum 6672 state 10101 baselsn 00000012303A0000 nextlsn 00000012303A82B0 2008-08-13-12.27.46.730628+600 I1051271E361 LEVEL: Warning PID : 4507 TID : 46912921135424PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 19 EDUNAME: db2logmgr (REX) FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108 MESSAGE : Started archive for log file S0006672.LOG. 2008-08-13-12.27.46.769572+600 I1051633E465 LEVEL: Warning PID : 4507 TID : 46912921135424PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 19 EDUNAME: db2logmgr (REX) FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180 MESSAGE : Completed archive for log file S0006672.LOG to /archivelogs/rextest/rextest/REX/NODE0000/C0000004/ from /translogs/rextest/. 2008-08-13-12.46.06.262630+600 I1052099E501 LEVEL: Event PID : 4507 TID : 46912929524032PROC : db2sysc INSTANCE: rextest NODE : 000 DB : REX APPHDL : 0-20 APPID: 192.168.40.10.17669.08081302460 AUTHID : REXTEST EDUID : 17 EDUNAME: db2agent (REX) FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20 CHANGE : CFG DB REX : "Database_memory" From: "552624" To: "552288" 2008-08-13-12.46.06.299268+600 E1052601E392 LEVEL: Info PID : 4507 TID : 46912916941120PROC : db2sysc INSTANCE: rextest NODE : 000 EDUID : 35 EDUNAME: db2loggr (REX) FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInitDelOldLog, probe:1440 DATA #1 : Cleaning up logs from RenameArchNum 6672 to delLimit 6673.