How to ensure that client import is happening.

[Former Member]

Hi all,

I have 2 systems DEV & PRD on AIX 5.3 & Orc 10.2.

I have exported the file from PRD successfully & moved to DEV & maintained required permissions.

Now i have created a new client in DEV system.

Logged in with SAP* & pass.

I have executed STMS_IMPORT & appreantly i can KX & KT files & i have started importing in to source client.

Now from past 2 hours in sm50 there is only 1 report SAPLTHFB in display. No changes in sm50 from the import started.

How should i ensure that import is happening with out any issues.please advice me on the following.

[Former Member]

Dear all,

the following ca be the status is client import is happening to long.

message from sap support

**********************************************************************************************

I logon and check this issue.

As far as I see there is no error.

You can see in DIR_TRANS/tmp the following file kept on

increasing in size, thus it is not hung.

X 37207251 prdadm 29.04.2009 09:26:27 PRPIT00011.PRD

X 328 prdadm 28.04.2009 07:51:42 PRPKKT00011.PRD

In PRPKKT00011.PRD you can see #pid 2519058 on isrdserver (prdadm)

Directory: /usr/sap/trans/tmp

Name: PRPKKT00011.PRD

#pid 2519058 on isrdserver (prdadm)

import

buffersync=yes

file='/usr/sap/trans/data/RT00011.PRP'

continuation='/usr/sap/trans/data/RT00011_#.PRP'

client=130

repeatimport=yes

Check if there is multiple tp and R3trans running at the OS.

But I guess it is ok, as there is no semaphore file complaint

in SLOG.

To me, it is merely a performance problem and no error reported.

I thus go to ST04 and have a look. I see possible root cause why

the main import is running slow.

There are wrongly set 10g parameters and also essential

"underscore" params for 10g Oracle is missing!

eg:OPTIMIZER_FEATURES_ENABLE 10.2.0.1 while you are at

Oracle 10.2.0.2

Please make sure that all the parameters are set as per note 830576

specifically for those 'events' and '_' underscore parameters. Not

having these parameters set can have a significant effect on the generalperformance of a system.

Please also make sure that you have applied all the interims patches

as per note 871096, especially the Optimizer merge fix in point 12.

As of Oracle database 10g, you are required to create statistics for theOracle dictionary. In addition, you need to calculate system statistics.Please refer note 838725 - Oracle database 10g: New database statistics

for more details.

You can ask your DB administrator to use program RSORADJV and copy

the script of note 1171650 to check.

The missing "underscore" params I am talking about are for instance:

BTREE_BITMAP_PLANS

BLOOMFILTER_ENABLED

CURSORFEATURES_ENABLED

.........

OPTIMIZERMJC_ENABLED

PUSHJOIN_UNION_VIEW

SORTELIMINATION_COST_RATIO

TABLELOOKUP_PREFETCH_SIZE

Please have your Oracle DBA analyze this note and adjust accordingly.

I am sorry but I do not have a more positive answer to your issue.

Best Regards,

[Former Member]

Hi Rahul,

You can check Client Import status in SCC3.

Also check for Import_monitor and File systems whether it gets full then can get stuck.

using topas you can find out current processes activity.

Also check for oracles alert log which gets udpated.

Regards,

Nitin Salunkhe

[Former Member]

Hi Rahul

in STMS_IMPORT ie. import queue screen, you can check job monitor for that transport request

Go To-->Import Monitor (after selecting that request)

Also, at OS level, check the tp process if running for that transport

ps -ef | grep tp

if any tp process is running, then check the time of start

check sm21 logs if anything stuck

thanks

Bhudev