IBM Support

IT43086: DB2 RESTORE WITH POINT-IN-TIME TYPE TO AN ALTERNATE LOCATION MIGHT SHOW DB2 ERROR SQL5099N

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When IBM Spectrum Protect Plus db2 restore job
    is started, then the command log for the restore
    job may contain the Db2 error SQL5099N.
    Even though the job was finished successfully
    and there are no errors in the job log:
    
    stdout:
    ===SPPAgent-output===
    SQL5099N  The value "LOGRETAIN" indicated by the database
    configuration parameter "LOGARCHMETH1" is not valid, reason code
    "13".
    
    
    
    IBM Spectrum Protect Plus Versions Affected:
    IBM Spectrum Protect Plus versions from 10.1.2 and  later
    
    Additional Keywords: SPPLUS, TS008182333, db2,  restore,
    Point-in-time,
    
    LOGARCHMETH1, SQL5099N
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * IBM Spectrum Protect Plus 10.1.2  till 10.1.14 users who     *
    * restore a Db2 database.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See "Error description".                                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in IBM Spectrum Protect Plus level     *
    * 10.1.14.1 and 10.1.15.                                       *
    * Note that this is subject to change at the discretion of     *
    * IBM.                                                         *
    ****************************************************************
    

Problem conclusion

  • The redundant setting of the database parameters was removed
    from the IBM Spectrum Protect Plus for Db2 agent so that
    misleading Db2 errors like  SQL5099N will not be printed into
    the command.log.
    

Temporary fix

  • If the restore job was finished successfully and there are no
    errors in the job log then the Db2 error SQL5099N printed in the
    command.log for the restore job can be ignored.
    

Comments

APAR Information

  • APAR number

    IT43086

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A1C

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-02-09

  • Closed date

    2023-05-08

  • Last modified date

    2023-05-08

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

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

Modules/Macros

  • Db2
    

Fix information

  • Fixed component name

    SP PLUS

  • Fixed component ID

    5737SPLUS

Applicable component levels

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A1C","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
01 February 2024