db2 bind java_db2 bind处理

PROG(DSNTIAD) PLAN(DSNTIAD)

LIBRARY('dbb1.runlib.load')

/*

*****************************************************************

4)db2相关联问答

Q4) Explain what a plan is?

A4) Plan is a DB2 object (produced during the bind process) that

associates one or more database request modules with a plan

name.

Q5) What is a DB2 bind?

A5) Bind is a process that builds “access paths” to DB2 tables.

A bind uses the Database Request Modules(s) (DBRM(s)) from the DB2

pre-compile step as input and produces an application plan. It also

checks the user’s authority and validates the SQL statements in the

DBRM(s).

Q2) What is an access path?

A2) The path that is used to get to data specified in SQL

statements.

Q6) What information is used as input to the bind process?

A6) The database request module produced during the pre-compile.

The SYSIBM.SYSSTMT table of the DB2 catalog.

Q19) What is a Database Request Module(DBRM)?

A19) A DBRM is a DB2 component created by the DB2 pre-compiler

containing the SQL source statements extracted from the application

program. DBRMs are input to the bind process.

Q24) What will the FREE command do to a plan?

A24) It will drop(delete) that existing plan.

Q32) Where are plans stored?

A32) Each plan is defined uniquely in the SYSIBM.SYSPLANS table

to correspond to the transaction (s) that are to execute that

plan.