We had an incident where our nightly DB optimization failed to due to lack of space in storage which caused our Automation Engine to fail to run with D type worker processes.
Our DB maintenance involves 3 steps. 1.Archive . 2. Reorg. 3 Unload. When archive portion got completed, it did not have enough space to store the files. Ever since, whenever we see in WP logs, UC_Reorg happens, WP's will start failing 1 by 1. We worked with the support and disabled out D type worker process which suppose to assist for users for better User Experience. Since then it has been stable but if Automic decides to run REORG, we will see the issues with WP's.
How can I resume out nightly DB maintenance from this point forward since some of the data is already flagged as A but not stored.
***** See the log ********************
20140120/210436.525 - U0011889 DB table 'MQPWP' is going to be reorganized.
20140120/210436.615 - U0011890 DB table 'MQPWP' was reorganized.
20140120/210436.627 - U0011889 DB table 'MQWP' is going to be reorganized.
20140120/210448.201 - U0003524 UCUDB: ===> Time critical DB call! OPC: 'EXEC' time: '11:573.899.000'
20140120/210448.201 - U0003525 UCUDB: ===> 'begin UC_Reorg ('MQWP'); end;'
20140120/210448.201 - U0011890 DB table 'MQWP' was reorganized.
20140120/210448.205 - U0003434 Server routine 'UCMAIN_R/MQREORG' required '0' minutes and '11,578' seconds for processing.
20140120/210448.211 - U0011889 DB table 'MQRWP' is going to be reorganized.
20140120/210448.248 - U0011890 DB table 'MQRWP' was reorganized.
20140120/210448.260 - U0011889 DB table 'MQOWP' is going to be reorganized.
20140120/210448.348 - U0011890 DB table 'MQOWP' was reorganized.
20140120/210448.355 - U0011889 DB table 'MQDWP' is going to be reorganized.