Database error -930 at FET

[Former Member]

Dear All,

We are running on AIX, DB6 (09.07.0003), SAP CRM ABAP 6.0 (SP22).

In system log (SM21) we are frequently getting the below given error:

Time Type Nr Clt User TCode Grp N Text

04:15:26 DIA 001 000 BGD_USER BY 2 Database error -930 at FET

04:15:26 DIA 001 000 BGD_USER BY 0 > SQL0930N There is not enough storage available to process

04:15:26 DIA 001 000 BGD_USER BY 0 > the statement. SQLSTATE=57011 row=1

04:15:26 DIA 001 000 BGD_USER BY 1 Database error -930

Could you please tell me the cause/text of the error code 930 in DB2, also how to check the process storage availability.

Regards,

Kiran

[paul_power]

Hi Kiran,

What is the entry in the db2diag.log from this time?

What are your current settings for:

-> INSTANCE_MEMORY

-> DATABASE_MEMORY

What is the output of db2level?

Regards,

Paul

[sunny_pahuja2]

Hi,

This means there is no more memory segment left in our system. Check below link:

https://www-304.ibm.com/support/docview.wss?uid=swg21113802&wv=1

Thanks

Sunny