473,387 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Need help with an automated backup process problem.

We are running DB2 8.1 on AIX 5.2.
DB2level shows:

DB21085I Instance "db2inst1" uses "32" bits and DB2 code release
"SQL08016"
with level identifier "02070106".
Informational tokens are "DB2 v8.1.1.56", "s040616", "U497635", and FixPak
"6".
Product is installed at "/usr/opt/db2_08_01".

We have a nightly script that does db2stop force then waits about 20
seconds. Issues another db2stop force. Waits another 20 seconds then
does a db2 list applications. Then the script performs full backups of
two databases.

Everyone once in a while the first backup fails because the database is in
use. Adding the second force stop and delay reduced the frequency of the
problem. The conclusion was that some process was hanging on so we added
the list applications.

It failed again but we only got erros on the list applications. Here is
what our script returns:

DB20000I The FORCE APPLICATION command completed successfully.
DB21024I This command is asynchronous and may not be effective
immediately.

Give db2 20 sec to close all connections...
SQL1224N A database agent could not be started to service a request, or
was
terminated as a result of a database system shutdown or a force command.

SQLSTATE=55032
Starting database backup of rmrsadb1...
DB20000I The FORCE APPLICATION command completed successfully.
DB21024I This command is asynchronous and may not be effective
immediately.

SQL1044N Processing was cancelled due to an interrupt. SQLSTATE=57014
Stopping DB2...
The following applications are still running after 40 seconds
SQL30081N A communication error has been detected. Communication
protocol
being used: "". Communication API being used: "". Location where the
error
was detected: "". Communication function detecting the error: "".
Protocol
specific error code(s): "", "", "". SQLSTATE=08001
Starting database backup of icmrsadb...
SQL30081N A communication error has been detected. Communication
protocol
being used: "*". Communication API being used: "*". Location where the
error
was detected: "". Communication function detecting the error:
"create_agent".
Protocol specific error code(s): "54", "*", "*".
Starting database backup of rmrsadb1...
SQL30081N A communication error has been detected. Communication
protocol
being used: "*". Communication API being used: "*". Location where the
error
was detected: "". Communication function detecting the error:
"create_agent".
Protocol specific error code(s): "54", "*", "*".
Stopping DB2...
SQL6036N START or STOP DATABASE MANAGER command is already in progress.
Stopping DB2 administration server...
stopDA: db2admin: not found.

Here is the db2diag.log file for that night:

2005-03-01-21.25.56.020166 Instance:db2inst1 Node:000
PID:57560(db2loggr (RMRSADB1) 0) TID:1 Appid:none
data protection sqlpghck Probe:1390

ExtNum 8060, state 401, baselsn 00000007B17B8000 nextlsn 00000007B1B93B0D

2005-03-01-21.30.29.232551 Instance:db2inst1 Node:000
PID:49596(db2loggr (ICMRSADB) 0) TID:1 Appid:none
data protection sqlpghck Probe:1390

ExtNum 31184, state 401, baselsn 0000001DC1EB8000 nextlsn
0000001DC1F0C957

2005-03-01-21.30.38.329882 Instance:db2inst1 Node:000
PID:77516(db2agent (ICMRSADB) 0) TID:1
Appid:*LOCAL.db2inst1.0D3332023031
database utilities sqlubcka Probe:0 Database:ICMRSADB

Starting a full database backup.

2005-03-01-22.07.00.785813 Instance:db2inst1 Node:000
PID:77516(db2agent (ICMRSADB) 0) TID:1
Appid:*LOCAL.db2inst1.0D3332023031
database utilities sqlubPollMsg Probe:1 Database:ICMRSADB

DiagData
0x544E8870 : 0xFFFFFB38 ÿÿû8

2005-03-01-22.07.00.966865 Instance:db2inst1 Node:000
PID:77516(db2agent (ICMRSADB) 0) TID:1
Appid:*LOCAL.db2inst1.0D3332023031
database utilities sqlubPollMsg Probe:1 Database:ICMRSADB

