IBM Mainframe Forum

Hi All,

I ran a delete job on a partitioned table . My step1 of the job will delete the 1st partition. My step2 will delete the 2nd partition and so on.

But when i try to delete 3th partition I am getting S04C abend with SQLCODE as -904.

-904 is unavailable of resource. But why S04C abend raised ? Please help. Thanks in advance.

-904 is unavailable of resource. But why S04C abend raised ? Please help. Thanks in advance.

since You did not care to post the message' s details...
the only help You will get is the suggestion to look at the relevant messages and codes manuals
an follow the instructions ( actions to be taken ) given there,
the best path is to work with Your database support to determine why a resource was not available.