RMACCESS
This table holds user information (one for each RMServer entry). It is not designed to hold multiple users for any given server.
| Column Name | Data Type | Attribute |
|---|---|---|
| ACC_USERID | SMALLINT | NOT Null |
| ACC_USERNAME | VARCHAR(32) | NOT Null |
| ACC_PASSWORD | [DB2] CHAR(128) FOR BIT DATA, [DB2 OS/400] GRAPHIC(200) CCSID 13488, [CSP] BIT VARYING(2048), [SQLSERVER] BINARY(1024), [ORACLE] RAW(128) | NOT Null |
| ACC_PUBLIC_KEY | [DB2] VARCHAR(3800) FOR BIT DATA, [CSP] BIT VARYING(60800), [SQLSERVER] VARBINARY(3800), [ORACLE] RAW(2000) | NOT Null WITH DEFAULT '', |
- Primary Key
- (ACC_USERID)
- Indexes
- None
- Referential Constraints
- None
Column Definitions
- ACC_USERID
- An ID number for reference from the RMServer table. The next highest number is always used for inserts.
- ACC_USERNAME
- A user name.
- ACC_PASSWORD
- If necessary, this password field can be updated with
an unencrypted password. Each server has its own key, and the key
is automatically encrypted the first time it is used.
If the key is lost, you can reset it by clearing the text in cmbcmenv.properties and in acc_password for all the rows in the RMACCESS table. When you restart the resource manager, the password is encrypted again and a new key is generated.
- ACC_PUBLIC_KEY
- Meant to hold a X509 certificate. Used to hold the prekey parts for the library server Token. Also used to hold the encrypted pass phrase for TSM encryption.