Command Line for Creating Environment

The action ENVCREATE is used to create an environment using the command line.

Command line format:

changeassistant.bat -MODE UM -ACTION ENVCREATE -TGTENV <target database> -OUT <log path> -REPLACE <Y or N> -EXONERR <Y or N> -CKYN <Y or N> -CT <database type> -CS <database server name> -OID <owner ID> -UNI <unicode> -CA <access id> -CAP <access id password> -CO <user id> -CP <user password> -CI <connect id> -CW <connect id password> -CZYN <Y or N> -CZ <DB owner> -CZP <DB owner password> -SQH <path to SQL Query tool> -INP <products> -PL <product line> -IND <industry> -INL <languages> -INBL <BASE LANGUAGE> -PSH <path to PS Home> -PAH <path to PS App Home> -PCH <path to PS Cust Home> -SQRF <SQR flags> -NPYN <Y or N> -NPSH <path to new PS Home> -NPAH <path to new PS App Home> -NPCH <path to new PS Cust Home> -NSQRF <new SQR Flags>

or

changeassistant.bat -MODE UM -ACTION ENVCREATE -INI <path to ini file>

The parameters for ENVCREATE action are:

Parameter Description

-MODE

Change Assistant Action (Required)

UM = Update Manager

-ACTION

Action name (Required)

ENVCREATE = Create Environment

-TGTENV

Name of target database. (Required)

-OUT

Path of log file (Optional)

If the log directory is not specified it uses the default defined under General Options.

-REPLACE

Replace existing data if it exists (Optional)

  • Y = Replace existing values if they exist. (default)

  • N = Do not replace values if they exist.

-EXONERR

Specify whether or not to launch GUI if an error or manual stop is encountered. (Optional)

  • Y = Do not Launch

  • N= Launch (default)

-CKYN

Validate database connection and retrieve information from database (Optional)

  • Y = Validate (by default)

  • N = Do not validate

-CT

Database Type (Required)

Database type is a number:

1 – DB2 zOS

2 – Oracle

3 – Informix

4 – DB2 LUW

6 – Sybase

7 – Microsoft SQL Server

-CS

Database Server Name (Optional)

-OID

Owner ID (Optional)

-UDI

Unicode (Required)

  • Y = Yes

  • N = No

-CO

User ID (Required)

-CP

User Password (Required)

-CA

Access ID (Required)

-CAP

Access Password (Required)

-CI

Connect ID (Required)

-CW

Connect Password (Required)

-CZYN

Set DB Owner Credentials (Optional)

  • Y = Yes

  • N = No (default)

-CZ

DBOwner ID (Required if –CZYN is Y)

-CZP

DBOwner Password (Required if –CZYN is Y)

-SQH

SQL Query Tool (Required)

-INP

Installed Products (Required)

Specify either all , a single or multiple products.

For example:

  • -INP all

  • -INP FMA

  • -INP FMA.REA,SMA

-PL

Product Line (Optional)

-IND

Industry (Required)

Specify either all , or a specific industry.

For example:

  • -IND all

  • -IND Commercial

-INL

Languages (Required)

Specify either all , or a specific languages.

For example:

  • -INL all

  • -INL ENG,FRA

-INBL

Base language (Required)

-PSH

PS Home (Required)

-PAH

PS App Home (Required)

-PCH

PS Cust Home (Required)

-SQRF

SQR Flags (Optional)

-NPYN

Enable new PS Home (Optional)

  • Y = Yes

  • N = No (default)

-NPSH

New PS Home (Required if –NPSH is Y)

-NPAH

New PS App Home (Required if –NPSH is Y)

-NPCH

New PS Cust Home (Required if –NPSH is Y)

-NSQRF

New SQR Flags (Optional)

-INI

Path to ini file.

See Using a Configuration File with Changeassistant.bat