Profile Registry variable - db2set

[#1]

Hi,

I need to add CAP OFF to the Profile Registry variable using the db2set command for DB2_REDUCED_OPTIMIZATION, while adding this it appends [O] at the end of the variable as shown below .what does this mean? does it have any impact to the variable?

DB2_REDUCED_OPTIMIZATION=4,INDEX,JOIN,NO_TQ_FACT,NO_HSJN_BUILD_FACT,STARJN_CARD_SKEW,NO_SORT_MGJOIN,CART OFF,CAP OFF [DB2_WORKLOAD] [O]

Regards,

cs

[hans-juergen_zeltwanger]

Hello,

DB2_REDUCED_OPTIMIZATION is usually set as part of the DB2_WORKLOAD=SAP variable. All "child" settings that are set by this "father" variable, are indicated by [DB2_WORKLOAD].

An [O] behind a variable indicates that you have overwritten DB2_WORKLOAD with an[O]ther setting.

Regards, Hans-Juergen