Saturday, November 29, 2008

Catalog mainframe server/subsystem/database

Many a times we need to catalogue the mainframe DB2 to be accessed from Command Line Processor.
Here are the syntax through which you can catalog the mainframe db2 subsystem.
CATALOG TCPIP NODE ZOS1 REMOTE MAINFRAME SERVER 800 OSTYPE MVS
CATALOG DB DSN1 AS DSN1 AT NODE ZOS1 AUTHENTICATION SERVER
CATALOG DCS DB DSN1 AS DB2DSN1

After this you can logon by providing userid and password:
db2 connect to dsn1 user USR01 using password01

Cheers..
Prakash
IBM Certified DB2 DBA

No comments: