Skip to Content

-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.

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 13.1