sql - How to check db2 version

Question

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

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

Thanks, Melita

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

294 views

1 Answer

深蓝 · Answer 1 · 2021-10-17T02:45:57+0000

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.