Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012

    Red face Unanswered: Add Partition issues.

    I have scheduled a script to add partitions automatically to a range partioned table. My concern was the scenarios in which the script might fail.

    Can you help me understand that how my ADD PARTITION command behave while :-

    1. OLTP transactions are being made onto the table.
    2. While database backup job is running.

    Thank you in advance

  2. #2
    Join Date
    Aug 2001
    As you have posted in a DB2 forum, I assume your question is on DB2.

    1) For your version of db2, the information center will have a topic Scnearios: Rolling in and rolling out partitioned table data . The info might depend on the version of db2.

    2) shouldn't be a problem as long as the backup is past the catalog tablespace backup "phase"

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

Tags for this Thread

Posting Permissions

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