09-08-09, 06:45
|
|
Registered User
|
|
Join Date: May 2007
Posts: 2
|
|
|
Backup Error - Message queue already created
|
|
DB2 9.1 fp3 on Windows
I am trying to back up a database on one of my servers. I have a task in the DB2 task center to do this. The task is set up to run nightly. For the first 3 weeks, I didn't have any problems. Then, I went on vacation, and it has been failing since. We all know that the reason it is failing is because I went on vacation.
Anyway, here is what is in the DB2diag.log for this...
Quote:
2009-09-08-00.15.22.937000-300 E19385465H402 LEVEL: Info
PID : 564 TID : 2300 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CARHORSP
APPHDL : 0-830 APPID: 10.1.2.45.61710.090908051524
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1391
MESSAGE : Starting an online db backup.
2009-09-08-00.15.22.937000-300 I19385869H502 LEVEL: Error
PID : 564 TID : 2300 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CARHORSP
APPHDL : 0-830 APPID: 10.1.2.45.61710.090908051524
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, database utilities, sqluCreateQueue, probe:131
MESSAGE : ZRC=0x870F003D=-2029060035=SQLO_QUE_DUP
"Message queue already created"
DATA #1 : String, 23 bytes
Creating message queue
2009-09-08-00.15.22.937000-300 E19386373H505 LEVEL: Severe
PID : 564 TID : 2300 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CARHORSP
APPHDL : 0-830 APPID: 10.1.2.45.61710.090908051524
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, database utilities, sqlubCreateQueue, probe:926
DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
-2044
DATA #2 : Hexdump, 8 bytes
0x549D5F38 : 04F8 FFFF 0100 0000 ........
2009-09-08-00.15.22.937000-300 E19386880H890 LEVEL: Severe
PID : 564 TID : 2300 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CARHORSP
APPHDL : 0-830 APPID: 10.1.2.45.61710.090908051524
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, database utilities, sqlubCreateQueue, probe:926
MESSAGE : SQL2044N An error occurred while accessing a message queue. Reason
code: "".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2044 sqlerrml: 1
sqlerrmc: 1
sqlerrp : sqlubCre
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:
2009-09-08-00.15.22.984000-300 E19387772H381 LEVEL: Severe
PID : 564 TID : 2300 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CARHORSP
APPHDL : 0-830 APPID: 10.1.2.45.61710.090908051524
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:850
MESSAGE : Backup terminated.
|
Here is the db2diag.log from the last time it worked...
Quote:
2009-09-03-00.15.11.937000-300 E19234990H402 LEVEL: Info
PID : 564 TID : 2244 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CARHORSP
APPHDL : 0-150 APPID: 10.1.2.45.57610.090903051513
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1391
MESSAGE : Starting an online db backup.
2009-09-03-00.15.16.125000-300 E19235394H324 LEVEL: Warning
PID : 564 TID : 2844 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
MESSAGE : ADM1844I Started archive for log file "S0000057.LOG".
2009-09-03-00.15.16.343000-300 E19235720H450 LEVEL: Warning
PID : 564 TID : 2844 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3170
MESSAGE : ADM1846I Completed archive for log file "S0000057.LOG" to
"n:\db2logs\carhorse\archive\DB2\CARHORSP\NODE0000 \C0000003\" from
"n:\db2logs\carhorse\active\".
2009-09-03-00.15.17.046000-300 E19236172H377 LEVEL: Info
PID : 564 TID : 2244 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CARHORSP
APPHDL : 0-150 APPID: 10.1.2.45.57610.090903051513
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:833
MESSAGE : Backup complete.
|
Any help would be greatly appreciated.
Thanks
|
|
dBforums
>
Backup Error - Message queue already created
Linear Mode
