An application group is a named group of applications, which are used when you use ODBC connections.
An application group defines the node location of the source, and if required, a user ID and password to access the source. When you add a registration group, PowerExchange adds an application group with the same name. You can also manually add an application group by using this procedure.
On the
Resources
tab in the
Resource Explorer
, click
Add > Application Group
.
In the
Add Application Group
dialog box, enter the following information:
Name
A user-defined name for the application group. Maximum length is 16 characters.
Location
The location of the source for which you want to extract change data. Select
local
if the 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
For an i5/OS or z/OS source, enter an operating system user ID if PowerExchange security is enabled. PowerExchange security is enabled when the PowerExchange SECURITY statement in the DBMOVER member is set to (1,
x
) or 2.
x
).
For a DB2 for Linux, UNIX, and Windows,
Microsoft SQL Server, or Oracle source, enter a valid database user ID, if required. For more information, see the SECURITY Statement in the
PowerExchange Reference Manual
.
Password
A password for the specified user ID.
If the source is on an i5/OS or z/OS system, you can enter a valid PowerExchange passphrase instead of a password. An i5/OS passphrase can be from 9 to 31 characters in length. A z/OS passphrase can be from 9 to 128 characters in length. A passphrase 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.
On z/OS, the allowable characters in the IBM IRRPHREX exit do not affect the allowable characters in PowerExchange passphrases.
On z/OS, 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
.
If you specify a user ID but omit the password, when you open the application group, the PowerExchange Navigator prompts you for the password in the
Missing Password
dialog box.
Click
Finish
.
The
Application Group
tab in the
Resource Inspector
displays the properties for the application group.
If you use ODBC connections to extract change data, the
Application Group
tab in the
Resource Explorer
displays any applications for the node location associated with the application group.