And I agree with you, Nick!
The other suggestion I meant to make is that since locklist comes out of
database global memory, you might take a look at that as well, and see what
other calls are being made on that menmory pool. Much harder to do at V7.
Regards
Alex

-----Original Message-----
From: dbaguru
[mailto:db2udbdba-ezmlmshield-x34314768.[Email address protected]
Sent: 17 November 2006 19:15
To: LazyDBA Discussion
Subject: Re: DB2 UDB 7.2.9 SQLstate 57011

Hi Hans,

Alex Levy has replied to your email, and I concur with his suggestion. You
may also want to increase the swap space on your server. I don't know what
operating system you're running, but the virtual storage/database resource
comment in the error message indicates a potential temp storage problem. I
suggest 2x memory for swap file size. BTW, you're still running on v7?
It's way past time to upgrade.

Nick

-------------- Original message --------------
From: "Kroon Hans " <db2udbdba-ezmlmshield-x14424416.[Email address
protected]

> DB2 UDB 7.2.9 SQLstate 57011
>
>
> We got the following sqlstate from our application: SQLstate 57011
> (Virtual storage or database resource is not available)
>
> We don't have any problem with our db2 server (disk space is ok and
> also no logfile problem) logprimary=5 and logsecond=15 and only 4
> logfiles, but no first active logfile.
>
> db2diag.log:
>
> 2006-11-17-10.39.34.575000 Instance:X2B1_PRD Node:000
> PID:249(db2syscs.exe) TID:455 Appid:C0A80106.1907.061117082717
> data_management sqldEscalateLocks Probe:2 Database:MDI_X2B1
> -- Lock Count, Target : 1252, 626
> -- Table (ID) Name : (2;335) KLBBS .VERZAMELPRINT
> -- Locks, Request Type : 1249
>
> What is here the problem? We have tried to change the app_ctl_heap_sz
> but this has no effect.
>
> regards,
> Hans Kroon
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
> a dba job: http://jobs.lazydba.com To Subscribe :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html



-----------------------------------------------
Scanned by 186k-NetCleanse, spam and virus protection



DB2 & UDB email list listserv db2-l LazyDBA home page