ODS (on-disk structure) is a number representing version of the database physical layout structure. When a new feature is added to the Firebird it might or might. In simple words, ODS (On-Disk Structure) is a number of database file format for the particular Firebird or InterBase RDBMS version. Almost all. Map the engine version to native ODS version using Firebird documentation or a bare bone database and extracts the ODS version with direct file access.

Author: Meztijar Kazigrel
Country: Kuwait
Language: English (Spanish)
Genre: Life
Published (Last): 3 September 2011
Pages: 189
PDF File Size: 19.12 Mb
ePub File Size: 18.65 Mb
ISBN: 430-4-18226-512-6
Downloads: 24989
Price: Free* [*Free Regsitration Required]
Uploader: Malakus

What is ODS version and how to retrieve it? | firebird Tutorial

For information about authentication mapping, see Mapping of Users firebiird Objects in the Security chapter. Did you see this question? If you desire so, firebrd changes will be credited to your name. If you only have remote connection to the server and you can log into the database, but you have no access to the database file itself, then starting with Firebird 2.

However, with Interbase 6. Per-table performance counters have been added to all of the monitoring tables. The maximum number of pages that can be configured for the database cache depends on whether the database is running under bit or bit Firebird:.

The most popular platforms—Windows and Linux x64 bit —were not affected by the change. Do you find this FAQ incorrect or incomplete? Note A odz provider for databases with ODS 8 to It will show something like. Historically, transaction ID space was limited to 2 31 transactions, counted from the time oes database was created.

After that point, the database becomes unavailable until backup and restore is performed to reset the transaction ID counter back to zero. Sometimes server may upgrade old ODS to some newer one, without notification.


The implemented solution has no additional storage overhead until the transaction counters grow beyond the 2 32 boundary. It is likely to be abandoned in a future version. It depends on various options that are known only when actually doing something.

To learn more, visit our add content page. Changes to Client Address Reporting. Check the engine version – http: ODS on-disk structure is a number representing version of the database physical layout structure. Sometimes you can get another kind of message, from the server not from gstat but with the same meaning.

If yes — the complexity of the migration will depend on how many features you used in the firebrid or administration process.

Maximum database size is increased to 2 32 pages previously 2 fjrebird pages. Changes to System Tables. Its option -h outputs the header page information, which contains the ODS: Anyway, if you try to do this, you need to extract metadata script from the database, and then try to create the new database from that script, using the same server.

So, the minor upgrade of ODS makes incompatible databases within same major server version. Implementation ID is Deprecated. The Implementation ID in the ODS of a database is deprecated in favour of a new field in database headers describing hardware details that need to match in order for the database to be assumed to have been created by a compatible implementation. Cross-platform copying of any ODS You have to create dummy database and then drop it.

If you haven’t used any new features of server X version of InterBase or Firebirdso you may return to X-1 following these steps:.


Later, it could be extended up to the 2 63 limit. Prior to Firebird 3. What is ODS version and how to retrieve it? For example, if you open a database with ODS 8. Email Required, but never shown.

Map the engine version to native ODS version using Firebird documentation flrebird knowledge base articles like http: This allows the server to work with database files from previous versions and simplify the transition from the old server firbird a new one. Except for Firebird 0.

What is ODS version and how to retrieve it?

To ensure quality, each change is checked by our editors and often tested on live Firebird databasesbefore it enters the main FAQ database.

Sign up using Facebook. Under these conditions, there will be no problems opening existing databases with the new Firebird sub-release. What is ODS version and how to retrieve it? In this case, if a database was created a long time ago and constantly modified, there can be incorrect old BLR for some objects.

After you fix all incompatibilities in this script, you can pump data from the old database to the new database.

All Firebird and InterBase On-Disk-Structure (ODS) versions – Firebird News

As it was said before, the last common was ODS 10, and since then Odz 2. For example, when you try to connect with 1. Databases created with bit and with bit builds of Firebird 1.