Answer Posted / eshwar

if tempdb is full
1. check the free space of tempdb by using command
1>sp_helpdb tempdb
2>go
it show the size of tempdb and free space
2) check whether logshold transaction is going on
1> select * from syslogshold
2>go
you see the long hold transaction if their is any long hold transaction
see the user and time and inform to the user by raising ticket to him
as per his response we will kill the long hold transaction command

1> kill sid
2>go

or else we will try to increase the size of tempdb
by using command
1>alter database tempdb on devicename='size',log on logdevice='size'
2>go
if this command is not working. we will clear the tempdb by using this dump command
1>dump tran tempdb to '/path'
2> go
or
1>dump tran with tranket_only
2>go
or
1>dump tran with no_log
2>go
if else it is also not working. We will clear the tempdb by using command
1>select lct_admin('abort',0,2)
2>go
this command will clear all transaction and longhold transaction in tempdb

Differentiate between replication server and sql remote?

969

---

How do I create a database in sybase central?

918

---

What is replication server in sybase?

840

---

How to find the time taken for rollback of the processed?

969

---

Who owns sybase?

846

---

What is a good example of a transaction in sybase?

1032

---

Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

855

---

State some of the products of sybase?

902

---

What are the operating systems in which sybase could take its presence?

901

---

How to check database size in sybase iq?

987

---

The secondary truncation point is on. How would you clear the logsegment?

869

---

What will you do if a replication thread goes down?

982

---

Explain index covering?

837

---

How do I set ts role in order to run certain dbccs?

789

---

How to restore sybase database in sap?

967

---