Source Data Extraction

Before you can convert your data to Control-M, you must extract it from your source scheduler.

The following lists the available extraction options for each scheduler:

Broadcom AppWorx Data Extraction

To extract the source data in AppWorx, create the following files in Appworx:

  • .exp: Enables you to migrate between two AppWorx Application Managers. This file contains all your environment definitions. You need to export the .exp file from your AppWorx environment to the conversion environment using the AppWorx export utility. For more information, see Exporting the AppWorx .exp File.

  • NodeMapping.txt: Enables you to map the operating system for each host used in the .exp file. You must import the NodeMapping.txt output file into the conversion environment. For more information, see Importing the Node Mapping File.

Exporting the AppWorx .exp File

This procedure describes how to export AppWorx objects to an .exp file. For more details about exporting objects, see the AppWorx Administration Guide.

Begin

  1. From the Export window of the AppWorx environment, select the objects you want to convert to Control-M, and click the arrow to move the objects to the Objects to be exported area.

  2. Click the Reference tab, select the dependencies and move them to the Objects to be exported area.

  3. Click Export.

    The file is saved as an .exp file.

  4. Verify that there are no missing modules or libraries as follows:

    1. Search for CHECK M or CHECK L at the beginning of the .exp file.

      CHECK M xxx: missing Module xxx.

      CHECK L xxx: missing Library xxx.

      These messages indicate that modules or libraries are missing.

    2. Open the .exp file with an editing tool.

  5. Do one of the following:

  6. The .exp file is successfully exported when No CHECK messages appear.

Fixing a Check Module Message

This procedure describes how to fix a CHECK Module message in the .exp file.

Begin

  1. From the AppWorx environment, select Object Type and select Modules.

  2. In the Search bar, type the module name, module_XXX and then click >> to add it to the Objects to be exported area.

  3. Click Export.

    The file is saved as an .exp file.

  4. Open the .exp file with an editing tool.

  5. Search for a CHECK M message at the beginning of the .exp file.

    If you find a Check M message, run this procedure again.

Fixing a Check Library Message

This procedure describes how to fix a CHECK Library message in the .exp file.

Begin

  1. From the AppWorx environment, select Object Type and select Libraries.

  2. In the Search bar, type the module name, library_XXX and then click >> to add it to the Objects to be exported area.

  3. Click Export.

    The file is saved as an .exp file.

  4. Open the .exp file with an editing tool.

  5. Search for a CHECK L message at the beginning of the .exp file.

    If you find a Check L message, run this procedure again.

Importing the Node Mapping File

This procedure describes how to import the AppWorx Node Mapping file.

Begin

  1. Copy the following script to your AppWorx environment:

    <Conversion Home>\scripts\AppWorx\NodeMapping.SQL

  2. Open a command prompt window and type the following command:

    sqlplus -S user/password @NodeMapping.SQL

    The script produces a NodeMapping.txt output file.

  3. Copy the NodeMapping.txt output file to the conversion environment.

Broadcom Automic (UC4) Data Extraction

You must extract UC4 data per object type, such as jobs, Agents, and Groups, into separate XML files.

Extract UC4 job object types into a Job XML file, and UC4 Agent object types to an Agent XML file.

Job objects are mandatory, and BMC recommends to include as many objects as possible for better conversion results.

Extract UC4 data to XML using one of the following methods:

  • UC4 Explorer: Extracts UC4 data to XML through the Export function in UC4 Explorer, as described in Extracting Objects of the Same Type to One File and Exporting Objects to Separate Files.

    • Do not use this export function for mass transports when using the UC4 Explorer.

    • The UC4 administrator can limit the maximum number of objects that are exported at one time. Use the key MAX_EXPORT_COUNT in the UC4 Variable UC_SYSTEM_SETTINGS for this purpose.

Extracting Objects of the Same Type to One File

This procedure describes how to extract objects with the same type to one file using the UC4 File Explorer.

Before You Begin

Ensure that the installed Service Pack version is at least the same as the source system (XML file).

Begin

  1. From the UC4 File Explorer click Search.

    The Search window appears.

  2. In the Name field, type *.

  3. In the Search For field, select Objects, and then from the drop-down list, select the object type you want to export, such as jobs.

    Do not use this export function for mass transports when using the UC4 Explorer. For more information, see the UC4 Administration Guide.

  4. Limit the maximum number of objects that are exported at one time with the MAX_EXPORT_COUNT in the UC4 Variable UC_SYSTEM_SETTINGS for this purpose.

  5. Click Start.

    A list of search results appears.

  6. Select all by pressing Ctrl + A.

  7. From the File menu, select Export.

    The Save dialog box appears.

  8. Click Save.

Exporting Objects to Separate Files

This procedure describes how to extract each object to a separate file using the UC4 File Explorer.

  • Do not use this export function for mass transports when using the UC4 Explorer.

  • The UC4 administrator can limit the maximum number of objects that are exported at one time. Use the key MAX_EXPORT_COUNT in the UC4 Variable UC_SYSTEM_SETTINGS for this purpose.

Before You Begin

Ensure that the installed Service Pack version is at least the same as the source system (XML file).

