Command Reference

CATALOG GLOBAL DATABASE

Creates a system database directory entry of the DCE type. This entry is used to define a local alias of the fully qualified DCE directory object name of the target database. The information about that database is stored centrally in the DCE directory.

Authorization

One of the following:

• sysadm
• sysctrl

Required Connection

None

Command Syntax

>>-CATALOG GLOBAL--+-DATABASE-+---database-global-name---------->
                   '-DB-------'
 
>----AS--alias--USING DIRECTORY--DCE---------------------------->
 
>-----+-------------------------+------------------------------><
      '-WITH--"comment-string"--'
 

Command Parameters

DATABASE database-global-name

Specifies the fully qualified name that uniquely identifies the database in the DCE name space.

AS alias

Specifies an alternate name for the database being cataloged.

USING DIRECTORY DCE

Specifies the global directory service being used.

WITH "comment-string"

Describes the DCE type entry in the system database directory. Any comment that helps to describe the database cataloged in this directory can be entered. Maximum length is 30 characters. A carriage return or a line feed character is not permitted. The comment text must be enclosed by double quotation marks.

Examples

   db2 catalog global database /.../cell1/subsys/database/DB3
      as dbtest using directory dce

Usage Notes

The maximum length of database-global-name is 255 bytes. The name must begin with either /.../ or /.:/.

Note:

If directory caching is enabled (see the configuration parameter dir_cache in GET DATABASE MANAGER CONFIGURATION), database, node, and DCS directory files are cached in memory. An application's directory cache is created during its first directory lookup. Since the cache is only refreshed when the application modifies any of the directory files, directory changes made by other applications may not be effective until the application has restarted.

To refresh the CLP's directory cache, use TERMINATE. To refresh DB2's shared cache, stop (db2stop) and then restart (db2start) the database manager. To refresh the directory cache for another application, stop and then restart that application.