Dont know why you need to bounce the server, but increase the package cache
size and you wont get the error.

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"edwinuy"
<db2udbdba-ezmlms
hield-x17952811.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
09/24/2004 01:50
AM Subject
Anyone encountered a similar error
message like this










Hi all,

Once in a while, I will get the error message ...

"A package cache overflow condition has occurred .you may want to adjust
the PCKCACHESZ DB"

Then I will have database locks happening and more often than not, we have
to bounce the server. Any suggestions?

Cheers,

EDWIN ONG UY
UNIT 4,64 GRANGE ROAD
MT EDEN 1003
AUCKLAND, NEW ZEALAND
Email: [Email address protected]
Mobile: 64-021-622092

-------------------------------------
This email is intended solely for the named recipient/s and as such is
confidential and may contain information that is privileged. If you have
received it by mistake, please notify the sender. You must not use, copy,
distribute or disclose its contents to anyone other than the addressee.
This email and any attachments might not be free from computer viruses or
other defects.



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



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