DB2 Version 9.7 for Linux, UNIX, and Windows

DBName CLI/ODBC configuration keyword

Specifies the database name to reduce the time it takes for the application to query z/OS® or OS/390® table information.

db2cli.ini keyword syntax:: DBName = dbname
Default setting:: Do not filter on the DBNAME column.
Only applicable when:: connecting to DB2® for z/OS and OS/390.
Usage notes:

This option is only used when connecting to DB2 for z/OS and OS/390, and only if (base) table catalog information is requested by the application. If a large number of tables exist in the z/OS or OS/390 subsystem, a dbname can be specified to reduce the time it takes for the application to query table information, and reduce the number of tables listed by the application.

If this option is set then the statement IN DATABASE dbname will be appended to various statements such as CREATE TABLE.

This value maps to the DBNAME column in the z/OS or OS/390 system catalog tables. If no value is specified, or if views, synonyms, system tables, or aliases are also specified via TableType, only table information will be restricted; views, aliases, and synonyms are not restricted with DBName. It can be used in conjunction with SchemaList, and TableType to further limit the number of tables for which information will be returned.