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
Tryin to download Itunes on my laptop and the error message pops up. It tells me to to unistall and reinstall and its not fixing the problem??Let's try a standalone Apple Application Support install. It still might not install, but fingers crossed an [More]
I've been dealing with a disk error that has tripped up every application I've used to correct it. Disk First Aid could nothing. I tried Disk Warrior, but that's taking centuries to run and still won't solve the end problem (according to a DW techie) [More]
I need help with editing and formatting a newly created pdf fileYou posted this in the Captivate forum, I think you need the Acrobat oneRead other 2 answers [More]
I'm building a game program and I've got a script that loads an external swf, and then duplicates the clip for the user to play. It worked until a few days ago when I reinstalled my OS (Mac OS 10.4.11) to fix an unrelated problem. The strange thing i [More]
I've managed to convert my drawing to grayscale, but I was hoping there was a way to change the base color. For example, instead of Gray or Black being the base color for the grayscale, I was hoping I could have shades of Blue instead. It would be ve [More]
Is there an adapter available to connect the nano 7 generation to the IHome 15?Yes, buy the lightning-to-30pin adapter from an apple store.Read other 2 answers [More]
I can find the caches directory: pwd/Users/wh/Library/Caches/com.apple.Safari But I also found that not all caches are saved here, because it's size doesn't grow along with the video playing by using safari. Safari 7.0 osx version save caches in the [More]
I need to know what going on with I tunes how do it work when u buy some y does it take so long to take the money and I need to see a billYou get an e-mail copy and you can look at your purchase history -covered in the article you linked.Read other 2 [More]
I had to have my hard drive replaced on my imac as a result of the recall. I use Time Machine and have no idea how to restore my info .  Help?This link should help you out. Mac 101: Time MachineRead other 3 answers [More]
Let me start by saying that Adobe has the most irritating customer support I have EVER dealt with... way to not have an email or phone number anywhere for your paying customers Adobe. and if there is a line/email way to hide it so effeciently it can [More]