The current release of IBM® Db2® Warehouse on Cloud offers the following new features and functions. Any changed or deprecated functions that require changes on the client side are also noted here.
26 Oct 2020
- A new Db2 engine based on 126.96.36.199. For more information about Db2 11.5.4, see the what's new and the following list of resolved APARs.
- New features are available through the console interface:
- The historical monitoring capability gives you the ability to view trends in your database performance, and analyze the database responsiveness, query performance, database throughput, and bottlenecks that are impacting your applications. The historical monitoring settings can be configured to control the volume of monitoring metrics collected and persisted for future analysis. Enable historical monitoring by logging into the console and navigating to Administration > Settings.
- You can scale the CPU/memory and storage available to your database in an integrated manner from the Db2 Warehouse on Cloud console. The bluadmin user has the privilege to scale by default. In order to enable other users, grant them the
- You now have a read-only view of all of the workloads running on your database, and the ability to cancel your own queries and kill your own applications.
- Support for capturing database events using an external Guardium server. This feature can be requested by opening a support case.
14 Sept 2020
4 June 2020
27 May 2020
16 April 2020 --> Deferred
- Port 50000 (the non-SSL port) will be closed on all instances unless a support ticket was opened to request that the port be kept open. An earlier email notification was sent to alert users of this upcoming change and the requirement to open a support ticket if you have legacy applications that must use this port.
- The Db2 engine will be updated to 188.8.131.52. To make use of new functionality included in Db2 184.108.40.206, make sure you download the 11.5 client driver from here. Before this update, the level on the system for most customers was close to the 11.5 GA level. For a list of APARs included in 220.127.116.11 and 18.104.22.168, see here.
- The console and Aspera components will also be updated with fixes.
9 Mar 2020
25 Feb 2020
14 Jan 2020
30 Nov 2019
14 Nov 2019
- Performance improvements
- Security enhancements
- Weak password detection. An attempt to update a password will now fail if the new password contains a string that is easy to guess.
- Fixed term passwords. An administrator can now set a fixed term password for another user. When the user logs in with this password, they are prompted to change the password.
- One additional behavior change. The following parameter must now be supplied when invoking the /auth/token REST API call. Previously this parameter was optional: -H "Content-Type: application/json" . The documentation will be updated shortly to reflect this change.
- Additional fixes
$ sudo /Library/Application\ Support/Aspera/Aspera\ Connect/uninstall_connect.sh
$ ~/Library/Application\ Support/Aspera/Aspera\ Connect/uninstall_connect.sh
11 Nov 2019
7 Oct 2019
26 August 2019
- Updated Db2 engine containing Oracle compatibility improvements, BLU compression enhancements, added support for LOB datatypes, concurrency improvements for some types of update and delete statements on column-organized tables, performance improvements for Spatial Analytics, and increased support for external tables.
- Updated console, with fixes for several defects including an intermittent failure while loading using Lift, and an error that caused file systems to fill up too quickly. The console also now displays the status during CPU/memory and storage expansion requests.
- Requirements for passwords have been strengthened. The minimum password length is now 15 characters (up from 12), and passwords must contain at least one of each of the following types of character: upper case letter, lower case letter, digit, and special character. When a user's legacy password does not meet the new requirements, the user will be prompted to change their password when they log in to the console.
- Db2 audit functionality is now available by default on all Flex systems on IBM Cloud.
25 June 2019
4 June 2019
3 June 2019
21 May 2019
29 March 2019
- The “Flex” plan is ideal for storage-dense workloads, inexpensive query of large data sets, and a development/test environment for cloud.
- The “Flex Performance” plan is ideal for high-performance production workloads that prioritize compute performance over storage density.
18 March 2019
Beginning on March 18th, an updated console interface will be made available for all Db2 Warehouse on Cloud Flex plans. The console includes the following changes:
For users with admin authority:
- The landing page has been redesigned and now includes a monitoring overview. The previous landing page contained three panels -- "Quick stats", "Connect" and "Load history". These panels have been moved. "Quick stats" is now available as hover help for the Storage item in the top menu bar; "Connect" has been moved to "Connection Information > Connect"; and "Load history" has been moved to "Load > Load history".
- Three new pages ("Explore - Views" ; "Explore - Authorizations" ; "Monitor - Storage") have been added.
- The "Explore - Tables" page has been redesigned, with new functionality added.
- The "RUN SQL" page has been redesigned.
- The console now supports Load from COS (Cloud Object Storage).
- New APIs have been added to allow you to query monitoring and metrics information, and to allow you to query information on schemas and SQL jobs.
For non-admin users:
- The landing page has been replaced by a redesigned version of the "Explore - Tables" page. See the description above for information on where you can find the contents of the old landing page.
- One new page ("Explore - Views") has been added.
- The "RUN SQL" page has been redesigned.
- The console now supports Load from COS.
- New APIs have been added. See the description above.
31 January 2019
The Db2 Warehouse on Cloud Flex Performance plan now supports compressed database sizes up to 96TB.
10 January 2019
Db2 Warehouse on Cloud Flex plans now support Identity and Access Management (IAM). This feature enables you to securely authenticate users for platform services and control access to resources consistently across the IBM Cloud platform. For more information, refer to the Knowledge Center.
2 November 2018
Db2 Warehouse on Cloud non-Flex plans have been updated with a new Db2 engine, an updated console, and additional fixes. The non-Flex plans now support Identity and Access Management (IAM). This feature enables you to securely authenticate users for platform services and control access to resources consistently across the IBM Cloud platform. For more information, refer to the Knowledge Center.
1 November 2018
Db2 Warehouse on Cloud Flex and Flex Performance plans are now HIPAA ready. Both plans have implemented required controls commensurate with the Health Insurance Portability and Accountability Act of 1996 (HIPAA) Security and Privacy Rule requirements. For information about how to order a HIPAA-ready Db2 managed service, contact your IBM sales representative or send email to: CloudDigitalSales@us.ibm.com.
17 October 2018
Db2 Warehouse on Cloud Flex service is now generally available. Like the Flex Performance plan released earlier in 2018, the new Flex plan includes independent scaling of storage and compute, self-service backup and restore, and fast-recovery HA. It is optimized for storage-dense workloads. For more information, see here.
16 August 2018
A new user interface is now available on all entry plans. Refer to the April 3rd update below for a list of new and changed functionality and for information about clearing your browser cache.
24 July 2018
IBM Hybrid Data Management Platform is now available for Db2 Warehouse on Cloud. This plan allows you to purchase IBM FlexPoints and allocate them towards multiple resources with a single subscription. For more information, see here.
3 April 2018
Db2 Warehouse on Cloud (non-Flex plan, non-entry plan) introduces a new console user interface. After your service is updated with the new console, follow the steps here to clear your web browser cache.
The new console includes the following new and changed functionality:
- On the CONNECTIONS page, you can view applications that connect to the current Db2 Warehouse on Cloud. When an application might impact the performance of the database, you can use the Force Application button to disconnect the application. You can also filter the applications using different metrics, and export the application status to a spreadsheet file.
- On the STORAGE page, you can view the storage status in a list or a heat map, either by schema or by table. You can also filter the storage status using different metrics, and export the storage status to a spreadsheet file.
- On the IN-FLIGHT EXECUTIONS page, you can view the SQL statements that are currently running on the database. You can also filter the SQL statements using different rules, and export the SQL statements to a spreadsheet file.
- Both administrator and normal users can use the monitoring features. For a normal user, only the data of the current user can be monitored and displayed.
- When you type SQL statements within the SQL editor, the syntax can be validated in real time and recommended fixes for the SQL statement are displayed as annotations in the SQL editor.
- You can save the SQL statements in the SQL editor either to the server, or to a .sql file in order to share the script with other users.
- By adding a FAVORITES tag to the saved SQL statements, you can load the SQL statements into the SQL editor with just one click on the drop-down menu of the Favorites button.
- You can export the result of one or more queries to a spreadsheet file, such as an .xlsx file or a .CSV file.
- When you access the console from different browsers, the history of SQL statements executed within the SQL editor is also displayed.
- You can also choose to run a subset of a group of SQL statements from the SQL editor.
- The SQL statements that you are working on are automatically saved and will be restored if you lose your connection to the console.
- Forgot password support: For non-entry plans, you can use your user ID and email address to reset the password if you forget your password. You can also use the /auth/reset REST API to reset the password. The reset instruction is sent to your email address and is valid for 24 hours. Note that you can only reset your password once within 24 hours.
- Password policy GUI support: Administrators can update or delete the existing password policy, create new password policies, and assign a specific password policy to a user on the Manage Users page, or using REST API endpoints. The principles in a password policy are enforced as follows for different user roles.
|Password expiration date||
|Password minimum length||
|Failed login attempts||
|Account lockout duration||
Support for Internet Explorer
- You can use Internet Explorer (IE) 11 to access the Db2 Warehouse on Cloud console.
- You can import data into Db2 Warehouse on Cloud using the load from external tables feature. If the original data is from PureData System for Analytics, it's recommended that you import the data using external tables because the performance is better and there is no lock on an external table.
- You can load the data from a local .csv file that is larger than 2GB. However, you need to enable the High-speed loads powered by Aspera button for a file that is larger than 10GB.
7 March 2018
Db2 Warehouse on Cloud (non-Flex plan) now supports IBM Cloud Object Store as a cloud object storage location from which to load data using Db2 utilities and SQL statements (the CREATE EXTERNAL TABLE statement) directly. Both regional and cross regional endpoints are supported. The same support is already included in the initial release of the Db2 Warehouse on Cloud Flex Performance plan.
20 February 2018
See the following announcement relating to Db2 Warehouse on Cloud:
This change was originally planned for April 2018, but will be delayed until December 2018.
13 February 2018
The Db2 Warehouse on Cloud Flex Performance plan now includes REST APIs for compute elasticity and storage expansion. These REST APIs provide customers with a programmatic interface to perform elasticity/expansion operations in addition to the Web UI. The swagger documentation for the REST APIs is available here.
31 January 2018
A new Flex Performance plan is available for Db2 Warehouse on Cloud. The Flex plan allows for independent, on-demand scaling of compute cores and storage capacity, giving clients greater control of resource consumption and increased efficiency with their operational expenses. In addition, the plan offers self-service backup and restore and fast-recovery high availability. For more information, see the following blog post.
17 November 2017
In 1Q 2018, there will be a change in how constraints are enforced in Db2 Warehouse on Cloud. For more information, see the following technote.
9 November 2017
This update includes the following compatibility updates:
- Enhanced NZPL SQL support, including support for %ROWTYPE, %TYPE, FOUND, ROW_COUNT, REFTABLE , AUTOCOMMIT and SELECT INTO record type.
- External Table extended with new options to support more native Db2 Warehouse file formats including CCSID, TIMESTAMP_FORMAT, DATE_FORMAT, and TIME_FORMAT options. Customers unloading and reloading data from Db2 Warehouse are recommended to use CCSID 1208 over ENCODING(INTERNAL) to maintain the data in unicode.
- HAVING CLAUSE now supports column aliases under SQL_COMPAT='NPS'
8 September 2017
External tables are now supported. For information about how to create them, see CREATE EXTERNAL TABLES statement.
INSERT performance improvements
Parallel inserts, vectorized inserts, and reduced logging are now enabled. Parallel inserts, vectorized inserts, and reduced logging can help improve performance. You can now complete large CTAS or INSERT from SELECT operations without using the LOAD from CURSOR syntax.
Federation (formerly called "fluid query") capability is now available for Db2-based sources over non-SSL connections. You can use federation capability to access data that is located on a data source that is different from the one to which you submitted a query. Supported data sources include IBM Db2, IBM Db2 Warehouse on Cloud, IBM Db2 Warehouse, and IBM Big SQL.
18 July 2017
The following table summarizes the new offering names:
|Previous name||New name||Effective date|
|IBM dashDB for Analytics||IBM Db2 Warehouse on Cloud||July 18, 2017|
|IBM dashDB Local||IBM Db2 Warehouse||July 18, 2017|
|IBM dashDB for Transactions||IBM Db2 on Cloud||June 20, 2017|
2 May 2017
- With dashDB for Analytics, you can now use the Boolean data type for all row-organized and column-organized dashDB tables. You can implicitly or explicitly cast values from Boolean data types to integer or string data types and vice versa. You can also carry out "group by" and "order by" operations on Boolean columns. Also, dashDB offers a set of new scalar functions, each of which returns a Boolean value based on the truth value of an input expression. Boolean support is not currently available with dashDB for Transactions.
- Updates include enhancements to security requirements for cipher specs of applications that access dashDB. If your application cannot connect to dashDB, complete the steps in the following technote.
16 October 2020