Strange behavior with library R3DESX0000, R3DES3260, R3PRDX0000, R3PRD3260

[Former Member]

Hello

We have 2 SAP systems in the same AS/400 system, DES and PRD.

PRD this just installed and unique has one client one just as DES.

But the size of the library is much greater in PRD, for example R3PRD3260 has 2.451.708Kb and R3DES3260 has 257.228Kb another library R3PRDX0000 has 3.651.172Kb and R3DESX0000 has 1.083.212Kb.

Somebody knows because it can be and as it is solved?

Thanks

[Former Member · Accepted solution]

HI,

this library belongs to SQL Packages.

stop SAP system and delete old SQL package from system.

for delete sql package

execute following

DLTR3PKG SID(<SID>) PKGTYPE(*ALL)

now start sap system and check the size of library.

regards,

kaushal

[Former Member · Accepted solution]

Hi

I will test it.

I was readding notes about it, and I found it and talk about the same, delete sql packages.

DLTR3PKG SID(PRD)

or

DLTR3PKG SID(PRD) PKGTYPE(*ALL)

Thanks

Edited by: GuillePo on Jun 4, 2008 3:01 PM

Edited by: GuillePo on Jun 4, 2008 3:03 PM

[teddylv_andersen2]

Hi,

The size of the libraries holding the SQL Packages will vary from system to system as the are depending of the load in the system. You will usually see that the more a system is used the bigger libraries. Please be aware that deleting the SQL Packages will decrease the performance of your system until SQL statements are prepared and saved in the libraries again, and that's the time where the library is growing.

We usually only delete SQL packages when having SQL errors in our system.

Teddy