An express-mode load with delimited ASCII
In an express-mode load with delimited ASCII, the load or unload job is limited by the available CPU. The conversion to or from HCL Informix® types to ASCII is the most expensive portion of these operations
Because this conversion is expensive, the following configuration
might be more appropriate. The following table lists sample values
of configuration parameters for an express-mode load with delimited
ASCII.
| Configuration parameter | Sample value | Comment |
|---|---|---|
| CONVERTVPS | 8 | One convert VP per CPU |
| CONVERTTHREADS | 2 | Four devices * 2 thread/device = 8 threads |
| STRMBUFFSIZE | 32 | Should be some multiple of AIOBUFSIZE. For this CPU-intensive case, 1 or 2 * AIOBUFSIZE is sufficient. |
| STRMBUFFERS | 4 | CONVERTTHREADS + 4 |
| AIOBUFSIZE | 32 | Choose a buffer size to match the best block size for the tape drive. Large buffers increase performance if sufficient memory is available. |
| AIOBUFFERS | 5 | CONVERTTHREADS + 4 or 2 * CONVERTTHREADS, whichever is larger |