By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,028 Members | 1,092 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,028 IT Pros & Developers. It's quick & easy.

Need help with an automated backup process problem.

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
U can also perform a quiesce on the database. ( authorities should be
revoked for this if necessary).

Nov 12 '05 #3

P: n/a
U can also perform a quiesce on the database. ( authorities should be
revoked for this if necessary).

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.