DBName CLI/ODBC and IBM data server driver configuration keyword

db2cli.ini keyword syntax:

DBName = dbname

IBM data server driverconfiguration file (db2dsdriver.cfg) syntax:

<parameter name="DBName" value="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 Db2 for 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.