Begin

  1. From the UC4 File Explorer click Search.

    The Search window appears.

  2. In the Name field, type *.

  3. In the Search For field, select the Objects and then from the drop-down list, select the object type you want to export, such as jobs.

    Do not use this export function for mass transports when using the UC4 Explorer. For more information, see the UC4 Administration Guide.

  4. Click Start.

    A list of search results appears.

  5. Right click on one of the objects, and select Export.

    The Save dialog box appears.

  6. Save as a .csv file.

  7. Create a new directory and copy the .csv file to the new directory.

  8. Run the following script:

    :SET &HOST# = "<name of Host>"

    :SET &CSV_FILE# = "<name of the file and full directory of the exported objects to csv>"

    :SET &EXPORT_PATH# = "<name of the target path directory>"

    :SET &HND#=PREP_PROCESS_FILE(&HOST#,&CSV_FILE#,,"COL=DELIMITER",'DELIMITER=";"')

    :PROCESS &HND#

    : SET &Line#=GET_PROCESS_LINE(&HND#,1)

    : PRINT "<&Line#>"

    : SET &OBJECT# = &Line#

    : SET &File# = "&EXPORT_PATH#&line#.xml"

    : SET &Ret# = EXPORT (&Object#, &File#)

    :ENDPROCESS

    This script runs on the WIN01 host and the .csv file is saved as Search.csv in the C:\temp directory and is exported to the C:temp\export directory:

    :SET &HOST# = "WIN01"

    :SET &CSV_FILE# = "c:\temp\search.csv"

    :SET &EXPORT_PATH# = "C:\temp\export\

    :SET &HND#=PREP_PROCESS_FILE(&HOST#,&CSV_FILE#,,"COL=DELIMITER",'DELIMITER=";"')

    :PROCESS &HND#

    : SET &Line#=GET_PROCESS_LINE(&HND#,1)

    : PRINT "<&Line#>"

    : SET &OBJECT# = &Line#

    : SET &File# = "&EXPORT_PATH#&line#.xml"

    : SET &Ret# = EXPORT (&Object#, &File#)

    :ENDPROCESS

Extracting UC4 Data to XML Using an Export Script

This procedure describes how to automatically export many objects to XML using an export script.

Before You Begin

Ensure the following:

  • The installed Service Pack version must be at least the same as the source system (XML file).

  • You have the permissions to run the export script function from the Client where the object currently exists.

Begin

  1. Log in to client 0 (Admin-Client).

  2. Open UC_SYSTEM_SETTINGS.

  3. Set the MAX_EXPORT_COUNT parameter to 1000000 (maximum).

    You do not need to restart.

  4. Save the object.

  5. Log in to the production client(s) and type the following script:

    :SET &OBJECT# = "<object_name>"

    :SET &FILE# = "<file_name>"

    :SET &RET# = EXPORT(&OBJECT#,&FILE#)

    If you have large files, filter the type of objects you want to convert.

  6. Split multiple objects in one XML file by running the SplitToSpecificObjectFiles.pl script located in the following directory:

    <Conversion_Home>\scripts\uc4

This example uses an export script with the calendar filter, which enables you to export only objects with the name Calendar:

:SET &OBJECT# = "CALE.*"

:SET &FILE# = "C:\temp\export\automic_CALENDAR_export.xml"

:SET &RET# = EXPORT(&OBJECT#,&FILE#)

By adapting the first Script-Line (:SET &OBJECT#=”[OBJECT_NAME_WITH_WILDCARDS”) you can also modify the exports. For instance, if your Calendars use the default naming convention, which starts with CALE.[NAME], you can create one XML file for all calendars as shown above.

Broadcom AutoSys Data Extraction

The extraction process of AutoSys data includes:

Converting AutoSys Jobs to Control-M

This procedure describes how to convert AutoSys jobs to Control-M.

Begin

  1. Run a full scan of all scripts run by AutoSys, which enables you to find occurrences of AutoSys command lines, executables and variables within the scripts.

  2. Identify any external interfaces, such as monitoring and alerting tools, reporting tools, help desk incident management tools and CMDB’s.

  3. Run a scan of the JIL file.

    The conversion tool does not handle Job_terminator and box_terminator statements. Before commencing the conversion, you must scan the JIL extract file keywords. For more information, see AutoSys Keywords.

  4. Create AutoSys virtual machines. For more information, see Creating Autosys Virtual Machines.

  5. Create AutoSys variables. For more information, see Creating AutoSys Variables.

Creating Autosys Virtual Machines

This procedure describes how to create AutoSys virtual machines, which are the AutoSys equivalent of Control-M host groups, and will be converted into Control-M host groups.

Begin

  • Obtain a list from AutoSys of all virtual machine names and the hosts that constitute the group, which is obtained by running the following AutoSys command:

    autorep –M ALL –d

    The following is example output when running the AutoSys command autorep –M ALL –d

    Copy
    autorep -M ALL
    Machine Name                  Max Load   Current Load Factor  O/S         Status
    _____________________________ __________ ____________ _______ ___________ ______
    abtgpdb                       ---        ---          1.00    Unix        Online
    abtgpftp                      ---        ---          1.00    Unix        Online
    abtgposs1                     ---        ---          1.00    Unix        Online
    abtgpstmt                     ---        ---          1.00    Unix        Online
    TGPRODDB.abtgpdb              ---        ---          ----    Unix        Online
    TGPRODFTP.abtgposs1           ---        ---          ----    Unix        Online
    TGPRODSTMT.abtgpstmt          ---        ---          ----    Unix        Online
    abtgqdb                       ---        ---          1.00    Unix        Online
    TGQADB.abtgqdb                ---        ---          ----    Unix        Online
    TGQAFTP.abtgqdb               ---        ---          ----    Unix        Online
    TGQASTMT.abtgqdb              ---        ---          ----    Unix        Online
    Example conversion to Control-M Server:
    ctmnodegrp -EDIT -NODEGRP TGPRODDB -APPLTYPE OS -ADD abtgpdb
    ctmnodegrp -EDIT -NODEGRP TGPRODFTP -APPLTYPE OS -ADD abtgposs1
    ctmnodegrp -EDIT -NODEGRP TGPRODSTMT -APPLTYPE OS -ADD abtgpstmt
    ctmnodegrp -EDIT -NODEGRP TGQADB -APPLTYPE OS -ADD abtgqdb
    ctmnodegrp -EDIT -NODEGRP TGQAFTP -APPLTYPE OS -ADD abtgqdb
    ctmnodegrp -EDIT -NODEGRP TGQASTMT -APPLTYPE OS -ADD abtgqdb

Creating AutoSys Variables

This procedure describes how to create AutoSys variables, which are the AutoSys equivalent of Control-M variables can then be embedded in the job definition or script.

Begin

  • Obtain a list of AutoSys variables and convert these manually to Control-M Variables for a one off installation.

    To obtain a list of AutoSys variables, run the following AutoSys command:

    autorep –G ALL

    The following is example output when running the AutoSys command autorep –G ALL.

    Copy
    autorep -G %TGPROD%Global Name Value                                  Last Changed        
    ____________________________   _____________________________________  ____________________
    TGPROD_APIINBOX                /tgprod/interfaces/inbox               03/02/2009 16:44:09 
    TGPROD_APIOUTBOX               /tgprod/interfaces/outbox              03/02/2009 16:44:09 
    TGPROD_AUTOBACKUP              /tgprod/reports/current                06/12/2009 11:00:50 
    TGPROD_AUTOBIN                 /opt/CA/AutoSys/autosys/bin            03/02/2009 16:44:09 
    TGPROD_DATEA                   2009-09-18                             09/18/2009 00:01:04 
    TGPROD_DATEB                   20090918                               09/18/2009 00:01:04 
    TGPROD_DATEC                   090918 
    Example conversion to Control-M\Server for Windows:
    ctmvar -ACTION SET -VAR "%%%%\TGPROD_APIINBOX"     –VAREXPR /tgprod/interfaces/inbox
    ctmvar -ACTION SET -VAR "%%%%\TGPROD_APIOUTBOX"    –VAREXPR /tgprod/interfaces/outbox
    ctmvar -ACTION SET -VAR "%%%%\TGPROD_AUTOBACKUP"   –VAREXPR /tgprod/reports/current
    ctmvar -ACTION SET -VAR "%%%%\TGPROD_AUTOBIN"      –VAREXPR /opt/CA/AutoSys/autosys/bin
    ctmvar -ACTION SET -VAR "%%%%\TGPROD_DATEA"        –VAREXPR 2009-09-18
    ctmvar -ACTION SET -VAR "%%%%\TGPROD_DATEB"        –VAREXPR 20090918
    ctmvar -ACTION SET -VAR "%%%%\TGPROD_DATEC"        –VAREXPR 090918

AutoSys Keywords

The following table describes the AutoSys keywords that you must scan for in the .JIL extract files.

Broadcom AutoSys Keyword

Action

job terminator: 1

job terminator: Y

job terminator: y

If any of these statements are present and the AutoSys box (folder) was set to a failure status, this job must be killed.

box terminator: 0

box terminator: N

box terminator: n

If a job in the box fails, do not stop the box or mark it as failed. In Control-M define an ON NOTOK DO OK in the job or group.

Extracting AutoSys Data

This procedure describes how to extract Broadcom AutoSys Workload Automation (AutoSys) data.

Begin

  • From the AutoSys environment, create the following definitions file by running the following commands:

    • .JIL Job Definitions: autorep –j ALL –q

    • .TZO Time Zone Definitions: autotimezone –l

    • .CAL Calendar Definitions: autocal_asc –E autosys.STANDARD_CAL –s ALL

Broadcom JOBTRAC Data Extraction

Extracting Broadcom JOBTRAC Data

This procedure describes how to extract Broadcom JOBTRAC data.

Begin

  1. From the JOBTRAC environment, locate the JCL file and then transfer it to your JOBTRAC machine via FTP with ASCII mode by running the following commands:

    • ftp> ascii

    • ftp> put <file location><library>(<Member>)

  2. Submit the job that collects all the required JOBTRAC data into one sequential file.

  3. Transfer the output file from the JOBTRAC machine to the conversion system in ASCII mode by running the following commands:

    • ftp> ascii

    • ftp> get <filename> <local data file>)

For information about the parameters, see Broadcom JOBTRAC JCL Parameters and Broadcom JOBTRAC JCL Parameters

Broadcom JOBTRAC JCL Parameters

The following table describes the parameters for the JCL file.

Parameter

Description

JCL created file

Defines a filename for the JCL file created on the Mainframe.

Output data file name

Defines a filename for the output file.

Default: CTM.JBT.OUT

Job card

Defines the job name

Default: //COLLECTED JOB.

Allocate converted JCL libraries

Enables you to allocate new JCL libraries. If this parameter is not selected, the Conversion Tool overrides the original JCL libraries.

JCL library Prefix

Defines a prefix value

Example: CTM

Unit

Defines the volser unit.

Volser

Defines the volume on which to allocate the output file.

Storage Management System (SMS) Data Class

Defines the data definition parameters.

SMS Storage Class

Defines the performance and availability requirements of the host machine.

SMS Management

Defines the data migration, backup, and retention attributes of the host machine.

Primary Allocation (CYL)

Defines a space allocation value.

Example: 100

Secondary Allocation (CYL)

Defines a space allocation value.

Example: 100

Number of Directory Blocks (Mainframe Editor Rules only)

Defines the number of directory blocks allocated to the converted JCL library. This must be the same as the number of directory blocks in the original JOBTRAC JCL library.

Broadcom JOBTRAC Environment Parameters

The following table describes the parameters for the JOBTRAC environment.

Parameters

Description

SCL

Defines the SCL (Software Collections) library, which contains JOBTRAC job definitions.

JCL (Job Controlled Language)

Determines JCL libraries to apply variable substitution.

ADI (Automatic Date Insertion)

Defines JOBTRAC variables that are stored in the PRODDATE member of DATELIB.

CCPF (Condition Code Program Filter)

Determines the values to be converted to ON PGMST and DO ACTION OK.

ADR (Automatic Dataset Recognition)

Defines the table used to create the Control-M/EM input file.

AMR (Automatic Message Recognition)

Defines the table used to create the Control-O input file.

SCS (System Command Scheduling)

Defines scheduling system commands to be issued by time processing periods or intervals.

RESOURCE

Defines resource conditions that must be met before the job can be submitted.

EXCLPARM

Determines the lists of event names or prefixes that are grouped for mutual exclusion recognition by controlling all job resource sharing or preventing concurrent runs of jobs.

Extracting Broadcom Dollar Universe Data

This procedure describes how to extract Dollar Universe data so it is converted to Control-M data.

Begin

  • From the Dollar Universe environment, create the following files by running the following commands:

    • Session List File: "uxlst ses ses=* vses=* full"

      Defines a list of sessions defined in the Dollar Universe node. For each session, the volume and description appears.

    • Session Details File: "uxshw ses ses=* lnk vses=*"

      Defines a detailed description for each session. It contains lists of UPRs and dependencies between UPRs that are defined with each session.

    • Task Details File: "uxshw tsk upr=* mu=* ses=* vupr=000 nomodel partage"

      Defines a detailed description of task parameters corresponding to the UPR or session that is running.

    • UPR File: "uxshw upr upr=* vupr=* partage"

      Defines a set of parameters and events that define the UPROC functionality.

    • Rule File: "uxshw rul rul=*"

      Defines an algorithm rule, which translates the required execution periodicity of a task.

    • Resource File: "uxshw res res=*"

      Contains the resource definitions.

      The following is an example of a Batch file to Load Resource Pools.

      ecaqrtab ADD QRResource1 0

      ecaqrtab ADD QRResource2 100

      ecaqrtab ADD QRResource3 25

    • Calendar File: "uxshw cal exp mu=* since=2010 before=2014 nomodel"

      Defines a calendars definition file.

    • Management Unit Details File: "uxshw mu mu=*"

      Contains management unit definitions.

    • Management Unit Dependencies: "uxlst HDP OUTPUT=c:\temp\LstHdp.txt"

      Contains a hierarchy of management unit dependencies.

    • SAP ZUXTS Table File: Select the transaction ID and table name and when connected to the table, extract the table into the CSV file.

      Contains all SAP job parameters and connects to your SAP system using the SAP Logon console.

      The SAP ZUXTS table file is required only if you have Dollar Universe UPROCs that use the uxstr sap command.

       

    • Agent Mapping File: Copy the UXSRSV.SCK Agent mapping file from the MGR folder in the Dollar Universe environment.

      Defines the mapping file (UXSRSV.SCK file) between agent logical and physical names.

Extracting Broadcom Unicenter WLM (TNG) Data

This procedure describes how to extract Unicenter WLM (TNG) data, so it is converted to Control-M data.

Begin

  1. From the Unicenter environment, create the cauexpr.txt file by running the following command:

    cauexpr -a

  2. Import calendar definitions, by running the following commands:

    • caldb save cal_filename.dsb

    • caldb script cal_filename.dsb > cal_filename.txt

Extracting Broadcom Workload Automation DE Data in Batch Mode

This procedure describes how to extract Workload Automation DE (dSeries) data using the imexutil utility in batch mode, enabling it to later be converted to Control-M data.

Begin

  • From the DE (dSeries) environment, do one of the following:

    • UNIX: Navigate to the install_dir/bin directory (where the server is installed) and type the following:

      imexutil.sh -h host -p port -u user -w password -c @cmdfilename|cmds

    • Windows: Navigate to the install install_dir\bin directory (where the server is installed) and type the following:

      imexutil.bat -h host -p port -u user -w password -c @cmdfilename|cmds

For information about the parameters, see Broadcom Workload Automation DE Data Extraction Parameters.

Broadcom Workload Automation DE Data Extraction Parameters

The following table describes the dSeries data extraction parameters for the imexutil utillity.

Parameter

Description

-h

Defines the IP address or DNS name for the server.

-p

Determines the port number for the server.

-u

Defines the Broadcom Workload Automation user ID

-w

Defines the password for the user ID.

The user ID and password are optional if you specify a filename instead of commands in the -c switch. Instead of specifying the -u and -w values, you can specify the user command in the file.

-c

Defines the export commands or a file containing the export commands.

@cmdfilename

Defines the file containing the commands.

If the filename contains a space, enclose the name with double quotes.

-c "@input file.txt"

cmds

Determines one or more commands. To specify multiple commands, separate each command with a semi-colon.

If the command contains a space, enclose the command with double quotes. Export command options are, as follows:

exportartifact: exportagent, exportagentgrp, exportalert, exportapplication, exportcalendar, exportevent, exportforecast, exportgroup, exportjavascript, exportresource, exportsundry, exportuser, exportreportdesign, and exportvarctx.

-c "exportapplication -outdir c:\applications;exportvarctx -outdir c:\contexts"

The import/export utility runs in batch mode.

Broadcom Workload Automation DE Data Extraction Examples

The following examples describe how to run the imexutil utility, when extracting Broadcom Workload Automation DE data.

Export artifacts from a server named prodserv in batch mode.

The following command exports all Applications to c:\applications and all calendars to c:\calendars:

imexutil.bat -h prodserv -p 7500 -u schedmaster -w schedmaster -c "exportapplication -outdir c:\applications;exportcalendar -outdir c:\calendars"

Export artifacts from a server named prodserv in batch mode using a command file.

The following command uses a file named commandfile.txt, which contains the client user ID, password, and the commands to export all Applications to c:\applications and all calendars to c:\calendars:

imexutil.bat -h prodserv -p 7500 -c @c:\commandfile.txt

The commandfile.txt file contains the following commands:

user schedmaster schedmaster

exportapplication -outdir c:\applications

exportcalendar -outdir c:\calendars

Cron Data Extraction

Extract Cron data using one of the following methods:

Configuring Control-M Fields for Cron Jobs

This procedure describes how to configure Control-M fields for Cron jobs.

As Cron does not have folders, Applications, or Sub-Application fields, you configure these fields for the jobs that BMC Discovery is importing to Control-M by changing the default values in the setting.cfg file to the values you set.

