Re: Anyone know what this means?

[jpcarr@xxxxxxxxxxxx]

Brad

Not sure but I think it would be something to do with the fact that the SQL
work area's for the job get created and never closed for days.

What activation group is the SQL running in?       The server instance is
the same job work area for days.   I don't know the exact reason but that
is why ending the instance and starting it clears it up.   You get a new
"PAG"  so to speak.

Something akin to having a job run for days and the program message queue
fills up.      You might have to run the stuff in a named activation group
and every so often do a ENDACTGRP   to clean things up and start over.

Is the top program that you call (The target of the URL)  an SQL program?
If you have one SQL program call another SQL program,  some internal work
area's get created during the first SQL program in the stack and don't get
cleared out until the top most SQL program ends (With *INLR   *ON).

How does this sound?

John Carr

--------------------------------

I have an e-RPG program running that does a dynamic SQL.  After a couple
days of running, it stops and gives this:

Space offset X'00FFF000' or teraspace offset X'0000000000000000' is
  outside current limit for object OCLIST.
SQL system error.

It does this for a while, then changes to this:
Pointer not set for location referenced.
SQL system error.

Any ideas?  Just wondering.  I'm on hold with IBM tech right now.  :)  This
happens on two machines that I've worked with.  Ending and restarting the
HTTP server instance fixes the problem.

Brad

+---
| 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
+---