DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.USEROPTIONS catalog view

Each row represents a server-specific user option value.

Table 1. SYSCAT.USEROPTIONS Catalog View
Column Name Data Type Nullable Description
AUTHID VARCHAR (128)   Local authorization ID, in uppercase characters.
AUTHIDTYPE CHAR (1)  
  • U = Grantee is an individual user
SERVERNAME VARCHAR (128)   Name of the server on which the user is defined.
OPTION VARCHAR (128)   Name of the user option.
SETTING VARCHAR (2048)   Value of the user option.