What is rebind in db2?
Why do we need reorg in db2?
What is buffer pool?
What does db2 mean?
define clustering index.
What is the difference between cursor and select statement?
Are view updateable?
Mention the different locking levels that are available in db2.
Before you give the explain statement, what are the prerogatives?
How do I create a view in db2?
When reorg is used?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is multi row fetch in db2?
Give the name of some fields form sqlca.