All Forums General
gundumraju 1 post Joined 06/11
19 Apr 2012
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

You must sign in to leave a comment.