Consultor Eletrônico



Kbase P22074: Is there a utility to display the database version?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   15/04/2008
Status: Verified

GOAL:

How to Determine What Progress Version the database is?

FACT(s) (Environment):

All Supported Operating Systems
Progress/OpenEdge Versions

FIX:

Currently there is no specified Progress executable that returns the database version.

To determine the Database version:

Option 1: View the database log file and search for (4234). This line will list the version of Progress that started the database.

Option 2: Run any proutil, rfutil, or prostrct commands against the database.
If the command is successful the database is the same major version as the utility and the Major version of the database is listed in the command's output.

i.e. proenv>rfutil db8 -C aimage extent list
PROGRESS Version 8.3E as of Thu Nov 15 12:55:05 EST 2001 ( database is 8.3E )
After imaging is not enabled for this database. (3803)

When the database is not of the same major version as the Progress utility an error (44) message will result.

i.e. ** Database has the wrong version number. (db: 4187, pro: 4246). (44)
The db and pro values returned by the error 44 are the sum of Database version + database block size.

For example:
database block = 4 K or 4096
database version = 91
4096 + 91 = 4187
message should display
Database has the wrong version number. (db: 4187, pro: <value>). (44)

The db / pro values for the different versions of Progress at the different database blocksizes are listed below:

Progress Version 1K block size 2K block size 4K block size 8K block size
1x.x 1174 2198 4246 8342
9.x 1115. 2139 4187 8283
8.x 1107 2131 4179 8275
7.x 1102 2126 4174 8260
.