IBM SG24-6526-00 manual Operating System/400 OS/400, SQL server job configuration

￿Model 270 feature 2252 Processor CPW 950 Interactive CPW 0

￿Model 820 feature 2396 Processor CPW 950 Interactive CPW 35

Notice the considerable variation in the processor CPW and the low interactive CPW. The variation in processor CPW may be because, although CPW is a good indicator of RPG and Cobol performance, it is not a good indicator of Java and WebSphere performance. Java performance is significantly affected by processor features, such as L2 cache, which do not affect the CPW rating as much.

There is a low interactive CPW is because WebSphere does not need interactive CPW. Little dumb terminal work is required to manage a WebSphere application. The small amount that is needed, such as starting the QEJBSBS subsystem, may be performed from the console.

Because of the single task exemption, this is possible even on a system with an interactive CPW of 0. Of course, a call.connect or vendor.connect user may be running System21 on the same system. This requires a certain amount of interactive CPW, but the WebSphere applications do not add to this requirement.

In V5R1, IBM introduced a new benchmark called Compute Intensive Workload (CIW). This is calculated differently than CPW. It depends more on such factors as the processor speed and depends less on system services. It is hoped that this value will be a better indicator of the likely performance of Java- and WebSphere-based applications. Unfortunately, IBM has only published CIW figures for the new V5R1 models, which does not include any of the previously mentioned systems. In the future, this new benchmark should be useful. If you are considering an upgrade, then try to find the CIW of your current system and the ones to which you are considering upgrading.

For systems below these recommended minimum specifications, IBM states that you may use them in environments that support a limited number of users and where longer server initialization times can be tolerated.

Geac’s experience is that a small installation may be successful if you are beneath the recommended processor levels. However, Geac recommends that you do not go below the recommended memory requirements. When there is insufficient memory, WebSphere performance is severely impaired. If you are considering an upgrade to improve WebSphere performance, then monitor your memory usage carefully. It may be more effective to upgrade the memory rather than the processor.

Older AS/400 models, before the 170 and 720 ranges, are liable to give poor WebSphere performance. Consider installing WebSphere on older AS/400 systems only if they are particularly large. Even so, the performance may be disappointing. Geac ran call.connect on a Model S30 with a CPW of 999, yet the performance was not much better than a 170-2385 with a CPW of only 460.

5.2 Operating System/400 (OS/400)

Several aspects of OS/400 configuration are important to WebSphere performance. These aspects are explained in the following sections.

5.2.1 SQL server job configuration

WebSphere applications make substantial use of Java Database Connectivity (JDBC). On the iSeries, there are two commonly used JDBC drivers:

￿Toolbox driver: This is primarily used by Java applications that are not running on the iSeries itself.

Chapter 5. Performance tuning 109