Troubleshooting
Problem
When running the db2look command (with either one of the options: -e -ct -dp -ap -a -m -l -x -f -wlm -xs -o) the command resulted on the error "SQL0001N Binding or precompilation did not complete successfully"
Symptom
The command output could be like the following:
- -- Creating DDL for XSR objects
-- Generate statistics for all creators
-- Creating DDL for table(s)
-- Running db2look in mimic mode
-- Output is sent to file: db2look.sql
-- 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 = /home/instace/sqllib/bnd/db2lkfun.bnd
RDS fn = sqlajbnd
RC = 0x0000 = 0
Reason = 0x0000 = 0
Reason2 = 0x0000 = 0
Warning flags =
--An error has occured during Binding
Error Message =
SQL0001N Binding or precompilation did not complete successfully.
SQLCA
Size = 136
SQLCODE = -1
Tokens = /opt/ibm/db2/V10.5/bnd/db2lkfun.bnd
RDS fn = sqlajbnd
RC = 0x0000 = 0
Reason = 0x0000 = 0
Reason2 = 0x0000 = 0
Warning flags =
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Tools - db2look","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1;10.5;9.5;9.7;9.8","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
01 May 2025
UID
swg21693517