Command Reference

UPDATE CLI CONFIGURATION

Updates the contents of a specified section in the db2cli.ini file.

The db2cli.ini file is used as the DB2 call level interface (CLI) configuration file. It contains various keywords and values that can be used to modify the behavior of the DB2 CLI and the applications using it. The file is divided into sections, each section corresponding to a database alias name. For more information about this file and the CLI/ODBC configuration keywords, see the CLI Guide and Reference.

Authorization

sysadm

Required Connection

None

Command Syntax

>>-UPDATE CLI----+-CONFIGURATION-+------------------------------>
                 +-CONFIG--------+
                 '-CFG-----------'
 
>-----+-------------------------+--FOR SECTION--section-name---->
      '-AT--+-GLOBAL-+---LEVEL--'
            '-USER---'
 
             .------------------.
             V                  |
>-----USING-----keyword value---+------------------------------><
 

Command Parameters

FOR SECTION section-name

Name of the section whose keywords are to be updated. If the specified section does not exist, a new section is created.

AT GLOBAL LEVEL

Specifies that the CLI configuration parameter is to be updated at the global level.

Note:

This parameter is only applicable when LDAP support is enabled.

AT USER LEVEL

Specifies that the CLI configuration parameter is to be updated at the user level. This parameter is only applicable when LDAP support is enabled.

USING keyword value

Specifies the CLI/ODBC parameter to be updated.

Usage Notes

The section name and the keywords specified on this command are not case sensitive. However, the keyword values are case sensitive.

If a keyword value is a string containing single quotation marks or imbedded blanks, the entire string must be delimited by double quotation marks. For example:

   db2 update cli cfg for section tstcli1x
      using TableType "'TABLE','VIEW','SYSTEM TABLE'"

When the AT USERLEVEL keywords are specified, the CLI configuration parameters for the specified section are updated only for the current user; otherwise, they are updated for all users on the local machine. The CLI configuration at the user level is maintained in the LDAP directory and cached on the local machine. When reading the CLI configuration, DB2 always reads from the cache. The cache is refreshed when:

• The user updates the CLI configuration.
• The user explicitly forces a refresh of the CLI configuration using the REFRESH LDAP command.

In an LDAP environment, users can configure a set of default CLI settings for a database catalogued in the LDAP directory. When an LDAP cataloged database is added as a DSN (Data Source Name), either by using the CCA (Client Configuration Assistant) or the ODBC configuration utility, any default CLI settings, if they exist in the LDAP directory, will be configured for that DSN on the local machine. The AT GLOBAL LEVEL clause must be specified to configure a CLI parameter as a default setting.

See Also

GET CLI CONFIGURATION

REFRESH LDAP.