Information Catalog Manager Administration Guide
An information catalog can either be local (stored on your workstation) or
remote. If an information catalog is remote, you must register it and
the server where it resides.
If you previously connected to a database that resides on the server on
which your remote information catalog resides, you can skip this section and
continue with Registering a remote information catalog.
You can use the DB2 Control Center to register a server node.
Information catalog administrators or remote database administrators can use
the DB2 Control Center to complete the following tasks. See the DB2
Control Center online help for more details.
- Add a system
- Add an instance
- Add a database
After these tasks are completed in the DB2 Control Center, you can then
use the Information Catalog Manager Register New Information Catalog window to
complete the registration process. Make sure that you have:
- The node name of the remote server.
- The database name under which your information catalog is cataloged on the
remote server.
You can skip the next section and continue with Registering a remote information catalog.
If you previously connected to a database that resides on the server on
which your remote information catalog resides, you can skip this section and
continue with Registering a remote information catalog.
Table 8 describes the tasks that you or your remote database
administrator need to complete before registering a server node and
information catalog, if you do not use the DB2 Control Center.
Table 8. Preparing to register a server node and information catalog
| Task
| Who
|
| Remote database administrator
| You
|
|---|
Edit the appropriate protocol command file for your information catalog
users' environment. There are four protocol command files
available:
- DGNTBIOS uses NetBIOS protocol
- DGTCPIP uses TCP/IP protocol
- DGCPIC uses CPIC protocol
- DGIPXSPX uses IPX/SPX protocol
The command files in this list are provided as examples, but you are not
limited to those. If you change the command files or create new ones,
they must have a file extension of BAT and reside in the \SQLLIB\PROTOCOL
directory.
You must modify each file to add the node name where the remote information
catalog resides.
|
| X
|
| Ask your database administrator for the node name of the remote
server.
| X
| X
|
| Ask your database administrator for the database name under which your
information catalog is cataloged on the remote server.
| X
| X
|
To register a server node:
- Click Start --> Programs --> IBM DB2
--> Information Catalog Manager --> Register
Server Node and Information Catalog.
The Register Server Node and Information Catalog window opens.
- Click Register new server node, and click OK.
The Register New Server Node window opens.
- Select a command file that is appropriate for your environment. The
Contents of command file field displays the protocol and database
commands that establish the connection between the Information Catalog Manager
and the remote database where your information catalog is stored.
- Click Register.
- The Register Server Node and Information Catalog window remains
open. You can register other server nodes or information catalogs, or
click Cancel to close the window.
To register a remote information catalog:
- Click Start --> Programs --> IBM DB2
--> Information Catalog Manager --> Register
Server Node and Information Catalog.
The Register Server Node and Information Catalog window opens.
- Click Register new information catalog, and click
OK.
The Register New Information Catalog window opens.
- In the Information catalog name field, type the name the remote
catalog will have on your local workstation.
- In the Server information catalog name field, type the name the
information catalog has on the remote server.
- From the Server node ID list, click the server node or DB2 Connect gateway workstation where the remote information catalog is
located.
- Click Register.
The Connect to Information Catalog window opens.
- In the User ID field, type the user ID required by the database
that stores your information catalog:
- DB2 Universal Database for OS/2 (remote)
- LAN user ID, which is specified with UPM on the remote workstation
- DB2 Universal Database for OS/390
- RACF user ID
- DB2 Universal Database for AS/400
- AS/400 user ID
- DB2 Universal Database for AIX
- AIX user ID
- DB2 Universal Database for Enterprise - Extended Edition
- AIX, Solaris Operating Environment, or LAN user ID (depending on the
operating system)
- DB2 Universal Database for the Solaris Operating Environment
- Solaris Operating Environment user ID
- DB2 UDB for Windows NT or DB2 UDB for Windows 2000 (remote)
- LAN user ID, which is specified with User Manager on the remote
workstation
- In the Password field, type the password for the user ID that
you entered in the User ID field.
Passwords are case sensitive for accessing databases on the following
operating systems, you must type them exactly as specified:
- AIX
- Windows NT and Windows 2000
- Solaris Operating Environment
- Click Connect.
Your new catalog is defined, and two Information Catalog Manager program
icons are created for the Information Catalog Manager entry on the
Start menu. One icon represents administrator functions,
which you can use only if you have the information catalog administrator
function installed on your workstation. The other icon represents user
functions.
- The Register Server Node and Information Catalog window remains
open. You can register other server nodes or information catalogs, or
click Cancel to close the window.
[ Top of Page | Previous Page | Next Page ]