Reply from vishal_chaudhary on Aug 21 at 3:12 AM Check free space
| | | ---------------Original Message---------------
From: sam kuriakose
Sent: Thursday, August 21, 2014 1:20 AM
Subject: Dispatcher Not Starting After Restarting Server for First Time
Hi David,
Please find the db2diag.log as follows.
2014-08-13-11.39.49.054000+330 I1F983 LEVEL: Event
PID : 796 TID : 1424 PROC : db2set.exe
INSTANCE: DB2EC9 NODE : 000
HOSTNAME: DEV
EDUID : 1424
FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120
START : New Diagnostic Log file
DATA #1 : Build Level, 232 bytes
Instance "DB2EC9" uses "64" bits and DB2 code release "SQL10053"
with level identifier "0604010E".
Informational tokens are "DB2 v10.5.300.125", "s140203", "IP23546", Fix Pack "3".
DATA #2 : System Info, 1760 bytes
System: WIN32_NT DEV Service Pack 1 6.1 AMD64 Family 16, model 10, stepping 0
CPU: total:5 online:5 Cores per socket:5 Threading degree per core:1 SIMD:N
Physical Memory(MB): total:7935 free:5922 available:5922
Virtual Memory(MB): total:207934 free:205921
Swap Memory(MB): total:199999 free:199999
Information in this record is only valid at the time when this file was
created (see this record's time stamp)
2014-08-13-11.39.49.054000+330 I987F331 LEVEL: Event
PID : 796 TID : 1424 PROC : db2set.exe
INSTANCE: DB2EC9 NODE : 000
HOSTNAME: DEV
EDUID : 1424
FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40
CHANGE : CFG DB2SET: DB2_WORKLOAD: From: "" To: "SAP"
2014-08-13-11.39.51.862000+330 I1320F328 LEVEL: Event
PID : 480 TID : 412 PROC : db2set.exe
INSTANCE: DB2EC9 NODE : 000
HOSTNAME: DEV
EDUID : 412
FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40
CHANGE : CFG DB2SET: DB2TERRITORY: From: "" To: "1"
2014-08-13-11.39.54.639000+330 I1650F375 LEVEL: Event
PID : 1860 TID : 3872 PROC : db2set.exe
INSTANCE: DB2EC9 NODE : 000
HOSTNAME: DEV
EDUID : 3872
FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40
CHANGE : CFG DB2SET: DB2ENVLIST: From: "" To: "INSTHOME SAPSYSTEMNAME dbs_db6_schema DIR_LIBRARY"
2014-08-13-11.39.57.337000+330 I2027F340 LEVEL: Event
PID : 3876 TID : 1288 PROC : db2set.exe
INSTANCE: DB2EC9 NODE : 000
HOSTNAME: DEV
EDUID : 1288
FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40
CHANGE : CFG DB2SET: DB2ATLD_PORTS: From: "" To: "60000:65000"
2014-08-13-11.40.00.036000+330 I2369F335 LEVEL: Event
PID : 3000 TID : 2756 PROC : db2set.exe
INSTANCE: DB2EC9 NODE : 000
HOSTNAME: DEV
EDUID : 2756
FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40
CHANGE : CFG DB2SET: DB2_HISTORY_FILTER: From: "" To: "L"
2014-08-13-11.40.05.824000+330 I2706F322 LEVEL: Event
PID : 3920 TID : 3800 PROC : DB2STOP.EXE
INSTANCE: DB2EC9 NODE : 000
HOSTNAME: DEV
EDUID : 3800
FUNCTION: DB2 UDB, base sys utilities, sqlestp.C::main, probe:416
DATA #1 : <preformatted>
argv[1]=[NOMSG]
2014-08-13-11.40.05.839000+330 I3030F321 LEVEL: Event
PID : 3920 TID : 3800 PROC : DB2STOP.EXE
INSTANCE: DB2EC9 NODE : 000
HOSTNAME: DEV
EDUID : 3800
FUNCTION: DB2 UDB, base sys utilities, sqlestp.C::main, probe:416
DATA #1 : <preformatted>
argv[2]=[DATA]
2014-08-13-11.40.05.839000+330 I3353F322 LEVEL: Event
PID : 3920 TID : 3800 PROC : DB2STOP.EXE
INSTANCE: DB2EC9 NODE : 000
HOSTNAME: DEV
EDUID : 3800
FUNCTION: DB2 UDB, base sys utilities, sqlestp.C::main, probe:416
DATA #1 : <preformatted>
argv[3]=[FORCE]
2014-08-13-11.40.05.839000+330 I3677F406 LEVEL: Event
PID : 3920 TID : 3800 PROC : DB2STOP.EXE
INSTANCE: DB2EC9 NODE : 000
HOSTNAME: DEV
EDUID : 3800
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:14303
MESSAGE : Obtained exclusive mode lock on the file:
DATA #1 : String, 38 bytes
C:\DB2\DB2EC9\DB2EC9\ctrl\db2strst.lck
2014-08-13-11.40.05.855000+330 I4085F1704 LEVEL: Event
PID : 3920 TID : 3800 PROC : DB2STOP.EXE
INSTANCE: DB2EC9 NODE : 000
HOSTNAME: DEV
EDUID : 3800
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 44 bytes
C:\db2\db2ec9\db2_software\\bin\DB2STOP2.EXE
DATA #2 : Hexdump, 256 bytes
0x000000000018013F : 433A 5C64 6232 5C64 6232 6563 395C 6462 C:\db2\db2ec9\db
0x000000000018014F : 325F 736F 6674 7761 7265 5C5C 6269 6E5C 2_software\\bin\
0x000000000018015F : 4442 3253 544F 5032 2E45 5845 004E 4F4D DB2STOP2.EXE.NOM
0x000000000018016F : 5347 0046 4F52 4345 0053 4E00 0000 0000 SG.FORCE.SN.....
0x000000000018017F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000018018F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000018019F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001801AF : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001801BF : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001801CF : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001801DF : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001801EF : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001801FF : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000018020F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000018021F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000018022F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
2014-08-13-11.40.05.855000+330 I5791F473 LEVEL: Severe
PID : 3920 TID : 3800 PROC : DB2STOP.EXE
INSTANCE: DB2EC9 NODE : 000
HOSTNAME: DEV
EDUID : 3800
FUNCTION: DB2 UDB, base sys utilities, sqleResetAddNodeInProgress, probe:0
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
DATA #1 : String, 38 bytes
C:\DB2\DB2EC9\DB2EC9\ctrl\db2addnd.lck
2014-08-13-11.40.05.855000+330 I6266F1410 LEVEL: Event
PID : 3920 TID : 3800 PROC : DB2STOP.EXE
INSTANCE: DB2EC9 NODE : 000
HOSTNAME: DEV
EDUID : 3800
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:10120
MESSAGE : ZRC=0x870F0133=-2029059789=SQLO_DB2_NOT_RUNNING
"The DB2 service is stopped"
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL10053
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1032 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLEPFIN
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #3 : Boolean, 1 bytes
false
DATA #4 : Boolean, 1 bytes
false
DATA #5 : Boolean, 1 bytes
false
DATA #6 : Boolean, 1 bytes
false
DATA #7 : Boolean, 1 bytes
false
2014-08-13-11.40.05.855000+330 I7678F397 LEVEL: Warning
PID : 3920 TID : 3800 PROC : DB2STOP.EXE
INSTANCE: DB2EC9 NODE : 000
HOSTNAME: DEV
EDUID : 3800
FUNCTION: DB2 UDB, base sys utilities, sqleReleaseStStLockFile, probe:14016
MESSAGE : Released lock on the file:
DATA #1 : String, 38 bytes
C:\DB2\DB2EC9\DB2EC9\ctrl\db2strst.lck
2014-08-13-11.40.12.064000+330 I8077F374 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Instance_memory" From: "20" <automatic> To: "675840"
2014-08-13-11.40.12.079000+330 I8453F350 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Dir_cache" From: "1" To: "0"
2014-08-13-11.40.12.079000+330 I8805F359 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Sysadm_group" From: "" To: "dbec9adm"
2014-08-13-11.40.12.095000+330 I9166F360 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Sysctrl_group" From: "" To: "dbec9ctl"
2014-08-13-11.40.12.095000+330 I9528F361 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Sysmaint_group" From: "" To: "dbec9mnt"
2014-08-13-11.40.12.111000+330 I9891F359 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Sysmon_group" From: "" To: "dbec9mon"
2014-08-13-11.40.12.126000+330 I10252F356 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Dft_mon_bufpool" From: "0" To: "1"
2014-08-13-11.40.12.126000+330 I10610F353 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Dft_mon_lock" From: "0" To: "1"
2014-08-13-11.40.12.142000+330 I10965F353 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Dft_mon_sort" From: "0" To: "1"
2014-08-13-11.40.12.157000+330 I11320F353 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Dft_mon_stmt" From: "0" To: "1"
2014-08-13-11.40.12.157000+330 I11675F354 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Dft_mon_table" From: "0" To: "1"
2014-08-13-11.40.12.189000+330 I12031F352 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Dft_mon_uow" From: "0" To: "1"
2014-08-13-11.40.12.204000+330 I12385F357 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Rqrioblk" From: "65535" To: "65000"
2014-08-13-11.40.12.204000+330 I12744F356 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Svcename" From: "" To: "sapdb2EC9"
2014-08-13-11.40.12.220000+330 I13102F351 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Keepfenced" From: "1" To: "0"
2014-08-13-11.40.12.235000+330 I13455F358 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Dftdbpath" From: "" To: "C:\db2\EC9"
2014-08-13-11.40.12.251000+330 I13815F363 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Diagpath" From: "" To: "\\DEV\db2dumpEC9"
2014-08-13-11.40.12.251000+330 I14180F355 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Num_initagents" From: "0" To: "5"
2014-08-13-11.40.12.267000+330 I14537F358 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Agent_stack_sz" From: "16" To: "128"
2014-08-13-11.40.12.298000+330 I14897F350 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Spm_name" From: "DEV" To: ""
2014-08-13-11.40.12.329000+330 I15249F355 LEVEL: Event
PID : 280 TID : 260 PROC : db2bp.exe
INSTANCE: DB2EC9 NODE : 000 DB : EC9
HOSTNAME: DEV
EDUID : 260
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Authentication" From: "0" To: "4"
Thanks,
Sam |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
