How To Check Db2 Version In Mainframe?
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
To check the DB2 version in a mainframe, you can use the DSNTIJRS program. DSNTIJRS is a DB2 utility that can be used to query the DB2 catalog tables to determine the version of DB2 that is installed on the system. To run the program, you will need to have DB2 system privileges.
Once you have the necessary privileges, you can run the program by typing the following command at a TSO prompt:
DSNTIJRS
This will display the version of the DB2 system that is installed. If the version is not displayed, you can also use the DSNTEP2 utility to retrieve the version of the DB2 system.
The simplest way to check the DB2 version in a mainframe is by issuing the command ‘DSNHLI RELEASE’ on DB2 command line processor. Alternatively, you can check the DB2 version from the SYSIBM catalog table SYSLGRNX.