Tom:

Database will hang if you could create a UOW which is bigger than the
underlying log filesystem...here is how you can do it.

Change the db config parameters logprimary + logsecond to a value which
exceeds the size of the filesystem containing log files. Then create a
dummy table and start inserting data until the size of UOW exceeds the
size of log filesystem. At that point database will start hanging :-)

Hope this helps.

Suresh.




"TOHare" <db2udbdba-ezmlmshield-x5841601.[Email address protected]
07/28/2006 10:31 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
How to make a database hang






Hi all,

Environment

Server : Solaris (a test server)

Os : Sun OS Ver 5.8

Database udb "DB2 v8.1.0.48", "s040212", "U496794", and FixPak "5"

I am doing some recovery / outage testing and I want to make
db2 instance and or a database 'hang', in order to document and verify the
correct actions to
take in the event of a 'hang'.

I've tried filling the file system where the logs and database files are
but
I was still able to
connect to the database

Any Ideas please ?


Regards,
Tom


***************************************************************
The information contained in this e-mail and any files transmitted
with it is confidential and may be subject to legal professional
privilege. It is intended solely for the use of the addressee(s).
If you are not the intended recipient of this e-mail, please note
that any review, dissemination, disclosure, alteration, printing,
copying or transmission of this e-mail and/or any file transmitted
with it, is prohibited and may be unlawful.
If you have received this e-mail by mistake, please promptly
inform the sender by reply e-mail and delete the material.
Whilst this e-mail message has been swept for the presence of
computer viruses, eircom does not, except as required by law,
represent, warrant and/or guarantee that the integrity
of this communication has been maintained nor that
the communication is free of errors, viruses, interception or
interference.
***************************************************************


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



CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000.

CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages by authorized Kohl's Associates at any time
without any further consent.


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