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.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.