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