What is your Db2 build level?
Today, during a discussion, there was the question on how to find out which Db2 version is used for the Db2 on Cloud instance someone was using. There are some ways to get to that information:
- Ask the IBM support.
- Look in the related documentation.
- Use SQL.
Opening a support ticket (if you are entitled) is probably not the best way to find the Db2 build level. So what is the Db2 product documentation you need? I would recommend the page What’s New in IBM Db2 Warehouse, IBM Db2 Warehouse on Cloud, and IBM Db2 on Cloud with links pointing to:
Those support pages list dates when Db2 version updates are performed. For Db2 on Cloud, the (as of today) latest entry from May 22nd states
Service update 11.5.9.0.00000.025 is now available for the Standard and Enterprise Plans and consists of updates to Db2 11.5.9.
Service update 12.1.1.0.00000.004 is now available for the Performance Plan and consists of updates for Db2 v12.1.1.
Db2 Administrative Procedures and Views
If you already have an instance of Db2 on Cloud or Db2 Warehouse on Cloud “on-hand”, simply using the built-in administrative procedures and views provides quick help. Here, as example, I am using ENV_SYS_INFO and thereafter ENV_INST_INFO:
SELECT * from SYSIBMADM.ENV_SYS_INFO
results info
and
SELECT * FROM SYSIBMADM.ENV_INST_INFO
produces the following output:
So, my instance of Db2 on Cloud is on level 11.5.9 and on a specific build.
If you have feedback, suggestions, or questions about this post, please reach out to me on Mastodon (@data_henrik@mastodon.social) or LinkedIn.