AH update not necessary when using ILM to execute DBUNLOAD utility to delete objects in recycle bin
book
Article ID: 84883
calendar_today
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
Error Message : N/A
If ILM is in place an update AH for example:
U0003594 UCUDB Ret: '6' opcode: 'EXEC' SQL Stmnt: 'update AH set AH_DeleteFlag = ? where AH_OH_Idnr in (select OH_IDNR from OH where OH_DeleteFlag = ?)'
did not make any sense at all and was enhanced with this fix.
Now the DB Unload utility did not reorganizes table AH when ILM mode is activated.