Table of Contents

2011 March

2011-03-01

DB2 Workload
Uses a single workload setting to configure several registry variables at once, a fine example of this is the 'SAP' workload.

DB2 9.7 registry variables - Note that documentation is incomplete

List registry variables

SELECT
 SUBSTR(REG_VAR_NAME, 1, 25) AS "REG_VAR_NAME"
,SUBSTR(REG_VAR_VALUE, 1, 15) AS "REG_VAR_VALUE"
,IS_AGGREGATE
,SUBSTR(AGGREGATE_NAME, 1, 15) AS "WORKLOAD_NAME"
 /**
  * I   Instance
  * G   Global
  * N   Database partition
  * E   Environment
  **/
,LEVEL
FROM TABLE(SYSPROC.REG_LIST_VARIABLES()) AS REGISTRYINFO
## These registry variables set for SAP workload
$ db2set -gd DB2_WORKLOAD=SAP