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
Hello, I have one af:table which is binded using DataControl based on ViewObject. I typed some values in each column and now I want to access those values from the iterator but its giving me initial value at the time page loaded. //getting the iterat [More]
I am using Illustrator CS5 on a mac running Lion 10.7.2. Printing to an HP Designjet Z6100. Getting muddy colors. We also have PCs on which we run the same version of AI using the same color management settings, to the same HP printers. We can't matc [More]
I work with a T420 laptop docked in a docking station. The following strange phenomenon is happaning: Occasionally, Items are being deleted or attempt to be deleted in various applications as if the Delete key is being pressed constantly. Examples: 1 [More]
hi good morning, I'm from malaysia, can I use apple education package my wife is a teacher, I'm interested for mac 13 inch water for her I be able to buy used apple education package how and what documents are neededYou will need to contact th Apple [More]
I had to reformat hard drive. My songs on are on my ipod. How do I move them into itunes? Dell Dimension 4600   Windows XP  Read the post by Zevoneer in this thread: http://discussions.apple.com/click.jspa?searchID=-1&messageID=4877749Read other 6 an [More]
I see that this was an issue two years ago -- cannot believe that it has not been fixed. Issue: Match updates play count/Last Played field from iTunes computer installs, but not via device plays. Three iPhones, an iPad, and an Apple TV all show this [More]
Hi, We have a standalone oc4j 10.1.3 that hosts an application whose many of its pages use https and so we need to buy SSL certificate from any of CAs like Verisign, GeoTrust, etc.. All of these CAs are asking us about the web server type that the st [More]
Hi All, We upgraded database from 9.2.0.5 to 10.2.0.4, the system was running fine. One month after upgrade we changed the compatibility from 9.2.0 to 10.2.0 for compatibilty and optimizers. Since then perfomance is poor for self service and PTO carr [More]
Hello, I have a requirement that Production Order is not be created without the BOM Is there any Customizing Setting?? I have the option by implementing User Exit but i want to know is there any standard setting??? Please throw some comments??? Regar [More]
Hej, We have a bunch of quite established VI's using in our laboratory and updated recently our old MACs with Labview 3 or 5 or 6 to new Imacs with  NI-USB 6009 acquisition boards running on Win XP on MAC (the USB cards had problems on MAC Os 10.4). [More]