Sybase ADDICT

Sybase tips, howto and technical informations – All in a blog !
  • Home
  • Sybase Downloads
  • Sybase Related Links


 


  • When was the last full backup of your database?

    February 27th, 2011 @ 11:22 AM by Jean-Francois LEBON | Be the 1st to comment

    To know when the last full backup of your database occurred you can look at the backupserver logfile, of course. But you don’t have to. Indeed you can find this information with Sybase ASE using the command “dbcc dbtable”.
    Read more…


    Tags: howto, sybase, Sybase Adaptive Server Enterprise, tips

  • List tables with allpages or datarows locking scheme

    February 4th, 2011 @ 2:26 PM by Jean-Francois LEBON | Be the 1st to comment

    To list the tables that use datapages or datarows locking scheme, use:

    select name,sysstat2
    from sysobjects
    where type = 'U'
    and (sysstat2 & 16384 = 16384 or sysstat2 & 32768 =32768)

    To list tables that use allpages locking scheme, use:

    select name,sysstat2
    from sysobjects
    where type = 'U'
    and sysstat2 & 8192 = 8192

    Tags: sybase, Sybase Adaptive Server Enterprise, transact-sql

  • Using “dump marker” to resync a warm standby

    January 4th, 2011 @ 4:32 PM by Jean-Francois LEBON | Be the 1st to comment

    I recently had to resync a warm standby database for a customer. When I can’t stop the transactions on primary database I use the “dump marker” clause while recreating the connection to the warm standby database with replication server. Indeed, you can resync a warm standby database anytime with no downtime on the primary database side using the “dump marker” method. Let’s assume the following warm-standy architecture:

    - SYBPARFRDEV01_DS as the primary dataserver
    - SYBPARFRDEV02_DS as the target dataserver
    - SYBPARFRDEV02_RS as the replication server
    - projectdb as the primary and replicated database

    Read more…


    Tags: replication, replication server, sybase

  • ASEMON: monitor Sybase products performances !

    October 31st, 2010 @ 11:21 AM by Jean-Francois LEBON | Be the 1st to comment

    A database administrator regularly need to address database performance issues. But database performance and tuning is not always an easy task because it can sometimes involve several complicated processes to find bottlenecks. For several years now, I use a free tool  named ASEMON released under GNU GPL license (yes, it is open source !!). ASEMON is developed and maintained by Jean-Paul Martin at Sybase France. Here is a short description of the product…

    1°) What is ASEMON ?

    ASEMON is an efficient and reliable tool that collect and store performance metrics from various Sybase products such as Sybase ASE, Replication Server and Sybase IQ. It is made of two components:

    Read more…


    Tags: replication server, Review, sybase, Sybase Adaptive Server Enterprise, Sybase Adaptive Server IQ

  • Query Optimization Secrets

    October 14th, 2010 @ 1:05 PM by Jean-Francois LEBON | Be the 1st to comment

    Embarcadero software and ISUG (International Sybase User Group) offer a free online webinar about query optimization for Sybase ASE. In this particular webinar, you will be able to ask directly your questions to optimize your sql queries with a bunch of top Sybase ASE experts like Peter Dobler and Kevin Sherlock. Query performances, Sybase ASE optimizer and optimizer mode will be discuss. This webinar is a valuable way to acquire or expand your knowledge.

    3 sessions of this free webinar are scheduled October 21th from 7:00AM to 7:00PM.
    See the schedule here.


    Tags: ase, news, sybase, Sybase Adaptive Server Enterprise, webcast

« Previous Entries



Categories:

  • Review
  • Sybase Adaptive Server Enterprise
  • Sybase Adaptive Server IQ
  • Sybase Articles
  • Sybase HowTo
  • Sybase News
    • End of Life Notice
    • General News
  • Sybase Replication Server
  • Sybase Tips & Tricks
  • Sybase Transact-SQL Code
  • Videos/Podcasts/Webcasts

Quick Links:

  • Sybase quick refence
  • Sybase Bookmarks
  • Sybase Team Forums
  • Sybase Inc
  • International Sybase User Group
  • CodeXchange
  • SQL Anywhere question and answer
  • You need a Sybase DBA

Archives:

  • February 2011
  • January 2011
  • October 2010
  • August 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • September 2009
  • July 2009
  • May 2009
  • April 2009
  • January 2009
  • December 2008
  • October 2008
  • September 2008
  • May 2008