Hi,
db2 client: DB2 V8.2 FP9a on Windows XP SP3
db2 server: DB2 V9.5 FP2a on Linux/390

I executed command from my db2 client:
db2look -d mydatabase -e -nofed -z table_schema -t table_name -i username -w password

The output is:
===================

-- USER is:
-- Specified SCHEMA is: TABLE_SCHEMA
-- The db2look utility will consider only the specified tables
-- Creating DDL for table(s)
-- This CLP file was created using DB2LOOK Version 8.2
-- Timestamp: 18.2.2009 14:20:59
-- Database Name: DNALCAD
-- Database Manager Version: DB2/LINUXZ64 Version 9.5.2
-- Database Codepage: 912
-- Database Collating Sequence is:µ8|Ô¨E

-- Binding package automatically ...
-- Bind is successful
-- Binding package automatically ...
--An error has occured during Binding

Error Message =
SQL0001N Binding or precompilation did not complete successfully.


SQLCA
Size = 136
SQLCODE = -1
Tokens = C:\PROGRA~1\IBM\SQLLIB\BND\DB2LOOK.BND
RDS fn = sqlajbnd
RC = 0x0000 = 0
Reason = 0x0000 = 0
Reason2 = 0x0000 = 0
Warning flags =

--An error has occured during Binding

Error Message =
SQL0031C File "C:\DB2LOOK.BND" could not be opened.

SQLCA
Size = 136
SQLCODE = -31
Tokens = C:\DB2LOOK.BND
RDS fn = sqlajbnd
RC = 0x0000 = 0
Reason = 0x0000 = 0
Reason2 = 0x0000 = 0
Warning flags =

===================

Is there any limitation accessing v9.5 server from v8.2 client.

we have a similar problem with both installation at v9
opening a pmr did not resolve the problem as they state tat db2look should be executed locally or through a schedule (also local)

przytula_guy, I have always executed db2look remotely for years, I think from DB2 v5 and it worked OK to version 8.2. Few weeks ago we have migrated to v9.5 and this db2look remotely stopped working. Strange.

I have also tried to execute db2look remotely from v9.5 client and it worked OK. So it looks like there is some kind of limitation with v8.2 client accessing v9.5 server.

I wouldn't be so surprised about that, given that the system catalog structure changed quite significantly between those versions.