Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007
    Posts
    2

    Unanswered: 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...

    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...

    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

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    On Unix/Linux, 0x870F003D error can be generated when the instance was terminated abnormally and didn't clean up the IPC resources before restarting. I'm not sure about Windows. Try to restart the server and see if that helps to resolve the error.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •