MVSFORUMS.com

[rs_naveen]

Hi,

I am invoking a CICS Program from a DB2 SP using DSNACICS call.
From the Cobol DB2 SP, we issue a SQL Call to DSNACICS.
For that, we need to give schema name of dsnacics in the SQL Call and also CICS Applid need to be passed to the DSNACICS.
EXEC SQL
CALL schema.DSNACICS(Parameters)
END-EXEC

As we will be working in different regions(Unit, System,UAT,Production),
how can we eliminate/minimize the region specific parameters(schema,CICS Applid).

I also tried using SYSPROC as schema,but it fails saying DSNACICS is not in APF authorized library. When I tried with the schema as TST, it worked.

Without hardcoding Schema and CICS Application Id, Is there any way to invoke DSNACICS from Cobol DB2 SP.

Regards
Naveen

[rs_naveen]

I am giving the MSG-AREA of DSNACICS Call without using Schema

DSNT530I DSNACICS COULD NOT RUN BECAUSE IT WAS NOT INVOKED FROM AN APF-AUTHORIZED LIBRARY

Sqlcode and Sqlstate are zeroes for SQL call statement.

[kolusu]

rs_naveen,

please do NOT post the same question in more than 1 forum. I have deleted your duplicate post in the DB2 forum.

DSNACICS needs to run in a WLM-established stored procedure address space. Although DSNACICS can run in an address space with other stored procedures, DSNACICS performs better if it runs in its own address space. Therefore, setting up a WLM application environment and startup procedure specifically for running DSNACICS is recommended.

After you set up the WLM application environment, you need to create a JCL startup procedure for the stored procedure address space. Installation job DSNTIJMV contains a sample startup procedure for a stored procedure address space for running DSNACICS called DSNCICS. When you run the installation or migration CLIST, DB2 customizes DSNTIJMV with data set names that you specify. Running DSNTJMV installs the startup procedure in your SYS1.PROCLIB data set. Use panel DSNTIPW to specify CICS data set names. You can specify the library that contains the load modules for the CICS EXCI interface in the CICS EXCI LIBRARY field of panel DSNTIPW. DSNACICS uses this library to connect to CICS and call CICS programs.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[rs_naveen]

Thanks Kolusu,

DSNACICS is in a different WLM environment currently, My doubt is, when I gave schema in SQL call statement,it worked; but without schema, it is giving the error mentioned earlier. How we can solve this problem?and why it gave error when I specified SQL call without schema?

Naveen

[Manas Biswal]

rs_naveen,

I have never used DSNACICS but from what I understand, it is a stored procedure that is used to run CICS TS programs. Now, for every stored procedure, you need to qualify it with a schema name. You can do that by hardcoding it on your SP call (like you did) or by specifying it on the "PATH" bind parameter for the SP package. The PATH bind parameter contains the qualifier for UDFs and stored procedures.
So, talk to your DBA and tell him to rebind the package for DSNACICS with the schema name that you need in the PATH bind parameter.

HTH...Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)

[rs_naveen]

Thanks Manas for the reply.