SQL Dumps are not inconsequential and should definitely not be ignored.
They represent a system error in SQL processing which means some type of
BPCS-program access to your database was done incorrectly. It can
represent a serious error in data processing and if for example, some
cursor is not being executed correctly, and BPCS continues to process
the transaction, you can end up with bad data in your database. This
cursor issue was an actual problem on V5R4 which some of the PTFs listed
on the Info APAR do correct and it did result in data errors in BPCS in
certain long running batch processes.

Please read the Info APAR for BPCS which Davide Roveda mentioned
earlier, and apply all the related PTFs. But very importantly - if these
do not resolve the issue, open a PMR with IBM support and contact Infor
support about the issue as well so that we can track the outcome. 

The way the Informational APAR for BPCS gets updated is through our
support center notifying IBM support liaison of an issue/PTF related to
the operating system which affects our customers. 

Thank you,

Genyphyr Novak | Senior Systems Software Engineer, ERP LX Architecture  

-----Original Message-----
From: bpcs-l-bounces+genyphyr.novak=ssaglobal.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+genyphyr.novak=ssaglobal.com@xxxxxxxxxxxx] On
Behalf Of bpcs-l-request@xxxxxxxxxxxx
Sent: 21 November 2006 19:00
To: bpcs-l@xxxxxxxxxxxx
Subject: BPCS-L Digest, Vol 4, Issue 254

Send BPCS-L mailing list submissions to

To subscribe or unsubscribe via the World Wide Web, visit
or, via email, send a message with subject or body 'help' to

You can reach the person managing the list at

When replying, please edit your Subject line so it is more specific than
"Re: Contents of BPCS-L digest..."

*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

   1. SQL Dumps (Molyneux, Tom)
   2. Re: SQL Dumps (Davide Roveda)
   3. Re: SQL Dumps (Mark.Lindley@xxxxxxxxxxx)


message: 1
date: Tue, 21 Nov 2006 10:27:09 -0000
from: "Molyneux, Tom" <TMolyneux@xxxxxxxxxxxxxx>
subject: [BPCS-L] SQL Dumps

We are on BPCS version V6.00.04 and have recently upgraded from an
AS/400 at V4R5 to a System i5 at V5R4. Since the upgrade I notice that
quite a few BPCS jobs are generating some kind of SQL dump - file =
QSQLSRV and it seems to be a CPYF to print for a "User Trace Dump for
job ........"

I assume this is due to some differences in SQL between the different
operating systems, am I right?

There doesn't seem to be any reference to anything very serious in the
dumps, but I'm not very au fait with SQL - is it anything to worry about
and if not is there anything I can do to stop these dumps generating.

Thanks in advance for any advice.

Tom Molyneux

National Oilwell Varco
Mono Pumps Limited
MIS Department

Tel.      0161 214 2142
Fax.     0161 214 2344
E:mail  Tom.Molyneux@xxxxxxx

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.