Call : (+91) 968636 4243
Mail : info@EncartaLabs.com

File-AID for DB2

( Duration: 1 Day )

This File-AID for DB2 training course provides the applications programmer with an in-depth knowledge of File-AID for DB2. It is aimed at programmers who need to code or support DB2 application programs written in COBOL, PL1 or C.

By attending File-AID for DB2 workshop, delegates will learn to:

Define and set the user parameters for File-AID for DB2
Set up a DB2 test environment, using correctly defined tables, views, indexes, synonyms and aliases using File-AID for DB2
Define and maintain Referential Integrity using File-AID for DB2
Define and maintain Table Check Constraints using File-AID for DB2
Define and maintain DB2 security using File-AID for DB2
Selectively copy data from one table to another
Browse and edit the data on a table
Use the Object List to display and maintain DB2 objects
Use the Privileges Utility to display and maintain privileges against DB2 objects
Use the File-AID for DB2 SQL LOAD utility to populate tables
Use the IBM LOAD utility to populate tables
Use the Impact Analysis Report to determine the effect of a change in column size or type
Use the SQL Analysis and Development utility to improve SQL performance
Produce reports of either data or audit information
Maintain referential integrity and application integrity

Familiar with the z/OS host environment, together with a working knowledge of DB2, SQL and using TSO / ISPF.

COURSE AGENDA

1

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

2

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

3

DB2 Object Create, Alter And Drop

Object Selection

4

Tablespaces

Tablespace Selection
Tablespace Definition
Tablespace Definition Parameters

5

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

6

Indexes

Index Selection
Index Definition
Index Definition Parameters

7

Views

View Selection
View Definition
View Definition Parameters

8

Synonyms And Aliases

Synonym & Alias Selection
Synonyms
Synonym Definition
Aliases
Alias Definition

9

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

10

Browsing And Editing Data

Browse Options
Browse Panel
Edit Options
Edit Panel
Selection Criteria
PF Keys
Row Navigation

11

Primary Commands

12

Line Commands

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

13

Selection Criteria

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

14

Object Lists

Object List Processing
Object List Utility
Object List Utility Parameters
Object Processing
Object List
Object Actions

15

SQL Command Manager

SQL Command Manager
SPUFI Access

16

Privileges

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

17

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

18

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

19

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

20

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

21

Table Relationships

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

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top

Notice

X