Information Catalog Manager Administration Guide

Creating the information catalog

You can create an information catalog on any of these database management systems:

DB2 Universal Database for OS/2
You need to install the administration tools for DB2 UDB for OS/2.

DB2 Universal Database for OS/390
You must have the DB2 Connect product on your workstations to use DB2 UDB for OS/390.

DB2 Universal Database for AS/400
You must have the DB2 Connect product on your workstations to use DB2 UDB for AS/400.

DB2 Universal Database for AIX
You must have TCP/IP installed on your workstations to use DB2 UDB for AIX.

DB2 Universal Database for Enterprise - Extended Edition
If you plan to store your information catalog on DB2 UDB EEE, follow the instructions for the platform on which your information catalog database resides.

DB2 Universal Database for the Solaris Operating Environment
You must have TCP/IP installed on your workstations.

DB2 Universal Database for Windows NT and DB2 Universal Database for Windows 2000
You must have TCP/IP or NetBIOS installed on your workstations.

You can define your information catalog using the Information Catalog Manager user interface or from an MS-DOS(TM) command prompt. To define your information catalog from the user interface, use the information in this chapter. To define your information catalog from an MS-DOS command prompt, see Creating an information catalog from the command line.

Defining an information catalog on DB2 Universal Database for OS/2

Table 3 describes the tasks you need to complete before defining the Information Catalog Manager on DB2 UDB for OS/2.

Table 3. Preparing to define an information catalog on DB2 Universal Database for OS/2
Task Who
Remote database administrator You
Create the database in which the information catalog will be stored. X
Ensure that you have SYSADM authority to define the new information catalog. X

To define the information catalog:

  1. Click Start --> Programs --> IBM DB2 --> Information Catalog Manager --> Initialize Information Catalog.

    The Initialize Information Catalog window opens.

  2. From the Select type of information catalog list, click DB2 UDB for OS/2.
  3. Click OK.

    The Define Catalog on DB2 UDB for OS/2 window opens.

  4. In the Information catalog name field, type the alias name for the remote database that is cataloged on your local workstation.
  5. From the Not-applicable symbol list, click a character:
    1. Click on the down arrow to display a list of valid symbols.
    2. Click the symbol that you want to use from the list.
  6. In the Primary administrator's user ID field, type the user ID of the person who will be the primary administrator of the information catalog. This user ID must have SYSADM authority.
  7. In the Backup administrator's user ID field, type the user ID of the person who will back up the primary administrator.
  8. Select the Import common object types check box to populate your information catalog with object types that you can use to exchange metadata with other conforming products.
  9. Click Define.

    The Connect to Information Catalog window opens.

  10. In the User ID field, type the LAN user ID (which is specified with UPM on the remote workstation).
  11. In the Password field, type the password for the user ID that you entered in the User ID field.
  12. 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 component installed on your workstation. The other icon represents user functions.

If you receive an error message stating that the Information Catalog Manager could not import the common object types, you need to initialize your information catalog with the predefined object types (see page "Initializing your information catalog with the predefined object types"). Then you can add the object types to your new information catalog.

Defining an information catalog on DB2 Universal Database for OS/390

Table 4 describes the tasks you or your remote database administrator need to complete before defining an information catalog on DB2 for OS/390.

Table 4. Preparing to define an information catalog on DB2 for OS/390
Task Who
Remote database administrator You
Create the database in which the information catalog will be stored.

The Information Catalog Manager provides a sample JCL file that the database administrator can change to create the database, storage groups, and table spaces. The sample file is called DGCRTDB.JCL and resides in the \SQLLIB\BIN directory in the path where the DB2 Universal Database is installed.

X
Ensure that you have SYSADM authority to define the new information catalog. X
Ask your database administrator for the following names:
  • Database name
  • Storage group name for tables
  • Storage group name for indexes
X X

