Interested to Buy Any Domain ? << Click Here >> for more details...
What are the functions of Bind?
- 2 Answers
- 8709 Views
- Amdocs, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha dasari
there are three things bind does:
1. as stated above, it derives the most optimised path for
each SQL in the DBRM.
2. it does a syntax check. this might sound redundant, but
here is where it refers to the DB2 Catalog and verifies the
table names, column names etc.
3. it checks authorization. here is where it checks if the
user has bind access to the table refered.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ms. stanley
To create the most optimal path for the SQL Queries in the
program
| Is This Answer Correct ? | 3 Yes | 0 No |
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
When do you specify the isolation level? How?
Explain about mirror activator disk mirroring?
Why use RUNSTAT Utility?
How to check last update on table in db2?
What is check constraint in db2?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
What is lock escalation?
What is the information associated with sysibm.syslinks table?
What is meant by concurrency?
Can you search give an array in the WHERE clause of a db2 query?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
COBOL 
