Mainframe - DB2 Administration
Mainframe - DB2 Administration
Duration in Hours (4 Hours session) : 96
Duration in Days: 24
MFSYS – 11 Advanced Module
IMS DB Administration for Mainframe
Course Code: MSDB15
12 Days of Theory and Lab
Lab and Assignments included
IMS Database Administration Modules
- Database manager
- Database handling
- Other Data Language/Integrated (DL/I) functions
- TM
- Transaction message processing
- Fast path
- Large system environment
- Distributed processing
- IMS –DB2 Attachment
- Introduction to DL/I
- DL/I application programming techniques
- Use of the DL/I test program
- Introduction to IMS access methods
- Hierarchic Indexed Sequential Access Method (HISAM), Hierarchic Indexed Direct Access Method (HIDAM), and Hierarchic Direct Access Method (HDAM) physical storage characteristics and organizations
- Introduction to High Availability Large Database (HALDB)
- DBD, PSB, and JCL datasets and coding
- Introduction to IMS database tuning
- Introduction to the lab project
- Review of the IMS access methods
- Measuring IMS database performance
- Lab 1: the base case
- Lab 2: using IMS reports
- Tuning VSAM buffers
- Lab 3: tuning VSAM buffers
- Tuning VSAM data sets
- Lab 4: tuning VSAM data sets
- Additional performance issues
- Tuning secondary indexes
- Lab 5: tuning secondary indexes
- Tuning HDAM
- Lab 6: tuning HDAM
- Tuning OSAM data sets and buffers
- Lab 7: OSAM data sets and buffers
- Other tuning considerations
- IMS security overview
- Default security overview
- SMU overview
- RACF overview
- Sign-on security
- Transaction security
- Command security
- Automated operator program security
- Dependent region and Application Group Name (AGN) security
- Security for IMS client/server interfaces (TCP/IP, Advanced Program-to-Program Communications (APPC), Open Transaction Manager Access (OTMA), and Open Database Access (ODBA))
- Security for Multiple Systems Coupling (MSC) and Intersystem Communication (ISC) environments
- Planning for RACF implementation
- Database control (CICS/IMS) and coordinator control (IMS/DB2) security
- Setup for IMS installation
- Installation of the IMS product using SMP/E
- Review IMS documentation setup process
- IMS and z/os control block structure overview
- IPCS analysis overview
- IMS wait analysis overview
- IMS ABEND analysis overview
- Dump Analysis exercise
- Enhancements and new functionality of IMS V8:
- Database Recovery and Sharing Control (DBRC) enhancements
- Image Copy 2 enhancements
- Data Entry Database (DEDB) enhancements
- Remote site recovery and coordinated IMS and DB2 disaster recovery
- Advanced Program-to-Program Communications (APPC) enhancements
- Transaction trace (new function)
- Syntax checker Interactive System Productivity Facility (ISPF) application
- Parallel database open and close processing (new function)
- Resource Recovery Services (RRS) support for IMS batch regions (new function)
- Support for Java dependent regions (new function)
- Overview of the Common Service Layer, the next step in the IMS architecture, which offers improved systems management through:
- Automatic Recovery Control Data Set (RECON) loss notification
- Operations manager and the single point of control
- Resource manager and sysplex terminal management
- DBRC overview
- DBRC installation
- DBRC log control
- Database Sharing