MQ ADMIN ID(S) field
The MQ ADMIN ID(S) field specifies the MQ_ADMIN_ID setting for the DB2OPT option in job DSNTIJRT. The authorization IDs entered in this field are granted ALL privileges on the MQ tables SYSIBM.MQPOLICY_TABLE and SYSIBM.MQSERVICE_TABLE by DSNTIJRT/DSNTRIN.
| Acceptable values: | Blank or at least one valid authorization ID |
|---|---|
| Default: | Blank |
| Update: | option 7 on panel DSNTIPB |
| DSNZPxxx: | none |
- blank
- The DB2OPT MQ_ADMIN_ID option in job DSNTIJRT/DSNTRIN is set to DEFAULT. DSNTRIN grants ALL privileges on the Db2 MQ tables SYSIBM.MQPOLICY_TABLE and SYSIBM.MQSERVICE_TABLE to all the authorization IDs specified in the GRANTTO parameter of each Db2 MQ function configuration control statement. The result of this option matches the DSNTRIN behavior before APAR PH55025.
- authid-list
-
An authorization ID, or a list of comma-separated authorization IDs. The specified authorization IDs are granted ALL privileges on the Db2 MQ tables SYSIBM.MQPOLICY_TABLE and SYSIBM.MQSERVICE_TABLE, while all the authorization IDs specified in the GRANTTO parameter of each Db2 MQ function configuration control statement are granted only SELECT privilege on the two Db2 MQ tables.
Each authorization ID must conform to these rules:
- Maximum length of 44 characters
- First character must be A-Z or @, #, or $
- Remaining characters must be A-Z, 0-9, @, #, $, or _
If a list of authorization IDs is specified, it cannot have embedded blanks. Its length must not exceed 44 characters, including commas.
