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, DEFAULT MERGEBLOCKRATIO ( col1 int, ... ...
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.
.... .... LOGON $LOGON; ARCHIVE DATA TABLES (coredb.coretable) ( PARTITIONS WHERE (! end_dt = DATE '9999-12-31' !) ),
RELEASE LOCK, FILE=ARCHIVE; LOGOFF; ENDSCRIPT
Error: 6852 PARTITIONS WHERE clause need to be simplified.
Thanks for the help in advance.