Begin

  1. Close the Conversion Tool.

  2. Locate the setting.cfg file in <Conversion Home>\data\ and set one or more of the following parameters:

    • CRON_DISCOVERY_JOBS_FOLDER_NAME=Conversion_discovery_CRON

    • CRON_DISCOVERY_JOBS_APPLICATION=Conversion_discovery

    • CRON_DISCOVERY_JOBS_SUB_APPLICATION=CRON

    All jobs converted using BMC Discovery have folder, Application and Sub-Application fields set to the values you set.

  3. Extracting Cron Data Using BMC Discovery

Extracting Cron Data Using BMC Discovery

This procedure describes how to extract Cron data using BMC Discovery.

Begin

  1. Install and learn how use BMC Discovery.

  2. In the Conversion Tool, in the Load Data window, define the following:

    • Discovery Server Host

    • Discovery User

    • Discovery Password

    The Conversion Tool connects to BMC Discovery and converts Cron jobs that are found by BMC Discovery to Control-M.

Cron Data Extraction Using Control-M/Agents

You can use the Control-M/Agent or Agents, installed on the same machine as the Conversion Tool, to collect Cron data from available Agents and Agentless Hosts. The computer where both Control-M/Agent and Conversion Tool must run Windows. The other Agentless Hosts may be Windows or Linux/UNIX.

The Control-M/Agent uses Control-M jobs and Agent utilities to collect the Cron data. The Control-M jobs run by the Agent executes a script file to collect data and to view a list of available hosts. The following script files are used, which are dependent on the host platform:

  • UNIX: captureScriptUnix.txt

  • Windows: captureScriptWindows.txt

To start the collection of data by Control-M/Agents, a job is submitted to the primary Control-M/Server. After a list of available hosts is created, in the Conversion Tool, you can select the hosts that from which you want to collect data. A job is then submitted to each selected host to retrieve the Cron data.

Setting Up the Cron Conversion Environment Using Control-M/Agents

This procedure describes how to use Control-M/Agents to extract your Cron data.

Before You Begin

Ensure the following:

  • Agent is installed and running on the same environment as the Conversion Tool.

  • Your operating system is Windows.

  • Agent is connected to a Control-M/Server and that the Agent is available.

  • Server allows execution of the ctmpsm and ctmcreate utilities by the Agent.

Begin

  • Copy the following script files from the Conversion Tool script folder, <Conversion Home>/scripts/DataCollection, to your Control-M/Server:

    1. captureScriptUNIX.txt

    2. captureScriptWindows.txt

Importing Cron Data Manually

This procedure describes how to import data manually to a Cron conversion project.

Before You Begin

  • Run the following command to create a text file that contains the machine's jobs:

    crontab -l >> {OutputFileName}.txt

Begin

  1. In the Cron - Load Data window, click Add.

    The Add Data Manually window appears.]

  2. From the Add Data Manually window, define the following:

    • Machine Name

    • User Name

    • Data File

  3. Click Apply & Close.

  4. Repeat steps 2–3 as needed.

  5. Click Import.

    The data is loaded into the Conversion Tool and appears in the Assessment Report window.

  6. Click Next.

    The Run Conversion window appears.

  7. Select Run conversion or Load existing conversion results and click Next, then click Finish.

IBM Tivoli Workload Scheduler (TWS) Data Extraction

This procedure describes how to convert TWS jobs to Control-M.

Begin

Run a full scan of all scripts run by IBM Tivoli Workload Scheduler (TWS) to search for occurrences of TWS command lines, executables and variables within the scripts.

  1. Identify external interfaces to monitoring and alerting tools, reporting tools, help desk incident management tools, and CMDBs.

  2. Create TWS variables, which are equivalent to Control-M variables and can be embedded in the job definition or script.

    These can be found in the Parms.txt file.

    $PARM

    PROD_E_SCR "c:\schedules\e-commerce\filecopy.txt"

    Example conversion to Control-M Server for Windows:

    ctmvar -ACTION SET -VAR "%%%%\PROD_E_SCR" –VAREXPR “C:\schedules\e-commerce\filecopy.txt”

  3. From the TWS environment, create the following files:

    • Job Definitions File: (Mandatory) Run the following command:

      composer create <jobs file> from JOBS or if the command creates an empty file: composer create <jobs file> from jobs=@#@

    • CPU Definitions File: (Mandatory) Run following command:

      composer create <cpu file> from CPU or if the command creates an empty file: composer create <cpu file> from cpu=@

    • Parameters Definitions File(Mandatory): Run the following command:

      composer create <parms file> from PARMS

    • Schedule Definitions File: (Mandatory) Run the following command:

      composer create <schedule file> from SCHED or if the command creates an empty file: composer create <schedule file> from sched=@#@

    • Resource Definitions Filez: (Optional): Run the following command:

      composer create <resource file> from RESOURCES

    • Calendar Definitions File: (Optional) Run the following command:

      composer create <calendars file> from CALENDARS

    • Variable Tables Definitions File: (Optional): Run the following command:

      composer create <variables file> from VARIABLES

    • Workstation Parameters: (Optional): Run the following command:

      <Workstation_name>_parms.txt

JP1 Automatic Job Scheduler Data Extraction

Data extraction from the JP1 scheduler is knowing the location of the JP1 Unit Definition File.

The following table describes how the Conversion Tool converts job types, job folders, OS jobs, variables, prerequisites and actions from JP1 to Control-M.

JP1

Control-M

JP1 Folders and Jobs

Root jobnet

Folder

Jobnet

Sub-folder

Job

Job

unit name (Job/Jobnet)

Job/Folder name

ex (execution-agent-name)

Host/Host Group

  • eu
  • un (execution-user-name)
  • JP1-user-name

Run As

JP1-user-name

Created By

Group unit name (ty=g) (contains a chain of all grandparent groups)

Application

If there are more than 2 level groups, the Application contains the grandparent group path.

Sub Group unit name (ty=g) - closest parent group

