How to check DB2 version in AS/400 green screen command line?

5 pts.
Tags:
AS/400 administration
AS/400 commands
DB2/400
Green Screen
IBM DB2
How to check db2 version in as400 green screen command line?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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 —

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • WoodEngineer
    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.
    6,715 pointsBadges:
    report
  • Hiraju11
    [...] How to check DB2 version in AS/400 green screen command line? [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following