DB2 (EnvSetup)

The registration utility may be executed from any workstation configured to connect to both the production environment database and the ConfigLab environment database.

In this example, we describe how to register a ConfigLab environment. We'll call the supported environment database "CDXPROD" and the ConfigLab environment database "CDXCLAB".

A sample file DB2-compare-source.bat is provided with an example for a Compare Source registration.

You may specify the following parameters on the command line. If parameters are not supplied, the registration utility prompts for them:

• Information about the supporting environment database:
  • Location of the database
  • Database user with SYSADM privileges
  • Password of database user with SYSADM privileges
  • Application Schema owner database user
  • Database user with read-write privileges to the application schema

  -s CDXCLAB,{sysadm user},{sysadm user password},CISADM,CISUSER

• Information about the supported environment database:
  • Location of the database
  • Database user with SYSADM privileges
  • Password of database user with SYSADM privileges
  • Application Schema owner database user
  • Database user with read-write privileges to the application schema

  -r CDXPROD,{sysadm user},{sysadm user password},CISADM,CISUSER

• Action:
  • I-Install (register), U-Reconfigure (reregister), D-Uninstall (deregister)

  -a I

• Environment type of the supporting environment:
  • CMPS-Compare Source, SYNT-Sync Target, CLAB-ConfigLab, ARCH-Archive

  -t CLAB

• Environment reference code:
  • The environment reference used to track the ConfigLab environment.

  -e PROD-CONFIGLAB

• Name prefix:
  • The prefix character used to reference database tables in the ConfigLab environment. Note that this character must not be C, S, or a name prefix used by an existing supporting environment.

  -n A

• Environment description:
  • Description of the environment reference.

  -d Production ConfigLab

• Apply changes to the databases:
  • Specify this parameter to apply the changes directly instead of writing them to a log file.

  -u

• Owner Flag:
  • Specify the Owner Flag for the application.

  -o owner flag value

• Log file name:
  • Specify the name of the log file if the parameter above was not specified.

  -l {log file name}