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

[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

[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