IT47949: THE TIERING PROCESS COMPLETED SUCCESSFULLY, BUT DID NOT TIER ALL DATA WHEN USING "TIER BY AGE = 0."

8.1.27.000-IBM-SPSRV-WindowsX64-162
8.1.27.000-IBM-SPSRV-Linuxx86_64-162
8.1.27.000-IBM-SPSRV-Linuxs390x-162
8.1.27.000-IBM-SPSRV-Linuxppc64le-162
8.1.27.000-IBM-SPSRV-AIX-162

APAR status

• Closed as program error.

Error description

• IBM Storage Protect tiering process does not select objects for
  tiering if the gmtinsdate is NULL. The following query can be
  run to identify such objects in backup and archive tables:
   
  select * from tsmdb1.archive_objects ao where objid in (select
  distinct sdro.objid
  from tsmdb1.sd_all_chunks sdac left join tsmdb1.sd_recon_order
  sdro on
  sdac.chunkid=sdro.chunkid left join tsmdb1.archive_objects imar
  on
  sdro.objid=imar.objid where imar.objid is not null and
  imar.gmtinsdate is null) for read only with ur
   
   
  select * from tsmdb1.backup_objects ao where objid in (select
  distinct sdro.objid
  from tsmdb1.sd_all_chunks sdac left join tsmdb1.sd_recon_order
  sdro on
  sdac.chunkid=sdro.chunkid left join tsmdb1.backup_objects imar
  on
  sdro.objid=imar.objid where imar.objid is not null and
  imar.gmtinsdate is null) for read only with ur
   
  To find the count of impacted objects which are not eligible for
  tiering, issue the below SQL query:
   
  select COUNT(*) from tsmdb1.archive_objects ao where objid in
  (select distinct sdro.objid
  from tsmdb1.sd_all_chunks sdac left join tsmdb1.sd_recon_order
  sdro on
  sdac.chunkid=sdro.chunkid left join tsmdb1.archive_objects imar
  on
  sdro.objid=imar.objid where imar.objid is not null and
  imar.gmtinsdate is null) for read only with ur
   
   
  select COUNT(*) from tsmdb1.backup_objects ao where objid in
  (select distinct sdro.objid
  from tsmdb1.sd_all_chunks sdac left join tsmdb1.sd_recon_order
  sdro on
  sdac.chunkid=sdro.chunkid left join tsmdb1.backup_objects imar
  on
  sdro.objid=imar.objid where imar.objid is not null and
  imar.gmtinsdate is null) for read only with ur
  
  
  IBM Storage Protect Versions Affected:  IBM Storage Protect
  Server versions  8.1.X 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. Note that this is     *
  * subject to change at the discretion of IBM.                  *
  ****************************************************************
  

Problem conclusion

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