How to check DB2 version in AS/400 green screen command line?
5 pts.
0
Q:
How to check DB2 version in AS/400 green screen command line?
How to check db2 version in as400 green screen command line?
ASKED: Apr 3 2009  5:34 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
1005 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
The DB/400 version is the OS/400 version

Option 1 issue command DSPOBJD OBJ(QSYS/QCMD) OBJTYPE(*PGM) press 8
system level ... V6R1M0 <-- that's the answer

Option 2 - do a print screen - usually ctrl-pause
look at the spool file 5761SS1 --> V6R1M0 <-- 080215 it will be on the second line

I'm sure there are other ways to get this info.

Phil

Here's a CL program I use on our system. I just call the CL and I get the info.
---CL Program: DSPVER ---
PGM

DCL VAR(&RELEASE) TYPE(*CHAR) LEN(6)
DCL VAR(&RCVVAR) TYPE(*CHAR) LEN(32)
DCL VAR(&RCVLEN) TYPE(*CHAR) LEN(4)
DCL VAR(&PRODINFO) TYPE(*CHAR) LEN(27)
DCL VAR(&ERRCODE) TYPE(*CHAR) LEN(8)

CHGVAR VAR(%BIN(&RCVLEN 1 4)) VALUE(32)
CHGVAR VAR(%BIN(&ERRCODE 1 4)) VALUE(0)

CHGVAR VAR(%SST(&PRODINFO 1 7)) VALUE('*OPSYS')
CHGVAR VAR(%SST(&PRODINFO 8 6)) VALUE('*CUR' )
CHGVAR VAR(%SST(&PRODINFO 14 4)) VALUE('0000' )
CHGVAR VAR(%SST(&PRODINFO 18 10)) VALUE('*CODE' )

CALL PGM(QSZRTVPR) PARM(&RCVVAR +
&RCVLEN +
'PRDR0100' +
&PRODINFO +
&ERRCODE )

CHGVAR VAR(&RELEASE) VALUE(%SST(&RCVVAR 20 6))
SNDMSG MSG('Release: '||&RELEASE) +
TOUSR(*REQUESTER)
ENDPGM
--- END OF CL ---
Last Answered: Apr 6 2009  3:14 PM GMT by Koohiisan   1005 pts.
Latest Contributors: Philpl1jb   24610 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

WoodEngineer   2280 pts.  |   Apr 7 2009  4:26PM GMT

This works from a green-screen comand line.
GO LICPGM.
Take option 10 - Display installed licensed programs.
When the list of programs appears, press F11 - Display release to see the release level.

 
0