|
|
File-AID for DB2
| Duration: 1 day |
| Participants: Application developers, end users, and others who want to make effective use of the File-AID for DB2 tool. |
|
Objectives:
Upon successful completion of this course you will be able to:
- Make effective use of the File-AID for DB2 tool. - Interactively edit, browse and manipulate DB2 tables, views and other objects. - Create, populate, customize and refresh DB2 data. - Extract and load table data. - Generate SQL. - Create new objects. - Specify selection criteria. - View Explain analysis reports. - Prototype SQL code, using FADB2. - Show authorization reports for specific objects. - Connect to SPUFI and Xpediter. |
|
Overview:
- This course is an interactive course designed to show students how to make effective use of the File-AID for DB2, a self-contained DB2 database management and testing tool. File-AID for DB2 has interactive and batch features and is a menu-driven interface similar to ISPF. - Students need access to the public EMP and DEPT tables (auth-id DSN8510 or similar), as well as to updatable EMP, DEPT, and PLAN_TABLES tables that have the student’s or instructor’s auth-id (XXDK). It is recommended that students be able to create objects of their own as well. |
| Prerequisites: Knowledge of File-AID On-Line (File-AID for TSO) is required as well as iknowledge of TSO/ISPF and DB2/SQL. |
| Format: Lecture and discussion with extensive hands-on exercises. |
|
Topic Outline:
- File-AID for DB2 Features - References - Setup Allocation Fields Allocation Message - Starting File-AID for DB2 - Choosing a Subsystem - File-AID for DB2 Primary Option Menu - User Parms Menu (Option =0) Display Options (Option =0.1) Dataset for SQL (Option =0.2) Batch JOB Statement (Option =0.3) PF Keys (Option =0.4) Object Creation Defaults (Option =0.5) Logging Options (Option =0.6) Print Options (Option =0.7) - Browse (Option =1) Browse Fields: Edit Template Information Browse Fields: Specify Browse Options Selection Criteria Member List Table / View Selection Screen Browse Selection Template Selection Template WHERE Conditions Primary Commands Selection Template Example Entering Selection Criteria Generated SQL F6 = Execute Saving Criteria Browse Wildcards - Edit (Option =2) - Utilities (Option =3) Object Selection (Option =3.2) Table Create (Option =3.2.1) Steps to Create a New Table Table Create from Model Add Columns to Table Definition Table Create Commands Execute the Create Command Create an Index (Option = 3.2.3) Create a View (Option =3.2.4) Using a View Copy Between Tables (Option =3.3) Copy Column Selection Copy Error Copy with Unique Index Object List Utility (Option =3.4) Generated DDL Privileges Information Index Information Index Key Information Column Information More Object Details Find Your Packages More Information on Packages Last TimeStamp for a Package SPUFI from File-AID (=3.5) Manage Privileges (Option =3.6) Privileges for Tables / Views Extract / Load (Option =3.7) Extract Selection Template Extract Choices Create Data Extract Dataset Create COBOL Extract Dataset Do the Extract View Extracted Output Browse Extracted COBOL Member Browse Extracted Unload Instruction Browse Extracted Class File Edit the Extract Data Load (Option =3.7) Load Confirmation Load Messages Load Detail Report Column Impact (Option =3.8) - SQL Analysis and Development (Option =4) Plan_Table Maintenance (Option =4.0) SQL Plan Analysis (Option =4.1) DB2 Explain Reports (Option =4.2) SQL Analysis Summary Plan_Table Reports Access Analysis Report (#1) Explain Detail Report (#2) Drill-Down into Report More on Explain Details Report Predicate Analysis Report (#3) Catalog Information Report (#4) More on Catalog Info Report SQL Analysis Edit Entry (Option =4.3) - FADB2 FADB2 EX Results FADB2 XP Results - Xpediter (Option =XP) - RDX (Option =R) |
|
|