Getting started with the HALDB modeling and migration tools

During the workflow process, Advisor gathers information and creates the JCL, control statements, and definitions for performing the selected task. You can then access and work with the results in the Maintain Existing Workflow window.

To get started with HALDB modeling and migration tools

1. Right-click a valid object and select the tool.For more information, see the online Help.

   The following HALDB modeling and migration tools are available when you right-click the indicated object. These tools accomplish the indicated tasks and work with the indicated type of workflows:

   Tool	Selected object	Task	Workflow type
   Maintain Existing Workflow window	IMSPLEX (RECON); full-function database; HALDB; HALDB partition	View, edit, submit, and delete existing workflows and complete Migrate to HALDB workflows.	All
   HALDB Migration Workflow Definition wizard	IMSPLEX (RECON)	Create a workflow to select a set of full-function databases and define parameters for converting those databases (and their associated databases) to HALDBs.	Migrate to HALDB
   Generate Model wizard	Full-function database	Create a workflow to convert the selected database to a HALDB.	Database Migrate to HALDB
   PSE Validation wizard	Full-function database; HALDB	Create a workflow to model the effects of a partition selection exit (PSE) on the selected database. 1	PSE Validation
   Rebalance HALDB wizard	HALDB	Create a workflow to model the effects of different parameters on the balance of records between partitions in an existing HALDB.	HALDB Rebalance
   Split Partition wizard	HALDB partition	Create a workflow to model the effects of different parameters on the division of a selected partition into multiple partitions.	Split Partition

   ^{1 To evaluate PSE routines, Advisor uses the name of the PSE module and the DBRC statements that define the database to determine where the PSE routine would place data from the original database. Advisor then reports record counts and sizes for each partition defined by the DBRC statements.}

2. Edit the information and click Submit.The tool creates the JCL and submits it:
   1. An EXTRACT job collects segment information from the original database.
   2. A SORT job sorts the extracted information.
   3. An ESTIMATE job creates recommendations.

   4. Advisor writes the recommendations to a PDS data set.

      That data set contains DBRC control statements to update DBRC, IDCAMS delete/define statements for the database data sets, and JCL to implement the recommendations. You can edit the PDS data set members.

   5. When the submitted job completes, a BMCMXA340683I message is displayed in the console.