db2-check-state

Various DB2 database state checks wrapped in a test harness for repeatability and automation.

Tests

Tests are SQL statements executed via a Sharness test harness. The output is TAP compatible so can be consumed by many systems.

Test currently included are:

1. Invalid Packages
2. Tablespace Status
3. Invalid Packages
4. Invalid Procedures and Functions
5. Re-Org Pending Tables

If tests fail re-mediation scripts are generated (to rebind packages for example).

Usage

• Clone this repo:

git clone https://github.com/jonbartlett/db2-check-state.git

• There is no uniform method to get the database instance name therefore editing the function DBConnect() may be necessary.
• Run tests either directly:

$ ./environment.t

or via Prove:

$ prove -v environment.t

Contributions

Are welcome. Fork and submit pull request.