How can I obtain my database version?

Sometimes a product depends on the version of the database

So you want to obtain this version. This is how to do that.

Step-by-step guide

Oracle:

Using Sqlplus:

select version from PRODUCT_COMPONENT_VERSION where product like '%Database%';

MS Sql Server

Use: MS SQL Server Management Studio

print @@version


DB2 for LUW

db2lim -l

Or issue this command


SELECT INSTALLED_PROD_FULLNAME, PROD_RELEASE FROM SYSIBMADM.ENV_PROD_INFO;


DB2 for iSeries

Use System I Navigator

Select connections

Select properties

There you see it