Current Position:Home > Importing is taking too much time (2 DAYS)

Importing is taking too much time (2 DAYS)

Update:10-11Source: network consolidation
Dear All,
I'm Importing below support packages together in a queue @ SAP Solution manger 4  .
SAPKB70015             Basis Support Package 15 for 7.00
SAPKA70015             ABA Support Package 15 for 7.00
SAPKITL426             ST 400: Patch 0016, CRT for SAPKB70015
SAPKIBIIP6             BI_CONT 703: patch 0006
SAPKIBIIP7             BI_CONT 703: patch 0007
SAPKIBIIP8             BI_CONT 703: patch 0008
SAPK-40010INCPRXRPM    CPRXRPM 400: patch 0010
SAPK-40011INCPRXRPM    CPRXRPM 400: patch 0011
SAPK-40012INCPRXRPM    CPRXRPM 400: patch 0012
SAPKIPYJ7E             PI_BASIS 2005_1_700: patch 0014
SAPKW70016             BW Support Package 16 for 7.00
importing is taking too much time (2 DAYS) in main import phase, I have seen SLOG, there are many rows " I am waiting 1 sec and 6 sec . and also checked transaction code STMS all support packages  imported except  one support package "SAPKW70016  "
Please advice.
Best Regards'

The Best Answer

Hello Mohan,
The DBTABLOG table does get large, the best is to switch off logging. If that's not possible, increase the frequency of your delete job, also explore one more alternative have a look at the archival object: BC_DBLOGS, you could archive old records (in accordance with your customer's data retention policies) to reduce the size of the table.
Also, have a look at the following notes, they will advise you on how to improve the performance of your delete job:
Note 531923 - Audit Trail: Indexes on table DBTABLOG
Note 579980 - Table logs: Performance during access to DBTABLOG
  • Filename in import statement Update:10-11

    Hi srinivas bobbala, Thank you for your response.But I think my quesition was not clear.My ques... is for suppose there is one datafile for importing like.. "datafile_21" Here my intention is it takes file from datafile_21 only but it appears in

  • Can not refresh snapshot changes after importing data of master site Update:10-11

    Hello ! I have two database computer,one as master site,one as snapshot site.Because the error of the hard disk of master computer,I use the exporting data file to recover my database.after importing ,I found I can't refresh the refreshgroup on snaps

  • Support package / add on import error in DB2 V9.1 / windows 2003 system Update:10-11

    Hi I have installed ERP 6.0 IDES version in Windows 2003 server with DB2 LUW 9.1 / FP5. I have selected "Row Compression" and "Deferred Table Creation" during installation. Now when I am importing add on BI Content 7.03, I am getting e

  • Import Fixed Asset by excel Update:10-11

    Hi Every one,      I am importing FA in SAP B1 PL 09 but failed, with system message log " Its active depreciation areas must be the same as those defined in the corresponding asset class. I checked depreciation areas and asset class, They correspond

  • Importing CD / adding folder goes to wrong folder Update:10-11

    iTunes Under preferences my iTunes media folder is set to "C:\iTunes" and up until recently all imported CD's and files went into that folder under the relevant artist name. Now, however, when importing they go to a new folder called &qu

  • Importing to AE files - goes to wrong folder Update:10-11

    I looked in the AE FAQ, didn't see the answer to my question, so here goes. I am using AE with editing video, meaning I only use AE for some basic things. This is one of those times where my lack of knowledge is driving me mad. When I went to import

  • Lightroom imports photos to wrong folder Update:10-11

    I've been importing lots of photos from my hard drive into lightroom and been moving/renaming them in the process. I only got lightroom a few weeks ago. This has worked fine but i've recently imported a few hundred photos off my iphone and doing the

  • CD imported to wrong folder organization Album/Artist instead of Artist/Alb Update:10-11

    I imported (ripped) a CD and the folder convention iTunes created in my music library was like this: AlbumName/ArtistName instead of ArtistName/AlbumName How could this happen. I have ripped hundreds of CD's and this is the first time it has happened

  • LR5 Importing to wrong folder Update:10-11

    I have been importing to folders on drive I. It is now full. I am trying to import to drive H which has plenty of room. Every time I try to import to H LR tells me that drive I is full, which of course I already bloody well know. So I am unable to im

  • Loops in red & importing sounds from iMovie Update:10-11

    There are some loops in red and I have tried to import them through setup but it says they are open, also when I try to import from iMovie it says "NOT INDEXED"?answeredRead other 2 answers