IT48422: COPY STORAGE RULE PERFORMANCE IS SLOW AFTER UPGRADING TO SERVER VERSION 8.1.27.000

APAR status

• Closed as program error.

Error description

• After upgrade to IBM Storage Protect server version 8.1.27.000,
  COPY storage rule operations are experiencing performance
  issues.
  
  The performance degradation appears to stem from a specific SQL
  query executed during COPY storage rule operations. A key part
  of this query includes an index scan directive:
  
  IXSCAN TABLE='IMBK' INDEX='IMBK_TIER_NDX'
  
  Along with
  coalesce(GMTINSDATE, INSDATE) >= ? AND coalesce(GMTINSDATE,
  INSDATE) < ?
  
  This use of COALESCE prevents the database optimiser from
  effectively utilising the IMBK_TIER_NDX index, resulting in
  inefficient query execution plans. Consequently, the query may
  fall back to full table scans, leading to increased latency and
  degraded performance during COPY storage rule operations.
  
  
  From the Servermon logs indicate that the 'DB2 Reg Exec'
  operation is consuming a substantial amount of time during COPY
  storage pool processing
  
  
  Thread XXXX ScObjectBatchBuilderThread parent=XXX
  2025-08-07T18:10:46.893-->2025-08-07T18:30:34.220
  PROCESS_NUMBER:XX,PROCESS_DESC:COPY STORAGE POOL (SUMMARY)
  Operation    Count Tottime Avgtime Mintime Maxtime InstTput
  Total KB
  ---------------------------------------------------------------
  -------------
  DB2 Reg Exec    2 1187.327 593.664 528.632 658.695
  DB2 Reg Fetch    1  0.000  0.000  0.000  0.000
  Unknown         0.000
  ---------------------------------------------------------------
  -------------
  Total         1187.327
  
  
  | MDVREGR 8.1.27.000-TIV_5698MSV |
  
  IBM Storage Protect Versions Affected:
  IBM Storage Protect Server at 8.1.27.000 on all supported
  platforms
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Storage 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.27.100 and 8.2.0. Note    *
  * that this is subject to change at the discretion of IBM.     *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms: 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