Course Duration
40 HOURS
About DB2
IBM DB2 is a family of database server products developed by IBM. These products all support the
relational model, but in recent years some products have been extended to support object-relational features
and non-relational structures, in particular XML. DB2 can be administered from either the command-line or a GUI.
The command-line interface requires more knowledge of the product but can be more easily scripted and automated.
The GUI is a multi-platform Java client that contains a variety of wizards suitable for novice users. DB2 supports
both SQL and XQuery. DB2 has native implementation of XML data storage, where XML data is stored as XML (not as
relational data or CLOB data) for faster access using XQuery.
Course Contents
DB2Introduction to DB2
- What is database and its basic types
- Database models
- Hierarchical
- Network
- RDBMS
- Object Oriented
- Discuss about storage group and volumes table spaces
- Index spaces
- Basic Information About
- Table
- Row
- Column
- Queries
- View
- Trigger
- Synonyms
- Alias
- Discuss Physical Storage of DB2
- DB2 objects
- Buffer pools
- Features of Database design and its types
- Discuss the advantages of DB2 over VSAM
- Discuss the features of data integrity and referential integrity
Interaction with DB2
- Interaction with DB2 using TSO with SPUFI tool and QMF tool
- Introduction to SQL for interacting with DB2
- Introduction to COBOL-DB2 application program
- Using run JCL we can pass the queries
- With execute immediate
- Using prepare and execute technique
- Using dynamic SQL for running the queries
- Discussing the compilation of COBOL-DB2 program
- Facility of Error handling in DB2
- Using DSNTIAR procedure approach
- Using SQL codes
- Discussing commit and rollback features
- Introduction to CURSOR concept
- Handling Null values in DB2
- Handling Varchars
- Locks facility
- Error Handling
- Error Handling – Introduction
- SQLCA
- DSNTIAR
- WHENEVER
- COMMIT
- Rollback
DB2 Utilities
- Data Consistency Utilities
- CHECK Utility
- REPAIR Utility
- REPORT Utility
- DIAGNOSE Utility
- Backup and Recovery Utilities
- COPY Utility
- MERGECOPY Utility
- QUIESCE Utility
- RECOVER Utility
- REBUILD Utility
- REPORT RECOVERY
- Data Organization Utilities
- LOAD Utility
- REORG Utility
- Catalog Manipulation Utilities
- CATMAINT Utility
- MODIFY Utility
- RUNSTATS Utility
- STOSPACE Utility
Miscellaneous
- DB2 Commands
- Dynamic SQL – Introduction
- Dynamic SQL – Types
- When to use Dynamic SQL
- Execute Immediate SQL
- Non-select dynamic SQL
- Parameter marker
- Fixed-list select
- Varying-list select SQL
Stored Procedure
- Stored Procedure – Development
- Creating Stored Procedures
- Managing Stored Procedures
- Executing a Stored Procedures
Register Now