Filter
Top Products
account is defined, adding a domain user to the local Administrators group on the
server does not grant the domain user SYSADM authority to this group.
To avoid adding a domain user to the Administrators group at the domain
controller, create a global group and add the domain users to which you want to
grant SYSADM authority to it. Then update the DB2 configuration parameter
SYSADM_GROUP with the name of the global group.
To update the DB2 configuration parameter, enter the following commands:
db2 update dbm cfg using sysadm_group global_group
db2stop
db2start
Related concepts:
v “System administration authority (SYSADM)” in Administration Guide:
Implementation
Related reference:
v “sysadm_group - System administration authority group name configuration
parameter” in Performance Guide
Extending the directory schema (Windows)
If you plan to use the Lightweight Directory Access Protocol (LDAP) directory
server feature with Windows 2000 or Windows Server 2003, you should extend the
Active Directory schema to contain DB2 object classes and attribute definitions.
You should perform this task before you install any DB2 products.
Extending the directory schema ensures that:
v The default DB2 instance, created during the installation, is cataloged as a DB2
node in Active Directory provided the installation user ID had sufficient
privileges to write to Active Directory.
v Any databases that the user creates after installation will automatically be
cataloged into Active Directory.
If
you decide to install your DB2 product and create databases before you extend
the directory schema, you will have to manually register the node and catalog the
databases.
Prerequisites:
Your Windows user account must have Schema Administration authority.
Procedure:
To extend the directory schema:
1. Log onto the domain controller.
2. Run the db2schex.exe program from the installation CD with a user account
that has Schema Administration authority. You can run this program without
logging off and logging on again, as follows:
runas /user:MyDomain\Administrator x:\db2\Windows\utilities\db2schex.exe
where x: represents the CD drive letter.
10 Getting started with DB2 installation and administration