View previous topic :: View next topic
|
Author |
Message |
Mounika Nemani
New User
Joined: 25 May 2018 Posts: 5 Location: India
|
|
|
|
Hi All,
I tried to run a delete query in SPUFI.
Code: |
DELETE
FROM HIST_QUANTITY
WHERE TERMINAL_ID = 'SPRLOD' |
the above query was suppose to delete 1574180 rows from the table.
but I am getting a -904 error with the following reason.
Code: |
SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90096, TYPE OF RESOURCE 00000302, AND
RESOURCE NAME TCPUD1PK.PK000070.X'00004E8A' |
need help on how to increase the page locks. or is there any optimization needed for the query to be executed so, that the table doesn't throw -904.
Thanks in Advance |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
The table did not 'throw' anything. Nothing gets thrown on the mainframe. Your query abended. |
|
Back to top |
|
|
jerryte
Active User
Joined: 29 Oct 2010 Posts: 202 Location: Toronto, ON, Canada
|
|
|
|
You can use the below to lock the entire table prior to the delete. You need to be sure no one else needs the table
LOCK TABLE HIST_QUANTITY IN EXCLUSIVE MODE |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3053 Location: NYC,USA
|
|
|
|
Such things are always discussed with DBAs.
Please do that |
|
Back to top |
|
|
|