Q

Storing a DB2 plan

Where exactly is a DB2 plan stored?
A DB2 "plan" is stored in the DB2 Directory and information about the plan is stored in the DB2 Catalog.

The DB2 Directory table that contains actual plans is SYSIBM.SCT02 (and SYSIBM.SPT01 contains actual packages). The plan is stored as cursor tables; packages as package tables. As DB2 runs programs it loads the cursor tables for plans and package tables for packages from the DB2 Directory tables into the EDM Pool.

The DB2 Catalog contains information about plans in the following tables:

SYSIBM.SYSDBRM
SYSIBM.SYSPLAN
SYSIBM.SYSPLANAUTH
SYSIBM.SYSPLANDEP
SYSIBM.SYSSTMT

And, the DB2 Catalog contains information about packages in the following tables:

SYSIBM.SYSPACKAGE
SYSIBM.SYSPACKAUTH
SYSIBM.SYSPACKDEP
SYSIBM.SYSPACKLIST
SYSIBM.SYSPACKSTMT
SYSIBM.SYSPKSYSTEM
SYSIBM.SYSPLSYSTEM

Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our .VO7aaqqaAFk.0@/search390>discussion forums.

This was first published in June 2004

Dig deeper on IBM DB2 management

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close