Question Re: DB Version and Patch level in Technology Q&A

DB Version and Patch level

Former Member — Thu, 04 Feb 2010 08:53:41 GMT

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

Re: DB Version and Patch level

paul_power — Thu, 04 Feb 2010 09:10:07 GMT

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

Re: DB Version and Patch level

Frank-Martin — Thu, 04 Feb 2010 09:14:01 GMT

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 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

Re: DB Version and Patch level

Former Member — Thu, 04 Feb 2010 21:23:13 GMT

Yes all of the above and also

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

Re: DB Version and Patch level

Former Member — Mon, 13 Jul 2015 09:21:47 GMT

Thanks Paul......

For your clear explaination.