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  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
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 ?    3 Yes 7 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 ?    5 Yes 6 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 ?    4 Yes 2 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 ?    9 Yes 0 No
Ajith Prabhakaran
 
  Re: How do you troubleshoot if your tempdb gets filled
Answer
# 5
if the system temp db gets filled, even sa cannot get 
connected to that temp db  to check which processes are 
blocking, in order to avoid this , a good concept of 
multiple temp dbs can be implemented and we can create temp 
dbs and assign newly created temp db to sa, so that sa 
could get the info of the processes that is blocking temp 
db, ab=nd by using lct_admin or some other commands we can 
abort that blocking transaction.
 
Is This Answer Correct ?    1 Yes 1 No
Bindu
 
  Re: How do you troubleshoot if your tempdb gets filled
Answer
# 6
use tempdb
go
sp_helpsegment "default"
go

 
Is This Answer Correct ?    1 Yes 0 No
Sanjeev Shekhar
 
  Re: How do you troubleshoot if your tempdb gets filled
Answer
# 7
If the transaction log of tempdb is full then you call 
login through sa and type following command.
> dump tran tempdb with trancate_only
> go

If the database is full then you can increase the size of 
the database on a free device.
> alter database tempdb on device_name = size
> go
 
Is This Answer Correct ?    1 Yes 0 No
Aditya
 

 
 
 
Other Sybase Interview Questions
 
  Question Asked @ Answers
 
what is the architechure of sybase ASE? ocbc1
can i gat any proper material for sybase if possible plz let me know balaji.cc1@gmail.com  2
what means of sybase ?? and how i can use sybase data base on my computer Iam the first use it >> any help please !  1
how to do application monitoring through AutoSys? Cognizent1
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
How do you troubleshoot if your tempdb gets filled HCL7
Sybase system databases  1
What is a temp table? how to denote temp table? Oracle3
 
For more Sybase Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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