DB2 für z/OS 39 Veranstaltungen

PREFERRED

IBM CV041G - z/OS and DB2 Basics for DB2 for z/OS DBA Beginners

Cegos_Integrata GmbH (7)

Course OutlineCONTENTS : Introduction, TSO/E and ISPF, Data Sets, JCL and SDSF, DB2 Relational Database Concepts, Structured Query Language (SQL) and SPUFI, DB2 Objects, The DB2 System, DB2 Commands and Program Preparation, DB2 Utilities, DB2 Shutdow...

• Seminar / Kurs
• Ohne Einstufung

• 22.04.2024 - 26.04.2024, Leinfelden-Echterdingen (DE)
• weiterer Termin verfügbar

PREFERRED

IBM CV041G - z/OS and DB2 Basics for DB2 for z/OS DBA Beginners (Live Online Training)

Cegos_Integrata GmbH (7)

Course OutlineCONTENTS : Introduction, TSO/E and ISPF, Data Sets, JCL and SDSF, DB2 Relational Database Concepts, Structured Query Language (SQL) and SPUFI, DB2 Objects, The DB2 System, DB2 Commands and Program Preparation, DB2 Utilities, DB2 Shutdow...

• Webinar
• Ohne Einstufung

• 22.04.2024 - 26.04.2024
• 2 weitere Termine verfügbar

PREFERRED

IBM CV042G - Db2 12 for z/OS: Intermediate Database Administration

Cegos_Integrata GmbH (7)

Course OutlineUnit 1Introduction The modern Mainframe Environment, Defining z/OS, What are the benefits of z/OS?, Typical z/OS workloads, Batch processing, Online Transaction Processing, Job roles in the Mainframe environment, z/OS Components and Ser...

• Seminar / Kurs
• Ohne Einstufung

• 12.08.2024 - 16.08.2024, Leinfelden-Echterdingen (DE)
• weiterer Termin verfügbar

PREFERRED

IBM CV042G - Db2 12 for z/OS: Intermediate Database Administration (Live Online Training)

Cegos_Integrata GmbH (7)

Course OutlineUnit 1Introduction The modern Mainframe Environment, Defining z/OS, What are the benefits of z/OS?, Typical z/OS workloads, Batch processing, Online Transaction Processing, Job roles in the Mainframe environment, z/OS Components and Ser...

• Webinar
• Ohne Einstufung

• 22.04.2024 - 26.04.2024
• 3 weitere Termine verfügbar

PREFERRED

IBM CV862G - DB2 11 for zOS Implementation Workshop

Cegos_Integrata GmbH (7)

Course Outline Installation preparation for DB2 10 for z/OS Installation CLIST Installing the DB2 10 subsystem Verification of DB2 10 with the sample applications Performing parameter update Migrating to DB2 11 conversion mode DB2 10 enabling-new-fun...

• Seminar / Kurs
• Ohne Einstufung

• 13.05.2024 - 17.05.2024, Leinfelden-Echterdingen (DE)

PREFERRED

IBM CV862G - DB2 11 for zOS Implementation Workshop (Live Online Training)

Cegos_Integrata GmbH (7)

Course Outline Installation preparation for DB2 10 for z/OS Installation CLIST Installing the DB2 10 subsystem Verification of DB2 10 with the sample applications Performing parameter update Migrating to DB2 11 conversion mode DB2 10 enabling-new-fun...

• Webinar
• Ohne Einstufung

• 13.05.2024 - 17.05.2024
• 2 weitere Termine verfügbar

PREFERRED

IBM CV851G - DB2 10 for zOS System Administration

Cegos_Integrata GmbH (7)

Course OutlineBasic architecture and fundamental mechanisms Explain the principles of:IPLing z/OS, TSO/E LOGON, Allocation CLIST, Control of DB2, START DB2 process, DSNZPARM member, DB2 address space structure, DB2 log, Catalog and directory, Data sh...

• Seminar / Kurs
• Ohne Einstufung

• 29.04.2024 - 03.05.2024, Leinfelden-Echterdingen (DE)
• weiterer Termin verfügbar

PREFERRED

IBM CV851G - DB2 10 for zOS System Administration (Live Online Training)

Cegos_Integrata GmbH (7)

Course OutlineBasic architecture and fundamental mechanisms Explain the principles of:IPLing z/OS, TSO/E LOGON, Allocation CLIST, Control of DB2, START DB2 process, DSNZPARM member, DB2 address space structure, DB2 log, Catalog and directory, Data sh...

• Webinar
• Ohne Einstufung

• 29.04.2024 - 03.05.2024
• 2 weitere Termine verfügbar

PREFERRED

IBM CV853G - Db2 12 for z/OS Intermediate System Administration

Cegos_Integrata GmbH (7)

Course OutlineStarting, stopping, and accessing Db2 Starting Db2 as part of the z/OS IPL process Data set allocation and APF authorization The START DB2 and STOP DB2 commands zParms, DSNTIJUZ, and DSNZPARM Address spaces IRLM and lock storageDb2 comp...

• Seminar / Kurs
• Ohne Einstufung

• 24.06.2024 - 26.06.2024, Leinfelden-Echterdingen (DE)

PREFERRED

IBM CV844G - Db2 12 for z/OS Basic Database Administration

Cegos_Integrata GmbH (7)

Course OutlinePreface Course Overview, Intended Audience, Course Objectives, Prerequisites Unit 1 - Db2 Relational database concepts Relational Database design, Data access, Interacting with Db2• Catalog and directory Unit 2 - SQL and SPUFI SQL SELEC...

