Kbase P42192: AS/400: Error 100 RESERVE and 100 COMMIT when adding a new field in as/400 through Progress DB2/400
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress/400 DataServer
IBM AS/400 (RISC)
SYMPTOM(s):
DB command error has occurred contact Progress Software with the following error
100 RESERVE
and
DB command error has occurred contact Progress Software with the following error
100 COMMIT
The table is not being journalled
Job attribute ALWMLTTHD of the PROSERVER is set to *NO
Error 100 RESERVE and 100 COMMIT when adding a new field in as/400 through Progress DB2/400 data dictionary in AS/400
This error is happening in the production system after adding a new field in a table using DB2/400 data dictionary from windows client.
The test system has the same file and added the same field in the test system before adding in the production but the test system is running fine.
CAUSE:
The cause is unknown as to why the problem happened in the production machine. As a workaround, removing that particular table using DB2/400 data dictionary in the production machine and re-adding it back manually resolved the problem.
FIX:
Here are the steps to resolve the error if you have duplicate tables defined in other then the problem machine:
1. Delete the problem table using Windows client with DB2/400 progress data dictionary
2. Dump the same table's definition from the other AS/400 machine using the PROGRESS format option to eliminate any problems with which library the file is in. Make sure you specify the proper library name in the DATABASE OBJECT LIBRARY
3. Load the .df in the problem machine