SYSCAT.WORKLOADCONNATTR catalog view

Each row represents a connection attribute in the definition of a workload.

Table 1. SYSCAT.WORKLOADCONNATTR Catalog View
Column Name Data Type Nullable Description
WORKLOADID INTEGER   Identifier for the workload.
WORKLOADNAME VARCHAR (128)   Name of the workload.
CONNATTRTYPE VARCHAR (30)   Type of the connection attribute.
  • 1 = APPLNAME
  • 2 = SYSTEM_USER
  • 3 = SESSION_USER
  • 4 = SESSION_USER GROUP
  • 5 = SESSION_USER ROLE
  • 6 = CURRENT CLIENT_USERID
  • 7 = CURRENT CLIENT_APPLNAME
  • 8 = CURRENT CLIENT_WRKSTNNAME
  • 9 = CURRENT CLIENT_ACCTNG
  • 10 = ADDRESS
CONNATTRVALUE VARCHAR (1000)   Value of the connection attribute.