0x544E8870 : 0xFFFFFB38 ÿÿû8

2005-03-01-22.07.03.708844 Instance:db2inst1 Node:000
PID:77516(db2agent (ICMRSADB) 0) TID:1
Appid:*LOCAL.db2inst1.0D3332023031
database utilities sqlubcka Probe:140 Database:ICMRSADB

Backup Terminated.

2005-03-01-22.07.12.765479 Instance:db2inst1 Node:000
PID:55220(db2agent (RMRSADB1) 0) TID:1
Appid:*LOCAL.db2inst1.0D3332030708
base sys utilities sqle_remap_errors Probe:100 Database:RMRSADB1

ZRC 0x80040003 remapped to SQLCODE -1044

2005-03-01-22.07.12.910078 Instance:db2inst1 Node:000
PID:55220(db2agent (RMRSADB1) 0) TID:1
Appid:*LOCAL.db2inst1.0D3332030708
base sys utilities sqlesrsu Probe:140 Database:RMRSADB1

DIA8003C The interrupt has been received.
ZRC=0x80040003ÿ

2005-03-01-22.07.13.259888 Instance:db2inst1 Node:000
PID:54066(db2bp) TID:1 Appid:none
database utilities sqlubckp Probe:26

DiagData
0x20286104 : 0xFFFFFBEC ÿÿûì

2005-03-01-22.07.31.187973 Instance:db2inst1 Node:000
PID:97292(db2bp) TID:1 Appid:none
database utilities sqlubckp Probe:26

DiagData
0x20286104 : FFFF 8A7F 3534 FF2A FF2A FF2A FF2A FFFF ÿÿ..54ÿ*ÿ*ÿ*ÿ*ÿÿ
0x20286114 : 6372 6561 7465 5F61 6765 6E74 FF00 create_agentÿ.

2005-03-01-22.07.31.383912 Instance:db2inst1 Node:000
PID:97292(db2bp) TID:1 Appid:none
database utilities sqlubckp Probe:26

DiagData
0x20286104 : FFFF 8A7F 3534 FF2A FF2A FF2A FF2A FFFF ÿÿ..54ÿ*ÿ*ÿ*ÿ*ÿÿ
0x20286114 : 6372 6561 7465 5F61 6765 6E74 FF00 create_agentÿ.

2005-03-01-22.07.37.804194 Instance:db2inst1 Node:000
PID:42224(db2sysc 0) TID:1 Appid:none
routine_infrastructure sqlerKillAllFmps Probe:5

Bringing down all db2fmp processes as part of db2stop
0x2FF217D0 : 0x00000000 ....

