Catalog is a database connecting process form the client to the server on local or remote. The purpose is to get the catalog information, namely generate the catalog used to assess the database. The system database catalog contains a list and a pointer. You can find the known database through the catalog no matter on local or remote. If there is no catalog info, the application can not connect to the database, so it should catalog before use the DB2.
Catalog includes the following two processes:- Map the server to the client, namely the catalog node.
- Map the database under the server instances to the client, namely the catalog database.
You can execute the DB2 catalog operation through both the command method and the Control Center interface. There are three edit command modes:
- The Command Window with non-interactive mode.
- The Command Line Processor with interactive mode.
- The Command Editor with visualization and interactive mode.
The following introduces the detail operation for the two processes.
Node Cataloging
Through the catalog node, the client machine can recognize the server machine, building the mapping from server to the client, which includes how to catalog and anti-catalog the nodes.
Database Cataloging
After finish cataloging node, it needs to catalog the database, which is used to map the database under the server instance to the client in the form of alias. Include two parts: database cataloging and database anti-cataloging.
Connect Database
After finish the node cataloging and database cataloging, connect the databases on server and the client.
Related Topics