View previous topic :: View next topic
|
Author |
Message |
John Poulakos
Active User
Joined: 13 Jun 2012 Posts: 178 Location: United States
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
John Poulakos
Active User
Joined: 13 Jun 2012 Posts: 178 Location: United States
|
|
|
|
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 |
|
|
John Poulakos
Active User
Joined: 13 Jun 2012 Posts: 178 Location: United States
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
John Poulakos
Active User
Joined: 13 Jun 2012 Posts: 178 Location: United States
|
|
|
|
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 |
|
|
|