Where is the access path logic created by the DB2 Optimizer stored?

Where is the access path logic created by the DB2 Optimizer
stored?

Question Posted / guest

Where is the access path logic created by the DB2 Optimizer stored?..

It is stored as bound plans/packages in the DSNDB01
directory in SKCT02, SKPT01 tablespaces.

Is This Answer Correct ?

4 Yes

2 No

More DB2 Interview Questions

Name the different types of Table spaces.

Which component is responsible for db2 startup and shutdown?

how to get duplicate records from tables?write qurey for this?

What is null indicator in db2?

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

what is the use of commit ? and what is the syntax?

What is difference between isnull and coalesce?

Mention the location where the output received from explain statement is stored.

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

What is data manager?

how we will do null data selection in cobol-db2 program

For more DB2 Interview Questions Click Here