Hi All
I am getting strange errors in my db2diag.log can any one tell me what
these errors mean??
Following is the code from my db2diag.log
*************** *************** *************** *************** *************** *************** ***
2006-02-23-17.53.12.253000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:1 Database:DEVM_D B
Error in agent servicing application with coor_node:
0x1BD7A612 : 0x0000 ..
2006-02-23-17.53.12.253001 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:2 Database:DEVM_D B
Error in agent servicing application with coor_agent_inde x:
0x1BD7A610 : 0x0161 a.
2006-02-23-17.53.12.268000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:3 Database:DEVM_D B
Error in agent servicing application with CLIENT PID:
0x1BD7A5F0 : 0x34323033 3024
2006-02-23-17.53.12.268001 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:4 Database:DEVM_D B
Error in agent servicing application with INBOUND APPLICATION ID:
0x189DC224 : 4143 3130 4530 3130 2E4A 3730 412E 3030 AC10E010.J70A.0 0
0x189DC234 : 4538 3833 3132 3232 3530 E883122250
2006-02-23-17.53.12.268002 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:5 Database:DEVM_D B
Error in agent servicing application with INBOUND SEQUENCE NUMBER:
0x189DC1CE : 0x0003 ..
2006-02-23-17.53.12.268003 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:6 Database:DEVM_D B
Error in agent servicing application with OUTBOUND APPLICATION ID:
2006-02-23-17.53.12.268004 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:7 Database:DEVM_D B
Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:
2006-02-23-17.53.12.268005 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:8 Database:DEVM_D B
Error in agent servicing application with AUTHORIZATION ID:
0x189DC0E5 : 5753 4143 4553 2020 0000 0000 0000 0000 DB_USER ........
0x189DC0F5 : 0000 0000 0000 0000 0000 0000 0000 00 ...............
2006-02-23-17.53.12.284000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:9 Database:DEVM_D B
Error in agent servicing application with PRODUCT SIGNATURE:
0x189DC290 : 0x32313038304C5 153 SQL08012
2006-02-23-17.53.12.284001 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:10 Database:DEVM_D B
Error in agent servicing application with APPLICATION NAME:
0x189DC266 : 6465 7665 6E76 2E65 7865 devenv.exe
2006-02-23-17.53.12.300000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
DRDA Application Server sqljsSignalHand ler Probe:10 Database:DEVM_D B
DIA0505I Execution of a component signal handling function has begun.
2006-02-23-17.53.12.315000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
DRDA Application Server sqljsSignalHand ler Probe:911 Database:DEVM_D B
Source Type not DRDA AS. SourceType =
0x025B82A0 : 0x00000004 ....
2006-02-23-17.53.12.315001 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
DRDA Application Server sqljsSignalHand ler Probe:20 Database:DEVM_D B
DIA0506I Execution of a component signal handling function is complete.
2006-02-23-17.53.12.315002 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
relation data serv sqlrr_signal_ha ndler Probe:50 Database:DEVM_D B
DIA0505I Execution of a component signal handling function has begun.
PID:1600 TID:440 Node:000 Title: RDS AGENT CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLCA
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS UCINTFC
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS UCINTFC: pCurrentPID =
0x1BD7A3D8 : 0x3C090F60 `. <
PID:1600 TID:440 Node:000 Title: RDS UCINTFC:
pCurrentPID->pkgnamcsn.rdbc olid =
0x3C090F82 : 0x2020534543415 357 DB_USER
PID:1600 TID:440 Node:000 Title: RDS UCINTFC: pCurrentPID->rdbcolidLen =
0x3C090F64 : 0x0008 ..
PID:1600 TID:440 Node:000 Title: RDS UCINTFC: pCurrentPID->rdbname =
0x3C090F70 : 4143 4553 5044 4D20 2020 2020 2020 2020 DEVM_DB
0x3C090F80 : 2020
PID:1600 TID:440 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgname =
0x3C090F94 : 5037 3531 3232 3839 2020 2020 2020 2020 P7512289
0x3C090FA4 : 2020
PID:1600 TID:440 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgcnstkn =
0x3C090FA6 : 0x574358527A574 263 cBWzRXCW
PID:1600 TID:440 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgsn =
0x3C090FAE : 0x0002 ..
Trap c0000005 detected in db2diag call from [0,0,0] trapfile created
PID:1600 TID:440 Node:000 Title: RDS APPL CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS NESTED APPL CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS SP REGISTERS CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS TRAN CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS NESTED TRAN CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS COORD CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS NESTED CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS INVOCATION CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
2006-02-23-17.53.12.409000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
relation data serv sqlrr_dump_ffdc Probe:20 Database:DEVM_D B
DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007
PID:1600 TID:440 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL08013
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:
PID:1600 TID:440 Node:000 Title: SQLCA
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: CREATOR
0x1D69198C : 0x2020534543415 357 DB_USER
PID:1600 TID:440 Node:000 Title: PACKAGE
0x1D6919AA : 0x3938323231353 750 P7512289
PID:1600 TID:440 Node:000 Title: CREATOR
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: PACKAGE
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: REQUEST TYPE
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: APM COMMON INFO
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: PACKAGE ENTRY
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: CACHED PACKAGE ENTRY
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: Recursive dump_sect
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SECTION NUMBER
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SECTION ENTRY
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SECTION CURSOR INFO
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SIBLING ENTRY
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
2006-02-23-17.53.12.518000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
relation data serv sqlrr_dump_ffdc Probe:902 Database:DEVM_D B
DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007
2006-02-23-17.53.12.518001 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
relation data serv sqlrr_dump_ffdc Probe:902 Database:DEVM_D B
PID:1600 TID:440 Node:000 Title: SQLE_DBCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_DBCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_AGENT_CB Pointer:
0x1BD7A380 : 0x18DD0080 €.Ý.
PID:1600 TID:440 Node:000 Title: SQLD_AGENT_CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_TRAN_CB Pointer
0x1BD7A388 : 0x18ADC3F0 ðÃ*.
PID:1600 TID:440 Node:000 Title: SQLD_TRAN_CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_APP_CB Pointer
0x1BD7A384 : 0x18ADC200 .Â*.
PID:1600 TID:440 Node:000 Title: SQLD_APP_CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: >> Begin CURSOR dump:
OPEN PERM CURSORS: >>
PID:1600 TID:440 Node:000 Title: << End CURSOR dump:
OPEN PERM CURSORS: <<
PID:1600 TID:440 Node:000 Title: >> Begin CURSOR dump:
OPEN TEMP CURSORS: >>
PID:1600 TID:440 Node:000 Title: << End CURSOR dump:
OPEN TEMP CURSORS: <<
PID:1600 TID:440 Node:000 Title: >> Begin CURSOR dump:
CLOSED CURSORS: >>
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=0, obj(FID)=11, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=0, obj(FID)=24, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=0, obj(FID)=81, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=0, obj(FID)=30, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=415, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=417, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=421, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=424, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=146, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=203, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=15, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: << End CURSOR dump:
CLOSED CURSORS: <<
PID:1600 TID:440 Node:000 Title: SQLI_CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLE_AGENT_PRIV ATECB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLE_APP_CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLE_TRAN_CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLP_LFPB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLP_ACB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLP_DBCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLP_TENTRY
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: locklist
Check C:\PROGRA~1\IBM \SQLLIB\DB2\l01 74.000 for additional data.
PID:1600 TID:440 Node:000 Title: NLSWA:DatabaseA pp
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: NLSWA:DatabaseD atabase
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: nlsacb
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: dbNLSAppCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: UnicodeNLSAppCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
2006-02-23-17.53.12.722001 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
access plan manager sqlra_sqlC_dump Probe:25 Database:DEVM_D B
Context info dumped! Check C:\PROGRA~1\IBM \SQLLIB\DB2\a16 00440.000 for
additional data.
2006-02-23-17.53.12.737000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
access plan manager sqlra_sqlW_raw_ dump Probe:25 Database:DEVM_D B
Private workspace info dumped! Check
C:\PROGRA~1\IBM \SQLLIB\DB2\a16 00440.000 for additional data.
2006-02-23-17.53.12.753000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
access plan manager sqlra_sqlW_raw_ dump Probe:25 Database:DEVM_D B
Shared workspace info dumped! Check
C:\PROGRA~1\IBM \SQLLIB\DB2\a16 00440.000 for additional data.
2006-02-23-17.53.12.768000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
relation data serv sqlrr_signal_ha ndler Probe:20 Database:DEVM_D B
DIA0506I Execution of a component signal handling function is complete.
PID:1600 TID:440 Node:000 Title: SQLE_AGENT_PRIV ATECB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLE_AGENTCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
2006-02-23-17.53.13.815000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleCleanupReso urces Probe:5 Database:DEVM_D B
DiagData
0x1BD7FE0C : 0x00000000 ....
2006-02-23-17.53.13.815001 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
routine_infrast ructure sqlerKillAllFmp s Probe:5 Database:DEVM_D B
Bringing down all db2fmp processes as part of db2stop
0x1BD7FCD8 : 0x00000000 ....
2006-02-23-17.57.18.597000 Instance:DB2 Node:000
PID:2296(db2sys cs.exe) TID:2284 Appid:none
base sys utilities LicCheckProcess ors Probe:20
SQL8017W The number of processors on this machine exceeds the defined
entitlement of "1" for the product "DB2 Enterprise Server Edition". The
number of processors on this machine is "2". You should purchase
additional
processor based entitlements from your IBM representative or authorized
dealer
and update your license using the License Center or the db2licm command
line
utility. For more information on updating processor based licenses, refer
to
the Quick Beginnings manual for your platform. For more information on
the
db2licm utility, refer to the DB2 Command Reference.
2006-02-23-17.57.19.675000 Instance:DB2 Node:000
PID:2296(db2sys cs.exe) TID:2284 Appid:none
base sys utilities startdbm Probe:911
ADM7513W Database manager has started.
2006-02-23-17.57.51.800000 Instance:DB2 Node:000
PID:2296(db2sys cs.exe) TID:440 Appid:AC10E00F. ED04.00A7C31227 51
base sys utilities sqledint Probe:30
Crash Recovery is needed.
2006-02-23-17.57.52.003000 Instance:DB2 Node:000
PID:2296(db2sys cs.exe) TID:440 Appid:AC10E00F. ED04.00A7C31227 51
recovery manager sqlpresr Probe:410 Database:DEVM_D B
Crash recovery started. LowtranLSN 000000005BDC44E E MinbuffLSN
000000005BDBD1E 8
2006-02-23-17.57.52.003002 Instance:DB2 Node:000
PID:2296(db2sys cs.exe) TID:440 Appid:AC10E00F. ED04.00A7C31227 51
recovery manager sqlprecm Probe:125 Database:DEVM_D B
Using parallel recovery with 5 agents 11 QSets 77 queues and 2 chunks
2006-02-23-17.57.52.018000 Instance:DB2 Node:000
PID:2296(db2sys cs.exe) TID:440 Appid:AC10E00F. ED04.00A7C31227 51
recovery manager sqlprecm Probe:400 Database:DEVM_D B
DIA2051W Forward phase of crash recovery has completed. Next LSN is
"000000005BDC44 EE".
2006-02-23-17.57.52.034001 Instance:DB2 Node:000
PID:2296(db2sys cs.exe) TID:440 Appid:AC10E00F. ED04.00A7C31227 51
recovery manager sqlpresr Probe:3170 Database:DEVM_D B
Crash recovery completed. Next LSN is 000000005BDC44E E
*************** *************** *************** *************** *************** *************** ***
Regards
Praveen
4  7352 
It looks like license issue involved here. You can use db2licm -l to
see what product you installed and what kind license you current have.
If you use more processors for your
product, you need to contact IBM to buy additional license.
Praveen_db2 wrote: Hi All
I am getting strange errors in my db2diag.log can any one tell me what
these errors mean??
Following is the code from my db2diag.log
*************** *************** *************** *************** *************** *************** ***
2006-02-23-17.53.12.253000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:1 Database:DEVM_D B
Error in agent servicing application with coor_node:
0x1BD7A612 : 0x0000 ..
2006-02-23-17.53.12.253001 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:2 Database:DEVM_D B
Error in agent servicing application with coor_agent_inde x:
0x1BD7A610 : 0x0161 a.
2006-02-23-17.53.12.268000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:3 Database:DEVM_D B
Error in agent servicing application with CLIENT PID:
0x1BD7A5F0 : 0x34323033 3024
2006-02-23-17.53.12.268001 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:4 Database:DEVM_D B
Error in agent servicing application with INBOUND APPLICATION ID:
0x189DC224 : 4143 3130 4530 3130 2E4A 3730 412E 3030 AC10E010.J70A.0 0
0x189DC234 : 4538 3833 3132 3232 3530 E883122250
2006-02-23-17.53.12.268002 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:5 Database:DEVM_D B
Error in agent servicing application with INBOUND SEQUENCE NUMBER:
0x189DC1CE : 0x0003 ..
2006-02-23-17.53.12.268003 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:6 Database:DEVM_D B
Error in agent servicing application with OUTBOUND APPLICATION ID:
2006-02-23-17.53.12.268004 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:7 Database:DEVM_D B
Error in agent servicing application with OUTBOUND SEQUENCE NUMBER:
2006-02-23-17.53.12.268005 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:8 Database:DEVM_D B
Error in agent servicing application with AUTHORIZATION ID:
0x189DC0E5 : 5753 4143 4553 2020 0000 0000 0000 0000 DB_USER ........
0x189DC0F5 : 0000 0000 0000 0000 0000 0000 0000 00 ...............
2006-02-23-17.53.12.284000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:9 Database:DEVM_D B
Error in agent servicing application with PRODUCT SIGNATURE:
0x189DC290 : 0x32313038304C5 153 SQL08012
2006-02-23-17.53.12.284001 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:10 Database:DEVM_D B
Error in agent servicing application with APPLICATION NAME:
0x189DC266 : 6465 7665 6E76 2E65 7865 devenv.exe
2006-02-23-17.53.12.300000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
DRDA Application Server sqljsSignalHand ler Probe:10 Database:DEVM_D B
DIA0505I Execution of a component signal handling function has begun.
2006-02-23-17.53.12.315000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
DRDA Application Server sqljsSignalHand ler Probe:911 Database:DEVM_D B
Source Type not DRDA AS. SourceType =
0x025B82A0 : 0x00000004 ....
2006-02-23-17.53.12.315001 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
DRDA Application Server sqljsSignalHand ler Probe:20 Database:DEVM_D B
DIA0506I Execution of a component signal handling function is complete.
2006-02-23-17.53.12.315002 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
relation data serv sqlrr_signal_ha ndler Probe:50 Database:DEVM_D B
DIA0505I Execution of a component signal handling function has begun.
PID:1600 TID:440 Node:000 Title: RDS AGENT CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLCA
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS UCINTFC
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS UCINTFC: pCurrentPID =
0x1BD7A3D8 : 0x3C090F60 `. <
PID:1600 TID:440 Node:000 Title: RDS UCINTFC:
pCurrentPID->pkgnamcsn.rdbc olid =
0x3C090F82 : 0x2020534543415 357 DB_USER
PID:1600 TID:440 Node:000 Title: RDS UCINTFC: pCurrentPID->rdbcolidLen =
0x3C090F64 : 0x0008 ..
PID:1600 TID:440 Node:000 Title: RDS UCINTFC: pCurrentPID->rdbname =
0x3C090F70 : 4143 4553 5044 4D20 2020 2020 2020 2020 DEVM_DB
0x3C090F80 : 2020
PID:1600 TID:440 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgname =
0x3C090F94 : 5037 3531 3232 3839 2020 2020 2020 2020 P7512289
0x3C090FA4 : 2020
PID:1600 TID:440 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgcnstkn =
0x3C090FA6 : 0x574358527A574 263 cBWzRXCW
PID:1600 TID:440 Node:000 Title: RDS UCINTFC: pCurrentPID->pkgsn =
0x3C090FAE : 0x0002 ..
Trap c0000005 detected in db2diag call from [0,0,0] trapfile created
PID:1600 TID:440 Node:000 Title: RDS APPL CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS NESTED APPL CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS SP REGISTERS CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS TRAN CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS NESTED TRAN CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS COORD CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS NESTED CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: RDS INVOCATION CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
2006-02-23-17.53.12.409000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
relation data serv sqlrr_dump_ffdc Probe:20 Database:DEVM_D B
DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007
PID:1600 TID:440 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL08013
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:
PID:1600 TID:440 Node:000 Title: SQLCA
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: CREATOR
0x1D69198C : 0x2020534543415 357 DB_USER
PID:1600 TID:440 Node:000 Title: PACKAGE
0x1D6919AA : 0x3938323231353 750 P7512289
PID:1600 TID:440 Node:000 Title: CREATOR
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: PACKAGE
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: REQUEST TYPE
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: APM COMMON INFO
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: PACKAGE ENTRY
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: CACHED PACKAGE ENTRY
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: Recursive dump_sect
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SECTION NUMBER
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SECTION ENTRY
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SECTION CURSOR INFO
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SIBLING ENTRY
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
2006-02-23-17.53.12.518000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
relation data serv sqlrr_dump_ffdc Probe:902 Database:DEVM_D B
DIA8516C A severe internal processing error has occurred.
ZRC=0x87120007
2006-02-23-17.53.12.518001 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
relation data serv sqlrr_dump_ffdc Probe:902 Database:DEVM_D B
PID:1600 TID:440 Node:000 Title: SQLE_DBCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_DBCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_AGENT_CB Pointer:
0x1BD7A380 : 0x18DD0080 €.Ý.
PID:1600 TID:440 Node:000 Title: SQLD_AGENT_CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_TRAN_CB Pointer
0x1BD7A388 : 0x18ADC3F0 ðÃ*.
PID:1600 TID:440 Node:000 Title: SQLD_TRAN_CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_APP_CB Pointer
0x1BD7A384 : 0x18ADC200 .Â*.
PID:1600 TID:440 Node:000 Title: SQLD_APP_CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: >> Begin CURSOR dump:
OPEN PERM CURSORS: >>
PID:1600 TID:440 Node:000 Title: << End CURSOR dump:
OPEN PERM CURSORS: <<
PID:1600 TID:440 Node:000 Title: >> Begin CURSOR dump:
OPEN TEMP CURSORS: >>
PID:1600 TID:440 Node:000 Title: << End CURSOR dump:
OPEN TEMP CURSORS: <<
PID:1600 TID:440 Node:000 Title: >> Begin CURSOR dump:
CLOSED CURSORS: >>
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=0, obj(FID)=11, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=0, obj(FID)=24, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=0, obj(FID)=81, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=0, obj(FID)=30, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=415, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=417, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=421, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=424, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=146, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=203, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLD_CCB:
pool(TID)=2, obj(FID)=15, indexid(IID)=0, class=0
PID:1600 TID:440 Node:000 Title: SQLD_CCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: << End CURSOR dump:
CLOSED CURSORS: <<
PID:1600 TID:440 Node:000 Title: SQLI_CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLE_AGENT_PRIV ATECB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLE_APP_CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLE_TRAN_CB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLP_LFPB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLP_ACB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLP_DBCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLP_TENTRY
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: locklist
Check C:\PROGRA~1\IBM \SQLLIB\DB2\l01 74.000 for additional data.
PID:1600 TID:440 Node:000 Title: NLSWA:DatabaseA pp
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: NLSWA:DatabaseD atabase
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: nlsacb
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: dbNLSAppCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: UnicodeNLSAppCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
2006-02-23-17.53.12.722001 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
access plan manager sqlra_sqlC_dump Probe:25 Database:DEVM_D B
Context info dumped! Check C:\PROGRA~1\IBM \SQLLIB\DB2\a16 00440.000 for
additional data.
2006-02-23-17.53.12.737000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
access plan manager sqlra_sqlW_raw_ dump Probe:25 Database:DEVM_D B
Private workspace info dumped! Check
C:\PROGRA~1\IBM \SQLLIB\DB2\a16 00440.000 for additional data.
2006-02-23-17.53.12.753000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
access plan manager sqlra_sqlW_raw_ dump Probe:25 Database:DEVM_D B
Shared workspace info dumped! Check
C:\PROGRA~1\IBM \SQLLIB\DB2\a16 00440.000 for additional data.
2006-02-23-17.53.12.768000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
relation data serv sqlrr_signal_ha ndler Probe:20 Database:DEVM_D B
DIA0506I Execution of a component signal handling function is complete.
PID:1600 TID:440 Node:000 Title: SQLE_AGENT_PRIV ATECB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
PID:1600 TID:440 Node:000 Title: SQLE_AGENTCB
Dump File:C:\PROGRA~ 1\IBM\SQLLIB\DB 2\1600440.000
2006-02-23-17.53.13.815000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleCleanupReso urces Probe:5 Database:DEVM_D B
DiagData
0x1BD7FE0C : 0x00000000 ....
2006-02-23-17.53.13.815001 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
routine_infrast ructure sqlerKillAllFmp s Probe:5 Database:DEVM_D B
Bringing down all db2fmp processes as part of db2stop
0x1BD7FCD8 : 0x00000000 ....
2006-02-23-17.57.18.597000 Instance:DB2 Node:000
PID:2296(db2sys cs.exe) TID:2284 Appid:none
base sys utilities LicCheckProcess ors Probe:20
SQL8017W The number of processors on this machine exceeds the defined
entitlement of "1" for the product "DB2 Enterprise Server Edition". The
number of processors on this machine is "2". You should purchase
additional
processor based entitlements from your IBM representative or authorized
dealer
and update your license using the License Center or the db2licm command
line
utility. For more information on updating processor based licenses, refer
to
the Quick Beginnings manual for your platform. For more information on
the
db2licm utility, refer to the DB2 Command Reference.
2006-02-23-17.57.19.675000 Instance:DB2 Node:000
PID:2296(db2sys cs.exe) TID:2284 Appid:none
base sys utilities startdbm Probe:911
ADM7513W Database manager has started.
2006-02-23-17.57.51.800000 Instance:DB2 Node:000
PID:2296(db2sys cs.exe) TID:440 Appid:AC10E00F. ED04.00A7C31227 51
base sys utilities sqledint Probe:30
Crash Recovery is needed.
2006-02-23-17.57.52.003000 Instance:DB2 Node:000
PID:2296(db2sys cs.exe) TID:440 Appid:AC10E00F. ED04.00A7C31227 51
recovery manager sqlpresr Probe:410 Database:DEVM_D B
Crash recovery started. LowtranLSN 000000005BDC44E E MinbuffLSN
000000005BDBD1E 8
2006-02-23-17.57.52.003002 Instance:DB2 Node:000
PID:2296(db2sys cs.exe) TID:440 Appid:AC10E00F. ED04.00A7C31227 51
recovery manager sqlprecm Probe:125 Database:DEVM_D B
Using parallel recovery with 5 agents 11 QSets 77 queues and 2 chunks
2006-02-23-17.57.52.018000 Instance:DB2 Node:000
PID:2296(db2sys cs.exe) TID:440 Appid:AC10E00F. ED04.00A7C31227 51
recovery manager sqlprecm Probe:400 Database:DEVM_D B
DIA2051W Forward phase of crash recovery has completed. Next LSN is
"000000005BDC44 EE".
2006-02-23-17.57.52.034001 Instance:DB2 Node:000
PID:2296(db2sys cs.exe) TID:440 Appid:AC10E00F. ED04.00A7C31227 51
recovery manager sqlpresr Probe:3170 Database:DEVM_D B
Crash recovery completed. Next LSN is 000000005BDC44E E
*************** *************** *************** *************** *************** *************** ***
Regards
Praveen
Hi Mike
Thanks for the reply.
Yes you are correct .We have 2 processors.But I found that I can update
the no. of processors successfully using
db2licm -n "Product Password" No._of_processo rs
What happens if I use this command?
Praveen
Praveen_db2 wrote: Hi All
I am getting strange errors in my db2diag.log can any one tell me what
these errors mean??
Following is the code from my db2diag.log
*************** *************** *************** *************** *************** *************** *** 2006-02-23-17.53.12.253000 Instance:DB2 Node:000
PID:1600(db2sys cs.exe) TID:440 Appid:AC10E010. J70A.00E8831222 50
base sys utilities sqleagnt_sigseg vh Probe:1 Database:DEVM_D B
This is a segmentation violation that DB2 encountered.
Either this is a defect/bug in DB2, or you were running external routines
(C/C++ functions/procedures). In the first case, it is a DB2 problem that
needs to be fixed. Please call IBM support in that case. If you are
running external routines, you might want to consider switching those to
FENCED routines so that they cannot simply bring down the DB2 engine when
they crash.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
mike_li wrote: It looks like license issue involved here. You can use db2licm -l to
see what product you installed and what kind license you current have.
If you use more processors for your
product, you need to contact IBM to buy additional license.
No, this is not a licensing issue. Why do you think so?
--
Knut Stolze
DB2 Information Integration Development
IBM Germany This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Sean C. |
last post by:
Helpful folks,
I've just migrated our test server from V7.2 -FP11 to V8.1.3, on WinNT 4.0.
Everything went pretty darn smoothly, however I get the following errors
when using the Control Center:
Click on the 'Event Monitor' folder, and an error dialog box
appears containing the following text:
SQL0713N The replacement value for
|
by: Fan Ruo Xin |
last post by:
Last monday, I tried to create a working table, and failed because of 'Log
Full'. There were two applications running at that time - one is autoload
(during the split phase), another one is "insert into a (NLI) ... SELECT ...
FROM ...".
I checked the db2diag.log (level=4) and notification file. It was
interesting that there was no any information about log full.
I had to kill the autoload process.
I haven'g got time to see if I can...
|
by: Shawn |
last post by:
We are on IBM DB2 7.1 ON WINDOWS. The db2diag.log is not working and
no new line written into it for few days. The last lines in
db2diag.log shows:
Warning: active log held by dirty pages.
Decrease softmax and/or increase num_iocleaners.
repeatedly . What is the problem? How can resolve it quickly? The
applicatipna dnLDAP is up and running though.
|
by: uthuras |
last post by:
I'm having strange problem after upgrading my database using db2updv8
utility. The database reside on AIX 5.2 box. I'm using DB2 V8.1 FP 4a.
My developer use DataStage 7.0 to access the database on the AIX box.
Each time when a job is executed at DataStage, it will give the
following warning messages
CIF41TSDSIFM01..LOAD_JOB_LOG.W_STGDB: SQLTables: Error retrieving
system catalog information for requested tables(s).
|
by: Rhino |
last post by:
I am trying to write a trigger/UDF combination that closely follows the
example given in the following DeveloperWorks article:
http://www-106.ibm.com/developerworks/db2/library/techarticle/0205bhogal/0205bhogal.html
Unfortunately, when my UDF starts to compose the email, something goes wrong
and DB2 begins writing to db2diag.log - and writing, and writing, and
writing. Millions of lines get written if I don't kill the processes.
I've...
| | |
by: Odd Bjørn Andersen |
last post by:
I have systems both on Windows and AIX. With DB2 ESE v8.1 fixpack 6a. On all
of these I get this message in the db2diag.log:
2005-08-18-03.20.09.609000+120 I3571H188 LEVEL: Error
PID : 5832 TID : 4184
FUNCTION: DB2 Tools, DB2 administration server, transmitRunCmdMessage,
probe:30
It says there is an error, but I am not able to figure out what it might be.
Every time a scheduled job in the Task Center is...
|
by: yerim y via DBMonster.com |
last post by:
Hello there,
I am having these recurring errors on the diaglog of my DB2 server and they
are the same ones on all databases. Can someone please help me diagnose it.
What's making me nervous is the level is marked as severe.
Thank you
2005-09-10-06.18.53.984000-240 I1005918H397 LEVEL: Severe
PID : 1192 TID : 1984 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : PSU
|
by: soccertl |
last post by:
I wrote code that parses the db2diag.log to look for errors that would
require us to generate a message to a service center indicating
something is wrong. My problem is trying to figure out what the errors
are. From studying the log, I noticed the codes on the first line after
the date/time are all the same for the same message. For example:
2005-11-17-09.55.31.988098-420 E5537C330 LEVEL: Error (OS)
PID : 21700 ...
|
by: mngrl |
last post by:
I have DB2 V8.2 installed on an AIX system and I want to see the sql
errors that are occurring on the system. When I look at db2diag.log
the messages all look like this:
2006-05-09-07.58.56.097229-300 I252960516G411 LEVEL: Severe
PID : 14832 TID : 3086866112 PROC : db2agent
(instance) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-1028 APPID: GA000BEF.I70F.01A009125841
FUNCTION: DB2 UDB,...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
