Add program works when I transact straight to it. Driver does XCTL into the same program and the INSERT gets -805.
Plan name matches the program name. Why would XCTL change anything?
XCTL itself is fine. Usually the driver's DB2ENTRY / plan setup differs, or the called program's package is not in the plan the thread is using.
Check which plan the thread actually has under CEDF (auth and plan on the SQL display). Bind the DBRM into that plan/collection, not just a plan that happens to share the program name.
Also compare PKLIST on both paths. Dynamic plan switching surprises people.
You must be signed in to reply to this thread