Re: SQL Dumps

Hi Tom

Did you carry out the SQL 'tweaks' as defined by SSA

Check these out:

http://www-912.ibm.com/n_dir/nas4apar.NSF/51d11a683a56a5cc862564c000763b23/f1914289734d926e8625719c003c6f97?OpenDocument
                                                                            
 www.redbooks.ibm.com/redbooks/pdfs/sg245410.pdf                            
                                                                            




Cheers
ML
------------------------------------------------------------------------


                                                                           
             "Molyneux, Tom"                                               
             <TMolyneux@mono-p                                             
             umps.com>                                                  To 
             Sent by:                  <bpcs-l@xxxxxxxxxxxx>               
             bpcs-l-bounces+ma                                          cc 
             rk.lindley=vonrol                                             
             l.com@xxxxxxxxxxx                                     Subject 
             m                         [BPCS-L] SQL Dumps                  
                                                                           
                                                                           
             21/11/2006 10:27                                              
                                                                           
                                                                           
             Please respond to                                             
              SSA's BPCS ERP                                               
                  System                                                   
             <bpcs-l@midrange.                                             
                   com>                                                    
                                                                           
                                                                           




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

--

This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: mark.lindley@xxxxxxxxxxx