Where is a description of the %OPTIONS symbol in BIND/REBIND utility models

[Legacy User]

I'm working with a client to cleanup your huge numbers of models in test and production environment. We checked each utility model, is it used also today, how can we customize it to use in production and test the same model. Today, we checked the BIND/REBIND and find the %OPTION symbol, which is an automatic symbol and cannot changed by the user. On the other hand, if we create a BIND/REBIND, we see, that are about 5 - 6 DB2 BIND/REBIND parms inserted. It are not BIND/REBIND values, because they will defined automatically from the REBIND execution:

 

A default of existing value for REBIND PLAN or REBIND PACKAGE means that the default is the value that was determined during the previous bind or rebind of the plan or package that you are rebinding. 

 

For example at a BIND, RCM generates in the %OPTION: QUALIFIER(EWH) ISOLATION(CS) CURRENTDATA(NO) DEGREE(1 ) DBPROTOCOL(DRDA)

at a REBIND i get:

QUALIFIER(EWH) ISOLATION(CS) DEGREE(1 ) DBPROTOCOL(DRDA)

Ok, the QUALIFIER may make sense, but the other ones are the regular defaults for the parms. So, its not necessary to add this parms to the BIND/REBIND statements.

 

They are only confusing for users and increase the length of the analysis output a log. BIND/REBIND statements are doubled in their length.

 

Or am i wrong?

[Lucio Basiaco]

Hi Erwin, I found this symbolic referenced here:

Symbolic Parameters - CA RC/Migrator™ for DB2 for z/OS and CA RC/Compare - 19.0 - CA Technologies Documentation 

It says this:

OPTIONS
BIND list of non-default options.

 

Cheers, Lucio.

[Legacy User]

Hi Lucio,

 

thanks for the info. But i checked it with the DB2 Command Reference, expect the QUALIFIER they are all default values:

 

 ISOLATION(CS) CURRENTDATA(NO) DEGREE(1 ) DBPROTOCOL(DRDA)

 

I checked it with the V10 and the V12 Command Reference. The defaults where not changed between the releases.

 

Erwin