To define the information catalog:

  1. Click Start --> Programs --> IBM DB2 --> Information Catalog Manager --> Initialize Information Catalog.

    The Initialize Information Catalog window opens.

  2. From the Select type of information catalog list, click DB2 UDB for OS/390.
  3. Click OK.

    The Define Catalog on DB2 UDB for OS/390 window opens.

  4. In the Information catalog name field, type the alias name for the remote database that is cataloged on your local workstation.
  5. In the DB2 database name field, type the name of the DB2 database.
  6. In the Name of storage group for tables entry field, type the name of the storage group that you will use for tables.
  7. In the Name of storage group for indexes field, type the name of the storage group that you will use for indexes.
  8. From the Not-applicable symbol list, click a character:
    1. Click on the down arrow to display a list of valid symbols.
    2. Click the symbol that you want to use.
  9. In the Primary administrator's user ID field, type the user ID of the person who will be the primary administrator of the Information Catalog Manager. This user ID must have SYSADM authority on DB2 UDB for OS/390.
  10. In the Backup administrator's user ID field, type the user ID of the person who will back up the primary administrator.
  11. Optional: To save the property values of each object in uppercase, select the Save object values in uppercase check box. The values are stored in the DB2 UDB for OS/390 database in uppercase, but you can enter the values in lowercase when you search for them.
  12. Select the Import common object types check box to populate your information catalog with object types that you can use to exchange metadata with other conforming products.
  13. Click Define.

    The Connect to Information Catalog window opens.

  14. In the User ID field, type your RACF user ID.
  15. In the Password field, type the password for the user ID that you entered in the User ID field.
  16. 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.

If you receive an error message stating that the Information Catalog Manager could not import the common object types, you need to initialize your information catalog with the predefined object types (see page "Initializing your information catalog with the predefined object types"). Then you can add the object types to your new information catalog.

Defining an information catalog on DB2 Universal Database for AS/400

Table 5 describes the tasks that you or your remote database administrator need to complete before defining an information catalog on DB2 UDB for AS/400.

Table 5. Preparing to define an information catalog on DB2 Universal Database for AS/400
Task Who
Remote database administrator You
Create the database in which the information catalog will be stored. X
Ensure that you have ALLOBJ authority to define the new information catalog. X

To define the information catalog:

  1. Click Start --> Programs --> IBM DB2 --> Information Catalog Manager --> Initialize Information Catalog.

    The Initialize Information Catalog window opens.

  2. From the Select type of information catalog list, click DB2 UDB for AS/400.
  3. Click OK.

    The Define Catalog on DB2 UDB for AS/400 window opens.

  4. In the Information catalog name field, type the alias name of the remote database that is cataloged on your local workstation.
  5. From the Not-applicable symbol list, click a character:
    1. Click on the down arrow to display a list of valid symbols.
    2. Click the symbol that you want to use.
  6. In the Primary administrator's user ID field, type the user ID of the person who will be the primary administrator of the Information Catalog Manager.

    The user ID must have ALLOBJ authority on DB2 UDB for AS/400.

  7. In the Backup administrator's user ID field, type the user ID of the person who will back up the primary administrator.
  8. Select the Import common object types check box to populate your information catalog with object types that you can use to exchange metadata with other conforming products.
  9. Click Define.

    The Connect to Information Catalog window opens.

  10. In the User ID field, type your AS/400 user ID.
  11. In the Password field, type the password for the user ID you entered in the User ID field.
  12. 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.

If you receive an error message stating that the Information Catalog Manager could not import the common object types, you need to initialize your information catalog with the predefined object types (see page "Initializing your information catalog with the predefined object types"). Then you can add the object types to your new information catalog.

Defining an information catalog on UNIX(R) systems

Table 6 describes the tasks that you or your remote database administrator need to complete before defining the information catalog on DB2 UDB for AIX and DB2 UDB for the Solaris Operating Environment. These steps also apply to DB2 UDB EEE for AIX and DB2 UDB EEE for the Solaris Operating Environment.

Table 6. Preparing to define an information catalog on UNIX systems
Task Who
Remote database administrator You
Create or identify the database in which the information catalog will be stored. If the database is created on the remote host, the database administrator might want to specify an authentication level for database security reasons. X
Ensure that you have SYSADM authority to define the new information catalog. X
Ask your database administrator for the name of the database. X X
If you are defining a DB2 UDB EEE information catalog, enter the following SQL commands from the DB2 Command Line Processor: 
CREATE NODEGROUP FLG32K 
ON NODE number CREATE 
REGULAR TABLESPACE FLG32K 
IN NODEGROUP FLG32K 
MANAGED BY SYSTEM USING 
('FLG32K')
where number is the identifying number of the node. 		X

