DB2 sql upadate failing
I am getting this DB2 Sql error updating
> update Test.sls77_01 set uttms = 'AA'
SQL State: 38501
Vendor Code: -443
Message: [CEE9901] Application error. RNX1216 unmonitored by CXT001U at statement 2100000001, instruction X'0000'. Cause . . . . . : The application ended abnormally because an exception occurred and was n ot handled. The name of the program to which the unhandled exception is sent is CXT001U CXT001U CXT001U. The program was stopped at the high-level language statement number(s) 2100000001 at the time the message was sent. If more than one statement number is shown, the program is an optimized ILE program. Optimization does not allow a single statement number to be determined. If *N is shown as a value, it means the real value was not available. Recovery . . . : See the low level messages previously listed to locate the cause of the exception. Correct any errors, and then try the request again.
> update Test.sls77_01 set uttms = 'AA'
SQL State: 38501
Vendor Code: -443
Message: [CEE9901] Application error. RNX1216 unmonitored by CXT001U at statement 2100000001, instruction X'0000'. Cause . . . . . : The application ended abnormally because an exception occurred and was n ot handled. The name of the program to which the unhandled exception is sent is CXT001U CXT001U CXT001U. The program was stopped at the high-level language statement number(s) 2100000001 at the time the message was sent. If more than one statement number is shown, the program is an optimized ILE program. Optimization does not allow a single statement number to be determined. If *N is shown as a value, it means the real value was not available. Recovery . . . : See the low level messages previously listed to locate the cause of the exception. Correct any errors, and then try the request again.
ASKER
still getting the error
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The sqlcode -443 means that a routine ( most likely a trigger in your case ) is failing with one or more errors.
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/codes/src/tpc/n443.html
As the message clearly states (which is probably an in house application message as I don't recognize this type of message as a typical DB2 message ) the statement number 2100000001 in the program CXT001U is causing your error.
You should call/send a messsage to your DB2 DBA to aid you in further analysis on this as more errors could be a root cause of your update failing.
Regards,
Tomas Helgi