AV | Actian Warehouse Release Notes

Welcome to Actian Data Platform > What’s New in the Actian Data Platform > Actian Warehouse Release Notes

Was this helpful?

Actian Warehouse Release Notes

Features	Database Engine	Warehouse Version	Release Date
• Backend fixes and improvements		630.0.18	April 4, 2024
• Backend fixes and improvements	620.14025	620.1.30	February 6, 2024
• Backend fixes and improvements	620.14021	620.1.26	November 15, 2023
• Backend fixes and improvements	620.14019	620.1.16	September 24, 2023
• Backend fixes and improvements	620.14018	620.1.13	August 23, 2023
• Backend fixes and improvements	620.14013	620.1.6	June 21, 2023
• Backend fixes and improvements	620.14007	620.0.29	April 6, 2023
• Dynamic Scaling	620.14003	630.0.18	January 17, 2023
• AWS AV-2 architecture added • Customer Managed Keys	6.1.30116	3.1.0	August 25, 2022
• Backend fixes and improvements	6.1.30110	2.2.8	May 5, 2022
• Enable users to save, import queries to their local system • Add database monitoring checks	6.1.30108	2.2.4	March 1, 2022
• Warehouse Details page updated • Ability to create databases is added • Adding SSO users documentation is updated	6.1.30107	2.2.1	February 17, 2022
• Backend fixes and improvements	6.1.30105	2.1.18	December 20, 2021
• Backend fixes and improvements	—	2.1.15	November 18, 2021
• Account AU monitoring is added to the Administration interface • “Backing Up” status is included in warehouse statuses	—	2.1.14	October 28, 2021
• Nine monitoring tables from the imadb database are available for querying • A Recurrence interval of “Schedule Once” is added to warehouse scheduling	—	2.1.10	October 7, 2021
• Backend fixes and improvements	—	2.1.7	September 2021
• Two monitoring capabilities are added: Cluster CPU Load and Execution Memory	6.1.30104	2.1.6	September 9, 2021
• Long-running queries are terminated after 24 hours	—	2.0.25	August 10, 2021
• Scaling running warehouses is now supported	6.1.30102	2.0.24	July 7, 2021
• Logging in with Actian ID or Single-Sign-on credentials is supported • Modifying idle stop period is available for Google Cloud warehouses • Idle stop now supports periods of 15 and 30 minutes • Opening service request with Actian Support enabled in Administration	6.1.30101	2.0.17	May 26, 2021
• Google Cloud Platform supported • Redesigned Query Editor released for Google Cloud	6.1.0-30101	2.0.11	April 27, 2021

630.0.18

Backend fixes and improvements were made.

620.1.30

Backend fixes and improvements were made.

620.1.26

Backend fixes and improvements were made.

620.1.16

Backend fixes and improvements were made.

620.1.13

Backend fixes and improvements were made.

620.1.10

Backend fixes and improvements were made.

620.1.9

Backend fixes and improvements were made.

620.1.6

Backend fixes and improvements were made.

620.0.29

Backend fixes and improvements were made.

620.0.18

Dynamic scaling enables warehouses to scale up or down in size without a restart. This enables you to adjust resources available to a warehouse without interrupting workloads. This feature is only available in a 620.x or above warehouse. Any existing 610.x-based warehouses need to upgrade to enable this new feature.

Note: Upgrading your warehouse to enable dynamic scaling requires a support ticket. New warehouses use 620.x warehouses by default.

For more information, see Scale a Warehouse

3.1.0

The architecture for Avalanche is updating for AWS. AWS AV-2 is a distinction that the architecture has been refreshed for AWS and it supports the same features as Google Cloud. AWS AV-1 is still supported, meaning customers that have warehouses built on AWS AV-1 are keeping the legacy functionality without being forced to go to the AV-2 functionality. When there are differences in the architecture, the documentation will note AWS AV-1 versus AWS AV-2.

You can create a new warehouse with data at rest encryption through Key Management Services (KMS). For more information, see Set Up Key Management Service for Data Encryption.

2.2.8

The database engine is updated to 6.1.30110.

Backend fixes and improvements were made.

2.2.4

The database engine is updated to 6.1.30108.

Enhance users ability to save, import, and export queries to and from their local system. For more information, see Save an Existing Query as a New Query, Import Queries, Export an Open Query, and Export All Queries from Saved Queries or Query History.

Enhance monitoring of Avalanche with new service checks to assist Support diagnostics.

2.2.1

The database engine is updated to 6.1.30107.

The Warehouse Details page is updated with a new menu on the left side of the page. For more information, see Warehouse Details.

The ability to create database instances is added to Avalanche. For more information, see Create a Database Instance. For information about the differences between warehouses and databases, see Comparing Warehouses and Databases.

Instructions on adding SSO users is updated at Add SSO Users.

2.1.18

The database engine is updated to 6.1.30105.

Backend fixes and improvements were made.

2.1.15

Backend fixes and improvements were made.

2.1.14

Account Administrators may monitor AU usage using the Administration interface. For more information, see Monitor AU Usage.

A new status, “Backing Up,” is added. For more information, see Warehouse Details and Automated Backup Process.

2.1.10

Nine monitoring tables from the imadb database are available for querying to those with useradmin profiles:

• ima_dbms_server_status

• ima_gca_connections

• ima_locklists

• ima_locks

• ima_log_transactions

• ima_resources

• ima_server_sessions

• ima_server_sessions_query

• ima_server_sessions_extra

For more information, see Working with Monitoring (imadb) Tables.

A Recurrence interval of “Schedule Once” is added to warehouse scheduling. For more information, see Schedule a Warehouse.

2.1.7

Backend fixes and improvements were made.

2.1.6

The database engine was updated to 6.1.30104.

Two new monitoring capabilities are added: Cluster CPU Load and Execution Memory. For more information, see Cluster CPU Load and Execution Memory.

2.0.25

Long-running queries are now terminated after 24 hours. For more information, see Query Editor Troubleshooting.

2.0.24

The database engine was updated to 6.1.30102.

You may now scale warehouses up or down while they are running. For more information, see Scale a Warehouse.

2.0.17

The database engine was updated to 6.1.30101.

The login page now supports logging in to Avalanche using your Actian ID or your organization’s Single-Sign-on credentials. For more information, see Log In.

You can now modify the idle stop period for Google Cloud warehouses. For more information, see Modify Idle Stop Period (Google Cloud Only).

Idle stop now supports periods of 15 and 30 minutes. For more information, see Create a New Warehouse.

You can open a service request with Actian Support on the Administration page. For more information, see Open a Service Request. If you are an administrator, you may contact Actian Support directly; see Contact Support.

2.0.11

The database engine was updated to 6.1.0-30101.

Google Cloud Platform is now supported. For more information, see Set Up Google Cloud Access.

The Query Editor was redesigned for a better user experience. For more information, see Using the Query Editor.

Last modified date: 10/30/2024