SUMMARY:   The Course is designed for those applications programmers using DB2 on a Linux, Unix or Windows environment. The presentation is a mixture of lecture sessions and a workshop, which is designed to introduce all aspects of relational technology as implemented by DB2, up to, and including version 9. AUDIENCE:   Applications programmers who are exposed to, or required to write and perform activities associated with application development and implementation, in a DB2 environment. PREREQUISITES:   Those attending the course should be familiar in developing applications. DURATION:   4 Days COURSE CONTENT:   DAY 1 TOPICS Introduction to DB2 Versions System architecture Terms/Terminology Instance/Database/Partitioned Database Tablespace regular/system temporary/user temporary/catalog Tables Views Merge Materialization Columns Nulls Referential Integrity Buffer Pools Alias Attributes Numeric Character Date/Time UDT Lob’s identity/sequence SQL Execution Environment Command line processing Command line prompt COMMAND CENTER CONTROL CENTER(WIZARD) SQL EXPLORER Data Definition Language Overview CONNECT DATABASE TABLESPACE TABLE ALTER DAY 2 TOPICS Catalog How to search the catalog Relevant tables History tables Simple SQL SELECT (single table) */ALL/COLUMNS/DISTICT/CONCATENATOR/literals/ORDER BY FETCH FIRST Efficiency aspects Predicates = (efficiency aspects) IN (efficiency aspects) BETWEEN (efficiency aspects) LIKE (efficiency aspects) AND/OR Built in function MAX/MIN/SUM/COUNT/AVG/COUNT_BIG Scalar Functions Examples and use of some of them e.g. SUBSTR/VALUE etc GROUP Complex SQL Table joins EQ JOIN SUBSELECT CORRELATED SUBSELECT union/except/intersect Left/Right/Full Joins In Line Tables CASE Remainder of DML statements UPDATE/DELETE/INSERT/MERGE DAY 3 TOPICS Embedded SQL DCLGEN SQLCA Error handling Whenever SQLCODE/SQLSTATE test Singleton selects Uncursored SELECTS (Singleton SELECTS) Scrollable cursors CURSOR CURSOR WITH UPDATE/DELETE Block Fetch Development cycle Dynamic/Static SQL Precompile DBRMs BIND PACKAGES Developing and running applications DAY 4 TOPICS LOCKING STRATEGY Introduction What resources can be locked? The different locks available Duration of a lock Commit/rollback Locking notes INDEXING Physical data management Tablespace Object Page Record identifier RUNSTATS/REORG MDC (version 8) Access strategy Multi table access path VISUAL EXPLAIN INDEX ASSIST HEALTH CENTRE SECURITY GRANT/REVOKE Table check constraints TRIGGERS STORED PROCEDURES Utilities BACKUP RESTORE LOAD/UNLOAD IMPORT/EXPORT IC/07