Solution : https://service.sap.com/sap/support/notes/507824 (SAP Service marketplace login required)
Summary :
Post upgrading to DB2 version 7 or higher, users may experience multiple issues including problems referenced by the stored procedure DSNACCOR in the system log (SM21), outdated or erroneous data in CCMS Monitor Set (RZ20), missing objects for suggested jobs in DBA Planning Calendar (DB13), and a lack of data under "Tablespaces without backup" in the Overview of Backup Status (DB12). The DB2 upgrade requires the installation of DSNACCOR as per provided guidelines. Once installed, DSNACCOR leverages Real Time Statistics (RTS) to efficiently recommend database maintenance actions based on a sophisticated analysis of data changes and utility requirements. This approach also extends monitoring capabilities across non-SAP and multiple SAP systems, helping manage DB2 instances more effectively. The installation also prompts enhancements in SAP transactions like RZ20 and DB12, which utilize advanced UI elements for displaying data.
Key words :
terms db2 mvs os390 abap cc/390 v7 stored procedure dsnaccor sm21 ccms monitorrz20 collecting bootstrap hourly daily 5 minutes db13 reorg suggestedrunstats needing db12 reason, pq57785 uq63023 incorrout stored procedure dsnaccor -------------------------------------------------------------------, pq46859 uq60879 add stored procedure, dsnurfit x'+9f3e' running reorg, pq57857 uq63172 abend04e rc00c200d8 dsnb1pmt, pq63014 uq68157 dsnaccor returns sqlcode -802, stored procedure named dsnaccor, pq57750 uq63225 abend0c4 dsnisegd +1622 running, collecting bootstrap nodes found, exception error fixed point overflow -------------------------------------------------------------------
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 |
| 593469 | DB2/390: Usage of global TEMP tables and related problems |
| 551104 | DB2/390: SAPLS_CCDSNU_DB2 terminates due to a timeout |
| 496904 | Performance notes database parameters FS-AM for DB2 z/OS |
| 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 |
| 324739 | DB2 z/OS: CCMS transport for 4.6D |
| 217093 | DB2 z/OS: CCMS transports for 4.6C |
| 132424 | DB2-z/OS: Optimizing access to the TRFC Tables |
| 116698 | DB2/390: Optimizing Access to Tables VBHDR, VBMOD, VBDATA |
| 113008 | DB2/390: Maintaining Catalog Statistics |
| 101217 | DB2 z/OS: Overview of transports and corrections |
| 83335 | DB2/390: Deadlocks, bad performance on cluster tables |
| 13719 | Preliminary transports to customers (note for customers) |