Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Location
    Massachusetts
    Posts
    27

    Question Unanswered: Should I imagecopy the mapping table?

    Environment - DB2 v7 on OS/390

    The mapping table which is used in an online reorg - should I imagecopy it the way I do for other tablespaces? Is it required? What if I dont do it?

    How do you guys do it?
    "It is Monday morning 3:02 AM. What is your SQL response time ?"

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Do you delete the mapping table when the reorg is finished?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2003
    Location
    Massachusetts
    Posts
    27
    Originally posted by Marcus_A
    Do you delete the mapping table when the reorg is finished?
    No, we reuse the same one during the next Reorg.
    So, I take it that it has to be copied since I am not deleting it?
    "It is Monday morning 3:02 AM. What is your SQL response time ?"

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I don't think you have to copy it, but it might help in case you had a disk drive failure and wanted to recover all the objects.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Sep 2003
    Location
    Massachusetts
    Posts
    27
    Originally posted by Marcus_A
    I don't think you have to copy it, but it might help in case you had a disk drive failure and wanted to recover all the objects.
    Thanks. I went ahead and prepared a job to copy it.
    "It is Monday morning 3:02 AM. What is your SQL response time ?"

  6. #6
    Join Date
    Jan 2004
    Location
    Zuerich, Switzerland
    Posts
    13
    please note that you only have to allocate minimal space to the mapping table space. REORG writes ONLY to the index of the mapping table, and does not write the tablespace pages.

    You might consider to delete the mapping tables after the REORG run and recreate them dynamically in the utility input stream using EXEC SQL. That is what we do in our installation, where some of the mapping table indexes get really huge.

    Also note that one mapping table per JOB is sufficient, even if mor than one table space is REORGed.

    have fun
    Last edited by Heinz Buehler; 02-11-04 at 05:18.

Posting Permissions

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