Return
-
Title
Getting an error :'The SQL statement failed because of a non-severe system error.' -
Description
User tried to extract DDL of tables and got error: 'The SQL statement failed because of a non-severe system error.'
-
Resolution
Contact IBM for resolution. See explanation of SQL0901N below.
-
Additional Information
SQL0901N
The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "<reason>".)Explanation:An error has occurred which is due to a system error. Processing of the
SQL statement has ended for reason "<reason>" (this is in English only
and is useful only to IBM support personnel).User response:
Record the message number (SQLCODE) and reason "<reason>".If trace was active, invoke the Independent Trace Facility at the
operating system command prompt. Then contact your technical service
representative with the following information:* Problem description
* SQLCODE
* reason "<reason>"
* SQLCA contents if possible
* Trace file if possible.Federated system users: isolate the problem to the data source failing
the request (refer to the Troubleshooting Guide to determine which data