Mass data reduction beyond standard archiving functionality

74 Views

I'm trying to refresh QA from prod. I don't have enough disk to maintain production size in QA long term (and even less when I refresh dev).

I've restored QA from a backup of prod and archived over 300GB (20-25%) and am now reorging tablespaces to free up disk space but I want more. I need to get rid of another 300GB at least in QA and probably that much again in the copy I deliver to dev.

I've found some programs to perform mass deletions from some of the biggest transactional tables but I'm still looking for more. Unfortunately, TDMS is not an option at this time for all sorts of reasons.

Table : cleanup program

NAST : RSCLNAST

CE1AP01 : RKEDELTEST

GLPCA : <help needed hereafter...>

VBOX

LIPS

VBRP

VBFA

MSEG

VBAP

CDCLS

COEP

BSIS

RFBLG

Some of the above have been reduced by transaction SARA but not far enough. I have gone into the customising settings to make sure the document retention periods for each applicable object has been set small enough.

We are considering ways to identify data from fiscal year 2002-2004 and burning that but we want to minimize the risk of data inconsistency.