Profile Registry variable - db2set

[Former Member]

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

[Former Member]

Hi,

i can't set DB2_REDUCED_OPTIMIZATION=4,INDEX,JOIN,NO_HSJN_BUILD_FACT,STARJN_CARD_SKEW,NO_SORT_MGJOIN,CART OFF,CAP OFF.

It is work only without CART OFF and CAP OFF?! What is wrong?

PS: DB6 Version is 9.7 and DB2_WORKLOAD=SAP

Regards

JR