Production incidentBeginner15 min
Incident: SQLCODE -180 loading partner transactions
Partner load failed: DSNT408I SQLCODE = -180 First day of the new payments partner (channel PTN)
The new payments partner sends three transactions a day. The load script built from their file is:
INSERT INTO TRANSACTION VALUES (61, 'A0000201', '2026/10/19', 250.00, 'PTN'), (62, 'A0000601', '2026/10/19', -40.00, 'PTN'), (63, 'A0001001', '2026/10/20', 75.50, 'PTN')
It failed with SQLCODE -180. Find out why and load the three transactions.
What you will do
- Run the script and read the -180
- Work out which value Db2 rejects
- Load the transactions
Simulated: the Lab runs entirely in your browser on a simulated, fictional z/OS system. Nothing is sent to or run on a real mainframe.
Free, no account needed.
Your work is saved on this device; sign in to keep it in your account.