17.2.2.1 DB2 CATALOG
DB2 maintains a set of tables that contain information about the data that DB2 controls. These tables are collectively known as the catalog.
The catalog tables contain information about DB2 objects such as tables, views, and indexes. When you create, alter, or drop an object, DB2 inserts, updates, or deletes rows of the catalog that describe the object.
The DB2 catalog consists of tables of data about everything defined to the DB2 system, including table spaces, indexes, tables, copies of table spaces and indexes, and storage groups. The system database DSNDB06 contains the DB2 catalog.
Before starting this step, you need to check:
- Whether the DB2 server on mainframe is started, and TCP/IP communication is up or not.
- Assign an unused TCP port for the DB2 instance listener and add it into your local configuration "/etc/services" like this:
db2c_db2art 60000/tcp
Next, use CATALOG TCP/IP NODE
, CATALOG DCS DATABASE
and CATALOG DATABASE
step by step to finish the connection setup.