Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    3

    Unanswered: Change OBID of a table

    Hi,

    I need to change OBID of some tables, but I could not find any solution for it.
    I thought that REPAIR utility can do, but I was not succeed with it yet.

    Please guide me if anyone know about this topic.

    Thanks,
    Amir

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Why do you want to change the object ID?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Oct 2007
    Posts
    3

    Change OBID of a table

    Hi,

    There is a problem from restoring the taken backup data from tables of a region to other.

    I have simple tablespace with many tables included. I need to restore some of the tables into another region with resume yes option.

    But the taken backup could not restored becuase as you know at
    WHEN(00001:00002 = X'000F') syntax of load CNTL , hex of OBID of table used as a key to find the specific unloaded data from whole backup which has been taken.

    Unfortunatly, OBID of the sourse region is not match with destination table.
    I decide to change OBID of destination table so that the data can be restored.
    Otherwise, the table must be drop/define with new OBID.

    I hope I could explain my problem.

    thanks,
    Amir

  4. #4
    Join Date
    Dec 2004
    Location
    Italy
    Posts
    32
    What about a DSN1COPY with the OBIDXLAT Option?

Posting Permissions

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