DB2 Stored Procedures

Discussion created by ca.portal.admin on Sep 7, 2010
Latest reply on Sep 7, 2010 by ca.portal.admin
Does anbody out there access CA-IDMS using network DML from DB2 Stored
Procedures? I have been asked by the DB2 Developers how to do it and I
had to confess complete ignorance.

I (Partially) understand from the DB2 guys that there are 2 flavours of
Stored Procedure. One runs in the DB2BDBM1 address space and the other
in a WLM managed address space. I get the impression that the latter
woul dbe pretty much like a batch job as far as IDMS is concerned. I'm
not sure about the other one because it sounds more like a kind of CICS
to IDMS communication - a single address space running tasks for
multiple users.

Any info from people who have done it / failed to do it / partially done
it , would be most welcome.

Please explain any DB2 considerations using simple language because I am
in no way a DB2 expert.


Chris Trayler, IXD
Bank Julius Baer & Co. Ltd.
P. O. Box, CH-8010 Zürich, Switzerland
Telephone +41 (0)58 887 4332, Fax +41 (0)58 887 4969 <>

*****JuliusBaer Disclaimer***** This e-mail is for the intended
recipient only and may contain confidential or privileged information.
If you have received this e-mail by mistake, please contact us
immediately and completely delete it (and any attachments) and do not
forward it or inform any other person of its contents. If you send us
messages by e-mail, we take this as your authorization to correspond
with you by e-mail, however, we will not accept the electronic
transmission of orders/instructions without a specific agreement being
in place to govern the same. If you do not wish to receive any further
e-mail correspondence please let us know. E-mail transmission cannot be
guaranteed to be secure or error-free as information could be
intercepted, amended, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses. Neither the Julius Baer Group nor the
sender accept liability for any errors or omissions in the content of
this message which arise as a result of its e-mail transmission. Please
note that all e-mail communications to and from the Julius Baer Group
may be monitored. This communication is for informational purposes only.
It is not intended as an offer or solicitation for the purchase or sale
of any financial instrument or as an official confirmation of any
IDMS 3rd-party providers forum


Re: DB2 Stored Procedures
"From our DB2 guru:

Yep, you can call IDMS from a DB2 Stored Procedure. We use WLM SPs
written in COBOL. The
WLM address spaces are multi user environments and will connect to IDMS
like a batch job.
Have found had to limit the NUMTCBs because of memory issues.
We have had security issues with our home grown security routines but
you will probably
be fine with default security. Essentially, we connect to DB2 from
.net applications and
Call the SPs from there.
There is also an IBM supplied SP, DSNACICS, which allows you to call
CICS trans/programs.
We are using this now, new here, to circumvent the security problems we
have had.
The security problems:
UserA calls a SP -fails with subschema access denied
UserB calls a SP -works because has access.
UserA calls again and uses same, now inactive connection, they
work now because
have UserBs access.

Also found that the ACID of the WLM address space, had to have
all possible access that any user
could possibly have.
Because of this, we only allow public data to be allowed from the batch
like WLM address spaces.

We have CA's Top Secret and, as said before, have home grown routines
that are believed to be causing
this behavior. You may be fine. But it's worth testing. If you do
have security issues, consider