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, 2023

Actian Ingres 10.0 – is the latest version of the Ingres Database an enterprise open source database

Samstag, Juli 29th, 2023

Actian 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, 2023

Full Convert – is performant and easy to use database converter

Actian Ingres Database Ingres 11.2 – housekeeping recommendations

Samstag, April 1st, 2023

Actian Ingres Database Ingres 11.2 – General Reference

Samstag, April 1st, 2023

Actian Ingres Database – Product Support Lifecycle Policy September 2022

Donnerstag, September 8th, 2022

  Actian Ingres Database – Product Support Lifecycle Policy September 2022

Actian Ingres Database Ingres 11.2 – using Multi Version Concurrency Control (MVCC)

Dienstag, April 19th, 2022

  Starting 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, 2022

Actian Ingres Database – Product Support Lifecycle Policy April 2022

Montag, April 4th, 2022

  Actian Ingres Database – Product Support Lifecycle Policy April 2022

DTM Migration Kit 1.13.18 – a powerful data import export or transformation tool

Samstag, Februar 5th, 2022

DTM 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

Actian Ingres Database – Product Support Lifecycle Policy August 2021

Donnerstag, August 19th, 2021

Actian Ingres Database – Product Support Lifecycle Policy September 2020

Donnerstag, September 17th, 2020

Actian Ingres Database – Product Support Lifecycle Policy May 2020

Samstag, Mai 23rd, 2020

Actian Ingres Database – Product Support Lifecycle Policy Febuary 2020

Sonntag, Februar 23rd, 2020

Actian Ingres Database – Product Support Lifecycle Policy 2019

Sonntag, März 24th, 2019