Where is the access path logic created by the DB2 Optimizer
stored?
Answer Posted / s
It is stored as bound plans/packages in the DSNDB01
directory in SKCT02, SKPT01 tablespaces.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is bind in db2?
Which component is responsible for processing sql statements and selecting access paths?
What is database reorganization?
Explain db2.
Explain in brief how does db2 determine what lock-size to use?
Explain how can you do the explain of a dynamic sql statement?
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?
What is a db2 cursor?
What is package in db2 mainframe?
List out the three types of page locks that can be held.
Before you give the explain statement, what are the prerogatives?
What is null value in db2?
Why select is not preferred in embedded sql programs?
What is db2 connect?
What is the role of union all and union