Fw: Strange error/dumps when using QuantumDB

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.