Prev: OT: Racial superiority / Intelligent design was Re: OT:Thanksgiving
Next: PowerCOBOL Drag and Drop
From: pompeyocatindig on 7 Jan 2008 21:58
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.
From: Pete Dashwood on 7 Jan 2008 22:27


<pompeyocatindig(a)gmail.com> wrote in message
news:47a70348-76aa-4016-9318-443b48262193(a)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."


From: Robert on 8 Jan 2008 01:22
On Mon, 7 Jan 2008 18:58:05 -0800 (PST), pompeyocatindig(a)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.
From: pompeyoc on 9 Jan 2008 10:01
On Jan 8, 2:22 pm, Robert <n...(a)e.mail> wrote:
> On Mon, 7 Jan 2008 18:58:05 -0800 (PST), pompeyocatin...(a)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.

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?
From: Robert on 9 Jan 2008 18:42
On Wed, 9 Jan 2008 07:01:27 -0800 (PST), pompeyoc <pompeyocatindig(a)gmail.com> wrote:

>On Jan 8, 2:22 pm, Robert <n...(a)e.mail> wrote:
>> On Mon, 7 Jan 2008 18:58:05 -0800 (PST), pompeyocatin...(a)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.
>
>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.
 |  Next  |  Last
Pages: 1 2
Prev: OT: Racial superiority / Intelligent design was Re: OT:Thanksgiving
Next: PowerCOBOL Drag and Drop