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.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]