Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Sybase Topics / September 2008

Tip: Looking for answers? Try searching our database.

global synchronization point

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
horos11@gmail.com - 18 Sep 2008 01:17 GMT
hey all,

I was wondering if it was possible to do the following -

I would like to set a 'sync point' where

1) transactions could occur on a given database or databases after the
sync point was created in multiple sessions.
2) I could globally 'roll back' the database to the sync point.

I'm not thinking of the transaction begin/commit/rollback cycle, I'm
thinking of it truly globally - where users could do multiple commits
and rollbacks, and then do a global rollback to a given point of time.

In oracle, I believe this is done through transaction logs; how do you
set up this in sybase?

Ed

(ps - how do you get the version of sybase that you are running
against via isql? I see in my case the binary is old (1999) but I'm
assuming that the database itself is a lot newer..)
mnajs - 18 Sep 2008 12:29 GMT
horos11@gmail.com pisze:
> [...]
> I'm not thinking of the transaction begin/commit/rollback cycle, I'm
[quoted text clipped - 3 lines]
> In oracle, I believe this is done through transaction logs; how do you
> set up this in sybase?

Hi,
If you perform database+transaction log dumps for your database
you can 'rollback' the state of database loading database from
the last db dump and loading transactions up to a specified time
(i.e. using 'until_time' option). I'm not an expert but I think
it would work.

> (ps - how do you get the version of sybase that you are running
> against via isql? I see in my case the binary is old (1999) but I'm
> assuming that the database itself is a lot newer..)

For ASE servers, @@verion is a server-wide, global variable that
contains version information.
>select @@version
>go

Regards,

Signature

Marcin Najs

Keith - 19 Sep 2008 17:47 GMT
On Sep 17, 7:17 pm, horo...@gmail.com wrote:
> hey all,
>
[quoted text clipped - 5 lines]
> sync point was created in multiple sessions.
> 2) I could globally 'roll back' the database to the sync point.

The "es" after database is the sticky point here. If you mean "within
the same database server" you're OK.  If you mean across database
servers I think what you are after is known as an "XA" architecture
and requires additional product for the database vendor [be it Oracle
or Sybase] as well a "transaction monitor" or equivalent (J2EE
Application Server, e.g.) and application support to do it right.
What if your application creates
flat files, for example, or sends pub / sub messages; are actions
required there (external to your database(s)) when you rollback?

Your problem statement is very general and (potentially) very
ambitious at the same time.

Keith
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.