Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How do I define a DB2 plan for a web servcie in CICS?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 77
Location: United States

PostPosted: Sat Apr 14, 2018 1:58 am    Post subject: How do I define a DB2 plan for a web servcie in CICS?
Reply with quote

I have looked all over and got no answers. The tech support staff I have to deal with don't know, either. I am introducing CICS web services to this environment... nothing like being a pioneer!

CICS has DB2TRAN and DB2ENTRY definitions to relate a DB2 plan to a CICS transaction. But, a web service provider has no CICS transaction. The only thing I can think of is to create DB2TRAN/DB2ENTRY definitions for the CICS SOAP listener transaction and that doesn't seem right.

Has anyone else run across this?
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8378
Location: Dubuque, Iowa, USA

PostPosted: Sat Apr 14, 2018 2:20 am    Post subject:
Reply with quote

Start by reading CICS and web services since you've got a lot of learning to do. You will not define DB2TRAN / DB2ENTRY definitions for the SOAP listener transaction -- you follow the procedure in the manual to define message handlers, header processing programs, and so forth. If you're going to be using DB2, you define it like any other CICS resource since it will be used in CICS not in the web.

There is also a Redbook for Application Development for IBM CICS Web Services (SG24-7126).
Back to top
View user's profile Send private message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 77
Location: United States

PostPosted: Wed Apr 18, 2018 1:55 am    Post subject:
Reply with quote

I have looked in every manual I could find and every redbook as well. I found no mention of DB2 with regard to web services. So, if you have any more specific clues I'd be glad to follow them. I have been writing CICS web service providers for years. I just never had to define the connection to DB2 before. Somebody else had already done that. But, there is no "somebody else" where I'm at now.
Back to top
View user's profile Send private message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 77
Location: United States

PostPosted: Wed Apr 18, 2018 2:41 am    Post subject:
Reply with quote

Hey Robert, I think I found something. Tell me if I'm right (or wrong). There is a default transaction ID (CPIH) in the web service URImap. I should be able to specify a unique transaction ID and add the DB2 Entry and DB2 Tran definitions to it.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8378
Location: Dubuque, Iowa, USA

PostPosted: Wed Apr 18, 2018 2:51 am    Post subject:
Reply with quote

It sounds like you're right but I've never dealt with DB2 combined with Web Services so I'm not sure.
Back to top
View user's profile Send private message
John Poulakos

New User


Joined: 13 Jun 2012
Posts: 77
Location: United States

PostPosted: Mon Apr 23, 2018 11:00 pm    Post subject: Reply to: How do I define a DB2 plan for a web servcie in CICS?
Reply with quote

In case anyone is interested, replace the CPIH default transaction in the web service URIMap with your transaction ID:

I UR
RESULT - OVERTYPE TO MODIFY
Urimap($604380)
Usage(Pipe)
Enablestatus( Enabled )
Analyzerstat(Noanalyzer)
Scheme(Http)
Redirecttype( None )
Tcpipservice()
Port()
Host(*)
Path(/ca1p/cjpdpTest)
Hosttype()
Ipresolved(0.0.0.0)
Ipfamily(Unknown)
Socketclose()
Sockpoolsize()
Transaction(WEB1)
Converter()
Program()

Then define a basic transaction and give it your web service program name:

I TR (WEB1)
STATUS: RESULTS - OVERTYPE TO MODIFY
Tra(WEB1) Pri( 001 ) Pro(CER04WS ) Tcl( DFHTCL00 ) Ena Sta
Prf(DFHCICST) Uda Bel Iso Bac Wai


Create a basic DB2Entry specifying the plan:

I DB2E (WEB1)
STATUS: RESULTS - OVERTYPE TO MODIFY
Db2e(WEB1 ) Use Ena Poo Hig Pro( 0000 ) Pth(0000)
Threadl( 0000 ) Threads(0000) Tpo Plan( CER04WS )

Last, create a DB2Tran:

I DB2T
RESULT - OVERTYPE TO MODIFY
Db2tran(WEB1)
Db2entry( WEB1 )
Transid( WEB1 )
Plan(CER04WS)

Note: it isn't fussy about the DB2Tran name.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts cics-dbctl connection and disconnection meykh2014 CICS 0 Sat Aug 18, 2018 5:38 pm
No new posts Send data from a CICS TS program to M... spiThingy CICS 2 Wed Aug 08, 2018 8:58 am
No new posts Error while initiation CICS program f... Ashishpanpaliya CICS 3 Mon Jul 16, 2018 5:12 pm
No new posts Usage/Utiliy of Plan in DB2 arijitS DB2 4 Thu Jun 21, 2018 8:16 pm
No new posts CICS startup problem John Poulakos CICS 3 Tue Jun 12, 2018 9:08 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us