How to find out which version of DB2

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
psankar
Member
Posts: 18
Joined: Tue Jul 21, 2009 1:47 pm

How to find out which version of DB2

Post by psankar » Thu Jul 23, 2009 11:04 am

Hi,
In our project we are using PLATINUM DB2,I want to know on which version of DB2 I am working.

Suggest me the way.

Thanks.

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Thu Jul 23, 2009 8:20 pm

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

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Thu Jul 23, 2009 8:21 pm

But for above command one needs to have the proper security permission.
Regards,
Anuj

psankar
Member
Posts: 18
Joined: Tue Jul 21, 2009 1:47 pm

Post by psankar » Fri Jul 24, 2009 8:52 am

Thanks!! Anuj.

I have tried that command,but getting error..Access Rejected.As you told we should have that access..

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Fri Jul 24, 2009 10:16 pm

Other alternative is your pre-compiler output that will tell you what version of DB2 you compiled.
Regards,
Anuj

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others