Sorry I wasn't clearer. A thead dump is a snapshot of all running threads in the system, not a stacktrace of failures.
You can generate a threaddump on Windows by running your server from the command line, and when the hang occurs during backup, pressing CTRL-Break (CTRL key and Break key at the same time). This will produce a threaddump in your console (cmd.exe) window. Copy/paste the threaddump somewhere we can take a look at it. If you are on Linux, you can produce a threaddump by sending the process a QUIT signal: kill -QUIT process_id Regards, Brett On Thu, Jun 9, 2011 at 4:01 PM, dvijender <vijender.devak...@db.com> wrote: > > Hi Mike, Brett, > > Attached thread dump. Here the database size is 20 GB. > > > Brett Wooldridge-2 wrote: >> >> Do you have a thread dump during the hang? What >> OS are you running on? >> >> Brett >> >> Sent from my iPhone >> >> On Jun 7, 2011, at 16:38, Vijender Devakari <vijender.devak...@db.com> >> wrote: >> >> Hi, >> >> Can you respond to this as this is very urgent. >> >> Best Regards, >> >> Vijender D, >> Deutsche Bank >> Ph: +65 6423 8530 >> Mobile: +65 94517994 >> >> ************************************************************ >> This mail is transmitted to you on behalf of [HCL]. >> Diese Post wird Ihnen im Namen der [HCL] ubermittelt >> ************************************************************* >> >> <graycol.gif>Vijender Devakari/ext/dbcom >> >> >> >> *Vijender Devakari/ext/dbcom* >> >> 06/03/2011 04:28 PM >> >> <ecblank.gif> >> To >> <ecblank.gif> >> derby-user@db.apache.org <ecblank.gif> >> cc >> <ecblank.gif> >> <ecblank.gif> >> Subject >> <ecblank.gif> >> SYSCS_UTIL.SYSCS_BACKUP_DATABASE failing <ecblank.gif><ecblank.gif> Hi >> Team, >> >> we are using below proc for backing up the database, but this call is >> hanging when the Database is size more like 3GB, 4GB, ... >> >> Can you let me know in which case we can use this and also what else we >> need >> to use to backup database incase if the siz is more. >> >> CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?) >> >> Best Regards, >> >> Vijender D, >> Deutsche Bank >> Ph: +65 6423 8530 >> Mobile: +65 94517994 >> >> ************************************************************ >> This mail is transmitted to you on behalf of [HCL]. >> Diese Post wird Ihnen im Namen der [HCL] ubermittelt >> ************************************************************* >> >> >> --- >> >> This e-mail may contain confidential and/or privileged information. If you >> are not the intended recipient (or have received this e-mail in error) >> please notify the sender immediately and destroy this e-mail. Any >> unauthorized copying, disclosure or distribution of the material in this >> e-mail is strictly forbidden. >> >> > http://old.nabble.com/file/p31806974/Logs.zip Logs.zip > -- > View this message in context: > http://old.nabble.com/Re%3A-SYSCS_UTIL.SYSCS_BACKUP_DATABASE-failing-urgent-tp31789732p31806974.html > Sent from the Apache Derby Users mailing list archive at Nabble.com. > >
