Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Posts
    33

    Unanswered: alternate option to "not logged initially"

    hi all,

    i am altering a table with "not logged initially" option to avoid logging while doing massive update (to avoid transaction log full). but sometimes i am getting an error
    SQL1477N For table "RPM.TRANS" an object "269" in table space "4"
    cannot be accessed. SQLSTATE=55019

    as per the above msg, i have to drop and recreate the table.

    is there any other way to run dml without logging

    pls advice

    regards
    sanjai

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

  3. #3
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Quote Originally Posted by sanjai
    hi all,

    i am altering a table with "not logged initially" option to avoid logging while doing massive update (to avoid transaction log full). but sometimes i am getting an error
    SQL1477N For table "RPM.TRANS" an object "269" in table space "4"
    cannot be accessed. SQLSTATE=55019

    as per the above msg, i have to drop and recreate the table.

    is there any other way to run dml without logging

    pls advice

    regards
    sanjai
    could you display commands you used. I just used this option before creating indexes on a huge table and it reduced the time by 30%.
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

Posting Permissions

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