Archive for the ‘INGRES Database’ Category
Actian Ingres NeXt CEO Lewis Black – a strategy to support your modernization journey with a phased approach to achieve incremental milestones
Samstag, Juli 29th, 2023Actian Ingres 10.0 – is the latest version of the Ingres Database an enterprise open source database
Samstag, Juli 29th, 2023Actian Ingres 10.0 Enterprise Edition – with Linux x86 64-bit
Spectral Core ‚Full Convert‘ – the easiest way to copy your data to another database
Dienstag, Juli 4th, 2023Full Convert – is performant and easy to use database converter
Actian Ingres Database Ingres 11.2 – housekeeping recommendations
Samstag, April 1st, 2023Actian Ingres Database Ingres 11.2 – General Reference
Samstag, April 1st, 2023Actian Ingres Database – Product Support Lifecycle Policy September 2022
Donnerstag, September 8th, 2022Actian Ingres Database Ingres 11.2 – using Multi Version Concurrency Control (MVCC)
Dienstag, April 19th, 2022Starting with Ingres 10.0 databases are created with Multi Version Concurrency Control (MVCC) as a default also databases upgraded from prior releases also have MVCC enabled
Table Requirements
MVCC only applies to tables that meet the following criteria:
They were not created with a page size of 2K
They are permanent tables; i.e., they are not temporary tables
They are not using the rtree storage structure
They are not one of the core system catalogs (i.e., iirelation, iiattribute)
They are not gateway tables
They do not contain data rows that are larger than the table’s page size
Other Requirements
You are not using an isolation level of read uncommitted
You are not using readlock = nolock
Logging has not been disabled, unless you are only issuing read-only queries
Fast commits have not been disabled
You are not running in a cluster environment
The easiest method to check a database’s MVCC status is to use:
infodb <dbname>
==================Fri Dec 17 08:27:01 2021 Database Information=================
Database : (testdb,actian) ID : 0x0B3687C5 Default collation :
Unicode enabled : Yes
Always logged : No
X100 supported : Yes
Database Encryption : No
Default unicode collation : udefault Unicode normalization : NFC
Extents : 5 Last Table Id : 265
Config File Version Id : 0x00090001 Database Version Id : 12
Mode : DDL ALLOWED, ONLINE CHECKPOINT ENABLED
Access : PUBLIC
Status : VALID,JOURNAL,CKP,DUMP,CFG_BACKUP
The Database has been Checkpointed.
The Database is Journaled.
MVCC is enabled in this database.
Journals are valid from checkpoint sequence : 2
We can however disable MVCC using:
alterdb -disable_mvcc <dbname>
Fri Dec 17 08:28:48 2021 ALTERDB: MVCC disabled for Database ‚testdb‘.
Use infodb again to verify
==================Fri Dec 17 08:29:42 2021 Database Information=================
Database : (testdb,actian) ID : 0x0B3687C5 Default collation :
Unicode enabled : Yes
Always logged : No
X100 supported : Yes
Database Encryption : No
Default unicode collation : udefault Unicode normalization : NFC
Extents : 5 Last Table Id : 265
Config File Version Id : 0x00090001 Database Version Id : 12
Mode : DDL ALLOWED, ONLINE CHECKPOINT ENABLED
Access : PUBLIC
Status : VALID,JOURNAL,CKP,DUMP,NOMVCC,CFG_BACKUP
The Database has been Checkpointed.
The Database is Journaled.
MVCC is disabled in this database.
Journals are valid from checkpoint sequence : 2
Actian Ingres Database Ingres 11.2 – Roadmap
Sonntag, April 17th, 2022Actian Ingres Database – Product Support Lifecycle Policy April 2022
Montag, April 4th, 2022DTM Migration Kit 1.13.18 – a powerful data import export or transformation tool
Samstag, Februar 5th, 2022DTM Migration Kit – is an advanced data management tool that designed for the multi-vendor environment and rarely used database support. It allows user database administrator or developer to import data from most popular formats to export database content to migrate data from different data sources