Re: Fw: Strange error/dumps when using QuantumDB

Not really - I haven't had the problem, just thought I'd try and help while
the Yanks are asleep!

I would guess the problem is either in the toolbox or in the way the iSeries
is handling the QZDASOINIT jobs, whichever is creating the user space.
Either way if you have a support contract it might be worth giving IBM a
call.

Chris.

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On
Behalf Of Peter.Colpaert@xxxxxxxxx
Sent: 26 April 2006 13:01
To: WDSCI-L@xxxxxxxxxxxx
Subject: [WDSCI-L] 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.