var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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
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