JET_DBINFOMISC4 Structure

Article
08/26/2021

Applies to: Windows | Windows Server

JET_DBINFOMISC4 Structure

The JET_DBINFOMISC4 structure holds miscellaneous information about a database. This is the information that is contained in the database header.

    typedef struct {
      unsigned long ulVersion;
      unsigned long ulUpdate;
      JET_SIGNATURE signDb;
      unsigned long dbstate;
      JET_LGPOS lgposConsistent;
      JET_LOGTIME logtimeConsistent;
      JET_LOGTIME logtimeAttach;
      JET_LGPOS lgposAttach;
      JET_LOGTIME logtimeDetach;
      JET_LGPOS lgposDetach;
      JET_SIGNATURE signLog;
      JET_BKINFO bkinfoFullPrev;
      JET_BKINFO bkinfoIncPrev;
      JET_BKINFO bkinfoFullCur;
      unsigned long fShadowingDisabled;
      unsigned long fUpgradeDb;
      unsigned long dwMajorVersion;
      unsigned long dwMinorVersion;
      unsigned long dwBuildNumber;
      long lSPNumber;
      unsigned long cbPageSize;
      unsigned long genMinRequired;
      unsigned long genMaxRequired;
      JET_LOGTIME logtimeGenMaxCreate;
      unsigned long ulRepairCount;
      JET_LOGTIME logtimeRepair;
      unsigned long ulRepairCountOld;
      unsigned long ulECCFixSuccess;
      JET_LOGTIME logtimeECCFixSuccess;
      unsigned long ulECCFixSuccessOld;
      unsigned long ulECCFixFail;
      JET_LOGTIME logtimeECCFixFail;
      unsigned long ulECCFixFailOld;
      unsigned long ulBadChecksum;
      JET_LOGTIME logtimeBadChecksum;
      unsigned long ulBadChecksumOld;
      unsigned long genCommitted;
      JET_BKINFO bkinfoCopyPrev;
      JET_BKINFO bkinfoDiffPrev;
    } JET_DBINFOMISC4;

Members

ulVersion

The native version of the database engine that created the database. See JetGetVersion to retrieve the native version for the current database engine.

ulUpdate

Tracks incremental database format updates that are backward compatible.

ulVersion, ulUpdate =	Meaning
0x620,0	Original operating system Beta format (4/22/97).
0x620,1	Add columns in the catalog for conditional indexing and OLD (5/29/97).
0x620,2	Add the fLocalizedText flag in IDB (6/5/97).
0x620,3	Add SPLIT_BUFFER to space tree root pages (10/30/97).
0x620,2	Revert revision in order for ESE97 to remain forward-compatible (1/28/98).
0x620,3	Add new tagged columns to catalog ("CallbackData" and "CallbackDependencies").
0x620,4	SLV support: signSLV, fSLVExists in db header (5/5/98).
0x620,5	New SLV space tree (5/29/98).
0x620,6	SLV space map (10/12/98).
0x620,7	4-byte IDXSEG (12/10/98).
0x620,8	New template column format (1/25/99).
0x620,9	Sorted template columns (6/24/99).
0x620,A	Merged code base (3/26/2003).
0x620,B	New checksum format (1/08/2004).
0x620,C	Increased max key length to 1000/2000 bytes for 4/8kb pages (1/15/2004).
0x620,D	Catalog space hints, space_header.v2 (7/15/2007).
0x620,E	Add new node/extent format to space manager, use it for reserved pools of space (8/9/2007).
0x620,F	Compression for intrinsic long-values (10/30/2007).
0x620,10	Compression for separated long-values (12/05/2007).
0x620,11	New LV chunk size for large pages (12/29/2007).

signDb

Signature of the database (including creation time). This structure is 28 bytes.

dbstate

This is the database state.

The following options are available for this member.

Value	Meaning
JET_dbstateJustCreated 1	The database was just created.
JET_dbstateDirtyShutdown 2	The database requires hard or soft recovery to be run in order to become usable or moveable. One should not try to move databases in this state.
JET_dbstateCleanShutdown 3	The database is in a clean state. The database can be attached without any log files.
JET_dbstateBeingConverted 4	The database is being upgraded.
JET_dbstateForceDetach 5	Internal.

lgposConsistent

Null if the database is in a dirty state. This is the log position that was used when the database was last brought to a clean shutdown state.

logtimeConsistent

Null if the database is in a dirty state. This is the time when the database was last brought to a clean shutdown state.

logtimeAttach

The time when the database was last attached with JetAttachDatabase.

lgposAttach

The log position that was used the last time the database was attached with JetAttachDatabase.

logtimeDetach

The time when the database was last detached with JetDetachDatabase.

lgposDetach

The log position that was used the last time the database was detached with JetDetachDatabase.

signLog