We currently connect to DB2 z/OS using DB2 Connector stage. we are planning to setup a new environment and replicate the same settings.
Can someone clarify before starting with the new env:
1) Do we need a DB2 client to be installed as well? How does the DB2 Connector stage connect to external database?
From IBM Knowlege center,
Currently i could see we haveThe DB2 connector connects to your databases using the DB2 client on the DataStage nodes. The connector requires that each database be cataloged in the DB2 client.
DB2_SERVER_EDITION 10.5.0.8 8 DB2 Server Edition
and the databases are catalogued.
Code: Select all
db2 => list db directory
System Database Directory
Number of entries in the directory = 12
Database 1 entry:
Database alias =<>
Database name =<>
Node name = <>
Database release level = 10.00
Comment =
Directory entry type = Remote
Authentication = SERVER
Catalog database partition number = -1
Alternate server hostname =
Alternate server port number =
2) Is it a runtime client or will just a DB2 driver suffice?
Does the DB2 connection to DataStage use tcp protocol?
Code: Select all
db2 => get dbm cfg
Database Manager Configuration
Node type = Client
Database manager configuration release level = 0x1000
Federated Database System Support (FEDERATED) = NO
Transaction processor monitor name (TP_MON_NAME) =