Unix authentication with LDAP authorization is not supported at this time, so it only makes sense to do this if you are using Unix authorization.
To set up support for both authentication mechamisms, change the following fields in DB2:
Table | Field | Old | New | Where | |
|
|
|
|
| |
server | NUM_AUTH_MECHS | 1 | 2 | desc_name = 'SSM | |
|
|
|
| System Manager' | |
server | AUTHN_MECHS1_MECHANISM | 0 | 2 | ||
| |||||
|
|
|
|
| |
server | AUTHN_MECHS1_AUTH_TYPE_KE |
|
|
| |
| Y | 0 | 1 |
| |
serverinterface |
|
|
| server_id = (select | |
AUTHN_MECH_SET_NUM_MECHS | 1 | 2 | server_id from server | ||
s |
|
|
| where desc_name = | |
|
|
|
| 'SSM System | |
|
|
|
| ||
serverinterface |
|
|
| Manager') and | |
AUTHN_MECH_SET_MECHS1 | 0 | 2 | descriptive_name = | ||
s |
|
|
| 'Administrative | |
|
|
|
| Client Interface' | |
|
|
|
|
|
This can be accomplished using the db2 interactive utility. Here's a sample session showing the commands to use. You'll need to be logged in to Unix as user 'hpss' to have the needed permissions on the database.
$ db2 |
|
(c) Copyright IBM Corporation 1993,2002 | |
Command Line Processor for DB2 SDK 8.2.5 | |
... |
|
For more detailed help, refer to the Online Reference Manual. | |
db2 => connect to hcfg |
|
Database Connection Information | |
Database server | = DB2/LINUX 8.2.5 |
SQL authorization ID | = HPSS |
Local database alias | = HCFG |
db2 => set schema hpss |
|
db2 => select num_auth_mechs, authn_mechs1_mechanism, | |
authn_mechs1_auth_type_key | |
from server where desc_name = 'SSM System Manager' | |
NUM_AUTH_MECHS AUTHN_MECHS1_MECHANISM AUTHN_MECHS1_AUTH_TYPE_KEY | ||
1 | 0 | 0 |
1 record(s) selected.
db2 => select authn_mech_set_num_mechs, authn_mech_set_mechs1 from
HPSS Installation Guide | July 2008 |
Release 6.2 (Revision 2.0) | 176 |
