DB2WSE Configuration
From Wiki
|
| User Guide |
DB2WSE is controlled by a number of configuration values, which are held in the DB2WSECFG table. The configuration values are all shipped with default values, but they may be changed where required. The following are the current valid configuration values:
DB2WSE Configuration Values
- CONVERT_PASSWD_CASE
- The CONVERT_PASSWD_CASE configuration value controls the conversion of passwords to upper-case for creation/checking purposes.
- If CONVERT_PASSWD_CASE is set to *YES, any DB2WSE profiles created or changed will have the password value specified in the PASSWD parameter to the CRTDWEPRF (Create DB2WSE Profile) command converted to upper-case prior to being stored. Additionally, when a password is passed in a DB2WSE request, it will be converted to upper-case before profile checking is performed.
- If CONVERT_PASSWD_CASE is set to *NO, any DB2WSE profiles created or changed will use the password value specified in the PASSWD parameter to the CRTDWEPRF command with no conversion to upper-case prior to being stored. Additionally, when a password is passed in a DB2WSE request, it will be used exactly as it was passed when DB2WSE performs profile checking.
- DEFAULT_AUTH_LEVEL
- The DEFAULT_AUTH_LEVEL configuration value specifies the default value that should be used for newly-created DB2WSE profiles and queries. The DEFAULT_AUTH_LEVEL configuration value can take any value from 1 to 999. See the details of the CRTDWEPRF and CRTDWEQRY (Create DB2WSE Query) commands for more details on how this configuration value is used.
- DEFAULT_PROFILE_ID
- The DEFAULT_PROFILE_ID configuration value specifies whether a particular DB2WSE profile should be used as the default if no user name and password were passed in the request. It is only valid if the USE_SYSTEM_AUTHORITY configuration value is set to *NO.
- If DEFAULT_PROFILE_ID has a value other than 0 (zero) and a user name and password are not passed in a DB2WSE request, the specified profile will be used when checking the authority to the specified table.
- Note that you should not set DEFAULT_PROFILE_ID to a value other than 0 unless you are certain that the specified profile has only limited authority.
- MAX_SELECT_ROWS
- The MAX_SELECT_ROWS configuration value specifies the maximum number of rows that can be returned as the result of a SELECT request.
- If a SELECT statement is specified which does not include a WHERE clause and which does not specify the FORROWS attribute to the SELECT statement (in other words, if all the rows in the table are requested), DB2WSE will immediately return an error if the number of rows in the table exceeds this value.
- If a SELECT statement is specified which includes either a WHERE clause or the FORROWS attribute to the SELECT statement, DB2WSE will return up to this number of rows. No error will be signaled.
- USE_SYSTEM_AUTHORITY
- The USE_SYSTEM_AUTHORITY configuration value controls the 'authority model' used by DB2WSE.
- If USE_SYSTEM_AUTHORITY is *YES, DB2WSE will use the System Authority Model. If USE_SYSTEM_AUTHORITY is *NO, DB2WSE will use the DB2WSE Authority Model. See the DB2WSE Authority Models page for details of the two different authority models.
Default Values, v1.00+ (Quick Reference)
| Field | Default Value |
|---|---|
| CONVERT_PASSWD_CASE | *YES |
| DEFAULT_AUTH_LEVEL | 500 |
| DEFAULT_PROFILE_ID | 0 |
| MAX_SELECT_ROWS | 2500 |
| USE_SYSTEM_AUTHORITY | *NO |