Thursday, November 20, 2008

DB2 Version and other info

How do you know the current DB2 version?
or
How will you confirm which phase(while migrating from V7 to V8 - Compatibility mode, Enable New Function mode and New Function mode) of migration currently going on for your DB2?

There is a simple command which can display all these information.
Go to command option of the DB2 and execute below command

-DIS GROUP
The output will be like:
DSN7100I + DSN7GCMD,
*** BEGIN DISPLAY OF GROUP(........) GROUP LEVEL(...),

GROUP ATTACH NAME(....),
--------------------------------------------------------------------
DB2 DB2 SYSTEM IRLM,
MEMBER ID SUBSYS CMDPREF STATUS LVL NAME SUBSYS IRLMPROC
-------- --- ---- -------- -------- --- -------- ---- --------
........ 0 DSN2 + ACTIVE 710 MVS1 TRLM DSN2TRLM
--------------------------------------------------------------------
*** END DISPLAY OF GROUP(........),
DSN9022I + DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION,

Cheers..

Prakash
IBM Certified DB2 Administrator

No comments: