We recently updated the database system from an older 12.0.1 to the current EBF, during this process we identified, that a dbupgrade was needed otherwise the db file would not start anymore.
Now we would like to automate this process and are looking for a good way how to check, if the dbupgrade is really necessary (or recommended).
asked 29 May '13, 10:11
If you just want to know whether a particular database has been upgraded or not (or to what EBF) - in contrast to know whether a new feature requires a DBUPGRAD run or not - , then you can query SYSHISTORY. That system view will contain an entry named "DBUPGRADE" for each DBUPGRAD-operation with the according version number, and thereby it should be easy to find out if another DBUPGRAD is required or not.
If no upgrade has ever been made, the "INIT" value will tell the version of the system catalog and the like...
answered 31 May '13, 07:42