Report Server Configuration for ESP WORKLOAD AUTOMATION
Article ID: 22095
Updated On:
Products
Issue/Introduction
Clarification on parameters when configuring Report Server for DB2:
To use DB2 on mainframe, the "-DISPLAY DDF" output is important to get the proper values.
Example:
DSNL080I !D91A DSNLTDDF DISPLAY DDF REPORT FOLLOWS:
DSNL081I STATUS=STARTDDSNL082I LOCATION LUNAME GENERICLUDSNL083I
DDD1APTIB A01.D91ADB2 -NONEDSNL084I TCPPORT=#### SECPORT=#### RESPORT=#### IPNAME=-NONEDSNL085I IPADDR=###.###.##.##
DSNL086I SQL DOMAIN=<Your domain> DSNL099I DSNLTDDF DISPLAY DDF REPORT COMPLETE
The DDD1APTIB (value under LOCATION) should be specified on RServerDbName; port #### (value after TCPPORT) should be specified on RServerDbPort.
The user specified on RServerDbUser, together with password, is used to connect to database by report server through JDBC call. It should have authority to connect, create/update tables.
This user and password should be defined by PASSWORD command in Report Server DB, with type RSERVER. (user and password, and type are all case sensitive)
RServerPort is to specify the listening port of the Report Server STC, which is used to receive requests from Report Server;
ESP_JDBC_PATH=<your path directory> is mandatory for DB2 JDBC file location on distributed platform and mainframe, the USS path specified on this parm should contain: <jar filename>
Environment
Component: ESP WORKLOAD AUTOMATION
Release: 12.0
Resolution
In the Installation and Configuration Guide, under "Configure Report Server", you will find very detailed information.
Feedback
