CREATE profile command

(BMC.DB2.SPE2210)


This command creates a migrate or baseline profile. Either include an existing profile to use for the scope rules or use the ADD SCOPE command to add scope rules to the profile definition.

You can use the CREATE profile command in the batch profile JCL.

Related topics

ADD-SCOPE-command

REPLACE-profile-command

Batch-profile-commands

Overview-of-baseline-profiles

CREATE MIGRATE PROFILE

This section describes CREATE MIGRATE PROFILE syntax.

BatchProfile_createMigrateKeyword_SPE2210.png

Variable

Description

profileOwner.profileName

This variable defines the name of the migrate profile that you want to create.

migrateType

This variable defines the type of migrate profile. Valid values are as follows:

Value

Description

OUTBOUND

OUTBOUND is the only valid value for the migrate type in the batch profile process. The Analysis and Compare components use outbound migrate profiles to generate worklists or CDL files, or to specify objects. If you do not specify a migrate type, the batch profile process defaults to OUTBOUND. 

INBOUND

The batch process does not support INBOUND migrate profiles. The Import component uses inbound migrate profiles to make input from another system compatible with the receiving subsystem’s version of the application. 

blProfileOwner.blProfileName

This variable specifies a catalog baseline profile to define scope rules that select the Db2 objects to include in the migration. If you do not specify a baseline profile, you must specify scope rules for the outbound migrate profile.

comment

The comment is displayed or printed whenever the profile is used and can contain descriptive text about the profile. The maximum length of the comment is 255 characters. Any characters beyond the maximum are truncated.

Examples

The following examples illustrate the use of the CREATE MIGRATE PROFILE command:

Examples

The following syntax creates an outbound migrate profile:

CREATE MIGRATE PROFILE MVSAMA.MPTEST1

The following syntax creates an outbound migrate profile that uses a catalog baseline profile for its scope rules:

CREATE MIGRATE PROFILE MVSAMA.MPTEST3 OUTBOUND BLPREF=MVSAMA.BPTEST1 

The following syntax creates a migrate profile with scope rules:

CREATE MIGRATE PROFILE PROFCR.MPSAMP3
ADD SCOPE INCLUDE DB QADB1 MIGDATA MIGCK MIGFK MIGTS MIGTB MIGRP MIGMK MIGTR
ADD SCOPE INCLUDE TS QADB2.TS01 MIGTB, MIGVW, MIGIX
ADD SCOPE INCLUDE TB QADB3.TB01 MIGDATA

CREATE BASELINE PROFILE

This section describes CREATE BASELINE PROFILE syntax that you use to create a baseline profile.

BatchProfile_createBaselineKeyword_SPE2210.png

Variable

Description

profileOwner.profileName

This variable defines the name of the baseline profile that you want to create.

baselineType

This variable defines the scope of the data structures when you create the baseline. Valid values are as follows:

Value

Description

CATALOG

A catalog baseline uses the data structures from the Db2 catalog. The catalog baseline profile can explicitly specify the scope rules or can reference the scope rules in an outbound migrate profile. If not specified, CATALOG is the default baseline type.

DDL

A DDL baseline uses the data structures from a DDL file or migrate-type worklist.

baselineTemplate

This variable specifies a template for the names of the baselines that are created using the profile. The template name must begin with an alphabetic character, cannot exceed 18 characters, and must contain either @@@@@@, @@@@@@@@, or ####:

  • @@@@@@ are replaced by the current date in the form YYMMDD.
  • @@@@@@@@ are replaced by the current date in the form YYYYMMDD.
  • #### are replaced by an ascending sequence of numbers.

migProfileOwner.migProfileName

This variable specifies an outbound migrate profile to use for scope rules in a catalog baseline. If you do not specify the migrate profile, you must specify scope rules for the catalog baseline. In a DDL baseline, the DDL file or migrate-type worklist specifies the scope. 

DELETEAGE = value

This option specifies the minimum number of days to retain a baseline created with this profile. This option specifies to automatically delete baselines that are built with this profile that are older than the DELETEAGE value. To retain all of the completed baselines, specify zero for this option and the RETAINMAX option.

RETAINMAX = value

This option specifies the maximum number of baselines to retain that were created with this profile. To retain all of the completed baselines, specify zero for this option and the DELETEAGE option.

comment

The comment is displayed or printed whenever the profile is used and can contain descriptive text about the profile. The maximum length of the comment is 255 characters. Any characters beyond the maximum are truncated.

Examples

The following examples illustrate the use of the CREATE  BASELINE PROFILE command:

Examples

The following syntax creates how to create a catalog baseline profile that uses an outbound migrate profile for its scope rules:

CREATE BASELINE PROFILE MVSAMA.BPTEST3 CATALOG MIGPREF=MVSAMA.MPTEST1

The following syntax creates a DDL baseline profile that defines a template for the baseline names.  It also specifies to retain the latest baseline created with this profile indefinitely or until another baseline is created with this profile.

CREATE BASELINE PROFILE MVSAMA.BPTEST4 DDL BLTEMP=MVSAMA#### DELETEAGE=0 RETAINMAX=1 

Important

You can use only one method to delete baselines automatically for a profile. That is, you cannot use a nonzero value for both DELETEAGE and RETAINMAX in the same job.

The following syntax creates a catalog baseline profile with RETAINMAX and scope rules:

CREATE BASELINE PROFILE PROFCR.BPCAT01 CATALOG
RETAINMAX=5 REMARKS(CATALOG BP create RETAINMAX)
ADD SCOPE DB QADB1 MIGALL
ADD SCOPE TS QADB2.TS01 MIGTB MIGFK MIGCK
ADD SCOPE SG SG001

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*