Recompiled an online DB2 program so I could debug under Xpediter. Bound DBRM to package, package to plan, NEWCOPY in CICS. First SQL = -805.
Thought I also needed to "refresh the plan." Turns out I may have bound against the batch test subsystem instead of the CICS one. Sound familiar?
Very familiar. -805 is "cannot find package/plan consistency token." Binding to the wrong DB2 subsystem is a classic way to get there.
Bind on the CICS test subsystem, NEWCOPY again, retry. Plan refresh is not a separate magic step beyond a correct BIND.
Yep, wrong SSID on the BIND. Fixed. Leaving the thread up because I almost deleted it as "never mind."
Keep it. Half the -805 tickets I see are wrong subsystem or forgot to bind after compile.
You must be signed in to reply to this thread