In the DB2 Table Filter dialog box, view or edit table filtering criteria for a DB2 catalog or DB2 unload file data map.
The dialog box contains the following fields:
DB Instance
The DB2 database instance name. Valid characters are ASCII characters and the pound and yen sign.
Location
The location of the data source. Select
local
if the data source is on the PowerExchange Navigator system.
This field lists the locations that are defined in NODE statements in the dbmover.cfg configuration file on the PowerExchange Navigator system.
Default is
local
.
UserID
A database user ID that can access the database, if required. For more information, see the SECURITY statement in the
PowerExchange Reference Manual
.
For a database on a supported Linux, UNIX, or Windows system, if you have enabled PowerExchange LDAP user authentication and, if applicable, disabled relational pass-through authentication, the user ID is the enterprise user name.
For more information, see the
PowerExchange Reference Manual
.
Password
A password for the specified user ID.
For access to z/OS, you can enter a valid PowerExchange passphrase instead of a password. A PowerExchange passphrase can be from 9 to 128 characters in length and can contain the following characters:
Uppercase and lowercase letters
The numbers 0 to 9
Spaces
The following special characters:
’ - ; # \ , . / ! % & * ( ) _ + { } : @ | < > ?
The first character is an apostrophe.
Passphrases cannot include single quotation marks (‘), double quotation marks (“), or currency symbols.
The allowable characters in the IBM IRRPHREX exit do not affect the allowable characters in PowerExchange passphrases.
A valid RACF passphrase can be up to 100 characters in length. PowerExchange truncates passphrases longer than 100 characters when passing them to RACF for validation.
To use passphrases, ensure that the PowerExchange Listener runs with a security setting of SECURITY=(1,N) or higher in the DBMOVER member. For more information, see "SECURITY Statement" in the
PowerExchange Reference Manual
.
Filter Data
Enter text in any of the following filter boxes:
Creator/Schema
DBName/Definer
Table
For DB2 for i5/OS, the maximum length is 10 characters in the
Creator/Schema
box and 32 characters in the
Table
box.
For DB2 for z/OS, the maximum length is 128 characters in the
Creator/Schema
box and 128 characters in the
Table
box.
In any filter box, you can use the following wildcard characters:
An asterisk (*) to represent one or more matching characters.
A question mark (?) to represent a single matching character.
Respect Case
By default, text entered in any of the filter boxes is converted to the standard case for the DB2 data source. Select the
Respect Case
option for those filters for which you do not want PowerExchange to use the standard case for the DB2 data source.