Ansicht
Dokumentation

05040 - How often do you have to delete SQL packages?

05040 - How often do you have to delete SQL packages?

rdisp/max_wprun_time - Maximum work process run time   Vendor Master (General Section)  
This documentation is copyright by SAP AG.
SAP E-Book

How often do you have to delete SQL packages?

Charlie,

You can look up the description of SQL errors in QSYS/QSQLMSG. The message
ID for the errors you have listed would be SQL0443, SQL0615 and SQL0303.

From the SQL reference manual: "Every SQLCODE has a corresponding message in
message file QSQLMSG in library QSYS. The message ID for any SQLCODE is
constructed by appending the absolute value (5 digits) of the SQLCODE to SQ
and changing the third character to 'L' if the third character is a 0. For
example, if the SQLCODE is 30070, the message ID is SQ30070."

Regards,
Stan


-----Original Message-----
From: Charlie Kil [mailto:chkil_2000Zy...]
Sent: Tuesday, 12 February, 2002 7:29 AM
To: DoNotReply@consolut.eu
Subject: How often do you have to delete SQL packages?


Hello,

I have a question for you guys.
We are having Database error -443, -615 and -303 on our BW development
system(ASCII).
Deleting SQL packages resolved the problem but it occurred after a couple of
days again.

I have couple of questions at this point.

1. How often should I delete SQL packages?

2. What are those errors, Database error 443, 615 and 303?
The system log did not give much information and I could not find any
related
documents.

If any of you had this kind of experience, please drop me a note.
Thanks so much.

Best regards
Charlie


Durban Tours - Südafrika Safari

BAL Application Log Documentation   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 2099 Date: 20240302 Time: 145457     sap01-206 ( 3 ms )