IO29295: AUTO DELETE ONLY RUNS 3600MS INSTEAD OF 3600 SECONDS DURING CONTENT MANAGER EXPIRATION

APAR status

• Closed as program error.

Error description

• Auto Delete only runs 3600ms instead of 3600 seconds during
  Content Manager Expiration
  
  On executing the following SQL queries the above mentioned issue
  is noticed:
  
  1. Here is the SQL on how to get the expired documents for
  ICMUT01099001
  
  select count(CREATETS),CURRENT TIMESTAMP from ICMUT01099001
  where ICM$AUTODELETEDATE < (CURRENT TIMESTAMP-CURRENT TIMEZONE)
  
  2. --get the itemtype id
  
  select itemtypeid from icmstcompdefs where componenttypeid=1099
  
  for example, itemtypeid is 1052
  
  3. --get task name. Note that you should use the real itemtypeid
  to replace the 1052
  
  select name from systools.ADMIN_TASK_LIST where name like
  'ICMAD_1052%'
  
  For example, the name is ICMAD_1052_miss300
  
  Note that you need use the real name gotten from 3# to replace
  the ICMAD_1052_miss300 for the SQLs in 4#, 5# and 6# below.
  
  4. select * from systools.ADMIN_TASK_LIST where
  name='ICMAD_1052_miss300'
  
  5. db2 "SELECT TASKID, STATUS, SQLCODE, SQLSTATE,
  RC,VARCHAR(SQLERRM( 'SQL'||CHAR(ABS(SQLCODE)),SQLERRMC, x'FF',
  'en_US', 1 ), 256) AS MSG_TXT FROM SYSTOOLS.ADMIN_TASK_STATUS
  where name='ICMAD_1052_miss300'"
  
  Note that you need to use the real name gotten from 3# to
  replace the ICMAD_1052_miss300
  
  6. SELECT * FROM ICMSTSERVICEEVENT where LSSERVICEID=2 and
  INSTANCEPARM like '%ICMAD_1052_miss300'
  

Local fix

Problem summary

•  Max duration of the retention automatic
  deletion service is checked incorrectly. After setting the
  maximum duration of the retention automatic deletion to x
  (where x > 0) seconds, the check for the maximum duration is
  x milliseconds instead of x seconds.
  

Problem conclusion

•  The problem is fixed in Content Manager
  Enterprise Edition version 8.7 fix pack 3.
  

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

  LIBRARY SERVER

• Fixed component ID

  5724B1907

Applicable component levels