Incident: SQLCODE -911 in the morning balance check
Your 06:30 balance check in SPUFI failed: DSNT408I SQLCODE = -911 ... REASON 00C9008E Change CHG4512 (fee adjustment job PAYADJ) was planned for Saturday
Every morning you run the balance check in SPUFI: SELECT TYPE, COUNT(*), SUM(BALANCE) FROM ACCOUNT GROUP BY TYPE. Today it failed with SQLCODE -911. Change CHG4512, a one-off fee adjustment job called PAYADJ, was planned for Saturday but was released into this morning's batch by mistake. The application owner has confirmed PAYADJ may be stopped and rerun on Saturday. Online banking (the CICS region CICSPRD1) must not be touched. In this exercise the SQL tab also accepts Db2 commands (lines starting with -), as the DB2I commands panel would. Find out what blocks the check, clear it the right way, and run the check.
What you will do
- Read the -911 and its reason code
- Find which thread holds the lock
- Remove the blocker without harming anything else, and run the check
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.