cancel
Showing results for 
Search instead for 
Did you mean: 

Large Number of Entries in ARFCRSTATE & VBDATA

Former Member
0 Kudos

Hello Experts,

The Tables ARFCRSTATE & VBDATA has large amount of Data in testing & Production server.

Because of which the performance of the system is affected.

Could you please help in the possibility of purging data from these tables?

ARFCRSTATE has more than 96M rows on Testing Server and more than 100M(Million) rows in PROD.

I tried using the report RSTRFCEU, but it is not working. The execution of report is not working, I think there might be a problem with the Inputs of the report.

Also tried SAP Note : 366869.

I Have SAP 4.7 with AIX.

Could you please Help !

Thanks.
Mayank Jain

Accepted Solutions (1)

Accepted Solutions (1)

Reagan
Advisor
Advisor
0 Kudos

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Please check the below notes and see whether it helps.

Note 375566 - Large number of entries in tRFC and qRFC tables

You can also  try to create Index for these tables and get the stats up to date.

Thanks and Regards,

Vimal

Former Member
0 Kudos

Hello Thanks for your Reply.
I tried using the Note : 375566, but it indirectly links to the NOTE : 366869.
we need to delete records from the TABLE.

Former Member
0 Kudos

Hi,

Yes. You can run the program RSTRFCER to delete the entries with executed status . You can set your desired frequency of deletion.

 

Thanks and Regards,

Vimal

Former Member
0 Kudos

Hi,

I tried using the report the RSTRFCER in BGD, but the report gives Dump "TSV_TNEW_PAGE_ALLOC_FAILED".

I deleted OLD Spool,Again i run the report but same error,

I checked the memory parameter they are also fine...

Former Member
0 Kudos

Please read the Note 1666693 - Report RSTRFCEU terminates with a memory related dump to resolve you issue.

Regards,

Roman

Former Member
0 Kudos

Hello,

Thanks for your feedback !!

The Note specified ask for the PARAMETER "abap/arfcrstate_col_delete", but when i search on my system the parameter is not present (in none of the profile).

Should i define the parameter.???

Reagan
Advisor
Advisor
0 Kudos

Hello Mayank

Should i define the parameter.???

and my answer to that question:

http://help.sap.com/erp2005_ehp_04/helpdata/en/fd/3b5c3c77062d7fe10000000a114084/content.htm

Cheers

RB