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-+--FOR SECTION--section-name--->
                 +-CONFIG--------+
                 '-CFG-----------'
 
                                 .------------------.
                                 V                  |
>-----+---------------+---USING-----keyword value---+----------><
      '-AT USERLEVEL--'

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 USERLEVEL: 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.

See Also

GET CLI CONFIGURATION

REFRESH LDAP.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]