IBM Support

db2exfmt command may fail with a SQL0035N error message.

Troubleshooting


Problem

Sometimes the db2exfmt command may fail to execute and return a SQL0035N error message. The below example clearly describes the problem : $ db2exfmt -d sample -g TIC -w -1 -n % -s % -# 0 -o exfmt.txt DB2 Universal Database Version 9.7, 5622-044 (c) Copyright IBM Corp. 1991, 2009 Licensed Material - Program Property of IBM IBM DATABASE 2 Explain Table Format Tool Connecting to the Database. Connect to Database Successful. Binding package - Error during Bind, near line 7978. Error Message = SQL0035N The file "db2exfmt.msg" cannot be opened. SQLCA Size = 136 SQLCODE = -35 Tokens = db2exfmt.msg Function= sqlabndx RC = 0x0000 = 0 Reason = 0x0000 = 0 Reason2 = 0x0000 = 0 Warning flags = Press ENTER to Continue ... Error during bind. Bind messages can be found in db2exfmt.msg

Resolving The Problem

To resolve the problem, issue the following bind command and then run the db2exfmt command again :

db2 bind db2exfmt.bnd blocking all grant public.
The file db2exfmt.bnd is located at ".../sqllib/bnd".

[{"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Business Unit":{"code":"BU001","label":"Analytics Private Cloud"},"Component":"Programming Interface - Bind","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;10.1","Edition":""}]

Document Information

Modified date:
16 June 2018

UID

swg21614629