Using the online interface to specify the log scan step

You specify the ongoing migration through the online interface only once.

It is not necessary to access the interface to make changes for subsequent runs of the job. Ongoing-migration-with-adjusted-ranges-job explains how BMC AMI Log Master adjusts time frame ranges with each subsequent batch job. Only completed transactions are migrated.

Before you begin

Define a work ID for migration with a log mark step. You use the log mark for the initial migration as the start point of the time frame in this procedure.

To define a filter that selects specific table space transaction

From the Actions category on the Main Menu, select Generate MIGRATE SQL and press Enter.BMC AMI Log Master displays the Generate Migrate SQL panel.
Select Specify Log Filter Criteria and press Enter.
Use the Structured or Free Form filter interface to define search criteria, and then press F3 to return to the Generate MIGRATE SQL panel.The filter for this example must select log records from customer-related tables that have data that is not null in the fields that are related to frequent-flyer discounts.

To define a time frame for ongoing migration

On the Generate MIGRATE SQL panel, select Specify Time Frame and/or Input Source and press Enter.BMC AMI Log Master displays the Time Frame Specification panel. The following figure shows the panel with values for this example:
============================= Time Frame Specification ==========================
Command ===> _________________________________________________________________
                                                                     SSID: DBAN
Work ID . . : ABC.$$WORKID0001
Description : ABC 2022-01-18 09.18.26 MIGRATE

Start of Log Scan. . . . . : ENDMASSLOAD(00000)
End of Log Scan. . . . . . : CURRENT
Log File Source. . . . . . : Subsystem BSDS

Options . . . _ 1. Modify Start Point
                   2. Modify End Point
                   3. Reset Time Frame using Log File Selections

Ongoing Process. . . . . . . . Y           (Y=Yes, N=No)
Rerun/Reprocess Options:
     Rerun Run Number. . . . .              (Run Sequence Number or LASTRUN)
  OR From Start of Run Number.              (Run Sequence Number or LASTRUN)
Reset/Purge Options:
     Generate New Handle ID. . N           (Y=Yes, N=No)
  OR Reset Handle ID . . . . . N           (Y=Yes, N=No)
     Purge . . . . . . . . . . N           (Y=Yes, N=No)
F1=Help    F3=Exit   F12=Cancel
Specify a start point and an end point for the time frame. For this example, define the time frame as follows:
- Proposed start point: log mark ENDMASSLOAD(00000), which marked the point of consistency for the first migration
- End point: CURRENT
To indicate that the job is an ongoing job, in the Ongoing Process field, type Y and press F3 to return to the Generate MIGRATE SQL panel.

To modify the output options

On the Generate MIGRATE SQL panel, select Define Report and File Outputs and press Enter.BMC AMI Log Master displays the Report and File Outputs panel. The default output for migrating data changes are a Summary report and a MIGRATE SQL file.
Add an Open Transaction report and press F3 to return to the Generate MIGRATE SQL panel.

To save the selections in a work ID

On the Generate MIGRATE SQL panel, select Work ID Options, JCL Generation.BMC AMI Log Master displays the Work ID File Menu.
Select Save As and press Enter.BMC AMI Log Master displays the Work ID Name Entry panel.
Save the work ID with the name shown in the following figure and press F3.BMC AMI Log Master displays the Work ID File Menu.
MIGRATE ====================== Generate Migrate SQL =====================
C .-------------------------------------------------. ________________________
   | FILE ============ Work ID File Menu =========== |               SSID: DBAN
W |   .-----------------------------------------------------------------------.
D | W | SAVE AS ===================== Work ID Name Entry ==================== |
   |   |                                                                       |
T | S | Type in the information then press F3 to update the repository        |
   |   |                                                                       |
S | A | Work ID . . . . . ABC.MIGRATE$ACCT                                    |
   |   | Description . . .                                                     |
O |   |    DAILY MIGRATION OF ACCOUNTING RECORDS TO DECISION SUPPORT DB.      |
   |   | Work ID Security . . . R (W=Read/Write, R=Read Only, N=No Access)    |
   |   | Date Format. . . . . . I (U=USA, E=EUR, I=ISO, J=JIS)                |
   |   |                                                                       |
   | F | F13=Help   F15=Exit   F24=Cancel                                      |
   '-- '-----------------------------------------------------------------------'

To generate and save the JCL

On the Work ID File Menu, select Generate JCL and press Enter.
Verify that the correct values for JCL generation are entered in the fields of the Generate JCL panel, (such as JCL data set name and job statement information).
To generate the JCL, press Enter.
To save the JCL, press F3.