none
Invoking CICS program using Biztalk through HIS RRS feed

  • Question

  • Hi,

    We have a requirement for DB2 (z-os 7.1x) bulk update using BizTalk server with the help of HIS. we have tried using DB2 adapter and few more approaches with limited performance benifits. Right now the idea is to call a CICS program from BizTalk server 2009 to update the DB2 data base.

    Can some one throw some light towards this direction? any documentation to achieve the requirement with samples would be really greatful.


    Thanks & Regards, Hari
    • Moved by Ben Cline1 Thursday, September 22, 2011 2:29 AM related to HIS (From:BizTalk Server General)
    Wednesday, September 21, 2011 11:20 AM

Answers

All replies

  • You can post this on http://social.technet.microsoft.com/Forums/en-US/biztalkhis/threads

    Unfortunately I can't move it. 

    If you are going to use the Transaction Integrator then you refer this article on msdn 

    How to Run TI Over TCP/IP

     


    Regards,
    Bali
    MCTS: BizTalk Server 2010,BizTalk Server 2006 and WCF
    Blog: http://dpsbali-biztalkweblog.blogspot.com
    -----------------------------------------------------
    Mark As Answer or Vote As Helpful if this helps.
    • Edited by DPS Bali Wednesday, September 21, 2011 12:06 PM Added link
    Wednesday, September 21, 2011 11:58 AM
  • There may be 2 ways to call a CICS program, the 1st is via HIS Transaction Integrator and if your version of CICS supports exposing CICS transaction as a web service that would be the other way.

    Transaction Integrator is fairly straight forward and there are good tutorials in the HIS documentation.  I did a POC a couple of year ago with it and it only took a day or so to get it running.


    Bill Chesnut | BizTalk Server MVP | Mexia Consulting | Melbourne Australia
    http://www.biztalkbill.com
    Please indicate "Mark as Answer" if this post has answered the question.
    Monday, October 3, 2011 12:40 PM
  • Hi,

    I cannot understand why your DB2 request is bad in performance. The best you can do is to avoid the CICS overhead is to write a DB2 Stored Procedure in C or COBOL (native DB2 SQL stored procedures will be available in DB2v9/v10).

    Here's a good white paper how to set up the CICS connection from HIS / Biztalk : http://download.microsoft.com/download/7/A/A/7AA24543-58A2-49BA-BE6E-2842EEDAD5F2/HIS2009_RevGuide.pdf

    This document will help you to set up your enterprise extender in order to connect to your mainframe / cics if you are going to use ipdlc : http://www.microsoft.com/downloads/details.aspx?familyid=86d6011a-3396-4c36-b4b1-af7f4d80a099&displaylang=en&tm

    There are several ways to connect to the mainframe : sna/ip or SOAP

    Best Regards,


    Steve Melan - BCEE My Blog : http://stevemelan.wordpress.com
    Monday, October 3, 2011 7:16 PM