What is access path in db2?
Which transaction use a command thread ?
Give a brief description of db2 isolation levels?
How to resolve deadlock issue
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
How do I delete a table in database?
Is db2 a database?
Where do you specify them?
What is db2 optimizer?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What is rct?
When reorg is used?