FIREBIRD ODS PDF

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: JoJosar Faujora
Country: Burundi
Language: English (Spanish)
Genre: Politics
Published (Last): 5 June 2009
Pages: 212
PDF File Size: 14.36 Mb
ePub File Size: 6.44 Mb
ISBN: 728-5-31039-932-8
Downloads: 21775
Price: Free* [*Free Regsitration Required]
Uploader: Faetaxe

If you are a commercial tool maker and your tool features a great way to handle the issue written about in this FAQ, please check out our advertisement page. For Named Pipes a. Sometimes server may upgrade old ODS to some newer one, without notification.

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

If your program can ensure those requirements, then it can work. Existing databases with ODS If you made the backup before server upgrade, there will be no problems to return back. Sign up using Facebook. What is ODS version and how to retrieve it? For example, if you open a database with ODS 8. This need to be done to check if there any bad old metadata in your database or bugs of script extraction in the server you use.

Check the engine version – http: As previously, Firebird will not open a database on little-endian that was created on big-endian, nor vice versa. ODS on-disk structure is a number representing version of the database physical layout structure. If oxs desire so, the changes will be credited to your name. Per-table performance counters have been added to all of the monitoring tables. If you haven’t used any new features of server X version firebifd InterBase or Firebirdso you may return to X-1 following these steps: There’s no way to know it upfront.

  AMELIE KUHRT PDF

ODS on-disk structure version is a number representing version of the database low-level data layout structure ODS. IB Surgeon Toggle navigation.

This is also true for Firebird 2. Operating system user name. This allows the server to work with database files from previous versions and simplify the transition from the old server to a new 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.

Since I have not found anything useful, I ended up creating a small function, which uses isql to create a bare bone database and extracts the ODS version with direct file access. It will show something like. For example, if we run gstat from InterBase 4 at database from Firebird 2, it will show Wrong ODS version, expected 8, encountered ? 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.

What is ODS version and how to retrieve it?

To firebrid 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. If it does, the ODS version must increase. When a new feature is added to Firebird it might or might not require the structure of ifrebird pages or system tables database metadata to change.

  ASTM E2375 PDF

Historically, transaction ID space was limited to 2 31 transactions, counted from the time the database was created. Not affiliated with Stack Overflow.

User and password here unnecessary, because gstat with —h option just read physical part of the database header page, number 0. For information about authentication mapping, see Mapping of Users to Objects in the Security chapter. They were carefully checked to verify that, for them, there is no actual difference between ODS 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.

Even if you tried to backup on the old server and restore at new, and it worked — never trust this. It depends on various options that are known only when actually doing something. Map the engine version to native ODS version using Firebird documentation or knowledge base articles like http: Later, it could be extended up to the 2 63 limit. User and password here unnecessary, because gstat with —h option just read fidebird part of the database header page, number 0.