Archiving on partition primary index fails when archiving on partitions.
All All,
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.
Arc script
....
....
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.
All All,
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.
Arc script
....
....
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.
Regards,
Srikanth