DB2 Version 9.7 for Linux, UNIX, and Windows


Lists the contents of the db2cli.ini file. This command can list the entire file, or a specified section.

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 CLI and the applications using it. The file is divided into sections, each section corresponding to a database alias name.



Required connection


Command syntax

Read syntax diagramSkip visual syntax diagram
>>-GET CLI--+-CONFIGURATION-+--+-----------------+-------------->
            +-CONFIG--------+  '-AT GLOBAL LEVEL-'   

   '-FOR SECTION--section-name-'   

Command parameters

Displays the default CLI configuration parameters in the LDAP directory. This parameter is only valid on Windows operating systems.
FOR SECTION section-name
Name of the section whose keywords are to be listed. If not specified, all sections are listed.


The following sample output represents the contents of a db2cli.ini file that has two sections:

   TableType="'TABLE','VIEW','SYSTEM TABLE'"


Usage notes

The section name specified on this command is not case sensitive. For example, if the section name in the db2cli.ini file (delimited by square brackets) is in lowercase, and the section name specified on the command is in uppercase, the correct section will be listed.

The value of the PWD (password) keyword is never listed; instead, five asterisks (*****) are listed.

When LDAP (Lightweight Directory Access Protocol) is enabled, the CLI configuration parameters can be set at the user level, in addition to the machine level. The CLI configuration at the user level is maintained in the LDAP directory. If the specified section exists at the user level, the CLI configuration for that section at the user level is returned; otherwise, the CLI configuration at the machine level is returned.

The CLI configuration at the user level is maintained in the LDAP directory and cached on the local machine. When reading the CLI configuration at the user level, 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 catalogued database is added as a Data Source Name (DSN), either by using the Configuration Assistant (CA) or the CLI/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 display the default CLI settings.