Iseries Settings

Note: Before you begin you will need to make sure you have Iseries V5R4 software installed. Any version earlier then this will not work because it does not have the indexing features. It is best practice to have all components installed.

Managing Current Indexes

- Open Iseries Navigator and login
- Open Databases > Schemas > (Your system schema – You will need to know where your data is stored) > indexes 
 

You should see all the indexes on the right side. When I create custom indexes I will usally start them with a Z so I can easly idetify them.
 

If you would like to see when an Index was last used, right click on it and select Description.
 

On the first tab you can see when the index was last filled. (Last Build)

Click on the Usage tab to see when it was last used.

 

 

 

System Recommended Indexes – Creating

There are two ways to look at the recommended indexes. You can look at the database as a whole or you can just look at a specific table. 

A.) Looking at recommended indexes for the database

Right click on the schema and select Index Advisor > Index Advisor

 

 

 

 

The recommended indexes should open in a new window. The recommended indexes will be sorted by the number of time recommended. 

Once you have found the indexes you would like to create you can double click on it or right click and select create index.

Note: The index name should not be longer then 10 digits longer. When you name it start it with a Z and something to help relate it to the table name 

B.) Creating Indexes on a Table

Navigate to Server name > Databases > Schemas > Your schema > Tables

 

 

 

 

 

Right click on the table and select Index Advisor > Index Advisor

 

 

 

ShareThis