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

Compare join and subquery in performance?

1001

---

How do the blocker processes exist internally in sybase?

950

---

How do I capture a process s sql in sybase?

1010

---

How to take backup in sybase database in sap?

939

---

Explanation about replication server software?

986

---

List the merits of index covering.

920

---

What is my identity burn factor vulnerability right now in sybase?

937

---

What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?

969

---

Differentiate between ltm and repagent?

1039

---

What is the relationship between jdbc and sybase?

1003

---

How do I run multiple versions of sybase on the same server?

930

---

What is the difference in storage type of numeric and decimal data types in sybase ?

906

---

Explain open server?

976

---

Explain about the features of sybase iq?

1060

---

Explain locking?

952

---