Prev: Regarding database Size
Next: Rounding error
From: satish mullapudi on 31 Aug 2009 04:58 Hi Everybody, Here is the desc. of our environment. DB2: v8.1 fp17 to v9.5 fp 3a OS: Win 2003 Server SP 1 RAM: 3.5 GB HDD: 80GB DB size 7.5 GB 1. Since days, we hve been getting a strange warning message in the event viewer logs: The description for Event ID ( 1 ) in Source ( DB2REMOTECMD_DB2COPY1 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: rcmdTcpipListener, Failed to configure listener's socket address. Check for port (db2ccmsrv) in SERVICES file, rc = 118423736., , , , , , , , . 2. Db2 on the server is abruptly going down without any reason. There is no info recorded either in the diag.log also. This is what strange! received this error in the diag log after a long while: 2009-08-30-10.28.11.504000+000 I23941959H548 LEVEL: Error PID : 11712 TID : 10776 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : METRICS APPHDL : 0-51 APPID: *LOCAL.DB2.090830102634 AUTHID : A3INDCOD EDUID : 10776 EDUNAME: db2agent (METRICS) 0 FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::update, probe: 60 RETCODE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT DETECTED" DIA8003C The interrupt has been received. Can anybody throw some light on whatz really happening . We are not able to get. Thanks in advance, Satish
From: Serge Rielau on 31 Aug 2009 07:57 satish mullapudi wrote: > Hi Everybody, > Here is the desc. of our environment. > DB2: v8.1 fp17 to v9.5 fp 3a > OS: Win 2003 Server SP 1 > RAM: 3.5 GB > HDD: 80GB > DB size 7.5 GB > 1. Since days, we hve been getting a strange warning message in the > event viewer logs: > The description for Event ID ( 1 ) in Source ( DB2REMOTECMD_DB2COPY1 ) > cannot be found. The local computer may not have the necessary > registry information or message DLL files to display messages from a > remote computer. You may be able to use the /AUXSOURCE= flag to > retrieve this description; see Help and Support for details. The > following information is part of the event: rcmdTcpipListener, Failed > to configure listener's socket address. Check for port (db2ccmsrv) in > SERVICES file, rc = 118423736., , , , , , , , . > 2. Db2 on the server is abruptly going down without any reason. There > is no info recorded either in the diag.log also. This is what > strange! > received this error in the diag log after a long while: > 2009-08-30-10.28.11.504000+000 I23941959H548 LEVEL: Error > PID : 11712 TID : 10776 PROC : db2syscs.exe > INSTANCE: DB2 NODE : 000 DB : METRICS > APPHDL : 0-51 APPID: *LOCAL.DB2.090830102634 > AUTHID : A3INDCOD > EDUID : 10776 EDUNAME: db2agent (METRICS) 0 > FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::update, probe: > 60 > RETCODE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT > DETECTED" > DIA8003C The interrupt has been received. > Can anybody throw some light on whatz really happening . We are not > able to get. > > Thanks in advance, > Satish I would call support.... The obvious question is of course whether DB2 is right. Is someone (or some service) shooting down DB2? -- Serge Rielau SQL Architect DB2 for LUW IBM Toronto Lab
From: Satish Mullapudi on 31 Aug 2009 08:25 On Aug 31, 4:57 pm, Serge Rielau <srie...(a)ca.ibm.com> wrote: > satish mullapudi wrote: > > Hi Everybody, > > Here is the desc. of our environment. > > DB2: v8.1 fp17 to v9.5 fp 3a > > OS: Win 2003 Server SP 1 > > RAM: 3.5 GB > > HDD: 80GB > > DB size 7.5 GB > > 1. Since days, we hve been getting a strange warning message in the > > event viewer logs: > > The description for Event ID ( 1 ) in Source ( DB2REMOTECMD_DB2COPY1 ) > > cannot be found. The local computer may not have the necessary > > registry information or message DLL files to display messages from a > > remote computer. You may be able to use the /AUXSOURCE= flag to > > retrieve this description; see Help and Support for details. The > > following information is part of the event: rcmdTcpipListener, Failed > > to configure listener's socket address. Check for port (db2ccmsrv) in > > SERVICES file, rc = 118423736., , , , , , , , . > > 2. Db2 on the server is abruptly going down without any reason. There > > is no info recorded either in the diag.log also. This is what > > strange! > > received this error in the diag log after a long while: > > 2009-08-30-10.28.11.504000+000 I23941959H548 LEVEL: Error > > PID : 11712 TID : 10776 PROC : db2syscs.exe > > INSTANCE: DB2 NODE : 000 DB : METRICS > > APPHDL : 0-51 APPID: *LOCAL.DB2.090830102634 > > AUTHID : A3INDCOD > > EDUID : 10776 EDUNAME: db2agent (METRICS) 0 > > FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::update, probe: > > 60 > > RETCODE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT > > DETECTED" > > DIA8003C The interrupt has been received. > > Can anybody throw some light on whatz really happening . We are not > > able to get. > > > Thanks in advance, > > Satish > > I would call support.... > > The obvious question is of course whether DB2 is right. Is someone (or > some service) shooting down DB2? > > -- > Serge Rielau > SQL Architect DB2 for LUW > IBM Toronto Lab That sounds good. Will be contacting them & will update the post. Tq Serge for the suggestion. regards, Satish
|
Pages: 1 Prev: Regarding database Size Next: Rounding error |