-
IBM Db2 12: Foundation for Relational DBAs (TDS_CLA96G)Les 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 DBAs (TDS_CLA94G)Les 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
-
IBM Db2 12.1: Security and Concurrency for Relational DBAs (TDS_CLA93G)Les 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
-
IBM Db2 12.1: Data Management and Recovery for Relational DBAs (TDS_CLA91G)Les 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
-
IBM Db2 12.1: Essentials for Relational DBAs (TDS_CLA90G)Les 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.7 (TDS_KM214G)Les 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 Security (TDS_CM43G)Les 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.7 (TDS_KM530G)Les 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.7 (TDS_KM304G)Les 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 Administrators (TDS_CV972G)Les 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 Tuning (TDS_CV964G)Les 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 Administration (TDS_CV881G)Les 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 Administration (TDS_CV880G)Les mer
COURSE CONTENT: Not available. Please contact.
-
Db2 for z/OS 13: Introduction to System Administration (TDS_CV854G)Les 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 Administration (TDS_CV853G)Les 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 Administration (TDS_CV845G)Les mer
COURSE CONTENT: Not available. Please contact.
-
Db2 12 for z/OS Basic Database Administration (TDS_CV844G)Les mer
COURSE CONTENT: Please refer to the course objectives.
-
DB2 11 for z/OS Application Programming Workshop (TDS_CV722G)Les 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) (TDS_CV321G)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 Beginners (TDS_CV042G)Les 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 Personnel (TDS_CV021G)Les 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 Fast Path (TDS_CM64G)Les 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 Queues (TDS_CM612G)Les mer
COURSE CONTENT: • Introduction • IMS, CQS, and Shared Queues Mainline Processing • Enabling Shared Queues • Special Considerations
-
IMS Data Sharing (TDS_CM502G)Les 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) (TDS_CM46G)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 Tuning (TDS_CM30G)Les 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 Relationships (TDS_CM241G)Les 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 Workshop (TDS_CM22G)Les 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) (TDS_CM20G)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 Programming (TDS_CM18G)Les 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 Programming (TDS_CM17G)Les 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 Programming (TDS_CM122G)Les 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 Management (TDS_CM111G)Les 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 Workshop (TDS_CM059G)Les 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 Fundamentals (TDS_CM01G)Les 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 Fundamentals (TDS_CE032G)Les 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…