Skip to Content

 

  

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

-ORGN (CDL origin subsystem)

The -ORGN command defines the system that originated the CDL.

-ORGN is a required command and must appear after -TIME and before -DEST.

 

The contents of the -ORGN command differs depending on the version of Db2 running in the subsystem where the Compare was run. The following sections describe the differences in the -ORGN command.

-ORGN command in a Db2 12 or later subsystem

The following figure shows the -ORGN command in a Db2 12 subsystem:

-ORGN 000100 SSID DEJM LOCATION DEJM CURRENT FUNCTION LEVEL 'V12R1M500'
-ORGN 000150 SSID DEJM LOCATION DEJM CATALOG LEVEL 'V12R1M500'         
-ORGN 000200 APPLCOMPAT IS 'V12R1M500'                                 
-ORGN 000250 APPLCOMPAT FROM DSNZPARM IS 'V12R1M500'

The -ORGN command parameters are described as follows:

  • Possible values for SSID are the origin subsystem of the CDL statements or an asterisk (*) if the origin subsystem is not known.
  • Possible values for LOCATION are the origin location ID of the CDL or * if the origin location is not known.
  • CURRENT FUNCTION LEVEL is the current function level of the Db2 subsystem.
  • CATALOG LEVEL is the current catalog level of the Db2 subsystem.
  • APPLCOMPAT is the current application compatibility level of the Db2 subsystem.
  • APPLCOMPAT FROM DSNZPARM is the current application compatibility level specified in the Db2 DSNZPARM.

-ORGN command in a Db2 11 or earlier subsystem

The following figure shows the -ORGN command in a Db2 11 subsystem:

-ORGN 000100 SSID DBAH   LOCATION *   RELEASE '111'

The -ORGN command parameters are described as follows:

  • Possible values for SSID are the origin subsystem of the CDL statements or an asterisk (*) if the origin subsystem is not known.
  • Possible values for LOCATION are the origin location ID of the CDL or * if the origin location is not known.
  • RELEASE is the version and release number of the Db2 system from which the CDL was generated. This release string is returned from a Db2 CALL ATTACH and must be enclosed with single quotes.

The following figure shows the -ORGN command:

-ORGN 000100 SSID DBAH   LOCATION *   RELEASE '111'

The -ORGN command parameters are described as follows:

  • Possible values for SSID are the origin subsystem of the CDL statements or an asterisk (*) if the origin subsystem is not known.
  • Possible values for LOCATION are the origin location ID of the CDL or * if the origin location is not known.
  • RELEASE is the version and release number of the Db2 system from which the CDL was generated. This release string is returned from a Db2 CALL ATTACH and must be enclosed with single quotes.

Related topic

CDL-commands


 

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

ALTER and BMC AMI Change Manager for Db2 12.1