-
Junior Member
what is the bind process , explain.
explain me abt Bind process in DB2.
-
Junior Member
Re: what is the bind process , explain.
what is the Bind processs in DB2.
-
Junior Member
Re: what is the bind process , explain.
Hi,
In DB2 bind is a process that makes bridge between the applications and the database.
Regards,
Shubhrojyoti
-
Junior Member
Re: what is the bind process , explain.
Bind converts high level database request into optimized internal form. It compiles the SQL statement into code.
-
Junior Member
Re: what is the bind process , explain.
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
-
Junior Member
Re: what is the bind process , explain.
Directly we can code DDL statements into PL/SQL programs..
-
Junior Member
Re: what is the bind process , explain.
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
-
Junior Member
Re: what is the bind process , explain.
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
Regards,
Rasipuram Manivannan
Plz correct it if i m wrong.
-
Junior Member
Re: what is the bind process , explain.
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
-
Junior Member
Re: what is the bind process , explain.
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules