Module | 3DB2 | Description | In this course students will use the DB2I interface to manage a DB2 database. It will make use of SQL to the various objects to create, manipulate and control. The various online utilities of DB2 will be used to manage objects, which will be paid attention to the commands, the JCL and restart the various possibilities that exist. | Topics | *Using SQL through SPUFI
DDL / DML / DCL
Information retrieve objects from the DB2 catalogue
*DB2 objects
Database / storage group / table space / table / index / view
*DB2 commands
Start / Stop/ Display
*Online Utilities
Load / Copy / Reorg / Check / Unload / Recover / Runstats
*Restart of utilities
*Troubleshooting | Prerequisites | Course 1DB2, 1JCL, 3JCL, 3TSO, 1VSAM | Coursedays | 2 days | Class | Online assignments | Special | DB2 Version 8 |
|
