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.
None
None
>>-GET CLI--+-CONFIGURATION-+--+-----------------+--------------> +-CONFIG--------+ '-AT GLOBAL LEVEL-' '-CFG-----------' >--+---------------------------+------------------------------->< '-FOR SECTION--section-name-'
The following sample output represents the contents of a db2cli.ini file that has two sections:
[tstcli1x]
uid=userid
pwd=password
autocommit=0
TableType="'TABLE','VIEW','SYSTEM TABLE'"
[tstcli2x]
SchemaList="'OWNER1','OWNER2',CURRENT SQLID"
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.
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.