db2set DB2_WORKLOAD

This little known option of the db2set command comes in handy when you want to see what the configuration parameters that are set as part of an aggregate workload setting. The two most commonly seen are DB2_WORKLOAD=SAP and DB2_WORKLOAD=ANALYTICS. The command and output are below:

C:\Program Files\IBM\SQLLIB_01\BIN>db2set -gd DB2_workload=analytics
DB2_ANTIJOIN=EXTEND
DB2_USE_ALTERNATE_PAGE_CLEANING=ON

C:\Program Files\IBM\SQLLIB_01\BIN>db2set -gd DB2_workload=SAP
DB2_REDUCED_OPTIMIZATION=4,INDEX,JOIN,NO_TQ_FACT,NO_HSJN_BUILD_FACT,STARJN_CARD_
SKEW,NO_SORT_MGJOIN,REDUCE_LOCKING,CART OFF,CAP OFF
DB2_MINIMIZE_LISTPREFETCH=YES
DB2_INLIST_TO_NLJN=YES
DB2_ANTIJOIN=EXTEND
DB2_IMPLICIT_UNICODE=YES
DB2_EVALUNCOMMITTED=YES
DB2_INTERESTING_KEYS=YES
DB2_SKIPINSERTED=YES
DB2_MDC_ROLLOUT=DEFER
DB2_OBJECT_TABLE_ENTRIES=65532
DB2NOTIFYVERBOSE=YES
DB2_VIEW_REOPT_VALUES=YES
DB2_OPT_MAX_TEMP_SIZE=10240
DB2_TRUNCATE_REUSESTORAGE=IMPORT
DB2COMM=TCPIP
DB2_DUMP_SECTION_ENV=YES
DB2_GRP_LOOKUP=,TOKEN
DB2_CREATE_DB_ON_PATH=YES
DB2_LIMIT_FENCED_GROUP=NO
DB2_RESTRICT_DDF=YES
DB2_ATS_ENABLE=YES
DB2_TRUST_MDC_BLOCK_FULL_HINT=YES
DB2COMPOPT=OJSJ,VOLATILETSF,WORKLOADSAP,BLU_SAP_MEMTBL
DB2_AGENT_CACHING_FMP=OFF
DB2STMM=APPLY_HEURISTICS:YES
DB2_ATM_CMD_LINE_ARGS=-include-manual-tables
DB2_CREATE_INDEX_COLLECT_STATS=YES
DB2_EXTENDED_OPTIMIZATION=GY_DELAY_EXPAND 1000,NO_NLJN_SPLIT_BUFFER
DB2_BLOCKING_WITHHOLD_LOBLOCATOR=NO
DB2_RUNTIME_DEBUG_FLAGS=TOLERANT_FLOAT,DISABLE_BLANK_TOLERANCE
DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=YES
DB2_SKIP_VIEWRECREATE_SAP=TRUE
DB2_INDEX_PCTFREE_DEFAULT=0
DB2_BCKP_INCLUDE_LOGS_WARNING=YES
DB2_CDE_STMTCACHING=YES
DB2_TRANSCHEMA_EXCLUDE_STATS=TRUE
DB2_CDE_WITHOUT_SYNOPSIS=%:/%/D%
DB2_TRANSCHEMA_EXCLUDE_STATS=TRUE