Archive for the ‘INGRES Database’ Category

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

Actian Ingres Database Ingres 11.0 – SQL Reference Guide

Samstag, Januar 26th, 2019

Actian Ingres Database Ingres 11.0 – SQL Reference Guide

SQL Tutorial – INTERSECT operator removes the duplicate rows from the final result set

Mittwoch, Januar 2nd, 2019

SQL Tutorial – the SQL cheat sheet provides you with the most commonly used SQL statements for your reference

Dienstag, Januar 1st, 2019

SQL Tutorial – helps you get started with SQL quickly and effectively through many practical examples

Dienstag, Januar 1st, 2019

If you are a software developer, database administrator, data analyst, or data scientist who wants to use SQL to analyze data this SQL Tutorial is a great start

SQL Tutorial – MINUS query giving results on exactly same data in two tables

Dienstag, Januar 1st, 2019

Actian Ingres Database ‚Housekeeping‘ – the purpose of this section is provide an introduction to housekeeping

Freitag, November 16th, 2018

Actian_logo   Actian Ingres Database ‚Housekeeping‘ – followings are several recommendations for performing housekeeping and maintenance of the Ingres Database