Skip to Content

SJTABLES—Star join table threshold

Use the Modify Star Join Table Threshold panel or the SJTABLES command to establish the Star Join threshold value. The new value takes effect immediately.

Modify Star Join Table Threshold panel

DDTG DEI1 Modify Star Join Table Threshold
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . . : STAR JOIN TABLE THRESHOLD

Type the new Star Join Table Threshold value that you wish to change to. Then press Enter.

Star Join Table Threshold
Star Join Table Threshold . . (0 - 32767)

Command syntax and parameters

image2018-12-24_23-7-46.png

Value

Description

DB2ssid

Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies.

opertuneID

OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job).

value

Determines when star join will be considered. Specify one of the following values:

  • 0—star join is considered if the query block has 10 or more tables (default)
  • A numerical value in the range 1–3 (star join is always considered)
  • A numerical value in the range 256–32767
  • A numerical value in the range 4–255 (star join is considered if the query block has at least the specified number of tables)

NORESET

The changes you request remain in effect until the Db2 subsystem is cycled.

Db2 parameter values

Field

Installation panel

CLIST parameter

ZPARM macro

ZPARM parameter

Star Join Table Threshold

None

None

DSN6SPRM

SJTABLES

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

OPERTUNE for DB2 12.1