Kbase 17601: How to know if the AS/400 schema holder is synchronized
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/03/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress/400 DataServer
SYMPTOM(s):
Unable to open the database file. (2468)
CAUSE:
There are two fields stored in the metaschema which indicate the synchronization level of the server schema and the schema holder.
These are:
1. _Db._Db-misc1[1] in the schema holder
2. P__DB._Db-misc1[1] in the server schema.
FIX:
To know if the schema holder is correctly synchronized against the server schema you can run a procedure like this having connected both schema holder and AS/400 database:
FIND FIRST P__DB NO-LOCK.
FIND FIRST _Db WHERE _Db._Db-type = "AS400" NO-LOCK.
IF P__DB._Db-misc1[1] > _Db._Db-misc1[1] THEN
DISPLAY "Not synchronized".
ELSE
DISPLAY "Synchronized".
To force a synchronization you can change the value of _Db._Db-misc1[1] to be minor than P__DB._Db-misc1[1] and then run the synchronization process from the Tools menu. But notice that modifying metaschema is not supported by Progress and you are doing it at your own risk. If you suspect your schema holder is not correct, the only supported way to fix it is building a new one from scratch. This does not take much more time compared to the synchronization.