Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Posts
    118

    Unanswered: Minimise Logging

    Hi Folks !

    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.

    thank you.
    Anil

  2. #2
    Join Date
    Jan 2005
    Posts
    191
    ALTER TABLE xxx ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE
    ?

    James Campbell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •