× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Chris,

I ran a test update from iSeries Nav, updating 2700 records, without 
problems.

Changed these same 2700 records back to the original value using 
QuantumDB, no dumps.

Then I issued an update statement for 16000 records from iNav, and the 
dump started around record 6000.

Any other suggestions?

Thanks,

Peter Colpaert
Application Developer
PLI - IT - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----
----- Forwarded by Peter Colpaert/Misc/BE/massive on 26/04/2006 13:58 
-----

Peter.Colpaert@xxxxxxxxx 
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
26/04/2006 13:10
Please respond to
Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>


To
Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>
cc

Subject
Re: [WDSCI-L] Strange error/dumps when using QuantumDB






Chris,

QUSER also has *NOMAX as storage limit:

User profile . . . . . . . . . . . . . . . :   QUSER 
 
Current library  . . . . . . . . . . . . . :   *CRTDFT 
Initial program  . . . . . . . . . . . . . :   *NONE 
  Library  . . . . . . . . . . . . . . . . : 
Initial menu . . . . . . . . . . . . . . . :   MAIN 
  Library  . . . . . . . . . . . . . . . . :     *LIBL 
Limit capabilities . . . . . . . . . . . . :   *NO 
Text . . . . . . . . . . . . . . . . . . . :   Work Station User 
 
Display sign-on information  . . . . . . . :   *SYSVAL 
Limit device sessions  . . . . . . . . . . :   *SYSVAL 
Keyboard buffering . . . . . . . . . . . . :   *SYSVAL 
Storage information: 
  Maximum storage allowed  . . . . . . . . :   *NOMAX 
  Storage used . . . . . . . . . . . . . . :   16620 
  Storage used on independent ASP  . . . . :   *NO 


I haven't had the nerve to try and run the SQL from iSeries Nav, but I'll 
give it a go on our development box, where I have the same problem as on 
our production box.

By the way, my project leader muttered something about "those darned 
trigger programs of yours", but I guess that, if the update works OK from 
5250 STRSQL, it's probably not a trigger problem, right?

Anyway, I'll try running the update from iSeries Nav and report back.

Thanks,
Peter Colpaert
Application Developer
PLI - IT - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----



"Price, Chris" <Chris.Price@xxxxxxxxxxxxx> 
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
26/04/2006 13:04
Please respond to
Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>


To
Websphere Development Studio Client for iSeries <wdsci-l@xxxxxxxxxxxx>
cc

Subject
Re: [WDSCI-L] Strange error/dumps when using QuantumDB






Peter,

Does the QUSER profile have the storage limits?

Have you tried running the SQL from a different remote client, such as
iSeries Navigator, and if so do you have the same problem? If so it's more
likely a problem with the Toolbox driver than the plugin.

Chris.

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-2024 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.