Archiving Z table

[Former Member]

Hi all,

In my ztable I have 10 million records, when user runs the report it takes too much time, for that I have already created one archive table same as my ztable, now I want to insert all ztable data(record) to my zarchive table, I want to keep only one month data in original ztable for that I want to create one archive program to insert all record in my zarhive table and keep 30 days data like: system date to older then 30 days.

Can you give me some idea how to create program? Give me some logic.

Thanks

zeni

Edited by: Julius Bussche on Oct 18, 2008 1:00 AM

Edited by: Julius Bussche on Oct 18, 2008 1:35 AM

[Former Member]

1) Please pick a more suitable title for your question.

B) Rather than trying to come up with some sort of user archiving process, it might be simpler to do some performance tuning on the programs that access this table.

Rob

[Former Member]

Okay, lets help him / her out => Archive Z table it is...

Edited by: Julius Bussche on Oct 18, 2008 1:34 AM