KD2_PFnn_EX_D2EXOBJ
DB2 EXPLAIN objects owner
- Description
-
Specify the AUTH ID of the OMEGAMON XE for DB2 PE started task.
- Required or optional
- Optional (Required in case KD2_PF_EX_D2EXACT is set to Y)
- Default value
- DB2PM
- Locations where the parameter value is stored
-
- Location 1
- In the EXBDssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
OWNER (<value>) +
- Location 2
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSPLAN TO <value>;
- Location 3
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSSTMT TO <value>;
- Location 4
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSTABLES TO <value>;
- Location 5
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSPACKSTMT TO <value>;
- Location 6
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSINDEXES TO <value>;
- Location 7
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSTABLEPART TO <value>;
- Location 8
- In the EXC8ssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
SET CURRENT SQLID = '<value>';
- Location 9
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSINDEXPART TO <value>;
- Location 10
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSPACKAGE TO <value>;
- Location 11
- In the EXGPssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON TABLE <value>..DGO_SYSDBRM TO %exuser%;
- Location 12
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT CREATETS ON DATABASE <KD2_PFnn_EX_D2EXDB> TO <value>;
- Location 13
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSTABLESPACE TO <value>;
- Location 14
- In the EXGPssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT INSERT ON TABLE <value>..DGO_SYSPACKAGE TO %exuser%;
- Location 15
- In the EXCQssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
SET CURRENT SQLID = '<value>';
- Location 16
- In the EXC0ssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
SET CURRENT SQLID = '<value>';
- Location 17
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSKEYS TO <value>;
- Location 18
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSINDEXSTATS TO <value>;
- Location 19
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSPACKDEP TO <value>;
- Location 20
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSTABSTATS TO <value>;
- Location 21
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSCOLUMNS TO <value>;
- Location 22
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT CREATETAB ON DATABASE <KD2_PFnn_EX_D2EXDB> TO <value>;
- Location 23
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT PACKADM ON COLLECTION KO2EX510 TO <value>;
- Location 24
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT USE OF STOGROUP SYSDEFLT TO <value>;
- Location 25
- In the EXCVssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
SET CURRENT SQLID = '<value>';
- Location 26
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSDATABASE TO <value>;
- Location 27
- In the EXDVssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
SET CURRENT SQLID = '<value>';
- Location 28
- In the EXGPssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON TABLE <value>..DGO_SYSPACKAGE TO %exuser%;
- Location 29
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSCOLDIST TO <value>;
- Location 30
- In the EXCTssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
SET CURRENT SQLID = '<value>';
- Location 31
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSFIELDS TO <value>;
- Location 32
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSDBRM TO <value>;
- Location 33
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSSYNONYMS TO <value>;
- Location 34
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT SELECT ON SYSIBM.SYSPACKLIST TO <value>;
- Location 35
- In the EXGPssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT INSERT ON TABLE <value>..DGO_SYSDBRM TO %exuser%;
- Location 36
- In the EXBPssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
OWNER (<value>) +
- Location 37
- In the EXGRssid member of the rhilev.midlev.rtename.RKD2SAM library
- Output line
-
GRANT BINDADD TO <value>;
- In the Configuration Tool (ICAT)
-
- Panel name
- DB2 Explain
- Panel ID
- KD261P4
- Panel field
- Owner of EXPLAIN objects
- Default value
- DB2PM
- Batch parameter name
- KD2_PF_EX_D2EXOBJ
- PARMGEN name
- KD2_PFnn_EX_D2EXOBJ
- PARMGEN classification
- EXPLAIN