-
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 DB2 Project Specifics U6DB2PSGLes 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. …
-
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…
-
TDS_KM204G IBM InfoSphere DataStage Essentials (v11.5)Les mer
This course enables the project administrators and ETL developers to acquire the skills necessary to develop parallel jobs in DataStage. The emphasis is on developers. Only administrative functions that…
-
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…