Answer Posted / gouri
dsnhpc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the physical storage length of time data type?
What is coalesce in db2?
How can you quickly find out the # of rows updated after an update statement?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is the role of data manager in the db2 database?
How is a typical db2 batch pgm executed?
When reorg is used?
what is a corelated subquerry?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Mention the different locking levels that are available in db2.
What is a page in db2?
What is the maximum No of rows per page?
What is concurrency?
Describe major components of db2?
Which component is used to execute the sql statements?