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 : <preformatted>
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 : <preformatted>
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 : <preformatted>
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 : <preformatted>
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 : <preformatted>
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 : <preformatted>
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" <automatic> To: "717795" <automatic>
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" <computed> To: "552624" <computed>
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 : <preformatted>
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 : <preformatted>
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 : <preformatted>
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 : <preformatted>
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" <computed> To: "552288" <computed>
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 : <preformatted>
Cleaning up logs from RenameArchNum 6672 to delLimit 6673.