Our event monitor for change history is not logging the alter
table attach partition command while it is logging the detach.
Here is a simple scenario that easily demonstrates the issue. It
looks like we forgot to include logging the attach:
db2 "create event monitor DDLHIST_EVM for change history where
event in (DDLALL) write to table DDLSTMTEXEC (table
DDLSTMT_CHGHIST), TXNCOMPLETION (table DDLTXN_CHGHIST)
autostart"
db2 set event monitor DDLHIST_EVM state 1
db2 "CREATE TABLE mysales (invoice_date date, inv_month int NOT
NULL GENERATED ALWAYS AS (month(invoice_date)), inv_year INT NOT
NULL GENERATED ALWAYS AS ( year(invoice_date)), item_id int NOT
NULL, cust_id int NOT NULL) PARTITION BY RANGE (inv_year,
inv_month) (PART Q1_2002 STARTING (2002,1) ENDING (2002, 3)
INCLUSIVE, PART Q2_2002 ENDING (2002, 6) INCLUSIVE, PART Q3_2002
ENDING (2002, 9) INCLUSIVE, PART Q4_2002 ENDING (2002,12)
INCLUSIVE)"
db2 "CREATE TABLE Q1_2003 (invoice_date date, inv_month int NOT
NULL GENERATED ALWAYS AS (month(invoice_date)), inv_year INT NOT
NULL GENERATED ALWAYS AS ( year(invoice_date)), item_id int NOT
NULL, cust_id int NOT NULL)"
db2 "alter table mysales attach partition Q1_2003 ENDING (2003,
3) INCLUSIVE from table Q1_2003"
db2 "alter table mysales detach partition Q1_2002 into Q1_2002"
db2 set integrity for mysales allow no access immediate checked
db2 "select event_timestamp, substr(STMT_TEXT,1,60) as STMT from
DDLSTMT_CHGHIST"
EVENT_TIMESTAMP STMT
--------------------------
-----------------------------------------------------------
2016-09-06-09.05.18.858916 CREATE TABLE mysales (invoice_date
date, inv_month int NOT
2016-09-06-09.10.00.503836 alter table mysales detach partition
Q1_2002 into Q1_2002
2016-09-06-09.10.36.395227 set integrity for mysales allow no
access immediate checked
This issue affects DB2 LUW v10.1 and v10.5. |
