Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How do you troubleshoot if your tempdb gets filled

Answer Posted / kk07

If your tempdb gets full you can do one of following:
you can expand your tempdb or you can use

select lct_admin(0,2)
go
It will abort all open transactions.But be sure the task by
confirming with the concern users.
Restarting the server is not recommanded.

Is This Answer Correct ?    16 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between db-lib and ct-lib in sybase?

835


How can I tell the datetime my server started?

970


Can I partition any table in sybase ?

990


How do I create a partitioned table that spans multiple devices in sybase?

792


Explain relationship between jdbc and sybase.

914


Which version of open client works with which ase in sybase?

920


Is sybase a database? Explain.

965


What is the command for quitting from sybase?

935


What measures are there to increase the db space?

906


How would you fix a munged log in sybase ?

960


Explain about the mainframe connect tools from sybase?

928


What is open client in sybase?

881


What are the main differences between 11.x and 12.x versions of sybase?

843


How would you configure identities in sybase?

1021


What are the best monitoring tools for the sybase database?

826