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

What is the stored procedure to view current lock and processes respectively?

594

---

How do I find the oldest open transaction in sybase?

535

---

What do you mean by deferred update in sybase?

591

---

Is sybase relational database?

555

---

How would you configure identities in sybase?

593

---

---

You want to delete a table in sybase. How would you do it?

530

---

You need to manipulate varbinary columns in sybase. How would you do that?

556

---

List different types of locks in sybase?

585

---

Explain intimate shared memory(ism)

607

---

What are the best monitoring tools for the sybase database?

493

---

How do I tell which tables have identities in sybase?

555

---

List similarities and differences between oracle & sybase.

594

---

What is coalesce in sybase?

608

---

Explain sybase sql server?

598

---

For synchronizing the logins from lower version to higher version, just take the 11.9.2 syslogins structure, go to 12.5 higher version server?

551

---