2005-03-01-22.07.38.314666 Instance:db2inst1 Node:000
PID:93056(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.551961 Instance:db2inst1 Node:000
PID:25192(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.400955 Instance:db2inst1 Node:000
PID:92796(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.395334 Instance:db2inst1 Node:000
PID:22268(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.659909 Instance:db2inst1 Node:000
PID:66914(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.572608 Instance:db2inst1 Node:000
PID:65090(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.222695 Instance:db2inst1 Node:000
PID:31558(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.433331 Instance:db2inst1 Node:000
PID:86448(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.318699 Instance:db2inst1 Node:000
PID:36902(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.354313 Instance:db2inst1 Node:000
PID:89550(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.620832 Instance:db2inst1 Node:000
PID:31036(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.220112 Instance:db2inst1 Node:000
PID:34766(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.617541 Instance:db2inst1 Node:000
PID:78208(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.146195 Instance:db2inst1 Node:000
PID:61996(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.590700 Instance:db2inst1 Node:000
PID:72804(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.796155 Instance:db2inst1 Node:000
PID:74800(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.018161 Instance:db2inst1 Node:000
PID:60898(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.804794 Instance:db2inst1 Node:000
PID:37334(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.559767 Instance:db2inst1 Node:000
PID:38962(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.274550 Instance:db2inst1 Node:000
PID:44920(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.265962 Instance:db2inst1 Node:000
PID:86090(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.098545 Instance:db2inst1 Node:000
PID:31760(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.337881 Instance:db2inst1 Node:000
PID:24062(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.064848 Instance:db2inst1 Node:000
PID:19950(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.677962 Instance:db2inst1 Node:000
PID:67718(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.830720 Instance:db2inst1 Node:000
PID:35694(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.452784 Instance:db2inst1 Node:000
PID:66268(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:4

DIA8501C A buffer pool logic error has occurred.
ZRC=0x870F0002ÿ

2005-03-01-22.07.41.817710 Instance:db2inst1 Node:000
PID:62442(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.895527 Instance:db2inst1 Node:000
PID:71512(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.522612 Instance:db2inst1 Node:000
PID:27376(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.195479 Instance:db2inst1 Node:000
PID:58100(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.939553 Instance:db2inst1 Node:000
PID:39526(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.986758 Instance:db2inst1 Node:000
PID:71998(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.381070 Instance:db2inst1 Node:000
PID:52532(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.424752 Instance:db2inst1 Node:000
PID:21962(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.505146 Instance:db2inst1 Node:000
PID:89672(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.300133 Instance:db2inst1 Node:000
PID:84406(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.411209 Instance:db2inst1 Node:000
PID:39282(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.522986 Instance:db2inst1 Node:000
PID:32142(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.289873 Instance:db2inst1 Node:000
PID:65376(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.618385 Instance:db2inst1 Node:000
PID:17100(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.42.037273 Instance:db2inst1 Node:000
PID:68886(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.039468 Instance:db2inst1 Node:000
PID:31466(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.012378 Instance:db2inst1 Node:000
PID:25018(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.397258 Instance:db2inst1 Node:000
PID:49862(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.492759 Instance:db2inst1 Node:000
PID:50710(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.787721 Instance:db2inst1 Node:000
PID:84696(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.907563 Instance:db2inst1 Node:000
PID:39736(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.276603 Instance:db2inst1 Node:000
PID:32382(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.317231 Instance:db2inst1 Node:000
PID:58446(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.033575 Instance:db2inst1 Node:000
PID:21560(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.557598 Instance:db2inst1 Node:000
PID:74456(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.627075 Instance:db2inst1 Node:000
PID:35004(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.42.132811 Instance:db2inst1 Node:000
PID:77054(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.306138 Instance:db2inst1 Node:000
PID:35956(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.771774 Instance:db2inst1 Node:000
PID:37732(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.521891 Instance:db2inst1 Node:000
PID:87642(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.032920 Instance:db2inst1 Node:000
PID:28456(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.660363 Instance:db2inst1 Node:000
PID:51676(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.462469 Instance:db2inst1 Node:000
PID:90746(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.344523 Instance:db2inst1 Node:000
PID:69954(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.799452 Instance:db2inst1 Node:000
PID:21238(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.222558 Instance:db2inst1 Node:000
PID:58324(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.470877 Instance:db2inst1 Node:000
PID:56506(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.009954 Instance:db2inst1 Node:000
PID:86732(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.490142 Instance:db2inst1 Node:000
PID:63708(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.777958 Instance:db2inst1 Node:000
PID:42316(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.366747 Instance:db2inst1 Node:000
PID:53188(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.494333 Instance:db2inst1 Node:000
PID:72248(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.674451 Instance:db2inst1 Node:000
PID:28832(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.08.00.886779 Instance:db2inst1 Node:000
PID:82060(db2stop2) TID:1 Appid:none
base sys utilities DB2StopMain Probe:911

ADM7514W Database manager has stopped.

2005-03-01-22.07.39.510935 Instance:db2inst1 Node:000
PID:56022(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.571840 Instance:db2inst1 Node:000
PID:74012(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.437450 Instance:db2inst1 Node:000
PID:59380(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.821065 Instance:db2inst1 Node:000
PID:9490(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.001826 Instance:db2inst1 Node:000
PID:61768(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.034889 Instance:db2inst1 Node:000
PID:80020(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.919006 Instance:db2inst1 Node:000
PID:37960(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.133106 Instance:db2inst1 Node:000
PID:52950(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.348949 Instance:db2inst1 Node:000
PID:34238(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.181990 Instance:db2inst1 Node:000
PID:53518(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.41.850591 Instance:db2inst1 Node:000
PID:88654(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.672924 Instance:db2inst1 Node:000
PID:48430(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.38.352466 Instance:db2inst1 Node:000
PID:93428(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.593842 Instance:db2inst1 Node:000
PID:40302(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.40.620496 Instance:db2inst1 Node:000
PID:71224(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.07.39.746573 Instance:db2inst1 Node:000
PID:44610(db2fmp (idle) 0) TID:1 Appid:none
common communication sqlccipcdarihandshake Probe:3

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x83000024".

2005-03-01-22.11.02.577835 Instance:db2inst1 Node:000
PID:52954(db2spmrsy 0) TID:1 Appid:none
oper system services sqloopenp Probe:60

errno:
0x2FF1C820 : 0x00000011 ....

PID:52954 TID:1 Node:000 Title: Path/Filename
/home/db2inst1/sqllib/spmlog/SPMLOG.LCF

2005-03-01-22.11.02.931886 Instance:db2inst1 Node:000
PID:54126(db2star2) TID:1 Appid:none
base sys utilities DB2StartMain Probe:911

ADM7513W Database manager has started.


Nov 12 '05 #1
3 6267
Try this

disconnect all users/applications

change the port (SVCENAME)

restart database

backup

change the port backup to original

restart database

Nov 12 '05 #2
U can also perform a quiesce on the database. ( authorities should be
revoked for this if necessary).

Nov 12 '05 #3
U can also perform a quiesce on the database. ( authorities should be
revoked for this if necessary).

Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: eddie wang | last post by:
Hello, I am running SQl Server 7.0. I have a database maintenance plan that runs once a day to perform backups. It seemed that the database backup files were created successfully. The problem...
13
by: Andy K | last post by:
Hi , I'm wondering what's going on with a restore I'm trying to do . My DB2 version is a 7.2 on a Linux RH ES 2.1 . I've copy a recent backup that was on NAS for a test on my machine . I...
2
by: Tim Hunter | last post by:
Hi, I am using Access-2003 under WinXP. I am also running a split database.. I have an application that runs in a college environment where if it can happen it will happen. Currently my...
1
by: | last post by:
Hi all My requirement is to "on button_click, backup a SQL database using SQLDMO.Backup object and update the progress in a ProgressBar. The problem is the progress bar does not update at all...
2
by: | last post by:
Hi all, continued from yesterday's posting... I still haven't found a solution to this issue. I put a breakpoint in private void SqlBackupPercentComplete(string message, int Percent) {...
1
by: | last post by:
Hi all I am posting this to check if anyone could help me. The problem still persists. I am beginner in C#. Thanks. Subject: SQLDMO.Backup and ProgressBar - help please From: ...
5
by: HSP | last post by:
hi. i need to restore an old database. The db was backed up using a DLT drive, using 2 volumes. The content for the tapes was copied to file onto Solaris machine using rsh and dd (for backup...
160
by: RG | last post by:
Greetings friends, This semester I have started a course in C programming. I was moving along fine until I reached to the topic of loops (feeling embarrassed among you elite programmers). My...
1
by: bhd282 | last post by:
Regarding this message: ADM10502W Health indicator "Database Backup Required" ("db.db_backup_req") is in state "Automated backup failed" on "database" "db2inst2.WAREHOUS". Is there any place...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.