I have a PPI table paritioned by end_dt
when archiving the partion of the table by partitioning column, i am getting error 6852.
I am using a valid partition while archiving, but still getting this error. Any suggestions on this will be helpful
In other cases I am able to archive/copy the partition without any issues.
My Table is like this.
CREATE SET TABLE coredb.coretable ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
strt_dt DATE FORMAT 'yyyy-mm-dd',
end_dt DATE FORMAT 'yyyy-mm-dd'
PRIMARY INDEX AGREEMENT1 ( col1 )
PARTITION BY CASE_N( end_dt = DATE '9999-12-31', NO CASE)
total available rows = 2 millions.
sel * from coredb.coretable where end_dt = DATE '9999-12-31'
results in a million records.
ARCHIVE DATA TABLES
( PARTITIONS WHERE
(! end_dt = DATE '9999-12-31' !)
Error: 6852 PARTITIONS WHERE clause need to be simplified.
Thanks for the help in advance.