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
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.