How to check db2 version

by

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.

More Related Contents:

  1. DB2 Comma Separated Output by Groups
  2. Does DB2 have an “insert or update” statement?
  3. how to transform comma separated column into multiples rows in db2
  4. INNER JOIN in UPDATE sql for DB2
  5. Pivoting in DB2
  6. Regular Expressions in DB2 SQL
  7. How to resolve SQL0418N Error
  8. DB2 Query to retrieve all table names for a given schema
  9. MySQL: Alternatives to ORDER BY RAND()
  10. IN vs ANY operator in PostgreSQL
  11. sql query to return differences between two tables
  12. Generate SQL Create Scripts for existing tables with Query
  13. SQL Server 2005 How Create a Unique Constraint?
  14. Is there any boolean type in Oracle databases?
  15. Physical vs. logical (hard vs. soft) delete of database record? [closed]
  16. sql server select first row from a group
  17. Convert Unixtime to Datetime SQL (Oracle)
  18. sqlite alter table add MULTIPLE columns in a single statement
  19. CTE error: “Types don’t match between the anchor and the recursive part”
  20. Automate Version number Retrieval from .Dtsx files
  21. Adding a new SQL column with a default value
  22. The text, ntext, and image data > types cannot be compared or sorted, except when using IS NULL or LIKE > operator
  23. Why do we need GROUP BY with AGGREGATE FUNCTIONS?
  24. Comma Separated values with SQL Query
  25. Looping through column names with dynamic SQL
  26. What’s the purpose of SQL keyword “AS”?
  27. Using SQL Server as a DB queue with multiple clients
  28. Can a COMMIT statement (in SQL) ever fail? How?
  29. “SELECT *” vs “SELECT ” for performance
  30. Postgres INTERVAL using value from table

Leave a Comment