Troubleshooting
Problem
IMPORT from DB2 Control center fails with error: "SQL3015N An SQL error "-805" occurred during processing."
Cause
Missing DB2 Package.
SQL0805N Package package-name was not found.
Diagnosing The Problem
Command used:
Example:
IMPORT FROM "c:\ImportError\data.txt" OF DEL METHOD P
(1, 2) MESSAGES "c:\ImportError\message.txt" INSERT INTO MYSCHEMA.TABLE1 (COLUMN1, COLUMN2);)
1) Check the message file generated, to identify the package name that is missing.
For example: The messages may be similar to:
SQL3015N An SQL error "-805" occurred during processing.
SQL0805N Package "NULLID.SQLUFH13 0X4141414141594758" was not found. SQLSTATE=51002
2) Check the following link to identify the bind file corresponding to the missing package:
http://www-01.ibm.com/support/docview.wss?uid=swg21648351
For example:
From the above error message, the missing package is NULLID.SQLUFH13, it corresponds to db2uimpm.bnd.
Resolving The Problem
To resolve the issue, create the missing package by binding the bind file identified.
For example, from the 'Diagnosing the Problem' step, we identified the bind file corresponding to missing package is db2uimpm.bnd, to bind it follow the below steps.
- On the DB2command line:
cd ../sqllib/bnd
db2 connect to <database name>
db2 bind db2uimpm.bnd blocking all grant public sqlerror continue
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Routines (SP & UDF) - SQL","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","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21665710