cancel
Showing results for 
Search instead for 
Did you mean: 

Performance issue while accessing SWwLOGHIST & SWWHEAD tables

thomas_tancheephong
Participant
0 Kudos

Hi,

We have applied workflow function in Purchase Order (PO) for release strategry purpose. We have two release levels.

The performance issue came while user who tried to update the existing PO in which the PO had already released. because after user amend the PO and then they pressed "SAVE" button in PO's screen, the release strategry will reset and it tried to read the SWwLOGHIST table, it took few seconds to minutes to complete the save process.

My workflow's schedule job details as below:

SWWERRE - every 20 minutes

SWWCOND - every 30 minutes

SWWDHEX - every 3minutes

Table Entries:

SWWHEAD - 6mil entries

SWwLOGHIST - 25mil entries

Should we do data archiving on the above workflow tables?

Is it only the solution?

Kindly advice,

Thanks,
Regards,

Thomas

Accepted Solutions (0)

Answers (3)

Answers (3)

thomas_tancheephong
Participant
0 Kudos

Hi,

The sizes for both tables as below:-

SWWLOGHIST - 3GB

SWWWIHEAD - 2GB

I've a REORGchk_alltables in weekly basis, in DB2/DB6 (DB) do I need to manually reorg of the tables or rebuild the indexes?

You can refer the attached screenshots for both tables.

Thanks,

Regards,

Thomas

Reagan
Advisor
Advisor
0 Kudos

Check whether the statistics of these tables are updated.

Perform an SQL tracing using the Tx ST05 and check the execution plan.

Archiving or deleting the date will not improve the performance. If there is mass deletion of data then I would consider doing a reorg of the tables and rebuild the indexes.

Regards

RB

former_member188883
Active Contributor
0 Kudos

Hi Thomas,

Archiving should be a good solution with such large number of entries.

Check out the following

Refer point 4 of SAP note 706478 - Preventing Basis tables from increasing considerably

Refer SAP note  49545 - Deleting unnecessary work items

Hope this helps.

Regards,

Deepak Kori

thomas_tancheephong
Participant
0 Kudos

Hi Deepak,

So far, we have yet to setup any storage server/dvd to intergrate with ECC for archiving function.

It is possible to proceed with write & delete steps in WORKITEM archive object although that is no storage been stored? In other words, which is delete the work flow data parmanently?

Not too sure whether auditor will need to check those workflow logs or not.

Any idea?


Thanks,

Regards,

Thomas