Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Unanswered: index state after LOAD TERMINATE

    This is on Version 8.1 and 8.2 (various fixlevels) on Sun Solaris

    I have this table with about 350 mil records and 3 mil records get LOADed every weekend. The indexing mode is INCREMENTAL.

    If the LOAD fails in the BUILD phase (eg. Tempspace disk full) and then a LOAD TERMINATE is issued, what will the state of the indexes be? Will they be marked invalid - requiring a full rebuild on the next table access or will they go back to the original valid state?

    Im preparing a support document and want to make sure I cover this bit, so that the operators know what to expect after a LOAD TERMINATE.

    For certain reasons, I do not want the load to be RESTARTed

    Oh, BTW, how do you identify the state of the index when the database is still online?


    Thanks in advance for any input

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  2. #2
    Join Date
    Jun 2001
    Posts
    20
    After a LOAD TERMINATE, the indexes will be marked invalid.

    Use INSPECT to identify the state of the index.
    - db2 "inspect check table name <table_name> for error state all results keep inspect.out"
    Format the out file (file will be in DIAGPATH)
    - db2inspf inspect.out inspect.fmt
    - Look for the lines
    Warning: Object is known to be in error state x400.
    Warning: Index object is in invalid state, requires index be re-built.

    Renga
    Renga

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Thank You Renga ,,, Makes sense

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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