-
IBM Db2 12: Foundation for Relational DBAsLes mer
COURSE CONTENT: Part 1: Essentials for Relational BAs • Introduction to Db2 v12.1 • Db2 Command Line and GUI Tools • The Db2 Database Manager Instance • Creating Databases…
-
IBM Db2 12.1: Performance and Tuning Optimization for Relational DBAsLes mer
COURSE CONTENT: Unit 1: Statistics and Query Optimization Unit 2: Indexing for Performance Improvements Unit 3: Using EXPLAIN Tools for Query Optimization Unit 4: Monitoring Fundamentals TARGET AUDIENCE:…
-
IBM Db2 12.1: Security and Concurrency for Relational DBAsLes mer
COURSE CONTENT: Unit 1: Locking and Concurrency Control Unit 2: Security and Access Control Fundamentals Unit 3: More about Db2 Security and Access Control TARGET AUDIENCE: This…
-
IBM Db2 12.1: Data Management and Recovery for Relational DBAsLes mer
COURSE CONTENT: Course Introduction Unit 1: Data Movement and Loading Fundamentals Unit 2: Backup and Recovery Unit 3: Database Maintenance, Monitoring, and Problem Determination TARGET AUDIENCE: This…
-
IBM Db2 12.1: Essentials for Relational DBAsLes mer
COURSE CONTENT: Course Introduction Unit 1: Introduction to Db2 v12.1 Unit 2: Db2 Command Line and GUI Tools Unit 3: The Db2 Database Manager Instance Unit 4: Creating Databases…
-
IBM InfoSphere QualityStage Essentials v11.7Les mer
COURSE CONTENT: • Data Quality Issues • Exercise 1: Pre-lab Prep • QualityStage Overview • Exercise 1: QualityStage Logon • Developing with QualityStage • Exercise 1: Import Table Definition…
-
IMS Diagnostic ApproachesLes mer
COURSE CONTENT: Not available. Please contact. TARGET AUDIENCE: Not available. Please contact. COURSE OBJECTIVE: Not available. Please contact. COURSE PREREQUISITES: Not available. Please contact. …
-
IMS SecurityLes mer
COURSE CONTENT: • Introduction to IMS Security • IMS Security Facilities • IMS Security Options • Introduction to RACF • User ID and Sign On Verification • Securing the…
-
IBM InfoSphere DataStage Engine Administration for Information Server v11.7Les mer
COURSE CONTENT: Unit 1: Introduction to the Information Server (DataStage) engine Information Server architecture How the DataStage Engine is used in Information Server DataStage Engine features Unit 2: Elements…
-
IBM InfoSphere DataStage Essentials v11.7Les mer
COURSE CONTENT: • Unit 01: Introduction to DataStage • Unit 02: Deployment • Unit 03: DataStage Administration • Unit 04: Working With Metadata • Unit 05: Creating Parallel Jobs…
-
Db2 13 for z/OS Utilities for Database AdministratorsLes mer
COURSE CONTENT: • RUNSTATS, DSN1COPY,REPAIR, and DIAGNOSE • LOAD and REBUILD INDEX performance and availability • Online CHECK DATA • REORG performance and availability • UNLOAD performance and availability…
-
Db2 12 for z/OS SQL Performance and TuningLes mer
COURSE CONTENT: • Introduction to SQL performance and tuning • Performance issues • Simple example • Visualizing the problem • Summary Performance analysis tools • Components of response time…
-
Db2 13 for z/OS Advanced Database AdministrationLes mer
COURSE CONTENT: Unit 1: Program Preparation and the Use of Packages – Part 1 Unit 2: Online Schema Changes – Part 1 Unit 3: Online Schema Changes – Part…
-
Db2 12 for z/OS Advanced Database AdministrationLes mer
COURSE CONTENT: Not available. Please contact. TARGET AUDIENCE: Students needing to augment their skill set in administering a Db2 12 for z/OS database environment. COURSE OBJECTIVE:…
-
Db2 for z/OS 13: Introduction to System AdministrationLes mer
COURSE CONTENT: Unit 1: Starting, Stopping, and Accessing Db2 Unit 2: Db2 Components and Processes Unit 3: System Security Unit 4: Db2 Authorization Unit 5: Program Flow for All…
-
Db2 12 for z/OS Introduction to System AdministrationLes mer
COURSE CONTENT: Starting, stopping, and accessing Db2 • Starting Db2 as part of the z/OS IPL process • Data set allocation and APF authorization • The START DB2 and…
-
Db2 13 for z/OS Basic Database AdministrationLes mer
COURSE CONTENT: Not available. Please contact. TARGET AUDIENCE: Students who will be performing the role of Db2 for z/OS database administrators who need to acquire the basic skills…
-
Db2 12 for z/OS Basic Database AdministrationLes mer
COURSE CONTENT: Please refer to the course objectives. TARGET AUDIENCE: >Students who will be performing the role of Db2 for z/OS database administrators who need to acquire…
-
DB2 11 for z/OS Application Programming WorkshopLes mer
COURSE CONTENT: • DB2 Concepts • Program Structure I • Program Preparation • Program Structure II • Recovery and Locking Concepts • Dynamic SQL Introduction • Managing Test Data…
-
New Functions and Features in Db2 for z/OS (v13)Les mer
COURSE CONTENT: • Unit 1: Db2 v12 Function Levels: Selected Highlights • Unit 2: Migrating to Db2 13 • Unit 3: Availability & Scalability • Unit 4: Performance •…
-
Db2 12 for zOS: Basics for DBA BeginnersLes mer
COURSE CONTENT: Unit 1 Introduction • The modern Mainframe Environment • Defining z/OS • What are the benefits of z/OS? • Typical z/OS workloads • Batch processing • Online Transaction…
-
Introduction to DB2 for zOS for Systems and Operations PersonnelLes mer
COURSE CONTENT: CONTENTS: z/OS Prequisite Review DB2 Relational Database Concepts Structured Query Language (SQL) and SPUFI DB2 Objects The DB2 System DB2 Commands and Program Preparation DB2 Utilities DB2…
-
IMS TM Performance and TuningLes mer
COURSE CONTENT: Not available. Please contact. TARGET AUDIENCE: Not available. Please contact. COURSE OBJECTIVE: Not available. Please contact. COURSE PREREQUISITES: Not available. Please contact. …
-
IMS Fast PathLes mer
COURSE CONTENT: • Overview of IMS Fast Path • Expedited Message Handler (EMH) • Main Storage Database (MSDB) • Data Entry Database (DEDB) • Fast Path System Functions •…
-
IMS Shared QueuesLes mer
COURSE CONTENT: • Introduction • IMS, CQS, and Shared Queues Mainline Processing • Enabling Shared Queues • Special Considerations TARGET AUDIENCE: This is an advanced course for…
-
IMS Data SharingLes mer
COURSE CONTENT: • Introduction to Data Sharing • Overview of Data Sharing Functions • Locking • Buffer invalidations and notifies • Installation and definition • Utilities • Normal operation…
-
IMS High Availability Large Database (HALDB)Les mer
COURSE CONTENT: • Overview • Database Structures • Definition • Partition Selection • DBRC Support • Database Commands • Utilities • Database Creation and Migration • Changing Databases •…
-
IMS Database Performance and TuningLes mer
COURSE CONTENT: • Introduction to IMS database tuning • Introduction to the lab project • Review of the IMS access methods • Measuring IMS database performance Lab 1: The…
-
IMS Logical RelationshipsLes mer
COURSE CONTENT: • Introduction to Logical Relationships • Unidirectional Logical Relationships • Unidirectional Logical Data Structures • Bidirectional Logical Relationships • Bidirectional Logical Data Structures • Database Load and…
-
IMS Physical Organization of Databases WorkshopLes mer
COURSE CONTENT: • Introduction to DL/I • IMS Access Methods • HISAM • DBD/PSB/Data Sets/JCL • IMS Test Utility: DFSDDLT0 • HD Access Methods • HIDAM • HDAM •…
-
IMS Database Recovery Control (DBRC)Les mer
COURSE CONTENT: • DBRC Overview • DBRC Implementation • Database Registration • Recording Log Information • Data Sharing • Subsystem Authorization • GENJCL (GENerate JCL) • Utilities • RECON…
-
IMS Transaction Manager Application ProgrammingLes mer
COURSE CONTENT: • IMS TM System Overview • Message Processing Programming • Get/Send Terminal Data • Message Format Services (MFS) • Create and use MFS control blocks • IMS/TM…
-
IMS Database Application ProgrammingLes mer
COURSE CONTENT: • DL/I Environment • DL/I Call Processing • DL/I Rtrieval Calls • DL/I Update Calls • DL/I Programming Techniques: Part 1 • DL/I Advanced Segment Search Arguments…
-
IMS DBCTL Systems ProgrammingLes mer
COURSE CONTENT: • Introduction to IMS DBCTL • IMS DBCTL Installation and Installation Verification Program (IVP) Dialog • IMS DBCTL System Definition • Preparing the operating system • IMS…
-
IMS System Programming – Database and Transaction ManagementLes mer
COURSE CONTENT: • IMS Packaging and Overview • IMS Installation and IVP • Transaction Flow: Input Messages • Transaction Scheduling and Execution • IMS Locking, IMS Logger and Syncpoint…
-
IMS Installation WorkshopLes mer
COURSE CONTENT: • Packaging and Installation • SMP/E Installation • IMS IVP Dialog • IMS Migration Considerations • IMS Definition • General IMS Maintenance Recommendations • Hints and Tips…
-
IMS FundamentalsLes mer
COURSE CONTENT: • IMS Database Fundamentals • Accessing IMS Databases – DL/I Calls • IMS Hierarchic Access Methods • Additional IMS Database Functions • IMS Transaction Manager • IMS…
-
IBM Db2 LUW Family FundamentalsLes mer
COURSE CONTENT: The following topics are included in this course: • Understanding a table • Data modeling and database design • How end users use Db2 • How a…