Database Cataloging

After finish the node cataloging, you can catalog the database. Map the database underground the server instances to the client in the way of alias.

Basic Steps

Method One: Command Method

The same with the method of node catalog, you can catalog the database through following three command mode.

  • Mode One: The Command Window with non-interactive mode

    Input db2cmd on Run to enter the command window of DB2; You can also enter the command window through Program -> IBM DB2 -> DB2COPY1-> Command Line Tools.

    Input the database catalog command in the command window:

    Copy
         
	db2 catalog db db_name as db_alias at node node_name
    • db_name: Input the database name to catalog. You can input the letters only or the combination of letters and figures. The letters are case-insensitive and doesn't support the special character.
    • db_alias: Input the database catalog to the alias used by the client.
    • node_name: Input the node name that the sever to catalog belongs to.

    If catalog the node successfully, the following contents are shown in command window.

  • Mode Two: The Command Line Processor with interactive mode

    The same with mode one, enter the command line processor through Program -> IBM DB2 -> DB2COPY1 -> Command Line Tools. Input the database catalog command in this processor:

    Copy
         
	catalog db db_name as db_alias at node node_name
    • db_name: Input the database name to catalog. You can input the letters only or the combination of letters and figures. The letters are case-insensitive and doesn't support the special character.
    • db_alias: Input the database catalog to the alias used by the client.
    • node_name: Input the node name that the sever to catalog belongs to.

    Compared to the Command Window, the commands in "Command Line Processor" only lack db2 key word.

    If catalog the database successfully, the following contents are shown in command line processor.

  • Mode Three: The Command Editor with visualization and interactive mode

    The same with mode one, enter the command line processor through Program -> IBM DB2 -> DB2COPY1 -> Command Line Tools. Input the database catalog command in this processor; You can also open this window through Control Center and Open with: Program -> IBM DB2 -> DB2COPY1 -> General Administration Tools -> Control Center.

    Input the node catalog command in the command editor window and the command format is the same as mode two. Then click the button to execute the command; Or you can select the selected item -> execute. The command result is shown in the window below. If something goes wrong, it will give the error info. If the result catalog successfully, the following contents are shown in the command editor.

Interface Execution Method

Right click the database under the server instances, and select the Add. Set the database name, alias etc. in the pop-up Add Database dialog box. The database name can be searched through the Discover button, as shown below. Click OK to finish the mapping from database to the client.


After establish the database catalog between database under the server instances and the client through the method above, you can view the catalog result in the Control Center. Right click the Control Center node of the directory tree, and select the Refresh item. The result is shown as below. You can see that the server has already connected with the client.

Related Topics

Database Anti-cataloging