Question Re: client export and import in Technology Q&A

client export and import

Former Member — Fri, 15 May 2009 09:42:11 GMT

Hi,

We need to do a client :300 export from PRD system and import it to Quality: 206 client.

The size of the database in PRD system is around 90 GB and database is Oracle 10.2.0; windows 2003 OS.

Hence please advise on the following.

1. How much free space we require in PRD system for client export, if the whole database size is

90 GB?

2. Can u plz. list the steps for client import and post import activities.

Thanks & Regards

DVRK

Re: client export and import

JPReyes — Fri, 15 May 2009 11:29:28 GMT

To find out the size of the client read SAP Note 118823

Regards

Juan

Re: client export and import

Former Member — Fri, 15 May 2009 13:30:24 GMT

Hi,

You can perform the client export using the Tcode SCC8. Once the export is done in the PRD system, you can see 2-3 number of transport request created based on the profile selection by you.

FTP these files from PRD to QAS system and import these transport requests in QAS system.

When Import of these requests are successful, please perform the post processing steps using Tcode SCC7.

For more details, please refer to the below link.

http://help.sap.com/saphelp_sm32/helpdata/en/69/c24c4e4ba111d189750000e8322d00/frameset.htm

With Regards,

Saurabh

Re: client export and import

Former Member — Fri, 15 May 2009 13:41:34 GMT

check

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=70547]

[http://help.sap.com/saphelp_sm32/helpdata/EN/69/c24c824ba111d189750000e8322d00/content.htm]

You can RSSPACECHECK to check space.

Re: client export and import

Former Member — Tue, 19 May 2009 09:06:11 GMT

Hi,

We have exported the client successfully and two cofiles and two data files( of around 4 GB size) have been generated.

We copied them into the trans directory of the target system client and trying to import them

with STMS_IMPORT.

The import started and running for a very long time. The logs are showing as " running main import".

The tp log is also showing it as " START MAIN IMPORT " phase.

How to check whether the actual import is happening or nothing is running ? In SM50 sometimes workprocesses are completely waiting, sometimes getting occupied. We have locked all the users also while importing.

Please advise.

Thanks,

DVRK

Re: client export and import

Former Member — Tue, 19 May 2009 10:14:33 GMT

Hi,

Please check the work process trace files and SM21 logs.

-Srini

Re: client export and import

ashish_mishra2 — Wed, 20 May 2009 05:13:23 GMT

best way to check import log is from os level

go to /usr/sap/trans/tmp directory

during the import the logfile generates in temp directory and continuously updates too.

once the import gets over .. same file will move to your log directory.

Currently if import is running, you can check import log from tmp directory.

Re: client export and import

Former Member — Wed, 20 May 2009 11:23:49 GMT

Hi,

Thanks a lot for the inputs.

But the log at the tmp directory showing that the main import is running. There are no updates on the lof file also.

" START MAIN IMPORT CQS I 20090520121702 cqsadm MYSAPQAS 20090520121656000b10 "

Even the tp log also showing that the main import is running.

How long this will run for 3 GB of data file size ?

Please advise,

Thanks

DVRK

Re: client export and import

Former Member — Wed, 20 May 2009 18:46:28 GMT

That is pretty much difficult to say how much time it will take because it depends on hardware and system. You can check the table space also. and keep watching the log file.

Regards,

Subhash

Re: client export and import

ashish_mishra2 — Wed, 20 May 2009 19:40:07 GMT

Hi,

3GB of RT file takes generally 6-8 hrs. But if really no updates are happening at OS level logfile inside temp directory, check whether the transport is running or not.

If the file is still present inside /trans/tmp dir., it means the import is running and u cn see the updates using tail -f <file name> or the time stamp of that file.

else the file will move to log dir incase the transport completes successfully or failed doesn't matter.

One reason of getting hung the transport during clent export/import is the PSAPTEMP teblespace. Keep an eye continuously on temp tablespace and add datafile if needed. in this case you will see the log dictating that "unable to extend next segment" kind of words.

Check the logfile, I am sure you will get an idea about the status of transport.

Regards,

Ashish

Re: client export and import

Former Member — Thu, 04 Jun 2009 12:32:47 GMT

Hi All,

Thanks a lot for the suggestions.

The import is successful after running the update statistics.

Regards,

DVRK

Re: client export and import

Former Member — Thu, 04 Jun 2009 12:33:55 GMT

Hi,

The catch is that we need to run the update statistics before starting client import.

This makes the import quite fast.

Thx,

DVRK