Kbase P102479: How to avoid messages CPA5305 on the AS/400 systems
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/24/2005 |
|
Status: Unverified
GOAL:
How to avoid messages CPA5305 on the AS/400 systems
FACT(s) (Environment):
IBM AS/400 (RISC)
FIX:
There are situation when creating a large number of records in a table (physical file) may result in the error CPA5305 that requires operator's intervention:
CPA5305: Record not added. Member <PF_Name> is full. (C I 9999)
The most common response is providing a number of records to add to the file. This will increase member's capacity. However, the fact that there's a need for interaction could be a problem when running non interactive (batch) jobs (using Native 4GL client). This situation will stop the process with a MSGW (message wait) status and will continue as soon as the response option is provided.
Some facts must be taken into consideration in order to circumvent the issue:
When creating physical file on AS/400 (CRTPF) the initial number of records in each member of the file can be specified. By default it's 10000. Whenever this value is reached a system automatically increments the size by 10% (or specified value in "Increment number of records" parameter if it's to be more than 10%). There's another parameter in the SIZE option of the CRTPF command: "Number of Increments", which determines the maximum number of increments that can be automatically added to the physical file member (0-32767). This is a "hard" limit. Whenever this limit is reached and there's a need to add more records the message CPA5305 appears giving a choice of manual action. This mechanisms prevent uncontrolled growth of physical files on the AS/400.
The easiest option to avoid such situations is to change the SIZE option in the physical files that cause problems using CHGPF command. When "maximum increments" is increased the file will be allowed to grow larger without sending a message. Adjusting "Increment number of records" to particular needs of the Application (the approximate growth of the table is well known) could remedy the situation as well.