Cataloging a Db2 database in the DataStage runtime container
Last updated: Mar 12, 2025
Catalog a Db2 database to use database scripts in your before-job and after-job subroutines.
About this task
Procedure
Was the topic helpful?
0/1000
Confirm
Do you want to log out?
Catalog a Db2 database to use database scripts in your before-job and after-job subroutines.
pod=`oc get pods | grep -i ds-px-default | grep -i px-runtime|grep -i Running | awk '{print $1}'`
echo $pod
oc rsh $pod
DB2INSTANCE
to
dsuser
. export DB2INSTANCE=dsuser
db2
to go to the db2-prompt. cd /home/dsuser/sqllib/bin ; ./db2 ;
Syntax:
CATALOG TCPIP NODE db2CatalogName REMOTE REMOTE-DB2-HOSTNAME SERVER DB2-PORT
Example:
CATALOG TCPIP NODE myDB2 REMOTE YAWLS1.FYRE.IBM.COM SERVER 50000
Syntax:
CATALOG DATABASE databaseName AT NODE db2CatalogName AUTHENTICATION SERVER
Example:
CATALOG DATABASE SAMPLE AT NODE myDB2 AUTHENTICATION SERVER
/home/dsuser/sqllib/db2
). Syntax:
CONNECT TO SAMPLE USER db2User USING db2Password
Example:
CONNECT TO SAMPLE USER db2inst1 USING db2inst1