Previous Topic: JDK Parameter

Next Topic: CA Datacom Parameters


DB2 Parameters

Your DB2 database administrator provides the values of these parameters, as they perform the tasks in Implementing DB2 with ReportCenter.

Item

Description and Use

ReportCenter DB2 Database Table Qualifier

The table qualifier chosen when the ReportCenter DB2 database was created, using the WRDB2CRE job. This name is needed to customize the ReportCenter SQL statements. The ReportCenter Java Task uses this name to qualify all table names in all SQL statements.

Default: None

My Details:

DB2 Load Library Data Set Names

The data set names of the DB2 SDSNEXIT, SDSNLOAD, and SDSNLOD2 load libraries. These load libraries contain executable code used by DB2 JDBC. They are used to set the STEPLIB environment variable for the ReportCenter Java Task.

Example:

SYS3.DB2810.SDSNEXIT

SYS3.DB2810.SDSNLOAD

SYS3.DB2810.SDSNLOD2

My Details:

 

 

 

DB2 JDBC Class File Directory or File Name

The HFS path name of the zip file (Legacy Driver) or directory (Universal Driver) that contains the DB2 JDBC Java classes.

This is included in the CLASSPATH specification for the ReportCenter Java Task.

Example:

/usr/lpp/db2/db2710/classes/db2j2classes.zip (Legacy Driver)

/usr/lpp/db2/db2810/classes (Universal Driver)

/usr/lpp/db2/db2910/classes

My Details:

 

 

 

DB2 JDBC DLL Directory Name

The HFS directory path name of your DB2 JDBC DLL Directory. This is included in the LIBPATH and LD_LIBRARY_PATH environment variable for the ReportCenter Java Task.

Example: /usr/lpp/db2/db2810/lib

My Details:

DB2 JDBC Properties File Name

The HFS path name of your DB2 JDBC properties file. This is used to set the DB2SQLJPROPERTIES environment variable for the ReportCenter Java Task.

Example: /usr/lpp/db2/db2810/classes/db2sqljjdbc.properties

My Details: