Re: Resource limit exceeded

[mandy.shaw@xxxxxxxxxxxxxxxxxxxxxxxxx]

I have never seen this, but three things that come to mind & that might
just be relevant are:
a) Have you 'byte-capped' the relevant user profile to limit its amount of
used auxiliary storage?
b) Have you limited the max. CPU time or max. temp storage on the relevant
*CLS?
c) If this relates to a complex SQL SELECT statement, s the Query Governor
coming into play (not even sure whether it *could*, but someone with better
knowledge of this area than me might be able to help)?
Worth a look in the QSYSOPR message queue, history log and/or relevant
QZDASOINIT joblog, if you haven't found these wanting already.
Mandy





"Nelson, Jim (RCIS)" <Jim.Nelson@RCIS-NET.COM> on 13/02/2001 15:49:53

Please respond to MIDRANGE-L@midrange.com

To:   "'MIDRANGE-L@midrange.com'" <MIDRANGE-L@midrange.com>
cc:    (bcc: Mandy Shaw/Pacific/UK)
Subject:  Resource limit exceeded





Our VB application that connects to the AS/400 via ODBC has a problem
printing.  Large print jobs (around 200 policies) receive the following
message:

Run-time error '146'.

S1000:(IBM)(Client Access Express ODBC Driver (32-bit))(DB2/400
SQL)SQL0904-
Resource limit exceeded.

Happens with client access and CA Express.  We've not found any
documentation on this problem, and do not know where to go next.  Has
anybody else had this problem?  We are on V4R3, going to V4R5 in 8 weeks...

It does not happen when we connect the application to our 'local' database
(SQLAnywhere) - the same print request that blows on the 400 works fine on
the local running from the same pc.

Thoughts?

Thanks, JN
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---



      Regards,
      Mandy Shaw

      Catalyst Solutions plc
      Kingfisher House
      Frimley Business Park
      Camberley
      Surrey
      GU16 5SG
      UK

      http://www.catalyst-solutions.com
      Email: Mandy.Shaw@uk.catalyst-solutions.com

      Telephone: +44 (0)870 166 1000
      DDI: +44 870 166 1324
      Facsimile: +44 870 168 3920
      Mobile: +44 410 447966





----------------------------------------------------------------------
----------------------------------------------------------------------
Catalyst Solutions plc.  Registered No 2918101.
Registered @ Kingfisher House, Frimley Business Park, Frimley,
Surrey. GU16 5SG   U.K.

NOTICE:
This message is intended only for the named addressee(s) and may
contain confidential and/or privileged information. If you are not the
named addressee you should not disseminate, copy or take any action
or place any reliance on it. If you have received this message in error
please notify postmaster@catalyst-solutions.com and delete the message
and any attachments accompanying it immediately.
----------------------------------------------------------------------


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---