How to determine FixPack level? 
Author Message
 How to determine FixPack level?
Hello -

Is there a way to determine to which FixPack DB2 7.1 has been patched to?

TIA -

Brian



Sun, 09 May 2004 01:08:24 GMT
 How to determine FixPack level?

use command db2level

Mike


Quote:
> Hello -

> Is there a way to determine to which FixPack DB2 7.1 has been patched to?

> TIA -

> Brian



Sun, 09 May 2004 06:09:35 GMT
 How to determine FixPack level?
On Unix:

# more sqllib/Readme/en_US.iso88591/Release.Notes

Release Notes

IBM(R) DB2(R) Universal Database
Release Notes

Version 7.2/Version 7.1 FixPak 4

Quote:

> Hello -

> Is there a way to determine to which FixPack DB2 7.1 has been patched to?

> TIA -

> Brian



Sun, 09 May 2004 07:40:35 GMT
 How to determine FixPack level?
Brian,

Try the DB2LEVEL command.  It will tell you the WR level that you are
at, and from the fixpack website, you can determine which WR
corresponds to which fixpack.  Not elegant, but it will do!

Mairhtin O'Feannag
ImadeThis.com

Quote:

> Hello -

> Is there a way to determine to which FixPack DB2 7.1 has been patched to?

> TIA -

> Brian



Sun, 09 May 2004 08:23:57 GMT
 How to determine FixPack level?
Hi,

And is there a way to do this in SQL or by queriing a special register ?

Thanks,

Damien


Quote:
> use command db2level

> Mike



> > Hello -

> > Is there a way to determine to which FixPack DB2 7.1 has been patched
to?

> > TIA -

> > Brian



Tue, 11 May 2004 19:08:25 GMT
 How to determine FixPack level?
Hi,

Take a look at
sqllib/include/sqludf.h: sqludf_dbinfo
 A simple C UDF will do the job to haul the platform and version into
SQL.

There should also be a java API to the dbinfo structure

Cheers
Serge
--
Serge Rielau
DB2 UDB SQL Compiler Development
IBM Software Lab, Canada



Wed, 12 May 2004 00:38:53 GMT
 How to determine FixPack level?
As of version 7.2, we increment the third value on the version level in the
Connect whenever we add function in a fixpak. Version 7.2 with Fixpak 3 is:
7.2.1. Version 7.2 with Fixpak 4 installed returns this on a CONNECT: 7.2.2.
This approach is also used on OS/390 and AS/400.

Quote:

> Hi,

> And is there a way to do this in SQL or by queriing a special register ?

> Thanks,

> Damien


> > use command db2level

> > Mike



> > > Hello -

> > > Is there a way to determine to which FixPack DB2 7.1 has been patched
> to?

> > > TIA -

> > > Brian

--

Certified DB2 Application Developer, DB2 Administrator
For DB2 Service: www.ibm.com/software/data/db2/udb/winos2unix/support
See DB2 tech articles at: www7b.boulder.ibm.com/dmdd/


Fri, 14 May 2004 21:14:06 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. Determining SP level in SQL Server client installation

2. Determine isolation level

3. t-sql to determine service pack level

4. Determining the current transaction isolation level

5. Determining SQL Server 7 Service pack level

6. SQL 6.5, How do I determine patch level?

7. Determine SP level

8. Determining SP level

9. determine service pack level

10. Determining Transaction Isolation Level

11. How to determine the EBF level of Open Client on OpenVMS

12. How to determine isolation level ?


 
Powered by phpBB® Forum Software