Although the SoftBase tools are made specifically for z/OS Db2 application developers (programmers), Db2 DBA’s can also use these tools and benefit from them. The tools allow DBA’s to focus on other tasks than:
- Extracting test data
- Loading test data
- Analyzing Db2 Access paths
- Analyzing Job performance
- Determining Db2 Dead Locks
- Building Complex Query SQL
- Gathering Db2 Catalog information
- Determining clustering index sort control cards to sort data before loading
- Building load control cards
- Recovery for restart
Application developers readily have this information needed for analysis and discussion while minimizing the need for DBA time. It’s much easier to resolve an issue if it is well identified.
