Home

Contribute

Submitted by Paul Miller on Fri, 2006-03-10 13:30.

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.

»

tempdb full

Submitted by Chris Langham on Tue, 2006-08-22 09:07.

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

»

Re: tempdb full

Submitted by Jim Prince on Tue, 2006-08-22 16:48.

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

»

Re: tempdb full

Submitted by Chris Langham on Thu, 2006-08-31 15:34.

Hello Jim,

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

All the best

Chris

»