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: Doujind Shazragore
Country: Seychelles
Language: English (Spanish)
Genre: Personal Growth
Published (Last): 15 April 2010
Pages: 479
PDF File Size: 9.67 Mb
ePub File Size: 5.21 Mb
ISBN: 198-3-97282-952-2
Downloads: 73364
Price: Free* [*Free Regsitration Required]
Uploader: Gamuro

Sometimes, you may require performs a downgrade and return back from the firebkrd server. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Please e-mail us what needs to be changed. To retrieve it you can use the Firebird API, or simply use the tool that reads it for you it’s on properties page of each database in FlameRobin.

Its option -h outputs the header page information, which contains the ODS: The implemented solution has no additional storage overhead until the transaction counters grow beyond the 2 32 boundary. It depends on various options that are known only when actually doing something. Sign up using Email and Password. Changes to Client Address Reporting.

What is ODS version and how to retrieve it?

Later, it could be extended up to the 2 63 limit. ODS on-disk structure is a number firdbird version of the database physical layout structure.


Historically, transaction ID space was limited to 2 31 transactions, counted from the time the database was created. If gstat will not understand read information, it will show corresponding message — what it expected, and what it found.

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

In order to work with a database with an older ODS it will be necessary to make a backup using gbak under the older server and restore it with gbak on Firebird 3. Even if you tried to backup on the old server and restore at new, and it worked — never trust this. Changes to System Tables. That is not going to work, because Firebird 2.

To do that you will need 2 computers with the new server and the old one. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. Currently, after 13 years of Firebird and InterBase development, migration between the latest versions of these servers is pretty difficult. Prior to Firebird 3. In the initial release, a database with an older ODS cannot be opened by Firebird 3.

FreeAdhocUDF ODS-versions

Cross-platform copying of any ODS 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:.

Sometimes server may upgrade old ODS to some newer one, without notification. Post as a guest Name. Maximum database size is increased to 2 32 pages previously 2 31 pages. When a new feature is added to Firebird it might or might not require the structure of database pages or system tables database metadata to change.


Connect to any database that you can Check the engine version – http: The ODS version, as reported by user tools, shows with which server version the database was created, e. Email Required, but never shown. Wrong ODS version, expected 11, encountered 11 — Firebird 2. This is also true for Firebird 2. We use cookies to make your experience of our websites better. It will show something fierbird.

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

If it does, the ODS number must increase. To learn more, visit our add content page. ODS on-disk structure version is a number representing version of the database low-level data layout structure ODS. So, migration will be easier if you have not used features since InterBase 7.

How to return to the previous version of Firebird or InterBase Sometimes, you may require performs a downgrade and return back from the new server. There’s no way to know it upfront. Operating system user name.

But there are some limitations, which will be described further.