Home > Archive > Cobol > January 2008 > External Stored Proc Limitations?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
External Stored Proc Limitations?
|
|
| pompeyocatindig@gmail.com 2008-01-07, 9:56 pm |
| Hi. I was wondering if anyone out here knows if there is a limit to
the size of an external stored procedure? I am currently using VB
programs in Windows to call small COBOL stored procs residing in AIX
without any problems. This time, however, I am planning to have
another VB program call a COBOL stored proc that, in turn, calls other
COBOL programs via ordinary COBOL CALLs.
Any ideas?
Simon? I'm hoping you're still around to help since you were the one
who managed to solved my first problem.
Thanks in advance.
| |
| Pete Dashwood 2008-01-07, 9:56 pm |
|
<pompeyocatindig@gmail.com> wrote in message
news:47a70348-76aa-4016-9318-443b48262193@c4g2000hsg.googlegroups.com...
> Hi. I was wondering if anyone out here knows if there is a limit to
> the size of an external stored procedure? I am currently using VB
> programs in Windows to call small COBOL stored procs residing in AIX
> without any problems. This time, however, I am planning to have
> another VB program call a COBOL stored proc that, in turn, calls other
> COBOL programs via ordinary COBOL CALLs.
>
> Any ideas?
>
> Simon? I'm hoping you're still around to help since you were the one
> who managed to solved my first problem.
>
> Thanks in advance.
I don't KNOW because I haven't done it (I HAVE done a bit of interlanguage
programming, recently with VB and COBOL) but I would not expect any limit
other than the normal ones of resource availability (memory, disk space,
etc.). Once the COBOL run time is loaded it works just like the VB
runtime...
Pete.
--
"I used to write COBOL...now I can do anything."
| |
| Robert 2008-01-08, 3:55 am |
| On Mon, 7 Jan 2008 18:58:05 -0800 (PST), pompeyocatindig@gmail.com wrote:
>Hi. I was wondering if anyone out here knows if there is a limit to
>the size of an external stored procedure? I am currently using VB
>programs in Windows to call small COBOL stored procs residing in AIX
>without any problems. This time, however, I am planning to have
>another VB program call a COBOL stored proc that, in turn, calls other
>COBOL programs via ordinary COBOL CALLs.
>
>Any ideas?
If you're tallking about Oracle, the external procedure runs as a child of the listener.
Unless a system administrator put limits on that user, which is unlikely, you should be
good.
If you want to find out for sure, write a quickie external procedure that does a malloc
for, say, 100 meg. Or run svmon -P (listener pid) Or, if you can get to it, look at the
/etc/security/limits file.
| |
| pompeyoc 2008-01-09, 6:56 pm |
| On Jan 8, 2:22 pm, Robert <n...@e.mail> wrote:
> On Mon, 7 Jan 2008 18:58:05 -0800 (PST), pompeyocatin...@gmail.com wrote:
>
>
> If you're tallking about Oracle, the external procedure runs as a child of the listener.
> Unless a system administrator put limits on that user, which is unlikely, you should be
> good.
>
> If you want to find out for sure, write a quickie external procedure that does a malloc
> for, say, 100 meg. Or run svmon -P (listener pid) Or, if you can get to it, look at the
> /etc/security/limits file.
Thanks for answering so quickly, guys. Our connection at the office
has been down for the last couple of days so I'm actually doing this
from my home.
Pete, I guess my next question is, resources from which server? Since
the database resides in the AIX server, does this mean the stored
procedure will be using its resources?
Robert, though I forgot to mention that we are using DB2 (my bad), I
could still try your suggestions. Is svmon an AIX shell command? What
do I expect to find in the /etc/security/limits file?
| |
| Robert 2008-01-09, 6:56 pm |
| On Wed, 9 Jan 2008 07:01:27 -0800 (PST), pompeyoc <pompeyocatindig@gmail.com> wrote:
>On Jan 8, 2:22 pm, Robert <n...@e.mail> wrote:
>
>Thanks for answering so quickly, guys. Our connection at the office
>has been down for the last couple of days so I'm actually doing this
>from my home.
>
>Pete, I guess my next question is, resources from which server? Since
>the database resides in the AIX server, does this mean the stored
>procedure will be using its resources?
Yes. I don't know how DB2 launches external procedures, so don't know which userid they
run under. If it's important to know, read $USER in the procedure and return it to the
client process.
>Robert, though I forgot to mention that we are using DB2 (my bad), I
>could still try your suggestions. Is svmon an AIX shell command? What
>do I expect to find in the /etc/security/limits file?
Svmon is a program that comes with a Tivoli performance tuning tool, which may or may not
be installed. You run it from a shell, like any other executable.
The limits file is where memory limits are defined. There should be a global limit, which
will probably be unlimited, and there MAY be limits for users or groups. There may also be
a limit on the number of data segments per process.
| |
| Pete Dashwood 2008-01-10, 7:55 am |
|
"pompeyoc" <pompeyocatindig@gmail.com> wrote in message
news:460ccd8d-7078-4b2a-82aa-5a3eab0dc423@s12g2000prg.googlegroups.com...
> On Jan 8, 2:22 pm, Robert <n...@e.mail> wrote:
>
> Thanks for answering so quickly, guys. Our connection at the office
> has been down for the last couple of days so I'm actually doing this
> from my home.
>
> Pete, I guess my next question is, resources from which server? Since
> the database resides in the AIX server, does this mean the stored
> procedure will be using its resources?
Absolutely... unless the procedure contains RPC (Remote Procedure Calls) to
components and applications distributed around the Network, in which case
the resources of the server(s) where each component resides will be used.
Pete.
--
"I used to write COBOL...now I can do anything."
| |
| Simon Tobias 2008-01-11, 7:55 am |
|
> Hi. I was wondering if anyone out here knows if there is a limit to
> the size of an external stored procedure? I am currently using VB
> programs in Windows to call small COBOL stored procs residing in AIX
> without any problems. This time, however, I am planning to have
> another VB program call a COBOL stored proc that, in turn, calls other
> COBOL programs via ordinary COBOL CALLs.
>
> Any ideas?
>
> Simon? I'm hoping you're still around to help since you were the one
> who managed to solved my first problem.
>
> Thanks in advance.
>
DB2 stored procedures run under the auspices of the server, rather than client-side.
By default, they're executed as setuid apps under the 'fenced' ID specified
at instance creation time.
IBM DB2 doc covers limits on the number of parameters you can use, stored
procedure name, number of nested levels. Search for "SQL Limits" within the
Information Center for DB2. As for the maximum application size permissible,
I guess that this *may* be limited by the ulimit settings on the machine,
memory available.
This isn't an area of DB2 which I'm totally familiar with, however, so you
may be best of talking to IBM. I see that you also posted on comp.databases.ibm-db2
, and that Serge has responded (he really knows his stuff from what I've
seen from his posts!), so you may now need to check the AIX configuration
(ulimit etc.).
SimonT.
|
|
|
|
|