Interested to Buy Any Domain ? << Click Here >> for more details...
How Plan is created while executing the query using SPUFI?
- 3 Answers
- 8461 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
Plan is already created during the installation of the DB2I
tools.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Before you give the explain statement, what are the prerogatives?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is difference between rollback and commit?
What is cursor stability in db2?
Give a brief description of db2 isolation levels?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is cursor in dbms?
What is the difference between nvl and coalesce?
what is db2 restart?
What is dbrm? What it contains?
How to resolve deadlock issue
How would you find out the total number of rows in a db2 table?
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 .....
List out the buffer pools in db2
What is access path in db2?
