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

What is rebind in db2?

Before you give the explain statement, what are the prerogatives?

What does db2 stand for?

Request to database but database is not available so what is was abend is raised?

Comment whether the cursor is closed during commit or not.

how to resolve -811

How to get the ddl of a table in db2?

What is the picture clause of null indicator variable?

How to test SQL -911 error while developing COB-DB2 program

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

What is the maximum size of a char data type in db2?

what is plan? is plan executable or package?

For more DB2 Interview Questions Click Here