Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to check db2 version

Tags:

sql

db2

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

Thanks, Melita

like image 630
gizmo Avatar asked Sep 29 '10 13:09

gizmo

People also ask

What is DB2 version?

IBM Db2 Community Edition is a free to download, use and redistribute edition of the IBM Db2 data server, which has both XML database and relational database management system features. It is limited to four CPU cores, 16 GB of RAM and no Enterprise support and fix packs.

How do I check my DB2 version in ZOS?

There is a DISPLAY GROUP command for DB2 on z/OS®. The data returned from this command includes the version number. For example, if your DB2 command prefix is -D91C, then input /-D91C DISPLAY GROUP from SD.

How do I check if DB2 is running?

To check the status of the target DB2. From EZDB2, hyperlink on DB2 Status Summary. This link takes you to the STDB2 view (Checking the status of all DB2 subsystems), but only one DB2 is displayed. To review recent history, on the COMMAND line type TIME * * 2H to see the last 2 hours by 15-minute intervals.

What is my current DB2 version in mainframe?

Type TSO DB2I and then select DB2 COMMANDS and use -DISPLAY GROUP to get the Version.

1 Answers

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.

like image 104
CanSpice Avatar answered Sep 30 '22 22:09

CanSpice
Sign in to Comment

Related questions

MySQL COUNT with LIMIT
oracle - what statements need to be committed?
SELECT * EXCEPT
Is there a coalesce-like function in Excel?
Using the DISTINCT keyword causes this error: not a SELECTed expression
GROUP BY and COUNT using ActiveRecord
Passing Output parameters to stored procedure using dapper in c# code
What is the linq equivalent to the SQL IN operator
MySQL: View with Subquery in the FROM Clause Limitation
How to create a new database with the hstore extension already installed?
Are left outer joins and left joins the same? [duplicate]
What is the meaning of <> in mysql query?
PL/SQL block problem: No data found error
Return pre-UPDATE column values using SQL only
How can I have NHibernate only generate the SQL without executing it?
Can there be constraints with the same name in a DB?
How to create a large pandas dataframe from an sql query without running out of memory?
SQL: Alias Column Name for Use in CASE Statement
How to get the trigger(s) associated with a view or a table in PostgreSQL
How to SELECT WHERE NOT EXIST using LINQ?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!