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 · Accepted solution]

not sure for option [O], but starting with DB2 9, there are options to set the variables specific to instance or globally or at other levels

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0...

After setting up the variable, now what db2set -all shows ?

[Former Member · Accepted solution]

Thanks for the quick response, db2set -all gives the below value for that parameter

<i> 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]

[Frank-Martin · Accepted solution]

Hi Cheriyan,

standard registry settings covered under the DB2_WORKLOAD setting are marked with [DB2_WORKLOAD] .

if you OVERRIDE one of those they are marked with [O] .

Were you going to apply note 1126400 ?

In this case you should have set

DB2_REDUCED_OPTIMIZATION=4,INDEX,JOIN,NO_TQ_FACT,NO_HSJN_BUILD_FACT,STARJN_CARD_SKEW,NO_SORT_MGJOIN,CART OFF,CAP OFF

without "DB2_WORKLOAD" at the end.

Regards

Frank

[Former Member · Accepted solution]

Hi Frank,

Thanks for the valuable reply, so if get DB2_REDUCED_OPTIMIZATION=4,INDEX,JOIN,NO_TQ_FACT,NO_HSJN_BUILD_FACT,STARJN_CARD_SKEW,NO_SORT_MGJOIN,CART OFF,CAP OFF [O] isthat ok? (without [DB2_WORKLOAD])

Regards,

Cs

[Frank-Martin · Accepted solution]

Hi cs,

yes. Please remember to remove the explicit setting after upgrading to a new DB2 fixpack level taht contains the "CAP OFF" setting under the DB2_WORKLOAD setting.

Regards

Frank