Archiving in EWM 702

[former_member738707]

Good day, experts.

I have two questions about archiving:

1) We faced problem with big data space in tables EWM 702:

/SCDL/DB_ADDMEAS, 665GB
/SCWM/HU_SW01, 199GB
/SCDL/DB_STATUS, 166GB
/SCDL/DB_DATE, 108GB
/SCWM/GMHUITM, 101GB
/SCWM/ORDIM_C, 88GB
/SCDL/DB_REFDOC, 74GB
/SCDL/DF_OUTB, 73GB
/SCMB/DF_DOC, 68GB
/SCDL/DB_HU, 51GB
/1DF/_PCA700, 43GB
/SCDL/DB_HUITEM, 39GB

I we've already done in SARA archieving objects DLV_REQ, DLV_INB, DLV_OUT (all statuses has been moved to correct, i mean for example TU or delivery has status DAC - X, etc).

But space of this tables are very big.

How can i reduce space of this tables in EWM, may be some OSS notes for SARA should be installed, or i can reduce space of this tables via another programs???

2) How can i reduce space of this LIME tables in EWM 702:

/LIME/NLOG_QUAN
/LIME/NLOG_TREE
/LIME/LOG_HEAD
/LIME/LOG_HEAD
/LIME/COLL_W2IM
/LIME/PI_IT_BIZ
/LIME/COLL_PN

I've installed OSS note 2746003 but there are no changes. I'm trying to archieve object LIME_NLOG via SARA but after data reading no any entriy has been archivied. May be i should to install any other OSS note or should to make any settings in SPRO or another program?

Thanks in advance.

[former_member738707]

Good day. I've made a test. i see one HU in table /SCWM/HU_SW01 and in SARA tx i archive and delete all data about this HU (object WME_HU) tables:

/SCWM/GMHUHDR
/SCWM/GMHUIDENT
/SCWM/GMHUITM
/SCWM/GMHUITMSN
/SCWM/GMHUREF
/SCWM/GMHUSTAT
/SCWM/GMHUSTOBJ

(data in these tables has been deleted)

also i've archive and delete data which can connect with testing HU in objects (WME_TO, WME_WO, DLV_OUT
but data in /SCWM/HU_SW01 still appears abut this HU.

[former_member738707]

Hello, Juergen. Thanks for your reply.

This table uses more then 200GB disk space and it is increase from day to day.

According your reply i should to forget about archiving(reducing) table /SCWM/HU_SW01 and there is no any other ability to reduce space of this table, am i right?

[JuergenPitz]

Hi,

I am no basis guy, and never really do archiving. But the way I understand this table, a lot of the entries should be removed in the moment when the relevant object is either deleted or archived.

The "virtual HU ID" has the following entries:

Handling Unit in Warehouse

A Dummy Handling Unit for Location

B Planned Handling Unit

C Dummy HU for Valuation Quantity Differences

E TU

P Dummy Handling Unit for Pending Differences

U Dummy Handling Unit for Pending Claims

W Planned Shipping Handling Unit

"A" is for bins and resources. So the quantity in here should rarely change.All the others should come and go. I can so in my table entries for E - TU, but not for W - Planned SHU, although I have one. Not sure why this is.The table is set up for "Expected Data Records 2.900.000 to 5.800.000" - so I guess it can be quite big.BrgdsJuergen

[former_member738707]

Good day. Have anyone idea how to archive table /SCWM/HU_SW01?

I see no info in OSS notes about archiving this table etc.

Thanks a lot for answer!

[JuergenPitz]

Hi,

I do not think that you archive entries of this table. The table description says "Shadow Table WME - Warehouse Number, HUIDENT, VHI". And the VHI entry can contain entries which say "Dummy Handling Unit for Location", "TU", or "planned HU". A bin is in EWM handled like a HU, I think this is were most entries are from.

Brgds

Juergen

[former_member738707]

Hello, Daniil. Glad to see you again.

Yes, we done writting process and deleting (out basis team). Data has been reduced. After this operations tables also has very big space data. So may be we need to change something ib logic of archiving in SARA via OSS note or another program?

About optimization (reorganisation) tables our basis team couldn't reorganize this top tables untill we reduce space of this tables via SARA.

[Daniil]

Hi Dmitriy, but after archiving table size was reduced, right? If records are deleted (e.g. 50% of records deleted but size remains ) in my point of view next steps should be done in the database. Not my specific to be honest 🙂

In the delivery Profile you have as well Retention period. You can check it in your system.

And make sure that you have only needed records in delivery tables.

BR,

Daniil

[Daniil]

Hi Dmitriy, just to be sure,

did you do write (to create archive) and as well delete (to actually delete data from the tables) with SARA? Have you checked number of records before and after archiving?

Just wondering how many deliveries do you have in your system ( /SCDL/DB_PROCH_O ) or how many records do you have in /SCDL/DB_ADDMEAS, I just checked how it is in relatively fresh system, and it is

208.360.080 records which are 10GB for /SCDL/DB_ADDMEAS. Maybe it is a problem on database level, and tables have to be optimized there? ( I am not an expert in this part).

BR,

Daniil