Size of table ARFCSDATA and ARFCSSTATE

[Former Member]

Hi Gurus ,

Can anyone tell me,

1.) what is the difference between ARFCSDATA , ARFCSSTATE and ARFCRDATA , ARFCRSTATE.

2.) Is any data stored in ARFCSDATA , ARFCSSTATE .

3.)What should be the size of ARFCSDATA , ARFCSSTATE .

In my system the size has grown to 3GB and 17GB respectively .

Please help ........

Regards

Anthony

[markus_doehr2]

The difference is, those are different tables used by the qRFC interface (CRM, BW, SCM) to transfer data consistently and transactional from one system to another.

Due to that fact, nobody can tell you the "sizes" of those tables since they depend on how much data you transfer between systems.

Check transaction SMQ1 and SMQ2 for data that is not processed. The "destination" is the RFC of the target system, maybe it´s unreachable at the moment and thus the data is queueing up.

--

Markus

[Former Member]

Hi Markus ,

Thanks for the reply ....

I have checked smq1(OUTbound) and smq2(INbound) T-code.

The smq2 gets excute very fast , but the smq1 takes lots time to get execute .

There are some old queues in the OUTBOUND, approx. 3,673,872 (checked in table TRFCQOUT).

Hence , i had run report RSTRFCES with the following parameters

Status of LUWs to Delete=*

User Name=*

Older Than (Days)=180

Package Size=5,000 .

But only 500 queues got deleted.

Please help as to how to increase the performance of smq1.

Are there any daily jobs that has to be run for the same.

Regards

Anthony

[markus_doehr2]

Don't just "delete" them. You need to check why they are not processed.

Are they in status SYSFAIL?

--

Markus

[Former Member]

Hi Markus ,

Some of them were in "SYSFAIL" and some in "NOT SEND", but i had checked there were very old queues , some were as old as 2005.

Regards

Anthony

[markus_doehr2]

If they are that old the can be deleted (select them and delete).

For actual queues one need to find out the reason why they are failing (doubleclick on the SYSFAIL entries)

--

Markus

[Former Member]

Dear Markus ,

Do we have to select individual queues and delete or is there any other method.

Regards

Anthony

[markus_doehr2]

Yes - you should do that manually. You can select all (via menu) if you really want to delete them all, but make sure there's no actual data in them.

--

Markus