What do you need to do before you do EXPLAIN?
Answer / s
Create the Plan_table to holds the results of the explain.
| Is This Answer Correct ? | 5 Yes | 0 No |
What is correlation names?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
Where is the access path logic created by the DB2 Optimizer stored?
Is ibm db2 free?
What is a Cartesian product?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
Can a Db2 table data be retrived through JCL?
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 do you mean by storage group (stogroup)?
what's the error code for Unique Index Violation?
How to compare data between two tables in db2?