In part 1 of this series, I introduced you to the basic functionality of Index Advisor. In this article, we will take a look at more of the options and functionality available with Index Advisor for Systems Director Navigator for i.

More Options

Apart from the obvious information (table and schema names), the Index Advisor window also gives us some pertinent information, such as:

• The advised key
• The first and last time the index was advised
• The number of times the index was advised
• The longest and average execution times for the queries that generated the index advise
• The

Once again, the alert and astute readers of this august publication have proven true the old adage that multiple methods exist for removing the outer covering of a feline animal. Several of you wrote in response to my article, Interpreted CL Members, to share other methods of running CL commands in interpreted mode. Here are some of the comments I received.

I use REXX to handle scripting for CL commands. While I’m not an expert, I’ve found it useful for tasks that you do at a command line to set up something, do over and over, and forget the

I set up a QFileSvr.400 connection for accessing AS/400 Integrated File Systems (AS/400 IFS) objects on another IBM i machine. I use it several times a month to transfer files. All of a sudden, the connection stopped working and I have no clue why. Do you have any idea what could happened and how I can fix it?

–Bob

As I’ve written before, I love using QFileSvr.400 for accessing, modifying, and copying or moving files between two IBM i systems (Power i, System i, and iSeries). A QFileSvr.400 link is incredibly easy to set up. All you have to do