Solution : https://service.sap.com/sap/support/notes/717935 (SAP Service marketplace login required)
Summary :
This SAP Note addresses issues encountered in SysLog SM21 and z/OS system logs related to stored procedures. Common errors include non-existent procedures, failures in creating TEMP databases, tablespaces, or exception tables, and issues executing procedures. Additionally, RACF messages indicate insufficient access authority and uncontrolled environments due to program activities. These problems stem mainly from not upgrading or improperly installing stored procedures after migrating to DB2 V8, or from enabling 'Execution via Stored Procedures' in earlier DB2 versions without proper setup. Solutions suggested involve referring to the SAP DBA Guide for DB2 z/OS to check the configuration of stored procedures and WLM environments, with specific procedures for submitting utilities and JCL jobs ensuring appropriate code page conversions. Parallel utility execution and DB2 command submission procedures enhance SAP system efficiency by facilitating multiple operations and reducing external dependencies.
Key words :
/os zos abap cc/390 stored procedure dsnaccmo dsnaccds dsnaccdr dsnaccdd dsnaccde dsnaccdl dsnaccjs dsnaccjf dsnaccjp dsnaccjq dsnaccuc dsnutils dsnaccss dsnaccmd ftp jes jcl job submission replacement ich408 ich408i ich420 ich420i bpxp014 bpxp014i reason, db2 version db2 server base fmid cc/390 enablement fmid 6 hdb6610 jdb661d 7 hdb7710 jdb771d 8 hdb8810 jdb881d 2, dsnx9wlm dsnx9spa dsnarrs dsn3id00 dsnx9wls dsnaccjs dsnaccjp dsnaccjq dsnaccjf dsnaccuc dsnaccss dsnaccsi dsnutils, pq84480 uq87177 enhance stored procedures ------------------------------------------------------------------- ------------------------------------------------------------------- db2 v7 apar ptf description, db13 db02 refresh dsnaccjs/jq/jf/jp db2, dsnutils db13 submit single utility dsnaccmo db13 submit, pq67703 uq76358 activate data set management stored procedures, st04 query db2 subsystem id dsnaccdl db02, pq48086 uq56632 dsnaccmd truncates thread token, pq50056 uq56630 dsnaccmd truncates thread token
Related Notes :
| 843808 | DB2-z/OS: functionality of db2radm |
| 765983 | DB2/zOS: Reducing number of DSNACCOR REORG recommendations |
| 731937 | DB2-z/OS: Customizing DB2 Connect for WebAS 6.20 and DB2 V8 |
| 593469 | DB2/390: Usage of global TEMP tables and related problems |
| 507824 | DB2/390 V7: Real Time Statistics and DSNACCOR |
| 457512 | DB2-z/OS: DB2 V7 Features |
| 427748 | DB2-z/OS: CCMS corrections (6.10, 6.20, 6.40, 7.x) |
| 388676 | DB2/390: CC/390 stored procedures corrections |
| 81737 | DB2-z/OS: APAR List |