Solution : https://service.sap.com/sap/support/notes/765983 (SAP Service marketplace login required)
Summary :
Users of DB2 on z/OS V7 and higher may experience extensive reorganization of tablespaces when executing "Online reorg on suggested tablespaces," as instructed by SAP Note 507824. This extensive activity can disrupt the operational workload. The reorganization recommendation by stored procedure DSNACCOR does not consider the tablespace size, leading to unnecessary reorganization for smaller tablespaces without performance loss. New thresholds in DSNACCOR reduce undue reorg recommendations by considering the absolute number of modified rows and the number of active pages, improving system efficiency without compromising SAP function. Configurations can be adjusted via transaction ST04 or DB2 under "DB Alert Settings."
Key words :
terms db2 mvs os390 abap cc/390 v7 stored procedure dsnaccor sm21 ccms monitor rz20 collecting bootstrap hourly daily 5 minutes db13 reorg suggested runstats needing db12 v8 reason, prerequisites stored procedure dsnaccor recommends tablespaces, stored procedure dsnaccor, /os v7 utility guide, suggested tablespaces, employ db2, installed real time statistics, advisory reorg status, thresholds dsnaccor, call transaction st04
Related Notes :
| 776547 | DB2/zOS: DB13 upload with stored procedure DSNACCDS |
| 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 |
| 507824 | DB2/390 V7: Real Time Statistics and DSNACCOR |
| 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) |