IBM Support

IC80721: IMPROVE DIAGNOSTIC MESSAGE DURING TABLE SPACE ROLLFORWARD

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When the user issues a table space rollforward while another
    table space rollforward is already in progress, error SQL4908N
    will be returned, and the following message will be written into
    the DB2 diagnostic log:
    
    FUNCTION: DB2 UDB, recovery manager, sqlpInitTblRecovery,
    probe:2770
    DATA #1 : <preformatted>
    A table space rollforward is already in progress.
    One or more of the table spaces specified in the list to be
    rolled forward is not in rollforward in progress state.
    Use the LIST TABLESPACES SHOW DETAIL command to get a list
    of table spaces in rollforward in progress or rollforward
    pending state.
    There are two ways to proceed.
    1. Complete the table space rollforward that is already in
    progress.
    This will not be possible if rolling forward to a point in time
    and
    either a table space is not in rollforward in progress state on
    all nodes or
    the table spaces are interdependent and all table spaces are not
    in
    rollforward in progress state on all nodes.
    Submit the rollforward command again with a list containing the
    table spaces that are in rollforward in progress state. You can
    submit
    a different rollforward command for each node or subset of nodes
    if
    required, but any table space in rollforward in progress state
    that is
    not included in the list will be put into restore pending state.
    Restore any table spaces place in restore pending state and then
    submit the new table space rollforward command.
    2. Cancel the table space rollforward that is in progress and
    start another table space rollforward.
    Submit the rollforward command again with the CANCEL option.
    A list of table spaces that are in rollforward in progress state
    and a node list are required only if rolling forward to end of
    logs.
    These table spaces will be put into restore pending state.
    Restore the table spaces and submit the rollforward command
    again.
    
    The purpose of this APAR is to improve suggestion 2. The current
    text is ambiguous, and some users may understand it in the way
    that they can cancel the running rollforward and submit another
    rollforward. However, this interpretation is incorrect.
    Canceling a running rollforward means that the table space will
    be put into restore pending state, which is a serious
    consequence. Only after restoring the table space again, the
    user will then be able to issue another rollforward.
    
    The new text for suggestion 2 will be made consistent with our
    manuals:
    
    2. Cancel the table space rollforward that is in progress
    (submit the rollforward command again with the CANCEL option) to
    put one or more table spaces on all database partitions on which
    forward recovery has been started in restore pending state. Use
    this option with caution, and only if the rollforward operation
    that is in progress cannot be completed because some of the
    table spaces have been put in restore pending state.
    

Local fix

Problem summary

  • See APAR Description
    

Problem conclusion

  • Problem first fixed in DB2 for Linux, UNIX, and Windows 9.7 Fix
    Pack 6
    

Temporary fix

  • See APAR Description
    

Comments

APAR Information

  • APAR number

    IC80721

  • 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

    2012-01-09

  • Closed date

    2012-06-06

  • Last modified date

    2012-06-06

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

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

    IC80828 IC84281

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC80721

Modified date: 06 June 2012