DB2 Version 9.7 for Linux, UNIX, and Windows

Extending the directory schema for Active Directory

Before the DB2® database manager can store information in the Active Directory, the directory schema needs to be extended to include the new DB2 database object classes and attributes. The process of adding new object classes and attributes to the directory schema is called schema extension.

About this task

You must extend the schema for Active Directory by running the DB2 Schema Installation program, db2schex. You should run this command before installing DB2 products and creating databases, otherwise you have to manually register the node and catalog the databases.

The db2schex program is included on the product CD-ROM in the following location: x:\db2\windows\utilities\ where x: is the DVD drive letter.

To update the schema, you must be a member of the Schema Administrators group or have been delegated the rights to update the schema. Run the following command on any machine that is part of the Windows domain:

   runas /user:MyDomain\Administrator x:\db2\Windows\utilities\db2schex.exe

where x: represents the DVD drive letter.

If you have run the db2schex command in an earlier version of the DB2 database management system, when you run this same command again on DB2 UDB Version 8.2, or later, the following two optional attributes are added to the ibm-db2Database class:

   ibm-db2AltGwPtr
   ibm-db2NodePtr

If you have not run the db2schex command on an earlier version of the DB2 database management system on Windows, when you run this same command on DB2 Version 9.7, or later, all the classes and attributes for DB2 database system LDAP support are added.

There are other optional clauses associated with this command. For more information, refer to the "db2schex - Active Directory schema extension command" topic.

Examples:

To install the DB2 database schema:
```
   db2schex
```

To install the DB2 database schema and specify a bind DN and password:

   db2schex -b "cn=A Name,dc=toronto1,dc=ibm,dc=com"
            -w password

Or,

   db2schex -b Administrator -w password

To uninstall the DB2 database schema:
```
   db2schex -u
```
To uninstall the DB2 database schema and ignore errors:
```
   db2schex -u -k 
```