what is the bind process , explain.

explain me abt Bind process in DB2.

what is the Bind processs in DB2.

Hi,
In DB2 bind is a process that makes bridge between the applications and the database.
Regards,
Shubhrojyoti

Bind converts high level database request into optimized internal form. It compiles the SQL statement into code.

Few things are happend in bind process. those are..
1. Checking for syntax like sql statements, DCLGEN variables.
2. it verifies the access authority like updating or retriving of data from database.
3. after completion of checking of access authority it creates a documentary evidance in PLAN_TABLE

Directly we can code DDL statements into PL/SQL programs..

consider u r running an application program such as pro c .. when u compile ,the sql statements present inside the c file is seperated and its being stored in the database as package (may contain access plan of the sql).. the above process in called binding.. during runtime its linked and the pgm is executed

Bind:



Paritially we can say as intermediator betwn application and database Bind will do the following activities.

1. autherization checking
2. creation of plan or package( depending on the dbrm)
if you want to know the dbrm list, Go to dbrmlib
3. Checking sql statements


[B][U][COLOR="DarkOrchid"]Regards,

Rasipuram Manivannan[/COLOR][/U][/B]

Plz correct it if i m wrong.

Basicaly the result of precompilation descides optimal path to perform operation on DB2 tables. A package bound with a plan gets created as a result of precompilation. Package can not execute on its one so it hsae to be bound with a PLAN. Plan can be execute.When Program will run this plan will get execute to perform DB2 operation.

Thanks,
Vaibhava Gupta

Bind does a syntax check for the sql statements extracted into dbrms, from the catalog info (such as table size, number of columns, indexes etc....)
and chooses a optimal access path to get the operation done on database. Even authorization check is also done during bind. Bind process is of two types.
1)bind package
2)bind plan
dbrms can be directly fed to bind plan to get a plan
or intermediate packages can be created by bind package and then inturn these packages can be fed to bind plan to get a plan. To execute a db2 program this plan should be provided together with the program. Important difference between plan and a package is,
plan is executable
package is not executable