Is there a way to determine the fixpack level of a V8 client
and server programmatically? I'm aware of the db2level command,
but only want to use that as a last resort.

Thanks in advance for any help!

You can get the info from sqlca on connect.
Here is an example using the CLP but you can use other programmatic means.


PROMPT>db2 -a connect to ....

Database Connection Information

Database server = DB2/NT 8.1.3
SQL authorization ID = XXXX
Local database alias = XXX


SQLCA Information

sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 44
sqlerrmc: 1ÿ1252ÿXXXXXXXXMÿXXXXÿQDB2/NTÿ53ÿ53ÿ0ÿ1252ÿ1ÿ
sqlerrp : SQL08013
sqlerrd : (1) 1 (2) 1 (3) 0
(4) 1 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 00000

Corresponding db2level

DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08013" with
level identifier "02040106".
Informational tokens are "DB2 v8.1.3.132", "s030728", "WR21324", and FixPak
"3".


PM

"Donna Lenharth" <donna_lenharth@yahoo.com> a écrit dans le message de
news:a12f1f14.0311061409.6dbb9d6@posting.google.co m...
> Is there a way to determine the fixpack level of a V8 client
> and server programmatically? I'm aware of the db2level command,
> but only want to use that as a last resort.
>
> Thanks in advance for any help!

You can also search the samples for
dbinfo

PM