DB Version and Patch level

[Former Member]

Hi Friends

Where can i see DB2 Version and patch level on ECC 6.0?

For Windows Database : DB2 or DB6??

Patch level?

Thanks

srinivas

[paul_power · Accepted solution]

Hi Srinivas,

From within R3 you can go to system -> status -> in the bottom left of the window that appears you will see, Database reease with a value of (for example) 09.05.0001

This would be db2 v9.5 fixpack1

On database level, simply issue the command: db2level

to show what release and fixpack level you are currently running.

Hope this helps,

Paul

[Former Member · Accepted solution]

Thanks Paul......

For your clear explaination.

[Frank-Martin]

Hi Srinivas,

DB6 is a SAP abbreviation for "DB2 for Linux, Unix and Windows" .

The DB2 version and FP level of your database server can be found in SAP transaction ST04 or DBACOCKPIT.

In SM50 you can view the work process traces to display the server and client level

C Running with UTF-8 Unicode

C Running with CLI driver

C

C Wed Oct 21 17:03:27 2009

C DB2 client driver version '09.05.0001'

C Connected to DB2 server type 'DB2/LINUXX8664'

C Connected to DB2 version '09.05.0002'

If you need more detailed information you have to use "db2level" in a DB2 CLP window on the DB server.

Regards

Frank

[Former Member]

Yes all of the above and also

/usr/local/bin/db2ls , which also gives installation details.