Sitemap

Amicuk Programming Answers

Archive Delete job taking too much time - STXH Sequential Read

2015-10-11   Views:3

Advertisement

Hello, We have been running Archive sessions in our production system in last couple of months. We use SARA and selecting the appropriate variants for WRITE, DELETE and STORAGE options. Currently we use the Archive object FI_DOCUMNT and the write job

Hello,
We have been running Archive sessions in our production system in last couple of months. We use SARA and selecting the appropriate variants for WRITE, DELETE and STORAGE options.
Currently we use the Archive object FI_DOCUMNT and the write job is finished as per the normal time (5 hrs based on the selection criteria). After that normally the delete job is used to complete in 1hr or less than 2hrs always (in last 3 months).
But in last few days the delete job is taking too much to complete (around 8 - 10hrs) when I monitor the system found that the Sequential Read for table STXH is taking too much time to read and it seems this is the cause.
Could you please provide a solution for the same, so that the job will run faster as earlier.
Thanks for your time
Shyl

The replay answer
Advertisement
Hi Juan,
After the statistics run the performance is quite good. Now the job getting finished as expected.
Thanks. Problem solved
Shyl

Go to See the other 4 answers

Archive Delete job taking too much time - STXH Sequential Read

Category:DefaultRelease time:2015-10-11Views:130

Hello, We have been running Archive sessions in our production system in last couple of months. We use SARA and selecting the appropriate variants for WRITE, DELETE and STORAGE options. Currently we use the Archive object FI_DOCUMNT and the write job[More]

PI 7.1 Archiving - Delete

Category:DefaultRelease time:2015-10-11Views:130

hi Team, We have PI 7.1 production environment and planning to implement ARCHIVING & DELETE for Integration Engine, Adapter Engine and Business Process Engine based messages. I had referred to 'How to arhive & delete' doc that highly available in[More]

Message archiving/deletion in PI 7.1

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I'm new to SAP PI. We have newly implemented PI 7.1 in our landscape. We have installed PI in HP UX 23 with oracle as the database. We have configured the messge archival/deletion in our PI production server. We have allocated a dedicated fil[More]

Issue with Archiving & Deletion of messages in PI ,SXMB_MONI messages

Category:DefaultRelease time:2015-10-11Views:130

Hello experts I am  working on Archiving & Deletion of messages in PI ,SXMB_MONI, i have fallowed all the steps which are avialable in /people/deepak.shah/blog/2010/04/22/archiving-deletion-of-messages-in-pi--part-2, but the messages still there in S[More]

Archival/Deletion of messages in XI 3.0 SP23

Category:DefaultRelease time:2015-10-11Views:130

Dear All,   We need to carry out a data deletion/purging activity at our XI box, where no archival/deletion policy has been incorporated ever. As a preparatory measure, I need to have some guidelines for the activities as under, 1. While defining an[More]

Seeburger message tracking archiving / deleting question

Category:DefaultRelease time:2015-10-11Views:130

Hello, We are using Seeburger 1.7 with XI 7.0 for our EDI translations..We store information in Seeburger Message Tracking for our business requirements.I would like to know how these entries could be archived(Compressed) and stored or deleted after[More]

Archive / Delete Q-INFO records

Category:DefaultRelease time:-0001-11-30Views:130

Hello , Which object in sara code should i use/create to archive/delete Q info records ? Thx in advance .Hi I am not very sure about archiving of the Quality info record but Deletion is possible only by putting the Deletion Indicator to the same in T[More]

Archiving  & Deleting the Cost center line items

Category:DefaultRelease time:-0001-11-30Views:130

My requirement is to delete the line items in the cost cneter as of today, but when i tried to archive & delete the Cost center line items using CO_item,i aam sucesfull in deleteing the past data, but the data of the last month and currenct month i w[More]

RSEXARCD: Idoc archiving deletion program issues

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have two queries: 1. The Idoc archive deletion program, RSEXARCD, when executed in background, terminates when there are no archive files to process (as seen in SARA). How can we prevent this? Our deletion jobs are scheduled weekly, but sometim[More]

Setting up archive delete functionalities using background job

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Through SARA transaction there we can set up a archive delete job by selecting the files, job timing details. Instead of this, we want to set up this functionality using a background job as per the variant and timing requirements. Is there any op[More]

Online Archive - Deleted Items Folder

Category:DefaultRelease time:-0001-11-30Views:130

Hello, I have setup retention policy and tags.  It seems to be working okay, almost.  A default retention tag applies which archives items after one year.  This seems to be working ok for folders such as inbox, and sent.  However, it does not seem to[More]

Hot
What are the common APIs we use in oracle interface,and any APIs are there for validation Of data During Tranfer to interface table. How to find Api s in oracle applications in Individual modulesFor 11i, all public APIS are listed at http://irep.orac [More]
Hello, I used places to geotag some of my pictures. That went nicely, and I now have Latitude and Longitude Metadata entries in the exif part of the metadata displayed by Aperture. However, when I export these pictures to JPG, this information is gon [More]
I disconnected my iPhone in the middle of an iTunes update. Now it wont run properly what do I do?  I was working online and I recieved a pop up from iTunes stating that there was an harwared update for my iPhone. I had it plugged up for a while , lo [More]
I created a long letter in Pages, using a text box. I saved most of it as a Pages file. When I reached the end of the page, a new one opened, but I have been unable to get back to the original page. The document with that name is on my desktop but it [More]
Respected the participant of a forum, our phone has got to water and a screen part don't work. Today it have removed and on a loop has found this sign. Who can prompt it QR code and as he can be read. In general we need to buy in exchange new, who ca [More]
Hi All, I have a unique requirement. I need to create an Alerting Service in SAP BI7.0 A WAD dashboard report needs to show alerts. The alerts will be unique to individuals(users). Overall implementation of the alerting service is based on 4 key elem [More]
Hi Experts, I have a below scenario  , I created a new out put type for sending RFQ through mail. but in vendor master i put multiple E-Mail id system not sent to all person only consider first E-Mail ID. Please share your Experience with me to solve [More]
I have this code in my JSPDynpage      public void onSaveButtonClicked (Event event) throws PageException            DropdownListBox dListMain = (DropdownListBox) getComponentByName("mydropdown");           DropdownListBox dListEthnicityNew = (D [More]
When I programming in Labview 6.1, in the property of plot, I found the line width only have 5 level. In my case, I need a much thicker plot line than level 5. Is there anyway to realize increasing the line width beyond the 5 options provided in Labv [More]
Hello All - How can I create hard line breaks in a JEditorPane's document with HTMLEditorKit after a line wraps. In other words, I'd like to see a <br> when the cursor moves to the next line. Please Help ! NormanYour answer is in your question....Th [More]