IBM Support

IT05192: "DB2PD -STACK ALL" CAUSE THE RESTORE FAILURE IN FUNCTION "SQLUREADFROMFILEDEVICE"

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Running the command "db2pd -stack all" in parallel with a
    restore execution, the restore can fail in function
    SQLUREADFROMFILEDEVICE.
    
    In db2diag.log, the following messages can be found:
    
    =============================================
    
    2014-09-08-09.25.24
    495100-240 I289214966E929      LEVEL: Error
    PID     : 24145                TID  : 46942692305216PROC :
    db2sysc 4
    INSTANCE: xxxx             NODE : 004
    EDUID   : 6370                 EDUNAME: db2med.5605.0 (RAVECR) 4
    FUNCTION: DB2 UDB, database utilities, sqluReadFromFileDevice,
    probe:836
    MESSAGE : Received ERROR
    DATA #1 : Hexdump, 107 bytes
    0x00002AB1B4462214 : 2F76 6172 2F6D 7364 6232 2F6E 7974 7874
    /var/msdb2/xxxx
    0x00002AB1B4462224 : 3134 302F 6462 3262 6163 6B2F 6462 326E
    140/db2back/db2n
    0x00002AB1B4462234 : 6764 756D 702F 6462 325F 6C6F 6164 2E37
    gdump/db2_load.7
    0x00002AB1B4462244 : 3339 382F 6E79 7078 7430 3830 2E72 6176
    398/xxxx.rav
    0x00002AB1B4462254 : 6563 722E 4E4F 4445 3130 3034 2E43 4154
    ecr.NODE1004.CAT
    0x00002AB1B4462264 : 4E30 3030 312E 3230 3134 3039 3033 3139
    N0001.2014090319
    0x00002AB1B4462274 : 3030 3535 2E30 3031 2E64 62
    0055.001.db
    
    2014-09-08-09.25.24.495403-240 I289215896E409      LEVEL: Error
    PID     : 24145                TID  : 46942692305216PROC :
    db2sysc 4
    INSTANCE: xxxx             NODE : 004
    EDUID   : 6370                 EDUNAME: db2med.5605.0 (RAVECR) 4
    FUNCTION: DB2 UDB, database utilities, sqluReadFromFileDevice,
    probe:907
    DATA #2 : Hexdump, 4 bytes
    0x00002AB1B27FD0A0 : A900 0F87
    ....
    
    2014-09-08-09.25.24.495597-240 E289216306E608      LEVEL: Error
    PID     : 24145                TID  : 46942692305216PROC :
    db2sysc 4
    INSTANCE: xxxx             NODE : 004
    EDUID   : 6370                 EDUNAME: db2med.5605.0 (RAVECR) 4
    FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice,
    probe:1266
    MESSAGE : Media controller -- Problem reading from local device
    
    /var/msdb2/xxxx/db2back/db2ngdump/db2_load.7398/xxxx.ravecr.NO
              DE1004.CATN0001.20140903190055.001.db (zrc =
    0x870f00a9)
    
    2014-09-08-09.25.24.495803-240 E289216915E435      LEVEL: Error
    PID     : 24145                TID  : 46942692305216PROC :
    db2sysc 4
    INSTANCE: xxxx             NODE : 004
    EDUID   : 6370                 EDUNAME: db2med.5605.0 (RAVECR) 4
    FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice,
    probe:1266
    MESSAGE : SQL0902C  A system error (reason code = "") occurred.
    Subsequent SQL statements cannot be processed.
    
    2014-09-08-09.25.24.496144-240 E289217351E342      LEVEL: Error
    PID     : 24145                TID  : 46942692305216PROC :
    db2sysc 4
    INSTANCE: xxxx             NODE : 004
    EDUID   : 6370                 EDUNAME: db2med.5605.0 (RAVECR) 4
    FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice,
    probe:1266
    DATA #1 : String, 3 bytes
    169
    
    2014-09-08-09.25.24.881063-240 E289217694E533      LEVEL: Error
    PID     : 24145                TID  : 46938191817024PROC :
    db2sysc 4
    INSTANCE: xxxx             NODE : 004          DB   : RAVECR
    APPHDL  : 4-159                APPID: *N4.xxxx.140907175826
    AUTHID  : xxxx
    EDUID   : 5605                 EDUNAME: db2agent (RAVECR) 4
    FUNCTION: DB2 UDB, database utilities, sqludMRResponse,
    probe:869
    MESSAGE : SQL0902C  A system error (reason code = "169")
    occurred.  Subsequent
              SQL statements cannot be processed.
    
    2014-09-08-09.25.24.945601-240 E289218228E431      LEVEL: Severe
    PID     : 24145                TID  : 46938191817024PROC :
    db2sysc 4
    INSTANCE: xxxx             NODE : 004          DB   : RAVECR
    APPHDL  : 4-159                APPID: *N4.xxxx.140907175826
    AUTHID  : MSDB2
    EDUID   : 5605                 EDUNAME: db2agent (RAVECR) 4
    FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:800
    MESSAGE : Restore Terminated.
    

Local fix

  • Avoid running "db2pd -stack all" during restore.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See problem description above.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7Fix Pack 11.                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 9.7Fix Pack 11.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT05192

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-10-27

  • Closed date

    2015-11-25

  • Last modified date

    2015-11-25

  • 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 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       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":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 November 2015