How to check db2 version

Question

How to check db2 version on Z/OS using only SQL commands?

Thanks, Melita

Answer 1

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.

Answer 2

SYSIBM.VERSION session variable?

Answer 3

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