How to check db2 version

sql db2

gizmo · Sep 29, 2010 · Viewed 142.7k times · Source

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

Thanks, Melita

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.