• Seminar / Kurs
• Ohne Einstufung

• 26.08.2024 - 28.08.2024, München (DE)
• weiterer Termin verfügbar

PREFERRED

IBM CV964G - Db2 12 for z/OS SQL Performance and Tuning

Cegos_Integrata GmbH (7)

Course OutlineIntroduction to SQL performance and tuning Performance issues Simple example Visualizing the problem SummaryPerformance analysis tools Components of response time Time estimates with VQUBE3 SQL EXPLAIN The accounting trace The bubble ch...

• Seminar / Kurs
• Ohne Einstufung

• 13.08.2024 - 15.08.2024, Leinfelden-Echterdingen (DE)

PREFERRED

IBM CV722G - DB2 11 for z/OS Application Programming Workshop

Cegos_Integrata GmbH (7)

Course OutlineDB2 Concepts, Program Structure I, Program Preparation, Program Structure II, Recovery and Locking Concepts, Dynamic SQL Introduction, Managing Test Data, Performance ConsiderationsObjectiveIncorporate static SQL statements in an applic...

• Seminar / Kurs
• Ohne Einstufung

• 07.08.2024 - 09.08.2024, München (DE)
• weiterer Termin verfügbar

PREFERRED

IBM CV963G - DB2 11 for z/OS Application Performance and Tuning

Cegos_Integrata GmbH (7)

Course OutlineIntroduction to Application Performance and Tuning, List common causes of application performance problems, Evalutate different approaches for detecting the problems, Describe possible solutions, Performance Analysis Tools, Understand c...

• Seminar / Kurs
• Ohne Einstufung

• 27.05.2024 - 31.05.2024, Leinfelden-Echterdingen (DE)

PREFERRED

IBM CV871G - DB2 10 for z/OS Utilities for Database Administrators

Cegos_Integrata GmbH (7)

Course Outline(CV831) utilities review, RUNSTATS, DSN1COPY,REPAIR, and DIAGNOSE, LOAD and REBUILD INDEX performance and availability, Online CHECK DATA, REORG performance and availability, UNLOAD performance and availability, Generic utility jobs (LI...

• Seminar / Kurs
• Ohne Einstufung

• 08.07.2024 - 10.07.2024, Leinfelden-Echterdingen (DE)

PREFERRED

IBM CV853G - Db2 12 for z/OS Intermediate System Administration (Live Online Training)

Cegos_Integrata GmbH (7)

Course OutlineStarting, stopping, and accessing Db2 Starting Db2 as part of the z/OS IPL process Data set allocation and APF authorization The START DB2 and STOP DB2 commands zParms, DSNTIJUZ, and DSNZPARM Address spaces IRLM and lock storageDb2 comp...

• Webinar
• Ohne Einstufung

• 24.06.2024 - 26.06.2024
• weiterer Termin verfügbar

PREFERRED

IBM CV832G - DB2 11 for z/OS Database Administration Workshop Part 1

Cegos_Integrata GmbH (7)

Course OutlineSetting up a DB2 database, Referential integrity, Getting data into and out of DB2, Keeping your DB2 data in good shape, Application data recovery basics, Program preparation and Bind, Security, SerializationThe course includes extensiv...

• Seminar / Kurs
• Ohne Einstufung

• 30.04.2024 - 03.05.2024, Leinfelden-Echterdingen (DE)
• weiterer Termin verfügbar

PREFERRED

IBM CV844G - Db2 12 for z/OS Basic Database Administration (Live Online Training)

Cegos_Integrata GmbH (7)

Course OutlinePreface Course Overview, Intended Audience, Course Objectives, Prerequisites Unit 1 - Db2 Relational database concepts Relational Database design, Data access, Interacting with Db2• Catalog and directory Unit 2 - SQL and SPUFI SQL SELEC...

• Webinar
• Ohne Einstufung

• 13.05.2024 - 15.05.2024
• 5 weitere Termine verfügbar

PREFERRED

IBM CV722G - DB2 11 for z/OS Application Programming Workshop (Live Online Training)

Cegos_Integrata GmbH (7)

Course OutlineDB2 Concepts, Program Structure I, Program Preparation, Program Structure II, Recovery and Locking Concepts, Dynamic SQL Introduction, Managing Test Data, Performance ConsiderationsObjectiveIncorporate static SQL statements in an applic...

• Webinar
• Ohne Einstufung

• 10.06.2024 - 12.06.2024
• 3 weitere Termine verfügbar

PREFERRED

IBM CV964G - Db2 12 for z/OS SQL Performance and Tuning (Live Online Training)

Cegos_Integrata GmbH (7)

Course OutlineIntroduction to SQL performance and tuning Performance issues Simple example Visualizing the problem SummaryPerformance analysis tools Components of response time Time estimates with VQUBE3 SQL EXPLAIN The accounting trace The bubble ch...

• Webinar
• Ohne Einstufung

• 13.08.2024 - 15.08.2024
• weiterer Termin verfügbar

PREFERRED

IBM CV963G - DB2 11 for z/OS Application Performance and Tuning (Live Online Training)

Cegos_Integrata GmbH (7)

Course OutlineIntroduction to Application Performance and Tuning, List common causes of application performance problems, Evalutate different approaches for detecting the problems, Describe possible solutions, Performance Analysis Tools, Understand c...

• Webinar
• Ohne Einstufung

• 27.05.2024 - 31.05.2024
• weiterer Termin verfügbar