IBM Support

LI75290: RESTORE TO A NUMBER OF PATHS LESS THAN THE ORIGINAL NUMBER OF AU TOMATIC STORAGE PATHS CAN FAIL WITH SQLB_AS_INVALID_STORAGE_PATH

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • During a redirected restore of a database with automatic
    storage.  If you specify a number of paths less than the
    original number of paths in the backup it can fail with
    SQL1051N.
    
    Example:
    The original 8 automatic storage paths are path1 - path8
    
    Given the restore command:
    db2 restore db sample from /backup ON
    'newpath1', 'newpath2', 'newpath3', 'newpath4'
    DBPATH ON 'dbpath'
    
    It can fail with an SQL1015N and you will see messages similar
    to the following in the db2diag.log:
    
    2009-11-21-17.49.03.759130-300 I124239656E584      LEVEL: Severe
    PID     : 5359                 TID  : 47033587067200PROC :
    db2sysc
    INSTANCE: db2inst1             NODE : 000
    EDUID   : 10224                EDUNAME: db2bm.9159.0 (LRT)
    FUNCTION: DB2 UDB, buffer pool services,
    sqlbReadStorageGroupEntry, probe:30
    MESSAGE :
    ZRC=0x800201A5=-2147352155=SQLB_AS_INVALID_STORAGE_PATH
              "Storage path does not exist or is inaccessible."
    DATA #1 : String, 38 bytes
    Error reading from storage group files
    DATA #2 : signed integer, 8 bytes
    0
    DATA #3 : Pointer, 8 bytes
    0x00002ac6dc3fcce8
    
    2009-11-21-17.49.03.759353-300 I124240241E1341     LEVEL: Error
    (OS)
    PID     : 5359                 TID  : 47033587067200PROC :
    db2sysc
    INSTANCE: db2inst1             NODE : 000
    EDUID   : 10224                EDUNAME: db2bm.9159.0 (LRT)
    FUNCTION: DB2 Common, OSSe, ossGetDiskInfo, probe:150
    MESSAGE : ECF=0x9000001A=-1879048166=ECF_FILE_DOESNT_EXIST
              File doesn't exist
    CALLED  : OS, -, stat                             OSERR: ENOENT
    (2)
    DATA #1 : String, 12 bytes
    /path8
    DATA #2 : unsigned integer, 8 bytes
    384
    CALLSTCK:
      [0] 0x00002AC547159F5B pdOSSeLoggingCallback + 0x91
      [1] 0x00002AC54C1E69EB /opt/ibm/db2/V9.5/lib64/libdb2osse.so.1
    + 0x1AD9EB
      [2] 0x00002AC54C1E7E1F ossLogSysRC + 0x113
      [3] 0x00002AC54C1FD29E ossGetDiskInfo + 0xB74
      [4] 0x00002AC5471CBC31
    _Z21sqlbGetFileSystemInfoPcP11OSSDiskInfoj + 0xE3
      [5] 0x00002AC5471C9200
    _Z30sqlbCopyStoragePathsFromDiskCBPcmP13SQLO_MEM_POOLS_
    P20SQLB_STORAGEGROUP_CBj + 0x206
      [6] 0x00002AC5471C8B09
    _Z25sqlbReadStorageGroupEntryPcl12SQLO_FHANDLElP13SQLO_
    MEM_POOLPP20SQLB_STORAGEGROUP_CBj + 0x1A3
      [7] 0x00002AC5471C847E
    _Z20sqlbReadStorageGrouplP23SQLB_STORAGEGROUP_TABLEP13S
    QLO_MEM_POOLPcj + 0x13E
      [8] 0x00002AC5471CA055
    _Z25sqlbReadStorageGroupTablePcP23SQLB_STORAGEGROUP_TAB
    LEP13SQLO_MEM_POOLj + 0x8B
    

Local fix

Problem summary

  • Users Affected: Any doing a redirected restore to a lesser
    
    number of paths.
    Problem description:A redirected restore with automatic storage
    to a lesser number of paths can fail with SQL1051N
    Problem summary: see above
    

Problem conclusion

  • Problem was first fixed in Version 9.5 FixPak 6
    

Temporary fix

  • n/a
    

Comments

APAR Information

  • APAR number

    LI75290

  • 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

    2010-01-26

  • Closed date

    2010-10-07

  • Last modified date

    2010-10-07

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

    LI75289

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

Document Information

Modified date:
07 October 2010