Verifying the customization of ZDT/Db2
After you have completed all the necessary steps to install and customize ZDT/Db2, you can perform the following steps to verify your customization.
- Use the ZDT/Db2
Edit/Execute SQL (Data Set)
function to execute sample DDL. This creates a small database that is used in subsequent IVP steps. - Run a batch job to execute the Db2® CHECK DATA utility against the Db2® objects in the ZDT/Db2 IVP database.
- Use the ZDT/Db2
Db2® Utilities
function to generate and run a job to take an image copy of the Db2® objects in the ZDT/Db2 IVP database. - Use the ZDT/Db2 editor to display and modify data in the ZDT/Db2 IVP tables.
- Use the ZDT/Db2
Basic SELECT Prototyping
function to create and execute a simple join of the tables in the ZDT/Db2 IVP database. - Use the ZDT/Db2
Copy utility
function to copy data from one IVP table to another. - Use the ZDT/Db2
Export utility
function to copy the data in one of the ZDT/Db2 IVP tables to a sequential data set. - Use the ZDT/Db2
Import utility
function to copy the sequential data set (created in step 7) into a Z Data Tools/Db2 IVP table. - Use the ZDT/Db2
Object list utility
function to display information about the ZDT/Db2 IVP database and objects.
To review the customization and verification steps, refer to:
- Checklist for installing and customizing ZDT/Db2
- Z Data Tools User’s Guide and Reference for DB2 Data.