View previous topic :: View next topic |
Author |
Message |
rs_naveen Beginner
Joined: 29 Jul 2005 Posts: 18 Topics: 4
|
Posted: Sat Nov 05, 2005 3:34 am Post subject: DSNACICS Region dependent Parameters |
|
|
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 |
|
Back to top |
|
 |
rs_naveen Beginner
Joined: 29 Jul 2005 Posts: 18 Topics: 4
|
Posted: Sat Nov 05, 2005 7:53 am Post subject: |
|
|
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. |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Sun Nov 06, 2005 10:19 am Post subject: |
|
|
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 |
|
Back to top |
|
 |
rs_naveen Beginner
Joined: 29 Jul 2005 Posts: 18 Topics: 4
|
Posted: Mon Nov 07, 2005 12:37 am Post subject: |
|
|
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 |
|
Back to top |
|
 |
Manas Biswal Intermediate

Joined: 29 Nov 2002 Posts: 382 Topics: 27 Location: Chennai, India
|
Posted: Mon Nov 07, 2005 10:15 am Post subject: |
|
|
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) |
|
Back to top |
|
 |
rs_naveen Beginner
Joined: 29 Jul 2005 Posts: 18 Topics: 4
|
Posted: Tue Nov 08, 2005 7:32 am Post subject: |
|
|
Thanks Manas for the reply. |
|
Back to top |
|
 |
|
|