Index Column Order

[abercrombieande]

I have a simple join statement

SELECT LO.ID
INTO   : H
FROM   QTEMP / TBLA GR
       LEFT OUTER JOIN TBLB AS LO
       ON     GR .A = LO.A
       AND    GR .B    = LO.B
       AND    GR .C = LO.C
       AND    GR .D    = LO.D

...

[abercrombieande]

I am looking for a good whitepaper on Indexes and Stats for V7.1. Coming from SQL Server I am use to checking the fragmention level and reorganizing or rebuilding the indexes and also running stats. I am at a lost for how the iSeries handles index maintenance and how to check fragmentation levels....

[abercrombieande]

Are there any system tables that contain the columns that compose an index. I see the sysindexes table so I have the index name but no idea what columns make up the index.

What I am trying to do is write some SQL that runs nightly to script all the indexes out.