IBM Support

LI73475: DB2BACKUP API FAILS WITH: SQL CODE: -2429

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • db2Backup API will return
    
    SQL code: -2429
    Message: SQL2429N  The database backup failed.  The following
    database partitions returned errors: "0,1".
    
    
    Case 1,  files have not been created yet.
    ------------------------------------------------
    Each node will return:
    - Node 0: backup size 0 MB, SQL code -1013; message SQL1013N
    The database alias name or database name "" could not be found.
    
    The db2diag.log will contain the fllowing 2 entries for each
    node:
    
    2008-05-28-13.42.00.298354-240 E8736A558          LEVEL: Severe
    PID     : 704994               TID  : 6427        PROC : db2sysc
    1
    INSTANCE: laman                NODE : 001         DB   : TEST3
    APPHDL  : 0-58                 APPID: *N0.laman.080528174158
    AUTHID  : LAMAN
    EDUID   : 6427                 EDUNAME: db2bm.3343.0 () 1
    FUNCTION: DB2 UDB, database utilities,
    sqlubProcessConfiguration, probe:976
    DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
    -2038
    DATA #2 : Hexdump, 8 bytes
    0x0000000110706718 : FFFF F80A FFFF FC0B
    ........
    
    2008-05-28-13.42.00.299338-240 E9295A541          LEVEL: Severe
    PID     : 704994               TID  : 6427        PROC : db2sysc
    1
    INSTANCE: laman                NODE : 001         DB   : TEST3
    APPHDL  : 0-58                 APPID: *N0.laman.080528174158
    AUTHID  : LAMAN
    EDUID   : 6427                 EDUNAME: db2bm.3343.0 () 1
    FUNCTION: DB2 UDB, database utilities, sqlubbuf, probe:326
    DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
    -2044
    DATA #2 : Hexdump, 8 bytes
    0x0000000110706718 : FFFF F804 0000 0002
    ........
    
    Case 2 , files have been created by a previous attempt:
    ----------------------------------------------------------------
    --
    
    Each node will return:
    
    - Node 0: backup size 0 MB, SQL code -902; message SQL0902C  A
    system error (reason code = "
    ") occurred.  Subsequent SQL statements cannot be processed.
    
    db2diag.log will contain (for each node):
    
    2008-05-28-13.50.19.158070-240 E12704A873         LEVEL: Error
    (OS)
    PID     : 262646               TID  : 9014        PROC : db2sysc
    0
    INSTANCE: laman                NODE : 000
    EDUID   : 9014                 EDUNAME: db2med.7474.0 () 0
    FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
    MESSAGE : ZRC=0x870F000A=-2029060086=SQLO_FEXS "file already
    exists"
              DIA8722C A file already exists.
    CALLED  : OS, -, open
    OSERR   : EEXIST (17) "File exists"
    DATA #1 : Codepath, 8 bytes
    1:13:15:16:37
    DATA #2 : File name, 48 bytes
    /net2/d_TMP/TMP/laman/.0..NODE0000.CATN0000..001
    DATA #3 : Bitmask, 4 bytes
    0x00800009
    DATA #4 : Hex integer, 4 bytes
    0x00000180
    DATA #5 : signed integer, 4 bytes
    0
    DATA #6 : signed integer, 4 bytes
    0
    DATA #7 : String, 105 bytes
    Search for ossError*Analysis probe point after this log entry
    for further
    self-diagnosis of this problem.
    
    2008-05-28-13.50.19.180993-240 E13578A412         LEVEL: Severe
    PID     : 262646               TID  : 9014        PROC : db2sysc
    0
    INSTANCE: laman                NODE : 000
    EDUID   : 9014                 EDUNAME: db2med.7474.0 () 0
    FUNCTION: DB2 UDB, database utilities, sqluInitFileDevice,
    probe:609
    MESSAGE : ZRC=0x870F000A=-2029060086=SQLO_FEXS "file already
    exists"
              DIA8722C A file already exists.
    
    2008-05-28-13.50.19.181502-240 E13991A344         LEVEL: Error
    PID     : 262646               TID  : 9014        PROC : db2sysc
    0
    INSTANCE: laman                NODE : 000
    EDUID   : 9014                 EDUNAME: db2med.7474.0 () 0
    FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC,
    probe:677
    MESSAGE : Media controller -- Generic error
    
    2008-05-28-13.50.19.181748-240 E14336A423         LEVEL: Error
    PID     : 262646               TID  : 9014        PROC : db2sysc
    0
    INSTANCE: laman                NODE : 000
    EDUID   : 9014                 EDUNAME: db2med.7474.0 () 0
    FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC,
    probe:677
    MESSAGE : SQL0902C  A system error (reason code = "") occurred.
    Subsequent SQL
              statements cannot be processed.
    
    2008-05-28-13.50.19.284410-240 E14760A949         LEVEL: Severe
    PID     : 262646               TID  : 7474        PROC : db2sysc
    0
    INSTANCE: laman                NODE : 000         DB   : TEST3
    APPHDL  : 0-69                 APPID: *N0.laman.080528175017
    AUTHID  : LAMAN
    EDUID   : 7474                 EDUNAME: db2agntp (TEST3) 0
    FUNCTION: DB2 UDB, database utilities, sqlubMWResponse,
    probe:870
    DATA #1 : Sqlcode, PD_TYPE_SQLCODE, 4 bytes
    -902
    DATA #2 : Hexdump, 83 bytes
    0x070000003BDA4B98 : FFFF FC7A 2020 2020 2020 2020 2020 2020
    ...z
    0x070000003BDA4BA8 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x070000003BDA4BB8 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x070000003BDA4BC8 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x070000003BDA4BD8 : 2020 2020 2020 2020 2020 7371 6C75 4D43
    sqluMC
    0x070000003BDA4BE8 : 496E 00
    In.
    
    
    2008-05-28-13.50.19.290062-240 E15710A1010        LEVEL: Severe
    PID     : 262646               TID  : 7474        PROC : db2sysc
    0
    INSTANCE: laman                NODE : 000         DB   : TEST3
    APPHDL  : 0-69                 APPID: *N0.laman.080528175017
    AUTHID  : LAMAN
    EDUID   : 7474                 EDUNAME: db2agntp (TEST3) 0
    FUNCTION: DB2 UDB, database utilities, sqlubMWResponse,
    probe:870
    MESSAGE : SQL0902C  A system error (reason code = "") occurred.
    Subsequent SQL
              statements cannot be processed.
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -902   sqlerrml: 69
     sqlerrmc:
     sqlerrp : sqlubMWR
     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:
    
    2008-05-28-13.50.19.290878-240 E16721A550         LEVEL: Error
    PID     : 262646               TID  : 7474        PROC : db2sysc
    0
    INSTANCE: laman                NODE : 000         DB   : TEST3
    APPHDL  : 0-69                 APPID: *N0.laman.080528175017
    AUTHID  : LAMAN
    EDUID   : 7474                 EDUNAME: db2agntp (TEST3) 0
    FUNCTION: DB2 UDB, database utilities, sqlubMWResponse,
    probe:872
    MESSAGE : SQL0902C  A system error (reason code = "
              ") occurred.  Subsequent SQL statements cannot be
    processed.
    
    ------------------------------
    

Local fix

  • N/A
    

Problem summary

  • See problem description.
    

Problem conclusion

  • First Fixed in DB2 V9.5 Fixpack 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73475

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-05-28

  • Closed date

    2009-01-21

  • Last modified date

    2009-01-21

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
21 January 2009