CATALOG Creation From AppServer to DB2 In WCS STAG And PROD Environments

CATALOG Creation From AppServer to DB2  In WCS STAG And PROD Environments


1. CATALOG for AppServer to DB2 Database For Connecting From AppServer To DB2

db2 "CATALOG TCPIP NODE  NODENAME REMOTE 10.129.xx.xx SERVER 50001 REMOTE_INSTANCE pprdinst SYSTEM RFDRPPWCSCOM"
db2 "CATALOG DATABASE PPRDADB AS PPRDADB AT NODE RILANODE AUTHENTICATION SERVER"

• Catalog STAGE DB2 Database on Staging Search Server(10.129.xx.xx) as pprdinst




db2 "CATALOG TCPIP NODE RILANODE REMOTE 10.129.34.102 SERVER 50001 REMOTE_INSTANCE pprdinst SYSTEM RFDRPPWCSCOM"
db2 "CATALOG DATABASE PPRDADB AS PPRDADB AT NODE RILANODE AUTHENTICATION SERVER"


• Catalog DB2 Database on Production WCS and Search Server, Below Step only need to be performed on 10.129.xx.11, 10.129.xx.12, 10.129.xx.15, 10.129.xx.16 as rilpinst (DB2 Client instance User)

db2 catalog TCPIP NODE RILPNODE REMOTE 10.129.xx.xx SERVER 50001 REMOTE_INSTANCE rilpinst
db2 catalog db RILPDB as RILPDB at NODE RILPNODE

• Catalog PROD DB2 Database on Staging WCS Server(10.129.xx.xx) as rilpinst

db2 "CATALOG TCPIP NODE PRDNODE REMOTE 10.129.xx.xx SERVER 50001 REMOTE_INSTANCE rilpinst SYSTEM PRDWCSDB"
db2 "CATALOG DATABASE RILPDB AS RILPDB AT NODE PRDNODE AUTHENTICATION SERVER"
Production DB should be catalog on staging WCS Server for Staging Propagation