app.db.db2.Db2StoredProcedure
Db2 stored procedure is SUPPRESSED by default.
Attributes
| CDM attribute | Value | Example |
|---|---|---|
| Name | Name of the Db2 stored procedure | |
| RoutineType | User-defined function or cast function | |
| Origin | Origin of the routine for external or external SQL procedure | |
| SpecificName | Specific name of the routine | |
| ExternalName | The path/module/function that Db2 should load to execute the routine | |
| Collid | Name of the package collection to be used when the routine is executed | |
| Language | Implementation language of the routine |
Requirements for discovery
- Discover options DB2 and DB2.SQL are enabled.
- SET ENABLE_ZRDS is YES.
- Filtering is enabled. By default, Db2 stored procedure report is SUPPRESSED.
- Db2 subsystem and related address spaces must be active and fully initialized.
- The user ID that runs the DLA must have authority to execute SQL command.
CDM specific information
| CDM Naming Policy | app.db.db2.Db2StoredProcedure | |
| CDM Attribute | Value | Example |
| Label |
For DataSharing: name-data sharing group-sysplex For not shared: name-subsystem |
|
| id (IdML) | label-Db2StoredProcedure | |
| sourceToken (IdML) | label-Db2StoredProcedure | |
Naming rules
Name and contains relationship from sys.zOS.DB2DataSharingGroup or sys.zOS.DB2Subsystem (if there is no sys.zOS.DB2DataSharingGroup).
Relationships
| Link Type | Source | Target | Comment |
|---|---|---|---|
| contains | sys.zOS.DB2Subsystem and sys.zOS.DB2DataSharingGroup | app.db.Db2StoredProcedure |