Sub Application

cm (comment)

Description

JP1 Job Types

UNIX/Windows jobs (ty=j,rj,pc,rp)

OS job

All other job types (such as ty=flwj, evsj, evwj, jdj, mlsj)

Dummy jobs

These jobs are not supported and converted to Dummy jobs. Manual conversion may be required.

Jobnet Connector (ty=nc)

Dummy jobs

These jobs are not supported and converted to Dummy jobs. Manual conversion may be required.

JP1 OS Jobs

command-text (te)

NOTE: script-file-name with no path (sc)

Command

JP1 commands and variables in the command line are not supported.

script-file-name (sc)

script - File Name

  • script-file-name (sc)
  • work-path-name (wkp)

script - File path

JP1 Variables

parameter (prm)

PARM

All other variables (such as env, SYSTEM variables) are not currently supported by the Conversion Tool. Manual conversion may be required.

JP1 Prerequisites and Action

ar=(f=[from unit], t=[to unit], [relation-type])

Events (In/Out)

The following are not supported:

  • Events of relation-type=con (from a judgment job).
  • Events of OR job are not converted as expected.

ar=(f=[from unit], t=[to Recovery unit], [relation-type])

If Actions

JP1 Scheduling

Group- open days (op)

Calendar- WORKDAYS-[group]

Group- closed days (cl)

Calendar- NON_WORKDAYS-[group]

st

From Time

The following are not supported:

  • 48 hour format (st>23:59)

  • Relative start time (st contains "+")

  • Multiple start times

sd, cy

Rule Based Calendars (RBC)

The following are not supported:

  • ed (expiration date).
  • Sd and no cy (Specific date).
  • Sd contains '+' (Relative date)
  • sh+shd (shifts)
  • jc (Reference to a calendar of another job group)
  • ejn (Exclusive schedule)
  • de

cy=N,(1,d)

RBC - Everyday (daily)

cy=N,(1,d) + sd contains '*'

RBC - WORKDAYS (daily)

Based on Calendar WORKDAYS [group]

If no calendar is found, open/closed days are converted to Everyday.

cy=N,(1,d) + sd contains '@'

RBC- NON WORKDAYS (daily)

Based on Calendar

NON_WORKDAYS [group]

If no calendar is found, open/closed days are converted to Everyday.

cy=N,(1,w), sd={su|mo|tu|we|th|fr|sa}

RBCs- Sunday, Monday, Tuesday,

Wednesday, Thursday, Friday, Saturday (Weekly)

The following is not supported:

  • If sd contains dd (e.g. 2015/11/26)
  • If sd contains {su|mo|tu|we|th|fr|sa}:n, n>1 (nth week of the month)

cy=N,(1,m)

RBC (Monthly)

The following is not supported:

If sd contains weekday (e.g. sd=yyyy/mm/{su|mo|tu|we|th|fr|sa})

cy=N,(1,m)

RBC (Monthly)

The following is not supported:

If sd contains weekday (e.g. sd=yyyy/mm/{su|mo|tu|we|th|fr|sa})

cy=N,(1,m), sd=yyyy/mm/dd | mm/dd| dd

RBC- Nth_of _month (Monthly)

cy=N,(1,m), sd=yyyy/mm/b | mm/b| b

RBC- Last_of_month (Monthly)

cy=N,(1,m), sd=yyyy/mm/b-DD | mm/b-DD| b-DD

RBC- Nth_from_month_end (Monthly)

cy=N,(1,m) + sd contains '*'

RBC- Nth_workday (Monthly)

Based on Calendar

WORKDAYS-[group]

cy=N,(1,m) + sd contains '*b'

RBCs- NthLastWorkday/ LastWorkday (Monthly)

Based on Calendar

WORKDAYS-[group]

cy=N,(1,m) + sd contains '@'

RBC- Nth_non_workday (Monthly)

Based on Calendar

NON_WORKDAYS-[group]

cy=N,(1,m) + sd contains '@b'

RBC- NthLastNonWorkday/ LastNonWorkday (Monthly)

Based on Calendar

NON_WORKDAYS-[group]

cy=N, (n,y)

Currently not supported.

cy=N,(n,d|w|m) where n>1 (Interval)

Currently not supported.

sd=0,ud

Scheduling is taken from the parent.

MS Task Scheduler Data Extraction

Extract Task Scheduler data using one of the following methods:

Configuring Control-M Fields for Task Scheduler Jobs

This procedure describes how to configure Control-M fields for Task Scheduler jobs.

As Task Scheduler does not have folders, Applications, or Sub-Application fields, you configure these fields for the jobs that BMC Discovery is importing to Control-M by changing the default values in the setting.cfg file to the values you set.

Begin

  1. Close the Conversion Tool.

  2. Locate the setting.cfg file in <Conversion Home>\data\ and set one or more of the following parameters:

    • MS_DISCOVERY_JOBS_FOLDER_NAME=Conversion_discovery_MS

    • MS_DISCOVERY_JOBS_APPLICATION=Conversion_discovery

    • MS_DISCOVERY_JOBS_SUB_APPLICATION=MS

    All jobs converted using BMC Discovery have folder, Application and Sub-Application fields set to the values you set.

  3. Complete the Extracting Task Scheduler Data Using BMC Discovery procedure.

Extracting Task Scheduler Data Using BMC Discovery

This procedure describes how to extract Task Scheduler data using BMC Discovery.

Begin

  1. Install and learn how use BMC Discovery.

  2. In the Conversion Tool, in the Load Data window, define the following:

    • Discovery Server Host

    • Discovery User

    • Discovery Password

    The Conversion Tool connects to BMC Discovery and converts Task Scheduler jobs that are found by BMC Discovery to Control-M.

Task Scheduler Data Extraction Using Control-M/Agents

