Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: db2look reports error " Binding or precompilation did not complete successfully"

    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.
    Last edited by grofaty; 02-18-09 at 09:30.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    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)
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    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.
    Last edited by grofaty; 02-18-09 at 13:33.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by grofaty
    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.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •