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
Hi All, I am using the FM's JOB_OPEN, JOB_SUBMIT and JOB_CLOSE in a report program to create batch jobs. Now some of the batch jobs have DL's  to which spools of the batch jobs are sent and are maintained in 'SPOOL LIST RECIPIENT' button of SM36. In [More]
Hi, I have a code like that: CALL FUNCTION 'JOB_OPEN'     EXPORTING       jobname          = lv_jobname     IMPORTING       jobcount         = lv_jobcount     EXCEPTIONS       cant_create_job  = 1       invalid_job_data = 2       jobname_missing  = 3 [More]
how can I buy an iweb 9? I'm upgrading to a new computer and I can't open my old website. I follow some advice but it doesn't open it. I think I need iweb 9 IreneGo to Amazon and buy either the iLife 09 or iLife 11 boxed set, both of which contain iW [More]
GRC AC 5.3 SP 10 CUP There are some old open CUP requests for super user access. I need to cancel them. When I try to cancel a request from config - request - administration - it gives me a message that "failed to cancel follwing request". Also [More]
I love my fifth generation iPod, but I see it has an important fault: It can't remove pics and/or songs by itself. It has to be connected to iTunes to do it, Am I right?. I've got other mp3 players and they all allow to remove files directly from the [More]
my phone is on recovery mode and when i try to restore it then it shows device is not eligible for the requestHi, are you doing it through Settings or via iTunes? If doing it through Settings, try plugging it in via USB and updating with iTunes. Hope [More]
Hi, if I do send a webpage with "Mail Contents of this page" then the images the page contains do not show up on Windows machines and some Mac's aswell. The message looks good in Mail before i send it. Does anyone have a solution for me?The phot [More]
I am trying to use linux-lts but get this error, I'm using rEFInd. I am able to boot the standard arch kernel, but when selecting the other entry in refind I just get the error. Warning: /lib/modules/3.14.17-1-lts/modules.devname not found - ignoring [More]
Hi All, We are using Oracle Coherence Standard Edition in our application. Any way to improve the performance of NamedCache.keySet(filter) configured as distributed? I know there is no scope for indexing since we are using Standard Edition. Thanksuse [More]
Could anyone advise on the best way to do this? I'd like my URL's to make more sense then they do at present. Currently I structure my sites to pull in cfinclude using a variable for each area, index.cfm?area=foo. It works fine but I'd like to browse [More]