Archiving on partition primary index fails when archiving on partitions.

General

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.

Thanks for the help in advance.

Regards,

Srikanth

Tags (3)