ZOSDBNameFilter IBM data server driver configuration keyword

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

Equivalent CLI keyword

DBName

Equivalent IBM® data server provider for .NET connection string keyword

DBName

IBM data server driver configuration file (db2dsdriver.cfg) syntax

<parameter name="ZOSDBNameFilter" value="dbname"/>

Default setting:

Do not filter on the DBNAME column.

Usage notes:

The ZOSDBNameFilter keyword is only used when you are connecting to Db2 for z/OS servers, and only if (base) table catalog information is requested by the application. If many tables exist in the Db2 for z/OS server, a dbname can be specified to reduce the time it takes for the application to query table information, and reduce the number of tables that are listed by the application.

If the ZOSDBNameFilter keyword is set, then the IN DATABASE dbname statement is appended to various statements such as the CREATE TABLE statement.

The ZOSDBNameFilter value maps to the DBNAME column in the Db2 for z/OS system catalog tables. If no value is specified, or if views, synonyms, system tables, or aliases are also specified by using the TableTypeFilter keyword, only table information is restricted; views, aliases, and synonyms are not restricted with the ZOSDBNameFilter keyword. The ZOSDBNameFilter keyword can be used with the SchemaFilter, and TableTypeFilter keywords to further limit the number of tables for which information is returned.

The ZOSDBNameFilter setting is ignored if target server is not Db2 for z/OS.

Example of using the IBM data server driver configuration file (db2dsdriver.cfg) syntax:

<database name="sample" host="localhost" port="446"> 
	<parameter name="ZOSDBNameFilter" value="DSNDB01"/>
</database>