To define the information catalog:

  1. Click Start --> Programs --> IBM DB2 --> Information Catalog Manager --> Initialize Information Catalog.

    The Initialize Information Catalog window opens.

  2. From the Select type of information catalog list, click DB2 family.
  3. Click OK.

    The Define Catalog on DB2 Family Database window opens.

  4. In the Information catalog name field, type the alias name of the remote database that is cataloged on your local workstation.
  5. From the Not-applicable symbol list, click a character:
    1. Click on the down arrow to display a list of valid symbols.
    2. Click the symbol that you want to use.
  6. In the Primary administrator's user ID field, type the user ID of the person who will be the primary administrator of the Information Catalog Manager.

    This user ID must have SYSADM authority.

  7. In the Backup administrator's user ID field, type the user ID of the person who will back up the primary administrator.
  8. Select the Import common object types check box to populate your information catalog with object types that you can use to exchange metadata with other conforming products.
  9. Click Define.

    The Connect to Information Catalog window opens.

  10. In the User ID field, type your AIX user ID.
  11. In the Password field, type the password for the user ID you entered in the User ID field.

    Passwords are case-sensitive on UNIX operating systems; you must type them exactly as specified.

  12. 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.

If you receive an error message stating that the Information Catalog Manager could not import the common object types, you need to initialize your information catalog with the predefined object types (see page "Initializing your information catalog with the predefined object types"). Then you can add the object types to your new information catalog.

Defining an information catalog on DB2 Universal Database for Windows NT or DB2 Universal Database for Windows 2000

Table 7 describes the tasks that you or your remote database administrator need to complete before defining an information catalog on DB2 UDB for Windows NT or DB2 UDB for Windows 2000. These steps also apply to DB2 UDB EEE for Windows NT.

Table 7. Preparing to define an information catalog on DB2 Universal Database for Windows NT or DB2 Universal Database for Windows 2000
Task Who
Remote database administrator You
If you are defining a DB2 UDB EEE information catalog, enter the following SQL commands from the DB2 Command Line Processor: 
CREATE NODEGROUP FLG32K 
ON NODE number CREATE 
REGULAR TABLESPACE FLG32K 
IN NODEGROUP FLG32K 
MANAGED BY SYSTEM USING 
('FLG32K')
where number is the identifying number of the node. 		X
Create or identify the database in which the information catalog will be stored. If the database is created on the remote host, the database administrator might want to specify an authentication level for database security reasons. X
Ensure that you have administrator authority to define the new information catalog. X
Ask your database administrator for the name of the database. X X

To define the information catalog:

  1. Click Start --> Programs --> IBM DB2 --> Information Catalog Manager --> Initialize Information Catalog.

    The Initialize Information Catalog window opens.

  2. From the Select type of information catalog list, click DB2 UDB for Windows NT.
  3. Click OK.

    The Define Catalog on DB2 UDB for Windows NT window opens.

  4. In the Information catalog name field, type the name that you want to assign to the local information catalog or the alias name of the remote database that is cataloged on your local workstation.
  5. From the Not-applicable symbol list, click a character:
    1. Click on the down arrow to display a list of valid symbols.
    2. Click the symbol that you want to use.
  6. In the Primary administrator's user ID field, type the user ID of the person who will be the primary administrator of the Information Catalog Manager.

    This user ID must have SYSADM authority.

  7. In the Backup administrator's user ID field, type the user ID of the person who will back up the primary administrator.
  8. Select the Import common object types check box to populate your information catalog with object types that you can use to exchange metadata with other conforming products.
  9. Click Define.

    The Connect to Information Catalog window opens.

  10. In the User ID field, type the user ID required by the database that contains your information catalog:

    DB2 UDB for Windows NT (local)
    Windows NT(R) 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

    DB2 UDB for Windows 2000 (local)
    Windows 2000 user ID
  11. In the Password field, type the password for the user ID that you entered in the User ID field.

    Passwords on Windows systems are case-sensitive; you must type them exactly as specified.

  12. 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 installed on your workstation. The other icon represents user functions.

If you receive an error message stating that the Information Catalog Manager could not import the common object types, you need to initialize your information catalog with the predefined object types (see page "Initializing your information catalog with the predefined object types"). Then you can add the object types to your new information catalog.

Migrating a DataGuide Version 5.2 information catalog

You can migrate a DataGuide(R) 5.2 information catalog to a DB2 Universal Database Version 7.1 information catalog if the information catalog resides on the following database systems:

You cannot migrate information catalogs that reside on DB2 UDB for Windows 95 or DB2 UDB for Windows 98. However, you can connect remotely to them.

After you install either the DB2 Warehouse Manager or the DB2 OLAP Server with the Information Catalog Manager component, use the Initialize Information Catalog window to define the information catalog. The steps for defining an information catalog begin on page "Defining an information catalog on DB2 Universal Database for OS/2". Select the task that is appropriate for the database system on which your information catalog database resides.

[ Top of Page | Previous Page | Next Page ]