Re: SQL Dumps

Hi, 

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
        bpcs-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/bpcs-l
or, via email, send a message with subject or body 'help' to
        bpcs-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
        bpcs-l-owner@xxxxxxxxxxxx

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
            tmolyneux@xxxxxxxxxxxxxx