Solution : https://service.sap.com/sap/support/notes/540158 (Connexion à SAP Service Marketplace requise)
Résumé :
When performing a client or remote client copy in SAP, the process may terminate unexpectedly due to an SQL error -901. This occurs when the DB2/400 system exhausts its limit of 32767 SQL packages generated within a work process, triggered by the intensive creation of SQL packages during extensive table copying. An interim solution involves restarting the affected work process or the instance and initiating the client copy anew, ensuring only necessary SQL packages are created. For prevention, it's recommended to distribute the client copy workload across multiple processes or apply specific SAP Notes designed to enhance SQL package management and minimize their proliferation.
Mots Clés :
urb log by4=> sql error -901 performing pre, /400 client copy sql0901 sa95563 package sqlpkg reason, r3<sid>32000c package, log by0=> sql-systemfehler, job=018434/<user>/wp00 [dbtran 6991 ], work process job log, remote client copy terminates, 03 2002c error => error -901, r3<sid>data/, table viea03 [dbtran 6991 ]
Notes associées :
| 541311 | CC-INFO: Parallel processes FAQ |
| 517589 | iSeries: Client copy performance |
| 212727 | CC-INFO: FAQs for parallel processes up to Release 4.6D |
| 63037 | AS/400: Deleting SQL Packages |