DB10 - File-AID for DB2 - 1 Day

Course Description

Customisation

For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.

Course Details

INTRODUCTION TO FILE-AID FOR DB2
File-AID for DB2 Invocation
The Primary Menu
Defaults and User Parameters
Browsing and Editing
Utilities
Creating, Dropping and Altering DB2 Objects
Copying Rows Between Tables
Object Lists
SQL Command Manager
Display, Grant, Revoke and Modify Privileges
Column Impact Analysis
SQL Analysis
Print Data
Referential and Application Relationships

SYSTEM PARAMETERS
An Overview of System Parameters
Browse Options
Edit Options
SQL Analysis Display Options
SQL Dataset Allocation
Batch Options
PF Keys
Database Parameters
Tablespace Parameters
Index Parameters
Logging Options
Print Options & Parameters

DB2 OBJECT CREATE, ALTER AND DROP
Object Selection

TABLESPACES
Tablespace Selection
Tablespace Definition
Tablespace Definition Parameters

TABLES
Table Selection
Table Parameters
Table Definition
Table Definition Parameters
Column Definition
Primary Key Definition
Foreign Key Definition
Default Column Value Definition
Column Check Constraints Definition

INDEXES
Index Selection
Index Definition
Index Definition Parameters

VIEWS
View Selection
View Definition
View Definition Parameters

SYNONYMS AND ALIASES
Synonym & Alias Selection
Synonyms
Synonym Definition
Aliases
Alias Definition

COPYING TABLE DATA
Table Selection
Table Copy Selection Template
Table Copy Selection Parameters
Column Selection
Column Selection Parameters
Selection Criteria
Copy Execution
SQL for Selection

BROWSING AND EDITING DATA
Browse Options
Browse Panel
Edit Options
Edit Panel
Selection Criteria
PF Keys
Row Navigation

PRIMARY COMMANDS
Autosave
Browse
Bounds
Cancel
Caps
Change
Char
Copy
Create
Cut
Delete
Display
Exclude
Filler
Find
Fmt
Graphic
Hex
Hide
Hold
Info
Locate
Max
Merge
Offset
Pad
Printp / Printds
Profile
Rbrowse
Redit
Repeat
Replace
Reset
Row
Show
Sort
SQLID
Table
Undo
Vfmt
Zero
Zoom

LINE COMMANDS
Insert
Repeat
Delete
Copy
Move
After
Before
Overlay
Exclude
First
Last
Show
Shift
Cols
Mask
Bounds
Protect
Unprotect
Overlay

SELECTION CRITERIA
Selection Criteria
Selection Criteria Parameters
Column Selection
Row Sequence
Where Clause
Relational Operators
Logical Operators
Conditional Operators

OBJECT LISTS
Object List Processing
Object List Utility
Object List Utility Parameters
Object Processing
Object List
Object Actions

SQL COMMAND MANAGER
SQL Command Manager
SPUFI Access

PRIVILEGES
Privilege Utility
Grant / Revoke Privileges
Grant / Revoke Privilege Parameters
Privilege Actions
Display Privileges
Grant Privileges
Revoke Privileges
Modify Privileges
Privilege List

EXTRACTING AND LOADING DATA
Extract and Load Utility
Data Extract and Load
Data Extraction
Extract Options
Extract Option Parameters
Extract Selection
Extract Execution
Extract Execution Parameters
Extract Dataset
Extract Dataset Parameters
Control Card Dataset
Control Card Dataset Parameters
Delimited File Options
Delimited File Option Parameters
Extract Confirmation
On-Line Extract
Batch Extract
Data Load
Load Options
Load Option Parameters
Load Dataset
Load Dataset Parameters
SQL Load
SQL Load Parameters
SQL Load Confirmation
SQL Load Report
DB2 Load Utility
DB2 Load Utility Parameters
DB2 Load Utility Confirmation
DB2 Load Utility Report

IMPACT ANALYSIS
Column Impact Analysis
Column Impact Analysis Parameters
Column Impact Analysis Table
Impact Selection
Impact Analysis Output Specification
Impact Analysis Output to Printer
Impact Analysis Output to Dataset
Column Impact Analysis Report

SQL PERFORMANCE
SQL Analysis and Development
PLAN_TABLE Maintenance
SQL Plan Analysis
Object Selection
F2PLAN_TABLE Table
Analysis Level
SQL Statement Analysis
SQL Statement Summary
Explain Results
Access Path Analysis
Explain Detail
Explain Detail - Table Information
Explain Detail - Column Information
Explain Detail - Index Information
Explain Detail - Related Table Information
Explain Detail - Table Partition Statistics
Explain Detail - Table Check Constraints
Explain Detail - Index Information
Explain Detail - Field Information
Predicate Analysis
Catalog Information
SQL Source Development and Analysis
Program / Source SQL Selection

PRINTING
Print Processing
Print Table Data
PRINTP Selection Template
Report Format
Report Format - Row Mode
Report Format - Table Mode
Audit Trail Report
Audit Trail Report Selection

TABLE RELATIONSHIPS
Relationship Options
Relationship Dataset
Relationship Table Maintenance
Relationship Summary
Relationship Details
RI Relationship Table Maintenance
Application Relationship Table Maintenance
Maintain Application Relationships

Course Enquiry