<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE FL_Course SYSTEM "https://www.flane.de/dtd/fl_course095.dtd"><?xml-stylesheet type="text/xsl" href="https://portal.flane.ch/css/xml-course.xsl"?><course productid="6928" language="en" source="https://portal.flane.ch/swisscom/en/xml-course/ibm-cm46g" lastchanged="2025-07-29T12:17:35+02:00" parent="https://portal.flane.ch/swisscom/en/xml-courses"><title>IMS High Availability Large Database (HALDB)</title><productcode>CM46G</productcode><vendorcode>IB</vendorcode><vendorname>IBM</vendorname><fullproductcode>IB-CM46G</fullproductcode><version>1</version><essentials>&lt;p&gt;You should complete:&lt;/p&gt;
&lt;ul&gt;

	&lt;li&gt;Physical Organization of Databases (CM220) or&lt;/li&gt;&lt;li&gt;Physical Organization of Databases - Web (CMW22)&lt;/li&gt;&lt;li&gt;or have equivalent work experience.&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;You should have:&lt;/p&gt;
&lt;ul&gt;

	&lt;li&gt;working knowledge of IMS full function databases&lt;/li&gt;&lt;li&gt;database administrator responsibilities for their support.&lt;/li&gt;&lt;/ul&gt;</essentials><audience>&lt;p&gt;This is an intermediate course for IMS database administrators, who implement and manage HALDB.&lt;/p&gt;</audience><contents>&lt;p&gt;Learn about the Information Management System (IMS) High Availability Large Database (HALDB). Examine how databases may be migrated to HALDB and the advantages of using HALDB.&lt;/p&gt;</contents><outline>&lt;ul&gt;
&lt;li&gt;Overview&lt;/li&gt;&lt;li&gt;Database Structures&lt;/li&gt;&lt;li&gt;Definition&lt;/li&gt;&lt;li&gt;Partition Selection&lt;/li&gt;&lt;li&gt;DBRC Support&lt;/li&gt;&lt;li&gt;Database Commands&lt;/li&gt;&lt;li&gt;Utilities&lt;/li&gt;&lt;li&gt;Database Creation and Migration&lt;/li&gt;&lt;li&gt;Changing Databases&lt;/li&gt;&lt;li&gt;Secondary Indexes&lt;/li&gt;&lt;li&gt;Application and Miscellaneous Considerations&lt;/li&gt;&lt;li&gt;HALDB Online Reorganization&lt;/li&gt;&lt;li&gt;Summary&lt;/li&gt;&lt;/ul&gt;</outline><essentials_plain>You should complete:



	- Physical Organization of Databases (CM220) or
- Physical Organization of Databases - Web (CMW22)
- or have equivalent work experience.
You should have:



	- working knowledge of IMS full function databases
- database administrator responsibilities for their support.</essentials_plain><audience_plain>This is an intermediate course for IMS database administrators, who implement and manage HALDB.</audience_plain><contents_plain>Learn about the Information Management System (IMS) High Availability Large Database (HALDB). Examine how databases may be migrated to HALDB and the advantages of using HALDB.</contents_plain><outline_plain>- Overview
- Database Structures
- Definition
- Partition Selection
- DBRC Support
- Database Commands
- Utilities
- Database Creation and Migration
- Changing Databases
- Secondary Indexes
- Application and Miscellaneous Considerations
- HALDB Online Reorganization
- Summary</outline_plain><duration unit="d" days="1">1 day</duration><pricelist><price country="CH" currency="CHF">850.00</price></pricelist><miles/></course>