Interested to Buy Any Domain ? << Click Here >> for more details...
Where is the access path logic created by the DB2 Optimizer
stored?
- 1 Answers
- 8445 Views
- I also Faced
- E-Mail Answers
Answer / s
It is stored as bound plans/packages in the DSNDB01
directory in SKCT02, SKPT01 tablespaces.
| Is This Answer Correct ? | 4 Yes | 2 No |
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
What is a db2 tablespace?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What is deadlock?
what is static sql? what is dynamic sql? Give me details
How to retrieve rows from a db2 table in embedded sql?
What action db2 takes when a program aborts in the middle of a transaction?
What is a clustering index ?
What are foreign keys in db2?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
Mention the definition of cobol in varchar field.
Explain an outer join?
COBOL 
