Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    Unanswered: DB29.7 /Windown 2008 - Load operations

    Hi
    Please advise.

    I have exported over 90million rows using export utility (ixf). Now I have to load into the new table and I dont need the logs generated.

    In default, the LOAD will not logged. Is it correct ? the statement is below.

    LOAD from ACCCCT.ixf of ixf insert into ACS (CUSTOMERNO,TIME_STAMP,BRANCH_CODE,SHORTNAME,MAGIC 1,ASV,ASTATUS,RESTDATETO,RESTUID,RESTCODE,RESTTEXT ,FREETEXT,OPENDATE,DEMOGRAPHICLOCN,VALIDFROM,VALID TO,STATUS,OPID_ENTRY,TIME_STAMP_ENTRY);

    If the LOAD is fail then the table/tablespace will not accessable. The question is, how can I start the load again ?
    Please share your experience.

    Thanks,

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Use the keyword "nonrecoverable" in your load command. Do not wait with you next backup after the load has finished.
    With restart/terminate options you can wriggle yourself out of an pending load. Personally I've never been successful and a drop/create table worked better for me....

Posting Permissions

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