IT48453: TIERING PROCESS COMPLETED SUCCESSFULLY WITHOUT TIERING ALL DATA WHEN USING TIER BY AGE = 0

8.2.2.000-IBM-SPSRV-Linuxx86_64
8.2.2.000-IBM-SPSRV-WindowsX64
8.2.2.000-IBM-SPSRV-AIX
8.2.2.000-IBM-SPSRV-Linuxppc64le
8.2.2.000-IBM-SPSRV-Linuxs390x

APAR status

• Closed as program error.

Error description

• Tiering process does not select objects as candidate for tiering
  if gmtinsdate is NULL. To find such objects, we can run
  following query:
  IBM Storage Protect tiering process does not select objects for
  tiering if the gmtinsdate is NULL. To identify such objects, you
  can run the following query:
  
  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
  
  To find the count of impacted objects, 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
  
  Earlier fix done with APAR 217329 caused the regression
  described in APAR 217548
  
  IBM Storage Protect Versions Affected: 8.1.27
  
  
  | MDVREGR 8.1.27.000-TIV_5698MSV |
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Storage Protect server users.                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Apply fixing level when available. This problem is currently
  projected to be fixed in level 8.2.2.
  Note that this is subject to change at the discretion of IBM.
  

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