{"course":{"productid":19516,"modality":6,"active":true,"language":"de","title":"Db2 12 for z\/OS Introduction to System Administration","productcode":"CV853G","vendorcode":"IB","vendorname":"IBM","fullproductcode":"IB-CV853G","courseware":{"has_ekit":true,"has_printkit":false,"language":"en"},"url":"https:\/\/portal.flane.ch\/course\/ibm-cv853g","essentials":"<ul>\n\n\t<li>Understanding of the objects (such as databases, table spaces, tables, indexes, and so forth) used in a Db2 subsystem<\/li><li>Basic knowledge of SQL<\/li><li>At least one year as a z\/OS systems programmer or equivalent knowledge<\/li><\/ul><p>OR<\/p>\n<ul>\n\n\t<li>At least one year as a Db2 for z\/OS Database Administrator<\/li><\/ul>","audience":"<p>This course is intended for z\/OS system administrators, database administrators, or other technical individuals who will be managing Db2 12 for z\/OS.<\/p>","contents":"<p>This course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z\/OS system.<\/p>","outline":"<p>Starting, stopping, and accessing Db2&bull; Starting Db2 as part of the z\/OS IPL process&bull; Data set allocation and APF authorization&bull; The START DB2 and STOP DB2 commands&bull; zParms, DSNTIJUZ, and DSNZPARM&bull; Address spaces&bull; IRLM and lock storageDb2 components and processes&bull; BSDS and logging&bull; Catalog and directory&bull; Program preparation and execution&bull; Transaction execution&bull; Data sharing in the sysplexSystem security&bull; Protecting Db2 data sets&bull; Controlling connections to Db2&bull; Db2 authorization exits&bull; Trusted context and roles&bull; Securing an application serverDb2 authorization&bull; Authorizations&bull; Controlling access for dynamic and static SQL&bull; Access control authorization exits&bull; Distributed securityProgram flow for all environments&bull; Connection types and language interfaces&bull; Program flowTSO and batch environments&bull; TSO&bull; UtilitiesTransaction flow in IMS and CICS (optional)&bull; Transaction processing&bull; Thread reuse&bull; SIGNON exitCICS - Db2 environment (optional)&bull; CICS connections to Db2&bull; DSNC transactionIMS - Db2 environment (optional)&bull; IMS-Db2 introduction&bull; IMS TM&bull; IMS\/DLI batch environmentDistributed - Db2 environment&bull; Distributed attachment&bull; Location aliases&bull; DDF profiling&bull; Block fetch&bull; Db2 REST servicesLogging&bull; The Db2 log&bull; Log commands&bull; Archiving considerations&bull; BSDSDb2 utilities&bull; Categorization&bull; DSNJU003 and DSNJU004&bull; BACKUP and RESTORE SYSTEMOperations (monitoring and controlling Db2)&bull; Issuing Db2 commands&bull; Basic workload controls&bull; Monitoring and controlling utilities&bull; DISPLAY commands&bull; Starting \/ stopping databasesRecovery&bull; Planning for recovery&bull; Table space recovery&bull; Log considerations&bull; DISPLAY and SET LOG commands&bull; Recovery considerationsSystem recover\/restart&bull; System checkpoints&bull; System restart after normal shutdown&bull; Page externalization&bull; Two-phase commit processing&bull; System restart after system failure&bull; Recovery considerationsJava with Db2&nbsp; (optional)&bull; JavaAdministrative task scheduler (optional)&bull; Overview&bull; Routines&bull; Scheduling features&bull; Life cycle&bull; Syncronization&bull; Commands<\/p>","essentials_plain":"- Understanding of the objects (such as databases, table spaces, tables, indexes, and so forth) used in a Db2 subsystem\n- Basic knowledge of SQL\n- At least one year as a z\/OS systems programmer or equivalent knowledge\nOR\n\n\n\n\t- At least one year as a Db2 for z\/OS Database Administrator","audience_plain":"This course is intended for z\/OS system administrators, database administrators, or other technical individuals who will be managing Db2 12 for z\/OS.","contents_plain":"This course provides students with an introduction to the skills and knowledge needed to administer a Db2 12 for z\/OS system.","outline_plain":"Starting, stopping, and accessing Db2\u2022 Starting Db2 as part of the z\/OS IPL process\u2022 Data set allocation and APF authorization\u2022 The START DB2 and STOP DB2 commands\u2022 zParms, DSNTIJUZ, and DSNZPARM\u2022 Address spaces\u2022 IRLM and lock storageDb2 components and processes\u2022 BSDS and logging\u2022 Catalog and directory\u2022 Program preparation and execution\u2022 Transaction execution\u2022 Data sharing in the sysplexSystem security\u2022 Protecting Db2 data sets\u2022 Controlling connections to Db2\u2022 Db2 authorization exits\u2022 Trusted context and roles\u2022 Securing an application serverDb2 authorization\u2022 Authorizations\u2022 Controlling access for dynamic and static SQL\u2022 Access control authorization exits\u2022 Distributed securityProgram flow for all environments\u2022 Connection types and language interfaces\u2022 Program flowTSO and batch environments\u2022 TSO\u2022 UtilitiesTransaction flow in IMS and CICS (optional)\u2022 Transaction processing\u2022 Thread reuse\u2022 SIGNON exitCICS - Db2 environment (optional)\u2022 CICS connections to Db2\u2022 DSNC transactionIMS - Db2 environment (optional)\u2022 IMS-Db2 introduction\u2022 IMS TM\u2022 IMS\/DLI batch environmentDistributed - Db2 environment\u2022 Distributed attachment\u2022 Location aliases\u2022 DDF profiling\u2022 Block fetch\u2022 Db2 REST servicesLogging\u2022 The Db2 log\u2022 Log commands\u2022 Archiving considerations\u2022 BSDSDb2 utilities\u2022 Categorization\u2022 DSNJU003 and DSNJU004\u2022 BACKUP and RESTORE SYSTEMOperations (monitoring and controlling Db2)\u2022 Issuing Db2 commands\u2022 Basic workload controls\u2022 Monitoring and controlling utilities\u2022 DISPLAY commands\u2022 Starting \/ stopping databasesRecovery\u2022 Planning for recovery\u2022 Table space recovery\u2022 Log considerations\u2022 DISPLAY and SET LOG commands\u2022 Recovery considerationsSystem recover\/restart\u2022 System checkpoints\u2022 System restart after normal shutdown\u2022 Page externalization\u2022 Two-phase commit processing\u2022 System restart after system failure\u2022 Recovery considerationsJava with Db2\u00a0 (optional)\u2022 JavaAdministrative task scheduler (optional)\u2022 Overview\u2022 Routines\u2022 Scheduling features\u2022 Life cycle\u2022 Syncronization\u2022 Commands","skill_level":"Beginner","version":"1","duration":{"unit":"d","value":3,"formatted":"3 Tage"},"pricelist":{"List Price":{"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":2400},"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":2100},"FR":{"country":"FR","currency":"EUR","taxrate":19.6,"price":2250},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":2100}}},"lastchanged":"2025-07-29T12:17:56+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/json-course-schedule\/19516","source_lang":"de","source":"https:\/\/portal.flane.ch\/swisscom\/json-course\/ibm-cv853g"}}