Previous Topic: Create a DB2 Data Source on UNIX Systems

Next Topic: Import the Default Policy Store Objects

Configure the DB2 Wire Protocol Driver

The following table contains configuration parameters for DB2 data sources. You can edit these parameters to configure data sources for separate key, audit log, session, and sample users databases.

Parameter

Description

How to Edit

Data Source Name

Name of the data source.

Enter the data source name inside the square brackets.

Driver

Full path to the SiteMinder DB2 Wire Protocol driver.

Replace "nete_ps_root" with the SiteMinder installation directory.

Description

Description of the data source.

Enter any desired description.

Database

Name of the DB2 UDB database.

Replace "nete_database" with the name of the database configured on the DB2 UDB server.

LogonID

Username required for accessing the database.

Replace "uid" with the username of the DB2 UDB administrator.

Password

Password required for accessing the database.

Replace "pwd" with the password of the DB2 UDB administrator.

IPAddress

IP address or hostname of the DB2 UDB server.

Replace "nete_server_ip" with the IP address or the hostname of the DB2 UDB server.

TcpPort

TCP port number of the DB2 UDB server.

Replace the default value of 50000 with the actual TCP port number of the DB2 UDB server.

Package

The name of the package to process dynamic SQL.

Replace "nete_package" with the name of the package you want to create.

PackageOwner

(Optional) The AuthID assigned to the package.

Empty by default. This DB2 AuthID must have authority to execute all SQLs in the package.

GrantAuthid

The AuthID granted execute privileges for the package.

"PUBLIC" by default. Specify the desired AuthID if you wish to restrict the execute privileges for the package.

GrantExecute

Specifies whether to grant execute privileges to the AuthID listed in GrantAuthid.

Can be either 1 or 0. Set to 0 by default.

IsolationLevel

The method by which locks are acquired and released by the system.

CURSOR_STABILITY by default.

DynamicSections

The number of statements that the DB2 Wire Protocol driver package can prepare for a single user.

100 by default. Enter the desired number of statements.


Copyright © 2010 CA. All rights reserved. Email CA about this topic