Starting Your Product › Preparing to Start CA Gen › Preparing to Start Host Encyclopedia › DB2 Secondary Authorization IDs › TICEXBPL CLIST

TICEXBPL CLIST

TICEXBPL is invoked prior to a DB2 plan bind to allow you to:

• Change input parameters
• Suppress or replace the plan bind

The following ISPF variables are saved (VPUT) in the shared pool before the call to this exit. They are populated with the values passed to the bind if the exit does not change them. If the exit changes these variables, it uses the new values.

BPLFLAG Y=do the bind, N=suppress the bind
BPLSYS DB2 Subsystem where bind is to be done
BPLNAME Plan name
BPLLIST Package list entries (if any)
BPLMEM0-20 DBRM member names (if any)
BPLLIBS DDNAMEs of the DBRM libraries
BPLISOL CS, RR, RS, UR
BPLVAL BIND, RUN
BPLREL COMMIT, DEALLOCATE

To use the input value of a variable, you must provide a VGET for it. To change a variable, you must provide a SET command and a VPUT for it. The CLIST delivered with the product has examples of the VGET and VPUT instructions, but they are commented out.

To suppress the bind entirely, change BPLFLAG to N. To replace the bind with your own, change BPLFLAG to N and add your own bind to the exit. See CLIST TICINSTX for an example of a plan bind.