Ims2disk.sh script has remain largely unchanged since 2010. There are standard desired behaviors that would increase usability of the script while simplifying the configuration in the servers cron.
Current standard functionality of Ims2disk.sh is to:
Complete a full dump of the ims db from LOCAL
Load the full dump into MAINT
Requesting 3 new options for Ims2disk.sh:
1. Add a new Ims2disk.sh flag that would force a 'dump tran ims' just prior to full dump
Why? When full dump/load takes long time (>12 hrs) on systems with large db and slow NAS - the logsegment in LOCAL is at risk of filling up.
2. Add a new flag to Ims2disk.sh that would automatically run an incremental dump.
-
Why? This would eliminate lengthy cron jobs with multiple scripts in a single line. Instead of the standard functionality listed above, the new sequence could be:
Complete a full dump of ims from LOCAL
Complete an incremental dump from LOCAL
Load full dump to MAINT
Load first incremental dump to MAINT
3. Add a new flag to Ims2disk.sh that calls Execdbcc.sh when completed.
Why? This would simplify cron and run the dbcc checks automatically post full backup without needing to 'guess' when the full backup completes to schedule the dbcc.
<EOM>