What is the use of predicate?
What is null value in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What happens in bind step in a db2 program?
What is the use of dclgen in db2?
What are the full forms of spufi and dclgen and why are they used?
What is db2? Explain.
i want to maintain uniqueness on pdf without make lf??????????
Mention the downsides of page level lock.
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 .....
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Is the primary key a clustered index?
What are the various isolation levels possible?
What is the role of the data page in the db2 database?
Explain in brief how does db2 determine what lock-size to use?