Difference between revisions of "Performance Tuning"

From MidrangeWiki
Jump to: navigation, search
m
m
Line 65: Line 65:
  
 
=== Open Query File Optimization ===
 
=== Open Query File Optimization ===
 +
 +
=== Program Performance Optimization ===
 +
 +
=== [[Query]] ===
 +
 +
==== CHGQRYA rules ====
 +
 +
==== Finite World ====
 +
 +
==== Query Indexing ====
 +
 +
==== Query Messages ====
 +
 +
=== Random Inefficiency ===
 +
 +
=== Read Slowly ===
 +
 +
=== Run Priority ===
 +
 +
=== Screen Restructuring ===
  
 
=== SQL ADVISOR ===
 
=== SQL ADVISOR ===
 +
 +
=== Start Stop Start Stop to Infinity ===
  
 
== Backup Management ==
 
== Backup Management ==
 +
 +
=== Protection Schemes ===
  
 
== Disk Space Cleaning ==
 
== Disk Space Cleaning ==
Line 89: Line 113:
  
 
=== Memory Moving ===
 
=== Memory Moving ===
 +
 +
=== Sign on Faster ===
  
 
== Task Scheduling ==
 
== Task Scheduling ==

Revision as of 07:18, 13 June 2005

This is one of the things you might look at while trouble shooting Degradation, but in fact ought to check periodically, to avoid a problem developing and not being spotted. Doubtless someone may update this article to reflect improvements in IBM eServers in later models. The reality of what is needed will vary greatly by what you have on your 400 hardware, in terms of system load, and which version of OS/400 or i5/OS.

Al Mac has similar notes at work in FIXTUNING, an SEU "document." Some of the terminology used by Al Mac may not be the correct stuff ... instead sometimes Al Mac has assigned names to a technique learned, or figured out outside formal 400 education, and not known what name would be better.

Brain Overload

This is a collection of complicated topics that can take a while to wrap our mind around and thoroughly "Grok", so pick one area, study it, leave the others alone, until ready to move on to something else.

Choices

Pre Requisites

What prior knowledge of the 400 is is smart for you to have some of, to help you swim in these waters?

Errors and other Clues

Communications Lines

Data Base Monitor

File hit Maximum records

Hogging System Resources

JOBLOG

Job Tracking

Library List vs. Qualified Calls

Performance Measurement

Data File
Spool File

Messages Management

Application Software Review

Batch Considerations

CPU Intensive

Blocking

CPU Sharing

Call Frequency

Data Slicing

Debug

Disk Access

Logicals

Access Path Sharing

Dimensions

Message Over Load

Open Query File Optimization

Program Performance Optimization

Query

CHGQRYA rules

Finite World

Query Indexing

Query Messages

Random Inefficiency

Read Slowly

Run Priority

Screen Restructuring

SQL ADVISOR

Start Stop Start Stop to Infinity

Backup Management

Protection Schemes

Disk Space Cleaning

File Size Fluctuation

Archival

Management Central

System Values

Allocations

Active Jobs

Automatic System Tuning

Cache vs. Bottlenecks

Memory Moving

Sign on Faster

Task Scheduling

Other Resources

Books and Manuals