IC61496: POINT IN TIME RESTORE DB WHEN USING 'ON' OPTION FAILS AT TSM 6.1 WITH ANR0367W SERVER FAILED TO FORMAT DB

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ANR0367W The server failed to format the database TSMDB1. This
    database name already exists. Received after what appears to be
    asuccessful dsmserv restore db operation. This error only
    occurs when a point in time (PIT) restore is run AND the "on"
    option is used to specify a new directory onto which the
    database is to be restored.
    .
    The complete set of message seen can be:
    ANR4635I Point-in-time database restore complete, restore date
    06/05/2009 02:20:59 PM.
    ANR0152I Database manager successfully started.
    ANR0367W The server failed to format the database TSMDB1. This
    database name already exists.
    ANR0172I rdbdb.c(873): Error encountered performing action
    InstanceStop.
    ANR0162W Supplemental database diagnostic information:
    -1042:**No State
    Information Available (133)**:-1042 (**No Other Information
    Available (63)**).
    ANR2032E RESTORE DB: Command failed - internal server error
    detected.
    ANR9999D Thread<1> issued message 2032 from:
    ANR9999D Thread<1>  0x0000000000bfa666 outMsgf+0x0xb6
    ANR9999D Thread<1>  0x0000000000492d34 AdmRestoreDb+0x0xc44
    ANR9999D Thread<1>  0x000000000051d0d0
    admRestoreDatabase+0x0x160
    ANR9999D Thread<1>  0x000000000046d32c main+0x0x17cc
    ANR9999D Thread<1>  0x00000035d1e1d974 *UNKNOWN*
    ANR9999D Thread<1>  0x000000000046b2fa SQLSetConnection+0x0x42
    TSM Versions Affected: 6.1
    Initial Impact: Medium
    Additional Keywords: zz61 move database db2
    

Local fix

  • While use of the "ON" option is the official way to
    restore a TSM/DB2 database to a new location the following
    can be done to accomplish the same thing:
        dsmserv removedb <dbname>
        dsmserv format <specifying the new dbdir, archivelogdir and
                        activelog dir>
        dsmserv restore db todate=<date>
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of Tivoli Storage Manager server.  *
    ****************************************************************
    * PROBLEM DESCRIPTION: See error description                   *
    ****************************************************************
    * RECOMMENDATION: Apply fixing level when available. This      *
    *                 problem is currently projected to be fixed   *
    *                 in level 6.1.2.  Note that this is subject   *
    *                 to                                           *
    *                 change at the discretion of IBM.             *
    ****************************************************************
    *
    

Problem conclusion

  • The problem has been corrected.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC61496

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    61L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-06-12

  • Closed date

    2009-07-02

  • Last modified date

    2009-07-02

  • 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

    TSM SERVER

  • Fixed component ID

    5698ISMSV

Applicable component levels

  • R61A PSY

       UP

  • R61H PSY

       UP

  • R61L PSY

       UP

  • R61S PSY

       UP

  • R61W PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Storage Manager

Software version:

61L

Reference #:

IC61496

Modified date:

2009-07-02

Translate my page

Machine Translation

Content navigation