-
Stable Device
What do you mean by Stable Device in Sybase replication?
mikeob
- Jun 17th, 2009
I think the textbook term is 'stable queue' - the place on disk where transacitons/data is stored until it reaches its destination(s). Plays the role of a ledger file in JMS/Tibco.
-
Purge Data
How will you purge data from audit database?
mikeob
- Jun 17th, 2009
To back up sysaudits_0n, set up a threshold which, when triggered, copies its contents into a permanent table and uses sp_configure to set the new active audit table to sysaudits_0(n+1). This will get...
-
Sybase Workspace
How is Workspace used in Sybase?
mikeob
- Jun 17th, 2009
I think it needs clarification. The only 'workspace' that comes to my mind here is a *.ws file from Sybase Power Designer. In that case a workspace serves as a container for physical, logical ERDs and reports, etc.
-
What is the difference between sybase 11.X and 12.XWhat is the advantage of UDB over sybase
mikeob
- Jun 17th, 2009
Although there are numerous differences, probably the most relevant was the introduction of data-only (pages, row level) locking for tables in 12.x. That was the biggest one that shook up the Sybase c...
-
how to check the long running transaction ?
mikeob
- Jun 17th, 2009
In addition to syslogshold one can look at master.sysprocess and the physical_io. If this is large (several hundred thousand) you are probably looking at a query doing a table scan. syslogshold tends to only store teh *longest*.
srihari
- Jul 8th, 2007
Select * from syslogshold
-
how the blocker processes exist internally in sybase
deepaish
- Aug 16th, 2009
You can execute the stored procedure sp_who , this will give you process id which is blocking what. This is more usefull since sometimes user doesn't have restricted permission for master database.
mikeob
- Jun 17th, 2009
One can look at master.sysprocesses blocked column to look at what is blocking what.
