SAP Note 507824 - DB2/390 V7: Real Time Statistics and DSNACCOR

Composant : DB2 for z/OS -

Solution : https://service.sap.com/sap/support/notes/507824 (Connexion à SAP Service Marketplace requise)

Mots Clés :
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               -------------------------------------------------------------------

Notes associées :

776547DB2/zOS: DB13 upload with stored procedure DSNACCDS
765983DB2/zOS: Reducing number of DSNACCOR REORG recommendations
717935DB2/zOS: FTP replacement by Stored Procedures
593469DB2/390: Usage of global TEMP tables and related problems
551104DB2/390: SAPLS_CCDSNU_DB2 terminates due to a timeout
496904Performance notes database parameters FS-AM for DB2 z/OS
457512DB2-z/OS: DB2 V7 Features
427748DB2-z/OS: CCMS corrections (6.10, 6.20, 6.40, 7.x)
388676DB2/390: CC/390 stored procedures corrections
324739DB2 z/OS: CCMS transport for 4.6D
217093DB2 z/OS: CCMS transports for 4.6C
132424DB2-z/OS: Optimizing access to the TRFC Tables
116698DB2/390: Optimizing Access to Tables VBHDR, VBMOD, VBDATA
113008DB2/390: Maintaining Catalog Statistics
101217DB2 z/OS: Overview of transports and corrections
83335DB2/390: Deadlocks, bad performance on cluster tables
13719Preliminary transports to customers (note for customers)