RE: strdbmon

And don't forget there are some great tools now in Ops Navigator where you
can graphically watch your SQL statements, the number of records it selects
at each stage of its process and the indexes it chooses to use. It even
suggests better indexes to build. All of this can be found under databases.
Right click and select "Run SQL Scripts"

Gary

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of Lemon, Mike
Sent: Tuesday, August 30, 2005 9:04 AM
To: 'System 21 Users'
Subject: RE: [SYSTEM21] strdbmon

FYI ALL... You can issue the STRDBG command, run a program, and review the
access path creation messages that show in the job log.  They show why each
access path was rejected and what access path was actually created any why.

This works for optimizing any AS400 query utility (OPNQRYF, Query/400, SQL,
etc.), not just System 21.

-Mike
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.