How to fetch the uncommited data from table ?
Answer / sudhir kumar
With the help of restart checkpoint logic.
| Is This Answer Correct ? | 0 Yes | 0 No |
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
List out the buffer pools in db2
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
Plan has the optimized access path in it. But is that optimized access path is attained or known
What is referential integrity?
What is the error code -803 ?
How is a typical db2 batch pgm executed?
My SQL is not performing well. Describe how will you fine tune it?
What is meant by dclgen?
Explain in detail about buffer manager and its functionalities?
What is usage pointer in cobol?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?