IBM Support

IT24654: SELECT * FROM DEDUPSTATS FAILS SINCE UPGRADE TO V8.1.5.0

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

  • select * from dedupstats:
    ANR0162W Supplemental database diagnostic information:
     -1:23502:-407 ([IBM][CLI Driver][DB2/NT64]  SQL0407N Assignment
    of a NULL value to a NOT NULL  column
     "TBSPACEID=2, TABLEID=158, COLNO=28" is not allowed.
    SQLSTATE=23502).
    ANR0157W Database operation INSERT for table DedupStats.SQL
    failed with result code 2332
    and tracking  ID: 000000A6E9335EE8.
    ANR0158W Database operation INSERT for table DedupStats.SQL
    failed with operation code
    2332 and tracking id 000000A6E9335EE8. The data for column 0 is:
    (string, len=6)0x7407040B193A.
    ANR0158W Database operation INSERT for table DedupStats.SQL
    failed with operation code
    2332 and tracking id 000000A6E9335EE8. The data for column 1 is:
    (string, len=12)0x444154414348414D42455253.
    .
    This is caused by V8.1.5.0 unable to read/understand dedupstats
    generated by versions prior to V8.1.5.0
    
    IBM Spectrum Protect Versions Affected: V8.1.5.0  on all
    platforms
    
    Customer/L2 Diagnostics:  N/A
    
    Initial Impact: Low
    
    Additional Keywords:
    

Local fix

  • 1. If possible, use "query dedupstats" instead.
    2. If the dedupstats records generated prior to 8.1.5 upgrade is
    not needed, please delete them.
    3. If time window allows,re-run "gen dedupstats" for all the
    filespaces. The old records will no longer be visited by SELECT
    command after new
    records generated.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of IBM Spectrum Protect server.                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing levels when available. This problem is          *
    * currently projected to be fixed in level 8.1.6. Note that    *
    * this is subject to change at the discretion of IBM.          *
    ****************************************************************
    

Problem conclusion

  • This problem was fixed.
    Affected platforms for reported release:  AIX, Linux, and
    Windows.
    Platforms fixed:  AIX, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT24654

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    81W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-04-13

  • Closed date

    2018-04-17

  • Last modified date

    2018-04-17

  • 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



Document information

More support for: Tivoli Storage Manager

Software version: 81W

Reference #: IT24654

Modified date: 17 April 2018


Translate this page: