Solution : https://service.sap.com/sap/support/notes/388676 (SAP Service marketplace login required)
Summary :
SAP Note addresses issues with Run Control Center Stored Procedures on OS/390, affecting DB2 on MVS environments, identified through CLI interface CEE dumps. The resolution involves sequence-specific imports referenced in Note 101217 per R/3 Release. Requirements entail DB2 V6.1 Putlevel 0009, DB2 APAR PQ36585, kernel patch 46D or onwards, and essential CCMS Transports (e.g., D6AK000107, D6DK000137). Necessary SQL GRANT permissions on multiple DSNACC and SYSIBM tables are specified. Periodic note review advised for continuous updates. Implementation includes procedural GRANT commands executed using Spufi to maintain system stability and effectiveness.
Key words :
additional key words db2 mvs os390 abap cc/390 stored procedures, symptom run control center stored procedures, cc/390 stored procedures run smoothly, planning calendar rebuild index, d6ak000107 related collective transport, d6dk000137 related collective transport, kddk000098 related collective transport, dsnutils stored procedures, db2 apar pq36585, prerequisites cli interface
Related Notes :
| 776547 | DB2/zOS: DB13 upload with stored procedure DSNACCDS |
| 765983 | DB2/zOS: Reducing number of DSNACCOR REORG recommendations |
| 717935 | DB2/zOS: FTP replacement by Stored Procedures |
| 507824 | DB2/390 V7: Real Time Statistics and DSNACCOR |
| 324739 | DB2 z/OS: CCMS transport for 4.6D |
| 217093 | DB2 z/OS: CCMS transports for 4.6C |
| 13719 | Preliminary transports to customers (note for customers) |