Talis Developer Network - Contribute - Comments

Re: tempdb full

Chris Langham — Thu, 31 Aug 2006 15:34:59 +0100

Hello Jim,

Thanks for your reply. I have already got Talis Support to expand tempdb.

All the best

Chris

Re: tempdb full

Jim Prince — Tue, 22 Aug 2006 16:48:05 +0100

Hi Chris,

1. Yes, tempdb is cleared down when Sybase is restarted. So since it's the MIS Server you can simply stop and start Sybase.

2. Tempdb can be expanded (it should be at least 200mb). You can use sp_helpdb to check. If it needs to be bigger I would suggest you log a call with Client Services.

Can I also suggest you direct future posts to the appropriate section of the Discussion Area.

Thanks,

Jim

tempdb full

Chris Langham — Tue, 22 Aug 2006 09:07:34 +0100

Hello All,

Over the past couple of weeks – I’ve had tempdb fill up twice on MIS. The only way I know to fix this problem is to load a backup onto MIS.

1. Is there a way of clearing down tempdb without restoring from backup?
2. Alternatively can tempdb be expanded?

I’ve been running some hefty SQLs through the WORK_SUBFIELD or the LOAN tables and I’m sure that these have filled up tempdb. Consequently the contents of this database aren’t needed.

Thanks

Chris

Contribute

Paul Miller — Fri, 10 Mar 2006 12:30:25 +0000

Contributions

Have you got a script that the rest of the community wants? Have you instructions for configuring a product or a modification that takes it to another level? We are looking for articles from the Developer community be they large or small. Please e-mail tdn.contributions@talis.com with any ideas or questions about submitting articles or other material.

If you want to contact us at the TDN for any other reason please e-mail tdn.developer@talis.com with your comments.