Challenge Overview
The expected language is DB@ - Stored procedure
Create an executable on AIX / UNIX platform which can be used to query the following parameters of a DB2 database for which a connection was previously established:
- Actual size of the database
- Total size of the database space.
- Actual size of the logs
- Total size of the logs
Query the DB2 catalog tables for the actual size of database
Query the DB2 catalog tables for the total space size of the database
Query the DB2 catalog tables for the actual size of database logs
Query the DB2 catalog tables for the total size of database logs
Final Submission Guidelines
Example of the Software Usage:
a) Establish a database connection:
b) Launch the executable as CHECKSPC:
CHECKSPC
Results of available space scanning:
(DB Name) available space: 0.00 Mb
(DB Name) total space: 0.00 Mb
(DB Name) Log Files available space: 0.00 Mb
(DB Name) Log Files total space: 0.00 Mb