Thread: DB2

SQLCODE -805 after recompile for Xpediter - wrong subsystem?

Started by Lisa • user4 replies206 viewsLast activity 2 weeks ago
Post #1
0 votes
Lisa
Reputation
96
Posts: 17
Joined: Jun 20, 2025, 1:40 PM
Posted: Jul 29, 2026, 1:31 PM

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?

Post #2
1 votes
Elena
Reputation
391
Posts: 19
Joined: Apr 18, 2024, 9:30 AM
Posted: Jul 29, 2026, 2:31 PM

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.

Post #3
0 votes
Lisa
Reputation
96
Posts: 17
Joined: Jun 20, 2025, 1:40 PM
Posted: Jul 29, 2026, 7:31 PM

Yep, wrong SSID on the BIND. Fixed. Leaving the thread up because I almost deleted it as "never mind."

Post #4
0 votes
Sandra
Reputation
198
Posts: 17
Joined: Oct 15, 2024, 8:30 AM
Posted: Jul 30, 2026, 3:31 PM

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