Buffer TABL reset

[Former Member]

Dear All,

Daily we are getting error "Buffer TABL reset" in sm21logs in development server.

my server details

Operating system..... "AIX"

Release.............. "5.3"

Hardware type........ "00C8D1D04C00"

Character length.... 16 Bits

Pointer length....... 64 Bits

Work process number.. 1

Shortdump setting.... "full"

Database type..... "ORACLE"

Terminal................. ""

Char.set.... "C"

SAP kernel....... 700

created (date)... "Sep 26 2008 04:50:06"

create on........ "AIX 2 5 005DD9CD4C00"

Database version. "OCI_102 (10.2.0.2.0) "

Patch level. 179

Patch text.. " "

Database............. "ORACLE 9.2.0.., ORACLE 10.1.0.., ORACLE 10.2.0.."

SAP database version. 700

Operating system..... "AIX 1 5, AIX 2 5, AIX 3 5, AIX 1 6"

SAP ECC 6.0

Please give the solution

Regards

KARAN

[Former Member]

Dear Karan,

when the buffers are inconsistent a reset of the pool or transparent table will be performed.

This is controlled in SE13 Maintain Technical Settings

Regards,

Gerd

[Former Member]

Dear Gerd,

thank you for your quick reply,

i have gone through the se13 transaction,it prompting for table.for which table i have to set the technical settings to resolve my issue.

Please elaborate the procedure.

Thanks Regards

KARAN

[rajasekhar_reddy14]

Hi ,

As per my knowledge we need to set buffer size for development system bit high,i think your buffer space got exceed..

refer below link it will help you regarding the best practices.

http://help.sap.com/saphelp_nw04/Helpdata/EN/c1/c397117b784f2285abae83c7964503/frameset.htm

Regards,

raj

[Former Member]

Dear Rajashekhar,

Free buffer space is avaliable in my surver,still we are getting problem.

Please find my server buffer details of TABL and TABLP.

Buffer HitRatio % Alloc. KB Freesp. KB % Free Sp. Dir. Size FreeDirEnt % Free Dir Swaps DB Accs

Tables

Generic Key 98.55 29,297 2,919 10.52 5,000 1,703 34.06 2,980 1,695,017

Single record 83.16 10,000 310 3.16 500 420 84 403 1,139,290

Please suggest.

Thanks Regards

KARAN