Back To LeighWeb Mainframe Utilities Page

 INDEXCOL accesses the DB2 catalog to determine all the columns in all the
 indexes for a given creator id.  It then adds up the bytes in each index and
 loads the results into an ISPF table and displays them in a scrolling panel.
 At the time of this writing no tool gives this information though it can be
 useful when doing catalog statistics updates for EXPLAIN "what-iffing" with
 Candle's !DB-Explain product.

 Syntax:

 COMMAND ===> tso indexcol {creator(creatorid)}

 The default creator id is "USSTRD00" (UNISTAR development).

 When the list is presented on your screen you have a few primary commands and
 one line command to choose from.

 Line command:

 "X" - This command on any line will exclude that line from the current display.
 This may be useful if you are wanting to keep a display of multiple index
 lengths on one screen but there are many screens worth of lines which you do
 not want to see.

 Primary Commands:

 "DEBUG ON³OFF" - This dynamically turns on or off debugging messages while
                  INDEXCOL is executing.

 "EDIT" - This command will bring you into an edit session on the work file
          which INDEXCOL created while preparing the scrollable list screen.  It
          contains all the individual columns, their length, and sequence, and
          total length in one big file.  This may be useful to see the details
          for a given index.

 "FIND xxx" - This command will position your display to the first line where a
              given string is found.  It is a good tool to position you to a
              particular set of indexes for a particular table since the index
              names all begin with the subject area prefix.

 "RESET" - This command will reset all the excluded lines (if there are any) so
           that all lines are displayed again.