ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  Sybase
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
How do you troubleshoot if your tempdb gets filled
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How do you troubleshoot if your tempdb gets filled
Answer
# 1
use tempdb
go
sp_helpsegment "default"
go
 
Is This Answer Correct ?    2 Yes 2 No
Sri
 
  Re: How do you troubleshoot if your tempdb gets filled
Answer
# 2
Do any of the following 
1. restart the sybase database server
2. alter the size of the tempdb
 
Is This Answer Correct ?    0 Yes 3 No
Prabhu
 
 
 
  Re: How do you troubleshoot if your tempdb gets filled
Answer
# 3
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 ?    3 Yes 0 No
Kk07
 
  Re: How do you troubleshoot if your tempdb gets filled
Answer
# 4
lct_admin (0,2) would abort all open transactions, or you 
can go for altering the tempdb space. Multiple tempdb's is 
a feature which can be implemented to minimize such issues 
of tempdb getting full.
 
Is This Answer Correct ?    4 Yes 0 No
Ajith Prabhakaran
 

 
 
 
Other Sybase Interview Questions
 
  Question Asked @ Answers
 
Sybase system databases  1
What is a temp table? how to denote temp table? Oracle1
can i gat any proper material for sybase if possible plz let me know balaji.cc1@gmail.com  1
How do you troubleshoot if your tempdb gets filled HCL4
what is the architechure of sybase ASE? ocbc1
Sybase 12.5 Database Statistics (Maximum)  1
In sybase, we can have multiple users associated to same login ,each corresponds to different databases, right? how can we login to one database with corresponding user id? ISRO1
 
For more Sybase Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com