Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: need help on cics xctl

    i need some help on this cics program issue.

    i have program a and program b . here what iam doing is iam
    doing an xctl from program a to b. when access goes into program
    and executing an sql its looking at the plan of A.Also in cedf what i
    obserrved was its showing me tranid of program A. cAN SOME ONE
    help me on this issue


  2. #2
    Join Date
    May 2003
    The only way to do plan switching in CICS is to do a CICS start on tran B. Obviously that is not a good idea (for reasons we will not discuss here).

    That is why packages were developed starting in DB2 version 3. You use packages for all your CICS programs in an application and make sure they all belong to the same plan. Obviously, not every CICS program package for the entire shop should be in the same plan (such as when other applications exist). Any time you do need to switch plans, you just start that tranid, instead of xctl.

    You should look at the RCT tables and find out more information about the DB2 CICS attach in the manuals.
    Last edited by Marcus_A; 02-25-04 at 11:24.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts