Challenge Overview
This contest is to implement a series of scripts to handle automated administration of database administration tasks. This contest is going to create ksh scripts handling Materialized Query Table Processing.
Please check the hight level details in the attached document - Materialized Query Table Processing.doc.
The hope is to produce ksh scripts that are generic enough to operate with the appropriate inputs, perform necessary error checking, database object validation and provide email based communication of any issues experienced during execution.
General Requirements
- Database server is DB2 v9.7 LUW Fixpak 5.
- Script is to be developed using standard ksh.
- A database called SCRIPTDB will be used for testing. The scripts for database creation is in the Download Section.
- SCRIPTDB contains a series of Range partition tables (SCRIPTDB.A1/A2, SCRIPTDB.B1/B2… etc). These have been created with the express purpose of testing and validation of the script.
- The desired environment is a Windows based machine. Cygwin is expected to use for executing the ksh scripts.
Samples
A sample ksh script is provided for your reference, please see the Download section. The format of this script can be used to fit the MQT refresh logic (some careful replacement of the list tablespaces and associated command modification). it provides a mechanism for error handling, notification and issuing DB2 commands.
Final Submission Guidelines
Deliverables
- Deployment Guide about the scripts usage
- Any test data for verification the db scripts
- the created ksh scripts fulfilling the rquirements.