Solution : https://service.sap.com/sap/support/notes/208919 (SAP Service marketplace login required)
Summary :
SAP Note addresses extended runtimes in transactions SCC5, SCCL, and SCC9, mostly when performed in non-empty clients or systems with fragmented or large tables. Issues linked to obsolete optimizer statistics and the DB2/390 optimizer choosing less efficient full table scans are also noted. To rectify these, it suggests corrections in various Support Packages depending on the transaction and issues specific patches for DB problems and change document copying inefficiencies. Additional measures include database reorganization, statistical updates, and utilizing parallel processes to improve transaction efficiencies.
Key words :
additional key words sccl, deleting individual critical tables, db2/390 mistakenly opts, full table scan, making local copies, sapkb46c01for remote copies, implement advance corrections 160732, sapdba export/import, copies larger blocks, advance corrections 262205 attached
Related Notes :
| 678942 | CC-ADMIN: Performance with buffered tables |
| 601196 | Client copy: Problems with report RCTXTCPY |
| 589886 | CC-ERROR: Performance with the remote SAPscript copying |
| 550226 | CC-ADMIN: Copying the Customizing takes a long time |
| 517589 | iSeries: Client copy performance |
| 365304 | CC-ADMIN: Reports for deleting tables |
| 212727 | CC-INFO: FAQs for parallel processes up to Release 4.6D |
| 180949 | CC-INFO: Change documents for a client copy |
| 161495 | CC-RELEASE: Error in client copy in 4.6A and 4.6B |
| 159316 | Reorganizing tables on SQL Server |
| 159171 | Recompilation of Stored Procedures |
| 155413 | Analysis of slow SQL statements |
| 113008 | DB2/390: Maintaining Catalog Statistics |
| 103747 | Performance: Parameter recommendations as of Release 4.0 |
| 96296 | CC-ERROR: Database problem in client copy |
| 70643 | CC-TOPIC: Client Deletion (SCC5) |
| 70290 | CC-INFO: Excluding tables with 'RSCCEXPT' |
| 67205 | CC-INFO: Copying large and productive clients |
| 31496 | CC-INFO: Client deleted by mistake |
| 22941 | Reorganization of tables and dbspaces! |
| 19466 | Downloading SAP kernel patches |
| 13719 | Preliminary transports to customers (note for customers) |