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

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 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