SSID Value of .CONNECT in a DDL to DDL Compare

Document ID : KB000025875
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

How is the SSID value of the .CONNECT determined when a DDL to DDL compare analysis is executed in RC/Compare for DB2 for z/OS?

Answer:

The .CONNECT statement generated by a DDL to DDL compare does not refer to an SSID explicitly. This is because the source and target don't exist in any current SSID DB2 catalogue.  When the generated code is executed and CA Batch Processor encounters this .CONNECT statement with no SSID  it implicitly connects to the SSID that the current session is connected to.