Kbase P44202: Error 100 RESERVE and 100 COMMIT when adding a new field in
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/12/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress/400 DataServer
FACT(s) (Environment):
IBM AS/400 (RISC)
SYMPTOM(s):
Error 100 RESERVE and 100 COMMIT when adding a new field in as/400 through Progress DB2/400 data dictionary in AS/400
DB command error has occurred contact Progress Software with the following error 100 RESERVE
and
A 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
This error is happening in the production system after adding a new new field in a table using DB2/400 data dictionary from windows client.
Do not have a test system with a similar database
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:
Dump the .df for the problem table in case need to reference the table definition or the size of each individual field when creating the table from scratch using DB2/400 dictionary in windows client. After that Delete the table manually and re-add it back.