Query on DB2 plan packlist for indirectly called DB2 pgm

Soundar_Raja · New User Joined: 21 Aug 2013 Posts: 1 Location: India

Hi,

My program which is part of DB2 collection A is calling a program of collection B which in turn is calling a program in collection C.

My DB2 plan includes collections A and B only and not C in the PACKLIST.

This works in one test environment but not in another. My transaction is triggered through CICS.

Kindly suggest if this is based on any DB2 parameter.

Thanks
Soundar

agkshirsagar · Posted: Wed Aug 21, 2013 8:27 pm

I believe all three collections need to be part of your PLAN you are using to initiate your transaction. If it is working in test, then program C package must be part of your plan somhow.

One possibility could be that call chain is using DPL for program in collection C and the mirror transaction in remote region may be associated with a plan that contains collection C. See if this is happening in your case.