IBM Support

IT35497: TRUNCATE SQL LOGS FAILS WITH EMPTY ERROR MESSAGE WHEN CATALOG IS NOT ENABLED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • IBM Spectrum Protect Plus SQL log truncation option as part of a
    virtual machine backup is invoked only when the file catalog
    option is also enabled. By enabling the file catalog option,
    credentials are required and used for the SQL log truncation
    operation.
    

Local fix

  • Enable File cataloging option and provide proper user
    credentials.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * IBM Spectrum Protect Plus levels 10.1.5, 10.1.6, and 10.1.7. *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply the fixing level when available. This problem is       *
    * currently projected to be fixed in IBM Spectrum Protect Plus *
    * levels 10.1.7 ifix2 and 10.1.8. Note that this is at the     *
    * discretion of IBM.                                           *
    ****************************************************************
    

Problem conclusion

  • IBM Spectrum Protect Plus has been updated to require user
    credentials to enable "Truncate SQL logs".
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT35497

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A15

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-01-12

  • Closed date

    2021-02-09

  • Last modified date

    2021-02-09

  • 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

    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":"A15","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
31 January 2024