Troubleshooting
Problem
db2look failing with "Recreate table DDL failed with rc = -2146303891" when executed from a cron job
Symptom
On a DB2 Partitioned Database, using cronjob to execute db2look fails to generate DDL for all tables in the database. The following messages are generated in the db2diag.log :
2013-04-06-21.17.09.712948-240 I184594438E502 LEVEL: Severe
PID : 3700 TID : 46921351686464PROC : db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB : SAMPLE
APPHDL : 1-38315 APPID: *N1.db2inst1.130407011307
AUTHID : DB2INST1
EDUID : 99864 EDUNAME: db2agent (SAMPLE) 1
FUNCTION: DB2 UDB, catalog services, sqlrlCreateTableDDL, probe:0
RETCODE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
"SQLCA has already been built"
2013-04-06-21.17.09.713051-240 I184594941E587 LEVEL: Error
PID : 3700 TID : 46921351686464PROC : db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB : SAMPLE
APPHDL : 1-38315 APPID: *N1.db2inst1.130407011307
AUTHID : DB2INST1
EDUID : 99864 EDUNAME: db2agent (SAMPLE) 1
FUNCTION: DB2 UDB, relation data serv, sqlrr_recreate_ddl, probe:150
DATA #1 : String, 51 bytes
Recreate table DDL failed with rc = -2146303891.
DATA #2 : Hexdump, 4 bytes
0x00002AACBA7EAF88 : 6D00 1280 m...
The reason code -2146303891 is mapped to SQL0902C which means that "A system error occurred and subsequent SQL statements cannot be processed."
[{"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"}],"Version":"9.7;9.5;10.1","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
swg21636248