IT36592: SPECTRUM PROTECT CAN STORE DUPLICATE RETENTION RULES WITH THE SAME RESULTING IN ERROR WHEN ACCESSING RETRULE VIA OC OR SELECT

IBM Spectrum Protect Server V8.1 Fix Pack 13 (V8.1.13) Downloads

APAR status

• Closed as program error.

Error description

• When defining retention rules on IBM
  Spectrum Protect server, it is possible that the server stores
  more than one retention rule with the same name. This situation
  can lead to an error when running SELECT FROM RETRULES directly
  from the command line or indirectly by accessing some Spectrum
  Protect Operations Center pages. Both situation will fail with
  the following error :
  
  ANR0102E admsql.c(6011): Error 1202
  inserting row in table 'RETRULEST
  
  Diagnostics:
  Using the
  ASTXN,DBDBG,DBITXN,DBRC server traceflags, the trace data shows
  there is a duplicate
  value for the index
  key.
  
  [144][dbieval.c][708][DbiEvalSQLOutcomeX]:SQLSTATE 23505,
  SQLCODE -803, SQLMsg=[IBM][CLI
  Driver][DB2/NT64] SQL0803N One
  or more values in the INSERT statement, UPDATE statement, or
  
  foreign key update caused by a DELETE statement are not valid
  because the primary key, unique
  constraint or unique index
  identified by "1" constrains table "TSMDB1.RETRULEST" from
  having
  duplicate values for the index key. SQLSTATE=23505
  , msg
  Len=343.
  [102][tbcli.c][5121][RdbPrepareAndExecuteStmt]:Executin
  g statement 'SELECT
  RULEID,NODEPAT,FSPAT,CODETYPE,NAMETYPE
  FROM "TSMDB1"."RETENTION_RULE_MEMBERS" WHERE (RULEID=?)
  ORDER
  BY NODEPAT, FSPAT FOR READ ONLY OPTIMIZE FOR 10 ROWS WITH UR
  --102' submitted from
  
  imretru.c(1195).
  [144][dbieval.c][714][DbiEvalSQLOutcomeX]:SQL
  diag info resolved using handle 3, state 23505, code
  -803, and
  msg=[IBM][CLI Driver][DB2/NT64] SQL0803N One or more values in
  the INSERT statement,
  UPDATE statement, or foreign key update
  caused by a DELETE statement are not valid because the
  primary
  key, unique constraint or unique index identified by "1"
  constrains table
  "TSMDB1.RETRULEST" from having duplicate
  values for the index key. SQLSTATE=23505
  
  Initial Impact:
  Medium
  
  IBM Spectrum Protect versions affected:
  Server
  8.1.7.x and above on all supported platforms
  
  Keywords:
  RETRULE, TS005053674, ANR0102E, 1202
  

Local fix

• Issue "RENAME RETRULE <duplicate retention rule name> <new
  retention rule name>" until duplicate
  retention rules have
  been uniquely renamed.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Spectrum Protect server users.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in level 8.1.13. 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

• R81A PSY

     UP

• R81L PSY

     UP

• R81W PSY

     UP