Ansicht
Dokumentation

02741 - Dbif_rsql_sql_error HELP PLEASE!

02741 - Dbif_rsql_sql_error HELP PLEASE!

CL_GUI_FRONTEND_SERVICES - Frontend Services   General Data in Customer Master  
This documentation is copyright by SAP AG.
SAP E-Book

Dbif_rsql_sql_error HELP PLEASE!


Hi Crosby,

Our AS400 is on V4R5M0, actually we just upgrade our OS.
The PATCH level is 621. The current level for our OS is 690.
So I think we are current on the system. Eventhough we plan
to apply Hot Package next week.
There is message in the work process job log. There is no
message specifically in Qsysopr.
I forgot what the message was in the WP joblog. Let me find
that.

Regards,

Isa...




>From: "Crosby Sinclair" <csinclaiZt...>
>To: miracle21Zh...
>Subject: Re: Dbif_rsql_sql_error HELP PLEASE!
>Date: Mon, 23 Jul 2001 10:07:19 -0400
>
>Isabelle, welcome to the group. One of the first thing you should do is
>check to see what DATABASE PACK level you are on for the version on AS400
>OS you are running, also check the cum ptf level you are also at. If you
>are not on the lates you need to first apply these PTF and delete the SQL
>packages and IPL your system. If these SQL 913 does not stop then you need
>to contact SAP. Also one of the things you can do is check on the OS side
>if there are any message on QSYSOPR that would indicate you are having
>problem with your DATABASE.
>
>Crosby Sinclair
>SAP/AS400 System Administrator
>Thomson Industries Inc.
>Internet www.thomsonind.com
>E-mail csinclairZt...
>Phone (516) 944-1337
>Fax (516) 883-8012
>
> >>> "isa belle" <miracle21Zh...> 07/20 2:08 PM >>>
>
>
>
>Hi SAP Experts =)
>
>My name is Isabelle. Nice to get to know you all from this mailing list.
>Our company currently have this problem that I hope you could provide
>solutions/input.
>
>We have been getting this sort dump : DBIF_RSQL_SQL_ERROR
>SQL error "-913" occurred when accessing table "TSP02 "
>Database error text........: "Row or object TSP02 in R3P20DATA type *FILE
>in
>use. Job=461919/P2000/DISP. Record 4096 in use by workprocess w19 on
>USMOAS03_P20_00."
>
>There is an oss note that we pull out explaining about database locks on
>AS400. But we are not sure how to implement the fix.
>We added more Update Work Processes. It deceased the number of short dumps
>we get
>for a couple of weeks, when suddenly we get them back like about 20 sama
>short dumps
>a day.
>
>Have anyone experience this short dump before?
>
>Any input will be appreciated.
>Thanks.
>
>Cheers,
>
>Isa. =0)
>
>
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


Durban Tours - Südafrika Safari

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   ABAP Short Reference  
This documentation is copyright by SAP AG.

Length: 4012 Date: 20240602 Time: 171842     sap01-206 ( 3 ms )