For DB2: In the ini file, the URL for DB2/os390 is something like jdbc:db2:db_name, where can we obtain the db_name?

For DB2: In the ini file, the URL for DB2/os390 is something like jdbc:db2:db_name, where can we obtain the db_name?

book

Article ID: KB0085333

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

Resolution:
Usually this information comes from in-house DB2 system administrator. You can advise your client to go to the DB2 master log and look for the literal ‘LOCATION’. Once found, they should see something as follow:
DDF START COMPLETE
LOCATION  S390LOC <-==
LU    P390.P390LU
GENERICLU -NONE
DOMAIN    TRON.RV.TIBCO.COM
TCPPORT   446
RESPORT   5020
‘S390LOC’is what being named at TIBCO’s mainframe. You need to capture the value from your client-site and type it in the &ltdb_name> field in the ini file.

This value is also used to configure DB2 Connect.

Issue/Introduction

For DB2: In the ini file, the URL for DB2/os390 is something like jdbc:db2:db_name, where can we obtain the db_name?