Create Explain Tables in DB2 9.7

Posted on 2010/06/01 by Balazs

Problem

The explain tables allow to create access plans and visualize them. Before the explain feature of DB2 can be used, the EXPLAIN tables need to be generated.

Solution

To create the EXPLAIN tables, the following command needs to be issued while connected to the database that the access plain needs to be generated in:
CALL SYSPROC.SYSINSTALLOBJECTS('EXPLAIN','C',NULL,'EXPLAIN_SCHEMA')

This entry was posted in AIX, DB2, Linux, Mac OS X, Windows and tagged , . Bookmark the permalink.

NewPush has solutions to fit your business needs.  For more than a decade, our focus has been to take on the technical challenges that are the hardest and most time-consumming.  Our goal is to free up your resources to focus on the core activities of your business and to drive your business performance.  Please visit our main site at newpush.com for more information or call us at +1-303-423-4500.