IBM Support

JR32625: USING CONTROL CENTER TO DO A REDIRECTED RESTORE MAY RESULT IN A SQL0902C IF THE ORIGINAL DRIVE LOCATION DOES NOT EXIST.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using the Control Center to restore a database from another
    server, if the orignal database resided on a different drive,
    then the restore will fail with a SQL0902C error.
    
    For example:
    Server A has Database SAMPLE defined on the D: drive.
    
    Server B only has a C: drive
    
    When trying to restore a backup from Server A onto Server B, the
    restore fails with a SQL0902C.
    
    The Control Center generates a backup statement with:
    
    RESTORE DATABASE SAMPLE FROM "C:\DB2_01\Backup" TAKEN AT
    20090218043023 TO "C:" INTO SAMPLE2 WITH 2 BUFFERS
    BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING
    

Local fix

  • db2 RESTORE DATABASE SAMPLE FROM "C:\DB2BKUP" ON "C:\"
    WITH 1 BUFFERS
    BUFFER 1024 redirect PARALLELISM 1 WITHOUT PROMPTING
    

Problem summary

  • Users Affected : Windows Users
    
    Problem Description:
    When using the Control Center to restore a database from
    another
    server, if the orignal database resided on a different
    drive,
    then the restore will fail with a SQL0902C error.
    
    Problem Summary:
    When using the Control Center to restore a database from
    another
    server, if the orignal database resided on a different
    drive,
    then the restore will fail with a SQL0902C error.
    

Problem conclusion

  • Problem first fixed in Version 9.5 Fixpak 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32625

  • Reported component name

    DB2 UDB WSE WIN

  • Reported component ID

    5765F3501

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-04-07

  • Closed date

    2010-01-18

  • Last modified date

    2010-01-18

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

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

    IC64047

Fix information

  • Fixed component name

    DB2 UDB WSE WIN

  • Fixed component ID

    5765F3501

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:
18 January 2010