You can use the Control-M/Agent or Agents, installed on the same machine as the Conversion Tool, to collect Task Scheduler data from available Agents and Agentless Hosts. The computer where both Control-M/Agent and Conversion Tool must run Windows. The other Agentless Hosts may be Windows or Linux/UNIX.

The Control-M/Agent uses Control-M jobs and Agent utilities to collect the Task Scheduler data. The Control-M jobs run by the Agent executes a script file to collect data and to view a list of available hosts. The following script files are used, which are dependent on the host platform:

  • UNIX: captureScriptUnix.txt

  • Windows: captureScriptWindows.txt.

To start the collection of data by Control-M/Agents, a job is submitted to the primary Control-M/Server. After a list of available hosts is created, in the Conversion Tool, you can select the hosts that from which you want to collect data. A job is then submitted to each selected host to retrieve the Task Scheduler data.

Setting Up the Task Scheduler Conversion Environment Using Control-M/Agents

This procedure describes how to use Control-M/Agents to extract your Task Scheduler data,.

Before You Begin

Ensure the following:

  • Control-M/Agent is installed and running on the same environment as the Conversion Tool.

  • Your operating system is Windows.

  • Control-M/Agent is connected to a Control-M/Server and that the Agent is available.

  • Control-M/Server allows execution of the ctmpsm and ctmcreate utilities by the Agent.

Begin

  • Copy the following script files from the Conversion Tool script folder, <Conversion Home>/scripts/DataCollection, to your Control-M/Server:

    1. captureScriptUNIX.txt

    2. captureScriptWindows.txt

Importing MS Task Scheduler Data Manually

This procedure describes how to import data manually to a MS Task Scheduler conversion project.

Before You Begin

Run one of the following commands:

  • schtasks /Query /XML >> <OutputFileName>.xml
  • schtasks /Query /V /FO CSV >> <OutputFileName>.csv

Begin

  1. In the Import data manually window, click Add.

    The Add Data Manually window appears.

  2. From the Add Data Manually window, define the following:

    • Machine Name

    • User Name

    • Date

  3. Click Apply & Close.

  4. Repeat steps 2–3 as needed, then click Import.

    The data is loaded into the Conversion Tool and a summary of the imported data appears in the Assessment Report window.

    For more information, see Data Evaluation.

  5. Click Next.

    The Run Conversion window appears.

  6. Select Run conversion or Load existing conversion results and click Next, then clickFinish.

Redwood CPS Data Extraction

You can extract and import CPS data in one of the following ways:

Extracting CPS Data on Oracle SQL Developer

This procedure describes how to extract Redwood CPS data on an Oracle SQL Developer.

Begin

  1. Log in to the database.

  2. From the SYSJCS file, select Table.

  3. Select the following tables:

    • RWS_CALL
    • RWS_JOB
    • RWS_OBJ
    • RWS_PAR
    • RWS_SEL
    • RWS_SRC
    • RWS_STEP
    • RWS_WEL
  4. Right-click and select Export.

  5. In the Export window, do the following:

    • Clear the Export DDL checkbox.

    • Select the Export data checkbox.

    • From the Format list select csv.

    • From the Save As list select Separate Files.

    • From the File box enter the location where the export file is to be created.

  6. Click Next, then Next, and thenFinish.

Extracting CPS Data on MSSQL Server

This procedure describes how to extract Redwood CPS data on a MSSQL Server.

