Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
1 4384
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How and when does the db2 enforces the unique key?
Can we delete records from view?
What is the use of reorg in db2?
What are db2 tables?
What is database alias db2?
can we view the access paths created by dbrm ? how ? thx
Is schema the same as database?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
List out the three types of page locks that can be held.
How to create backup table in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Is db2 free?
What is host variable?
Define data page.
