This command stores database location information in the system database directory. The database can be located either on the local workstation or on a remote database partition server.

The DB2 CATALOG DATABASE command syntax is as follows:

catalog database [ Database-name ] as [ Alias ] at node [ Node-name ] 
authentication [ Authentication-type ] 

db2 catalog database db2wasa at node wasa-host authentication dcs with 
"catalog the local db2wasa with dcs authentication type"

DB2 CATALOG DATABASE takes the following parameters:

Database-name

Specifies the name of the database to catalog.

Alias

Specifies an alias as an alternate name for the database being cataloged. If an alias is not specified, the database manager uses database-name as the alias.

Node-name

Specifies the name of the database partition server where the database being cataloged resides. This name should match the name of an entry in the node directory. If the node name specified does not exist in the node directory, a warning is returned, but the database is cataloged in the system database directory. The node name should be cataloged in the node directory if a connection to the cataloged database is desired.

Authentication-type

The authentication value is stored for remote databases (it appears in the output from the LIST DATABASE DIRECTORY command) but it is not stored for local databases