How to check db2 version

Question

How to check db2 version on Z OS using only SQL commands   Thanks  Melita

User · Answer

I used   SELECT   FROM TABLE SYSPROC ENV GET INST INFO        from tyranitar and that worked on Z OS  Here s what I got   SERVICE LEVEL DB2 v9 7 0 6   I d vote up if I could  Thanks

User · Answer

In z OS while on version 10  use of CURRENT APPLICATION COMPATIBILITY is not allowed  You will have to resort to  SELECT GETVARIABLE  SYSIBM VERSION   AS VERSION         GETVARIABLE  SYSIBM NEWFUN    AS COMPATIBILITY FROM SYSIBM SYSDUMMY1   Here is a link to all the variables available  https   www ibm com support knowledgecenter SSEPEK 12 0 0 sqlref src tpc db2z refs2builtinsessionvars html db2z refs2builtinsessionvars

User · Answer

You can query for the built-in session variables with SQL  To identify the version of DB2 on z OS  you need the SYSIBM VERSION variable  This will return the PRDID - the product identifier  You can look up the human-readable version in the Knowledge Center    SELECT GETVARIABLE  SYSIBM VERSION   FROM SYSIBM SYSDUMMY1   -- for example  the above returns DSN10015 -- DSN10015 identifies DB2 10 in new-function mode  see second link above

User · Answer

There is a typo in your SQL  Fixed version is below   SELECT GETVARIABLE  SYSIBM VERSION   FROM SYSIBM SYSDUMMY1   I ran this on the IBM Mainframe under Z OS in QMF and got the following results  We are currently running DB2 Version 8 and upgrading to Ver 10   DSN08015  -- Format seems to be DSNVVMMM -- PPP IS PRODUCT STRING  DSN  -- VV IS VERSION NUMBER E G  08 -- MMM IS MAINTENANCE LEVEL E G  015

User · Answer

You can try the following query   SELECT service level  fixpack num FROM TABLE    sysproc env get inst info      as INSTANCEINFO   It works on LUW  so I can t guarantee that it ll work on z OS  but it s worth a shot

User · Answer

Both worked for me   SELECT   FROM TABLE SYSPROC ENV GET INST INFO       or   SELECT   FROM SYSIBMADM ENV INST INFO

User · Answer

For DB2     SELECT   FROM SYSIBMADM ENV INST INFO  - SERVICE LEVEL

User · Answer

SELECT GETVARIABLE   SYSIBM VERSION    FROM SYSIBM SYSDUMMY1  -- PPP IS PRODUCT STRING  DSN  -- VV IS VERSION NUMBER E G   10  11 -- M IS MAINTENANCE LEVEL E G  5  -DISPLAY GROUP  THIS WILL DISPLAY THE LEVEL CM  ENFM  N

User · Answer

In AIX you can try   db2level   Example output   db2level DB21085I  This instance or install  instance name  where applicable   db2inst1   uses  64  bits and DB2 code release  SQL09077  with level identifier  08080107   Informational tokens are  DB2 v9 7 0 7    s121002    IP23367   and Fix Pack  7   Product is installed at   db2 09 07

User · Answer

Another one in v11   select CURRENT APPLICATION COMPATIBILITY from sysibm sysdummy1   Result   V11R1   It s not the current version  but the current configured level for the application

User · Answer

There is also the env inst info admin view  As with CanSpice I can only vouch for LUW  but there should at least be a similar view available for Z OS   SELECT   FROM SYSIBMADM ENV INST INFO

User · Answer

SELECT GETVARIABLE  SYSIBM VERSION   FROM SYSIBM SYSDUMMY1

User · Answer

db2ls command will display the db2level along with the install path and install date   To determine the specific product installed   db2ls -p -q -b  lt installpath gt    on db2ls command    The following will appear   Install Path       Level   Fix Pack   Special Install Number   Install Date    Installer UID --------------------------------------------------------------------------------------------  opt ibm db2 V9 7  9 7 0 7        7                      Thu Aug  1 12 25 53 2013 CDT     0   visit IBM Website

User · Answer

To find out the fixpak information using command prompt  db2level  To find out the version and license information using command prompt  db2licm -l  C  Users Administrator gt db2level DB21085I  This instance or install  instance name  where applicable   DB2   uses  64  bits and DB2 code release  SQL10051  with level identifier  0602010E   Informational tokens are  DB2 v10 5 100 63    s130816    IP23521   and Fix Pack   1   Product is installed at  C  SQLLIB  with DB2 Copy Name  DB2COPY1     C  Users Administrator gt db2licm -l Product name                       IBM Data Server Client  Product identifier                 db2client  Version information                10 5

User · Answer

Try the first or the second   SELECT   FROM TABLE SYSPROC ENV GET INST INFO     SELECT   FROM TABLE SYSPROC ENV GET PROD INFO     SELECT   FROM TABLE SYSPROC ENV GET SYS INFO

[sql] How to check db2 version

Examples related to sql

Examples related to db2