on 2014 Apr 09 3:29 PM
Hi Folks,
Reviewing our Solman system I found that some tables are getting really large, I found SMD_HASH_TABLE is over 71GB compressed. I found the note 1958979 - Solution Manager - Tablespace increase which in turn directs you to the attached document of the note 1480588 - ST: E2E Diagnostics - BI Housekeeping - Information.
Per the document, I executed TAANA transaction and ran analysis on the table and got the following data,
Per the next steps, I added the following entry in the table E2E_BI_DELETE.
the next run of the job, I got an ABAP dump with timeout.
Looks like while selecting the data for deletion, it timed out.
Has someone faced this issue and can suggest ways I can run this outside of this job one time to clean up this table. I believe the subsequent runs will be ok as long as the housekeeping job is run regularly.
regards
Yogesh
Request clarification before answering.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
12 | |
9 | |
8 | |
8 | |
5 | |
4 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.