Begin

  • From the <Conversion Home>/scripts/<Redwood> directory, type the following command:

    redwood_MsSQL_export -U <username> -P <password> -S <database server> -D <database/schema name> [-T <table names list>

    A batch script exports the table from the Redwood MSSQL server.

    -T table1,table2,table3

Tidal CPS Data Extraction

Extract and import Tidal data in one of the following ways:

Extracting Tidal Data on MSSQL Server

This procedure describes how to extract data on a Tidal MSSQL Server.

Begin

  • From the <Conversion Home>/scripts/Tidal directory, type the following command:

    tidal_MsSQL_export(-U <username> -P <password>| -W <Windows credentials>)-S <database server> -D <database/schema name>

    The command, causes a batch script to export the table from the Tidal MSSQL server.

Extracting Tidal Data Using Oracle SQL Developer

This procedure describes how to extract data on an Oracle SQL Developer.

Begin

  1. From Oracle SQL developer, log in to the database.

    BMC recommends to log in as DBO user, but you can log in with any user with read permissions on the Tidal database.

  2. Expand the table group.

  3. Select the following tables:

    • JOBDTL

    • NODMST

    • OWNER

    • USRMST

    • RESMST

    • VARMST

    • TRGMST

    • TRGJOB

    • EVNTMST

    • EVNTYEAR

    • EVNTCOND

    • EVNTFSCL

    • EVNTCHLD

    • WORKUSR

    • WORKGRP

    • JOBCLS

    • RESJOB

    • JOBMST

    • JOBDEP

    • NODLSTDT

    • NODLSTMS

    • TRGTSK

    • TSKALRT

    • TSKLOG

    • TSKMAIL

    • TSKMST

    • TSKSCH

    • TSKVAR

  4. Right-click and select Export.

  5. From the Export window, do the following:

    • Clear the Export DDL checkbox.

    • Check the Export data checkbox

    • From the Format list, select csv.

    • From the Save As list, select Separate Files.

    • From the File box, enter the location of the export file.

  6. Click Next, Next, and then Finish.

ASG Zena Data Extraction

Extract and import Zena data in one of the following ways:

Extracting Zena Data on an Oracle SQL Developer

This procedure describes how to extract Zena data on an Oracle SQL Developer.

Begin

  1. Log in to the Zena database and type your database name.

  2. Select the following tables:

    • definitions

    • agents

  3. Right-click and select Export.

  4. From the Export window, do the following:

    • Clear the Export DDL checkbox.

    • Check the Export data checkbox.

    • From the Format list select csv.

    • From the Save As list select Separate Files.

    • From the File box enter the export file location.

  5. Click Next, Next and then Finish.

Extracting Zena Data on an MSSQL Server

This procedure describes how to extract Zena data on an MSSQL Server.

Begin

  • From the <Conversion Home>/scripts/<Zena> directory, type the following command:

    zena_MsSQL_export -U <username> -P <password> -S <database server> -D <database/schema name>

    You do not have to insert <tables list> because a table default value is set to run conversion. After you run the command, a batch script exports the table from the Zena MSSQL server.

Hadoop-Oozie Data Extraction

Extract and import Hadoop-Oozie data in one of the following ways:

  • Automatic Import: Define the Hadoop-Oozie database owner credentials in the Conversion Tool.

  • Manual Import: Extract and then load the required data. For more information, see Extracting Hadoop - Oozie Data

Extracting Hadoop - Oozie Data

This procedure describes how to manually extract Hadoop - Oozie data.

Begin

  • Create the following files:

    • coordinator.xml: Converts to a folder in Control-M. Each action in the Coorindator XML is converted to a subfolder created from the corresponding workflow.
    • workflow.xml: Holds the Hadoop execution types (such as Map/Reduce, sqoop, Pig, Hive) that converts to Control-M for Hadoop jobs.

    • bundle.xml: Enables you to batch a set of coordinator applications.

    • bundle.properties: Holds the variables and its values.

SAP Data Extraction

You can export and import SAP data in one of the following ways:

Downloading the SAP Java Connector Files

This procedure describes how to download the required SAP Java Connector files so that you can import your data automatically to Control-M.

Begin

  1. Download the sapjco3.jar and sapjco3.dll C library files from http://service.sap.com/connectors.

  2. In the left pane, under Connectors, click SAP Java Connector and then click Tools & Services.

  3. In the right pane, under SAP Java Connector (SAP JCo), click the quick link to download SAP JCo Release 3.x.

  4. Download the sapjco3.jar and sapjco3.dll C library files from that section.

    Ensure that you download the appropriate files for your computer architecture (32 bit or 64 bit).

  5. Copy the sapjco3.jar and sapjco3.dll C library files to the following directory:

    <Conversion Home>\lib

    • Windows: Obtain and install the Visual Studio .Net C/C++ runtime libraries required by JCo.

    • For more information about how to obtain and install the Visual Studio runtime libraries, see the Support and Release Strategy section in the SAP Java Connector download page.

    • Starting with JCo 3.0.00, JCo running on Windows requires the Visual Studio 2005 C/C++ runtime libraries. See SAP note 684106 for details on how to install them.

  6. After adding the files, restart the Conversion Tool and continue with automatic data import.

Extracting SAP Data Using the Control-M SAP Jobs Extractor Manually

This procedure describes how to extract SAP data using the Control-M SAP Jobs Extractor so that you can import your data manually to Control-M.

Begin

  1. Extract the BMC Control-M SAP Jobs Extractor zip file from the following location:

    <Conversion Home>\scripts\SAP\BMC_CONTROL-M_SAP_jobs_extractor.zip

  2. Download the sapjco3.jar and sapjco3.dll C library files from http://service.sap.com/connectors

  3. In the left pane, under Connectors, click SAP Java Connector and then click Tools & Services.

  4. In the right pane, under SAP Java Connector (SAP JCo), click the quick link to download SAP JCo Release 3.x.

  5. Download the required files from that section and copy the sapjco3.jar and sapjco3.dll C library files to the following path:

    <BMC Control-M SAP Jobs extractor folder>

  6. Run the sapextgui.cmd command.

    The BMC Control-M SAP Jobs Extractor window appears.

  7. In the SAP Connection field, complete the SAP parameters.

  8. Click Test Connection to test the connectivity to the SAP system.

  9. In the Jobs Filter field, define the mandatory parameters:

    • Job Name

    • User Name

    • Job Status

    You can use "*" characters for Job Name and Job Count.

    The remaining parameters are optional.

  10. After you define the parameters, save the file.

    You can retrieve the file for reuse, using the Load Rule File and Save Rule File buttons.

  11. Click Get Jobs.

    The jobs are extracted.

  12. Click Yes and then Yes.

    The output file is saved.

    The jobs have been successfully extracted.

Extracting IBM Sterling Connect:Direct Data

This procedure describes how to extract IBM Sterling Connect:Direct data so that you can import your data manually to Control-M.

Begin

  • Extract the content of the Sterling Process Files Directory to use in the Conversion Tool.

IBM Sterling Connect:Direct Mapping

The conversion from IBM Sterling Connect:Direct (C:D) is based on having input C:D process files that contain all the file transfer logic (such as source host, target host , file to transfer etc.) and reside in your file system.

If C:D file transfers are triggered within scripts, obtains file transfer parameters from outside scripts, and dynamically creates C:D process files you need to replace all the jobs that calls those scripts with the File transfer job template that use those parameters.

The following table describes how the Conversion Tool converts job types, files, statements and parameters from IBM Sterling Connect:Direct to Control-M.

IBM Sterling Connect:Direct

Control-M

Process Files

SMART folders containing Managed File Transfer (MFT) jobs (and Dummy jobs)

COPY statements

MFT jobs

RUN statements

Dummy jobs

SUBMIT statements

Dummy jobs

GOTO, IF, EIF, EXIT, SYMBOL statements

Not converted and must be manually handled.

The Conversion Tool issues a warning message if those statements exist in the Process files.

COPY FROM and TO parameters

MFT FTP-LPATH1 and FTP-RPATH1 job parameters (the source and destination locations on the host computers) corresponding to which one is defined as the PNODE (Primary node) and SNODE (Secondary node) in IBM Sterling Connect:Direct.

PNODE (Primary node) and SNODE (Secondary node)

The conversion specifies a connection profile name consisting of a combination of a PNODE and SNODE separated by a dash. The user needs to create the Connection profiles in the Control-M Configuration Manger and chose them manually from the MFT jobs created by the Conversion Tool.