We have a stored procedure (SP), called the master SP. The Master SP calls several other SPs in it.
Towards the end, there is one SP that does a clean up. To clean up, it does a DELETE FROM tablename;
The are not hundreds of thousands records to be deleted , but are certainly in few thousands per table (and there are three such tables).
Now if this was the os/390 world, and this was a step within a JCL, I would have just recommended a LOAD REPLACE a dummy dataset with LOG NO.
In the UDB on AIX world, although I could LOAD a empty dataset with non-recoverable option, I am not sure if that is possible in this case. esp. given that its a SP within a stream of other Sps called by a master sp.
does anyone have any ideas as to how could I clear tables using a SP and minimise the logging overhead.