KD2_PFnn_SQLID
SQLID
- Description
-
Customize a different SQLID if other than the default USER in the following xKD2SAM DB2 Grant jobs:
- -
- EXGPssid
- -
- EXGRssid
- -
- OMGPssid: Grant DB2 privileges to each user ID that will work with the OMEGAMON Server
- -
- OMGRssid: Grant DB2 privileges on the DB2 subsystem to the OMEGAMON Collector plan/package owner that are necessary to administer the collector
- Required or optional
- Required
- Default value
- USER
- Locations where the parameter value is stored
-
- Location 1
- In the EXGPssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
SET CURRENT SQLID = <value>;
- Location 2
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
SET CURRENT SQLID = <value>;
- Location 3
- In the OMGPssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
SET CURRENT SQLID = <value>;
- Location 4
- In the OMGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
SET CURRENT SQLID = <value>;
- In the Configuration Tool (ICAT)
- This value cannot be updated using the Configuration Tool.
- Batch parameter name
- KD2_PF_SQLID
- PARMGEN name
- KD2_PFnn_SQLID
- PARMGEN classification
- OMPE