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
I have recently updated to Lightroom 5.7 on my PC and also use Phototshop CS5.1. When I use LR and then try to use the Edit in CS5.1 option I get the error message saying I should upgrade to Camera Raw plug-in version 8.7. I cannot find any way of do [More]
I have the xiph codec thing installed for playing ogg files. Ogg files play fine if the files are stored locally on the mac. However, if I try to play the same files when they are stored on another computer on the network, it refuses to play them. Wh [More]
I have newer iMac with Duo-2-Core with latest OX updates. I start my Appleworks and starting points pops up then as I am scrolling down about 1/3 down my docs it just quits? Now yes I have quite a few in that file but not that much to overload. Any t [More]
Hi All, I am looking for documentation on Manager Self Service 50.1 (The ITS version of MSS). Can anyone tell me where I can find information or documentation for this? Thanks Raj BalakrishnanHi, Are you looking for a configuration document ? You can [More]
Hi, I am developing a web tool that accesses client's Bingads accounts via OAUTH2 granting. I am downloading data from clients daily. Generally it worked, but for 2 days I am experiencing a weird issue, that in random times (but more and more often t [More]
Hi, Could some one please tell me, where can i maintian QoS (EOIO) in RFC to ABAP Proxy scenario? I have to make sure, the data goes in order. Thank you in advance. Best Regards, Prasad.Hello Michal, But i read the below link, http://www.sdn.sap.com/ [More]
I was wondering why i was not getting the right output. The program should give me.. Storing : 0 Checking Queue... Printing: 0 Storing: 1 Checking Queue... Printing:1 etc... but instead all I get is... Storing :0 Checking Queue.. Storing:1 Checking Q [More]
Hello Experts, Pl advise if we have Pre-configured Solution for Small And Medium Downstream Co's for Oil & Gas.? Any link or material for reading, please let me know. Background - We are working on the scope to finalise processes for Small And Medium [More]
Unable to transfer nikon coolpix S70 files to bridge?What is the output extension?  Why can't you transfer?Read other 2 answers [More]
I'm attempting to install lotusnotes852_macen.dmg and the Installer crashes every time I try. I've deleted all Lotus files, rebooted, and the Installer continues to crash. Below is the beginning of the crash log. I'd greatly appreciate any suggestion [More]