请教各位:
linux系统下crontab设定22:00用脚本对数据库进行online带日志备份。
后查看diag.log发现,
每天22:00备份时,就会出现db2自动停止,然后自动启动。脚本里没有对数据库进行启停的语句,请教各位,这是什么原因?日志如下:
2012-01-15-22.00.02.699694+480 E8567316G477 LEVEL: Info
PID : 28416 TID : 818932640 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-10541 APPID: *LOCAL.db2inst1.120115140003
AUTHID : DB2INST1
EDUID : 57 EDUNAME: db2agent (GATEWAY)
FUNCTION: DB2 UDB, database utilities, sqluxGetDegreeParallelism, probe:522
DATA #1 :
Autonomic BAR - using parallelism = 4.
2012-01-15-22.00.02.702582+480 E8567794G512 LEVEL: Info
PID : 28416 TID : 818932640 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-10541 APPID: *LOCAL.db2inst1.120115140003
AUTHID : DB2INST1
EDUID : 57 EDUNAME: db2agent (GATEWAY)
FUNCTION: DB2 UDB, database utilities, sqluxGetAvailableHeapPages, probe:632
DATA #1 :
Autonomic BAR - heap consumption.
Targetting (50%) - 2480 of 4960 pages.
2012-01-15-22.00.02.702764+480 E8568307G501 LEVEL: Info
PID : 28416 TID : 818932640 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-10541 APPID: *LOCAL.db2inst1.120115140003
AUTHID : DB2INST1
EDUID : 57 EDUNAME: db2agent (GATEWAY)
FUNCTION: DB2 UDB, database utilities, sqlubTuneBuffers, probe:883
DATA #1 :
Autonomic backup - tuning enabled.
Using buffer size = 513, number = 4.
2012-01-15-22.00.02.716961+480 E8568809G449 LEVEL: Info
PID : 28416 TID : 818932640 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-10541 APPID: *LOCAL.db2inst1.120115140003
AUTHID : DB2INST1
EDUID : 57 EDUNAME: db2agent (GATEWAY)
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1528
MESSAGE : Starting an online db backup.
2012-01-15-22.00.15.796040+480 I8569259G467 LEVEL: Warning
PID : 28416 TID : 2947541920 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 38 EDUNAME: db2lfr (GATEWAY)
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
1193
DATA #2 : unsigned integer, 4 bytes
1
2012-01-15-22.00.16.271374+480 E8569727G374 LEVEL: Info
PID : 28416 TID : 2948590496 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 35 EDUNAME: db2logmgr (GATEWAY)
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
DATA #1 :
Started archive for log file S0001193.LOG.
2012-01-15-22.00.16.364000+480 E8570102G496 LEVEL: Info
PID : 28416 TID : 2948590496 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 35 EDUNAME: db2logmgr (GATEWAY)
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180
DATA #1 :
Completed archive for log file S0001193.LOG to /db_files/logarchive/db2inst1/GATEWAY/NODE0000/C0000001/ from /db_files/dbfiles/db2in
st1/NODE0000/SQL00001/SQLOGDIR/.
2012-01-15-22.00.29.430204+480 I8570599G1504 LEVEL: Event
PID : 26918 TID : 2964420272 PROC : db2stop
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2stop2
DATA #2 : Hexdump, 256 bytes
0xBFF55510 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0xBFF55520 : 716C 6C69 622F 6164 6D2F 6462 3273 746F qllib/adm/db2sto
0xBFF55530 : 7032 0046 4F52 4345 0053 4E00 0000 0000 p2.FORCE.SN.....
0xBFF55540 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFF55550 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFF55560 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFF55570 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFF55580 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFF55590 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFF555A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFF555B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFF555C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFF555D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFF555E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFF555F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFF55600 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2012-01-15-22.00.30.844768+480 I8572104G375 LEVEL: Event
PID : 26981 TID : 2964072112 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:104
DATA #1 : String, 26 bytes
Force phase is in progress
DATA #2 : Hexdump, 4 bytes
0xBFE7EC8C : 0000 0000 ....
2012-01-15-22.00.30.845345+480 I8572480G465 LEVEL: Event
PID : 28416 TID : 2931813280 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc
FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::ExecuteStopForce, probe:1000
DATA #1 : String, 47 bytes
[Force]->Number of applications to be forced :
DATA #2 : Hexdump, 4 bytes
0xAEBFB024 : 0A00 0000 ....
2012-01-15-22.00.31.148837+480 I8572946G429 LEVEL: Error
PID : 28416 TID : 2955930528 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 18 EDUNAME: db2tcpcm
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:126
MESSAGE : Return code from sqleIsStopPending =
DATA #1 : Hexdump, 4 bytes
0xB02FE1A0 : 6CE8 FFFF l...
2012-01-15-22.00.31.158352+480 I8573376G429 LEVEL: Error
PID : 28416 TID : 2959076256 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 15 EDUNAME: db2tcpcm
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:126
MESSAGE : Return code from sqleIsStopPending =
DATA #1 : Hexdump, 4 bytes
0xB05FE1A0 : 6CE8 FFFF
2012-01-15-22.00.31.264282+480 I8573806G429 LEVEL: Error
PID : 28416 TID : 2956979104 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 17 EDUNAME: db2tcpcm
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:126
MESSAGE : Return code from sqleIsStopPending =
DATA #1 : Hexdump, 4 bytes
0xB03FE1A0 : 6CE8 FFFF l...
2012-01-15-22.00.31.288914+480 I8574236G429 LEVEL: Error
PID : 28416 TID : 2956979104 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 17 EDUNAME: db2tcpcm
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:126
MESSAGE : Return code from sqleIsStopPending =
DATA #1 : Hexdump, 4 bytes
0xB03FE1A0 : 6CE8 FFFF l...
2012-01-15-22.00.31.539943+480 E8574666G423 LEVEL: Info
PID : 28416 TID : 818932640 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-10541 APPID: *LOCAL.db2inst1.120115140003
AUTHID : DB2INST1
EDUID : 57 EDUNAME: db2agent (GATEWAY)
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:860
MESSAGE : Backup complete.
2012-01-15-22.00.31.579662+480 I8575090G412 LEVEL: Info
PID : 28416 TID : 2949639072 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
EDUID : 36 EDUNAME: db2loggr (GATEWAY)
FUNCTION: DB2 UDB, data protection services, sqlpghck, probe:1390
DATA #1 :
ExtNum 1194 state 1 baselsn 0000000411FE0000 nextlsn 0000000411FE000C
2012-01-15-22.00.32.051999+480 E8575503G465 LEVEL: Event
PID : 28416 TID : 818932640 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-10541 APPID: *LOCAL.db2inst1.120115140003
AUTHID : DB2INST1
EDUID : 57 EDUNAME: db2agent (idle)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000
STOP : DATABASE: GATEWAY : DEACTIVATED: NO
2012-01-15-22.00.32.052402+480 I8575969G308 LEVEL: Event
PID : 26981 TID : 2964072112 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:108
DATA #1 : String, 47 bytes
Force phase is completed and preparing to stop.
2012-01-15-22.00.32.052555+480 I8576278G378 LEVEL: Event
PID : 26981 TID : 2964072112 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:210
DATA #1 : String, 29 bytes
Deactivate phase is bypassed.
DATA #2 : Hexdump, 4 bytes
0xBFE7EC80 : 0100 0000 ....
2012-01-15-22.00.32.052623+480 I8576657G398 LEVEL: Event
PID : 26981 TID : 2964072112 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:230
DATA #1 : String, 49 bytes
Deactivate phase is completed, preparing to stop.
DATA #2 : Hexdump, 4 bytes
0xBFE7EC80 : 0100 0000
2012-01-15-22.00.32.052717+480 I8577056G287 LEVEL: Event
PID : 26981 TID : 2964072112 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
DATA #1 : String, 26 bytes
Stop phase is in progress.
2012-01-15-22.00.32.052784+480 I8577344G302 LEVEL: Event
PID : 26981 TID : 2964072112 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.
2012-01-15-22.00.32.113841+480 I8577647G304 LEVEL: Event
PID : 26981 TID : 2964072112 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
DATA #1 : String, 43 bytes
System controller termination is completed.
2012-01-15-22.00.32.114009+480 I8577952G325 LEVEL: Event
PID : 26981 TID : 2964072112 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:270
DATA #1 : String, 26 bytes
Active EDUs to be waited :
DATA #2 : unsigned integer, 4 bytes
1
2012-01-15-22.00.32.124997+480 I8578278G441 LEVEL: Warning
PID : 28414 TID : 2931813280 PROC : db2wdog
INSTANCE: db2inst1 NODE : 000
EDUID : 2 EDUNAME: db2wdog
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0xAEBFC410 : 0000 0000 ....
2012-01-15-22.00.32.125406+480 I8578720G320 LEVEL: Error
PID : 9601 TID : 2911763360 PROC : db2fmp (
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:4
RETCODE : ZRC=0x800F00FC=-2146500356=SQLO_INV_PARM "Invalid input parameter"
2012-01-15-22.00.32.125783+480 I8579041G320 LEVEL: Error
PID : 9601 TID : 2999896992 PROC : db2fmp (
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:4
RETCODE : ZRC=0x800F00FC=-2146500356=SQLO_INV_PARM "Invalid input parameter"
2012-01-15-22.00.32.125930+480 I8579362G387 LEVEL: Error
PID : 9601 TID : 2999896992 PROC : db2fmp (
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:999
MESSAGE : FMP exiting with error. Last agent registered:
DATA #1 : Hexdump, 4 bytes
0xB2CEC274 : 0000 0000 ....
2012-01-15-22.00.32.125824+480 I8579750G387 LEVEL: Error
PID : 9601 TID : 2911763360 PROC : db2fmp (
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:999
MESSAGE : FMP exiting with error. Last agent registered:
DATA #1 : Hexdump, 4 bytes
0xAD8DF274 : 0000 0000
2012-01-15-22.00.32.126124+480 I8580138G400 LEVEL: Warning
PID : 9601 TID : 2911763360 PROC : db2fmp (
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : Thread of db2fmp terminated with nonzero rc
DATA #1 : Hexdump, 4 bytes
0xAD8DF428 : 95FB FFFF ....
2012-01-15-22.00.32.125870+480 I8580539G320 LEVEL: Error
PID : 9601 TID : 3052652208 PROC : db2fmp (
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:4
RETCODE : ZRC=0x800F00FC=-2146500356=SQLO_INV_PARM "Invalid input parameter"
2012-01-15-22.00.32.126040+480 I8580860G400 LEVEL: Warning
PID : 9601 TID : 2999896992 PROC : db2fmp (
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary logging func, probe:0
MESSAGE : Thread of db2fmp terminated with nonzero rc
DATA #1 : Hexdump, 4 bytes
0xB2CEC428 : 95FB FFFF ....
2012-01-15-22.00.32.125044+480 I8581261G323 LEVEL: Event
PID : 26981 TID : 2964072112 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:280
DATA #1 : String, 24 bytes
There is no active EDUs.
DATA #2 : unsigned integer, 4 bytes
0
2012-01-15-22.00.32.125568+480 I8581585G320 LEVEL: Error
PID : 24135 TID : 3052156592 PROC : db2fmp (
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, common communication, sqlccipcdarihandshake, probe:4
RETCODE : ZRC=0x800F00FC=-2146500356=SQLO_INV_PARM "Invalid input parameter"
2012-01-15-22.00.32.428220+480 I8581906G387 LEVEL: Error
PID : 24135 TID : 3052156592 PROC : db2fmp (
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:999
MESSAGE : FMP exiting with error. Last agent registered:
DATA #1 : Hexdump, 4 bytes
0xBFFBB710 : 0000 0000 ....
2012-01-15-22.00.32.822778+480 E8582294G301 LEVEL: Event
PID : 26981 TID : 2964072112 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514W Database manager has stopped.
STOP : DB2 DBM
2012-01-15-22.00.35.095552+480 I8582596G1505 LEVEL: Event
PID : 27222 TID : 2964125360 PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0xBFB7D9B8 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0xBFB7D9C8 : 716C 6C69 622F 6164 6D2F 6462 3273 7461 qllib/adm/db2sta
0xBFB7D9D8 : 7232 0000 0000 0000 0000 0000 0000 0000 r2..............
0xBFB7D9E8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFB7D9F8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFB7DA08 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFB7DA18 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFB7DA28 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFB7DA38 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFB7DA48 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFB7DA58 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFB7DA68 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFB7DA78 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFB7DA88 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFB7DA98 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBFB7DAA8 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2012-01-15-22.00.37.506292+480 E8584102G396 LEVEL: Warning
PID : 27224 TID : 2964354736 PROC : db2star2
INSTANCE: db2inst1 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.
2012-01-15-22.00.37.817362+480 E8584499G1405 LEVEL: Event
PID : 27272 TID : 2932861856 PROC : db2syscr
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:1
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "db2inst1" uses "32" bits and DB2 code release "SQL09058"
with level identifier "06090107".
Informational tokens are "DB2 v9.5.0.8", "s110603", "IP23269", Fix Pack "8".
DATA #2 : System Info, 436 bytes
System: Linux gd1 6 2 i686
CPU: total:16 online:16 Cores per socket:4 Threading degree per core:1
Physical Memory(MB): total:36560 free:24018
Virtual Memory(MB): total:38616 free:26074
Swap Memory(MB): total:2056 free:2056
Kernel Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:36864
msgNumberOfHeaders:65536 msgMaxQueueSize:65536
msgMaxSegmentSize:16 shmMax:4294967295 shmMin:1 shmIDs:9216
shmSegments:9216 semMap:256000 semIDs:9216 semNum:256000
semUndo:256000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
Cur cpu time limit (seconds) = 0xFFFFFFFF
Cur file size limit (bytes) = 0xFFFFFFFF
Cur data size (bytes) = 0xFFFFFFFF
Cur stack size (bytes) = 0x00800000
Cur core size (bytes) = 0xFFFFFFFF
Cur memory size (bytes) = 0xFFFFFFFF
nofiles (descriptors) = 0x00000800
2012-01-15-22.00.37.819508+480 E8585905G431 LEVEL: Info
PID : 27272 TID : 2932861856 PROC : db2syscr
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:9
MESSAGE : ADM0506I DB2 has automatically updated the "mapped_base" kernel
parameter from "0x40000000(hex) 1073741824(dec)" to the recommended
value "0x10000000(hex) 268435456(dec)".
2012-01-15-22.00.37.870040+480 E8586337G568 LEVEL: Warning
PID : 27274 TID : 2932861856 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc
FUNCTION: DB2 UDB, oper system services, sqloSystemControllerMain, probe:100
DATA #1 : String, 242 bytes
Address Space Layout Randomization (ASLR) is enabled in this environment.
ASLR may cause intermittent failures in shmat() for any processes other than
db2sysc, and is recommended to be disabled. To disable it, set
kernel.randomize_va_space=0
2012-01-15-22.00.38.013659+480 E8586906G331 LEVEL: Warning
PID : 27274 TID : 2932861856 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe:18
DATA #1 : String, 28 bytes
Memory usage is limited to:
DATA #2 : signed integer, 8 bytes
17179869184
2012-01-15-22.00.38.037388+480 I8587238G527 LEVEL: Event
PID : 27274 TID : 2932861856 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfBufferManager::initBufferManager, probe:10
START : Starting FCM Buffer Manager
1 resource group(s).
128 buffers allocated.
Maximum number of buffers supported is 8192.
Total buffer manager memory required for 1 logical and 0 fail-over partition(s) is 860172 bytes.
2012-01-15-22.00.38.039274+480 I8587766G536 LEVEL: Event
PID : 27274 TID : 2932861856 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfChannelManager::initChannelManager, probe:10
START : Starting FCM Channel Manager
1 resource group(s).
2560 channels allocated.
Maximum number of channels supported is 8192.
Total channel manager memory required for 1 logical and 0 fail-over partitions(s) is 2269200 bytes.
2012-01-15-22.00.38.044195+480 I8588303G533 LEVEL: Event
PID : 27274 TID : 2932861856 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfSessionManager::initSessionManager, probe:10
START : Starting FCM Session Manager
1 resource group(s).
128 sessions allocated.
Maximum number of sessions supported is 64000.
Total session manager memory required for 1 logical and 0 fail-over partitions is 1724416 bytes.
2012-01-15-22.00.38.046513+480 I8588837G414 LEVEL: Event
PID : 27274 TID : 2932861856 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqlkf_init_allocate_shared, probe:500
START : FCM infrastructure started
FCM running in non-shared mode; FCM parallelism degree: 1; comm protocol: TCP/IPv4
2012-01-15-22.00.38.058156+480 I8589252G389 LEVEL: Info
PID : 27274 TID : 2932861856 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc
FUNCTION: DB2 UDB, Self tuning memory manager, stmmAttachToShmAtStartup, probe:1127
MESSAGE : Attached to STMM shared memory segment.
DATA #1 : Pointer, 4 bytes
0xb7fc5000
2012-01-15-22.00.39.251056+480 E8589642G302 LEVEL: Event
PID : 27224 TID : 2964354736 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
2012-01-15-22.00.42.165965+480 E8589945G466 LEVEL: Event
PID : 27274 TID : 2954881952 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-7 APPID: 198.203.4.1.8059.120115140039
AUTHID : GATEWAY
EDUID : 20 EDUNAME: db2agent (GATEWAY)
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000
START : DATABASE: GATEWAY : ACTIVATED: NO
2012-01-15-22.00.42.174699+480 E8590412G462 LEVEL: Event
PID : 27274 TID : 2941250464 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-10 APPID: *LOCAL.DB2.120115140042
AUTHID : GATEWAY
EDUID : 33 EDUNAME: db2stmm (GATEWAY)
FUNCTION: DB2 UDB, Self tuning memory manager, stmmLog, probe:1008
DATA #1 :
Starting STMM log from file number 7
2012-01-15-22.00.42.179158+480 I8590875G639 LEVEL: Error
PID : 27274 TID : 2938104736 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-13 APPID: *LOCAL.DB2.120115140045
AUTHID : DB2INST1
EDUID : 36 EDUNAME: db2evmli (DB2DETAILDEADLOCK)
FUNCTION: DB2 UDB, database monitor, sqmEvmonWriter::initTarget, probe:40
MESSAGE : ZRC=0x840D000C=-2079522804=SQLM_RC_EVIO2 "path not found"
DATA #1 : String, 17 bytes
DB2DETAILDEADLOCK
DATA #2 : String with size, 71 bytes
/db_files/dbfiles/db2inst1/NODE0000/SQL00001/db2event/db2detaildeadlock
2012-01-15-22.00.42.179366+480 I8591515G528 LEVEL: Error
PID : 27274 TID : 2938104736 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-13 APPID: *LOCAL.DB2.120115140045
AUTHID : DB2INST1
EDUID : 36 EDUNAME: db2evmli (DB2DETAILDEADLOCK)
FUNCTION: DB2 UDB, database monitor, sqmEvmonWriter::activate, probe:40
MESSAGE : ZRC=0x840D000C=-2079522804=SQLM_RC_EVIO2 "path not found"
DATA #1 : String, 17 bytes
DB2DETAILDEADLOCK
2012-01-15-22.30.40.912486+480 I8592044G432 LEVEL: Warning
PID : 27274 TID : 2932861856 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfDynamicResourceMgr::AdjustResources, probe:100
DATA #1 :
FCM Automatic/Dynamic Resource Adjustment (Channel): 640 will be released; new total will be 1920
2012-01-15-23.00.40.703086+480 I8592477G432 LEVEL: Warning
PID : 27274 TID : 2932861856 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfDynamicResourceMgr::AdjustResources, probe:100
DATA #1 :
FCM Automatic/Dynamic Resource Adjustment (Channel): 384 will be released; new total will be 1536
2012-01-16-00.06.15.817774+480 E8592910G583 LEVEL: Warning
PID : 27274 TID : 2934959008 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-161 APPID: 198.203.4.1.9595.120115142043
AUTHID : GATEWAY
EDUID : 39 EDUNAME: db2agent (GATEWAY)
FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:2
MESSAGE : ADM5500W DB2 is performing lock escalation. The total number of
locks currently held is "1082", and the target number of locks to
hold is "541".
2012-01-16-00.06.15.818765+480 E8593494G540 LEVEL: Warning
PID : 27274 TID : 2934959008 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-161 APPID: 198.203.4.1.9595.120115142043
AUTHID : GATEWAY
EDUID : 39 EDUNAME: db2agent (GATEWAY)
FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:3
MESSAGE : ADM5502W The escalation of "1079" locks on table "GATEWAY
.T_CUSTOMERCOUNT_IP" to lock intent "S" was successful.
2012-01-16-00.16.15.919296+480 E8594035G583 LEVEL: Warning
PID : 27274 TID : 790621088 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-463 APPID: 198.203.4.1.9851.120115150249
AUTHID : GATEWAY
EDUID : 41 EDUNAME: db2agent (GATEWAY)
FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:2
MESSAGE : ADM5500W DB2 is performing lock escalation. The total number of
locks currently held is "1080", and the target number of locks to
hold is "540".
2012-01-16-00.16.15.919710+480 E8594619G541 LEVEL: Warning
PID : 27274 TID : 790621088 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-463 APPID: 198.203.4.1.9851.120115150249
AUTHID : GATEWAY
EDUID : 41 EDUNAME: db2agent (GATEWAY)
FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:3
MESSAGE : ADM5502W The escalation of "1040" locks on table "GATEWAY
.T_CUSTOMER_STAGENUM" to lock intent "X" was successful.
2012-01-16-00.16.15.925940+480 E8595161G583 LEVEL: Warning
PID : 27274 TID : 790621088 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : GATEWAY
APPHDL : 0-463 APPID: 198.203.4.1.9851.120115150249
AUTHID : GATEWAY
EDUID : 41 EDUNAME: db2agent (GATEWAY)
FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:2
MESSAGE : ADM5500W DB2 is performing lock escalation. The total number of
locks currently held is "1076", and the target number of locks to
hold is "538".