client export and import

[Former Member]

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

[ashish_mishra2 · Accepted solution]

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.

[Former Member · Accepted solution]

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

[former_member185031 · Accepted solution]

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

[ashish_mishra2 · Accepted solution]

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

[Former Member · Accepted solution]

Hi All,

Thanks a lot for the suggestions.

The import is successful after running the update statistics.

Regards,

DVRK

[Former Member]

Hi,

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

This makes the import quite fast.

Thx,

DVRK

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

Please check the work process trace files and SM21 logs.

-Srini

[JPReyes]

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

Regards

Juan