If you face daily maintenance issue on your IFM RB, please provide following data to be checked.
1. AIS Daily maintenance process logs, taken by exporting from AIS Monitor.
2. server counters logs, taken from logs folder inside your RB instance.
3. Top 50 SQL query and number of data on each partitions, taken by running query attached in this KB.
4. Export data from SQL_FOR_BATCH table from IDB and IFM_APP databases
5. Export data from SQL_FOR_BATCH_LOG table from IDB and IFM_APP databases
6. Export data from SQL_FOR_BATCH_LOG_ARCHIVE from IDB and IFM_APP databases
7. Export data from TEMP_PARTITIONS_TO_SWITCH table from IDB.
SELECT * FROM IDB.STAGING_IDB.SQL_FOR_BATCH SELECT * FROM IDB.STAGING_IDB.SQL_FOR_BATCH_LOG SELECT * FROM IDB.STAGING_IDB.SQL_FOR_BATCH_LOG_ARCHIVE SELECT * FROM IFM_APP..SQL_FOR_BATCH SELECT * FROM IFM_APP..SQL_FOR_BATCH_LOG SELECT * FROM IFM_APP..SQL_FOR_BATCH_LOG_ARCHIVE |