Sybase ADDICT

This sql query tells you if Direct IO is supported on your platform:

select low from spt_values
where  type='io'

A value of 1 means “Yes, direct io is supported on this platform”.
A value of 0 means “No, direct io is NOT supported on this platform”.

Read this nice post from David Wein about Direct I/O device option.

Want to know what platform your Sybase Adaptive Server is running on ? No need to connect to the machine to find out, just run this little query:

select name from master..spt_values
where type = 'E' and number = 1
go

For me it shows:

name
--------------------------------------------------------
linux

Nice…

This year Sybase User Training & Solutions Conference, formerly known as TechWave, will be held August 9-11 at the Hilton Washington, in Washington, DC. Sybase TechWave is a useful and informative event where you can share or improve your products knowledge. The event is scheduled as follow: a free day for prospects and business guests, and a fee to attend the multi-day technical training. They even plan to expand the event by including an additional day of technical training.

Visit http://www.sybase.com/techwave for more details.

When speaking of moving/copying database between dataservers, database “dump and load” strategy usually come up in mind. Thanks to mount, unmount and quiesce database commands, you can sometimes replace advantageously “dump/load” operations.

1°) Moving a database:

I assume here we want to move completely the database DBLA01 from source dataserver SYBPARFRDEV01_DS to destination dataserver SYBPARFRDEV02_DS. Both dataservers are on the same machine. Database DBLAB01 has it’s own devices.

Read more…

Sybase is announcing the end of engineering support for ASE Database Expert Option and ASE SQL Expert Option for all platform as of 02/01/2011. These products will be discontinued, means Sybase will not provide these products anymore.

But Sybase customers are eligible to upgrade to “Quest SQL Optimizer Suite for Sybase ASE” at no additional charge.

Details of the upgrade program can be found here:
http://www.quest.com/sql-optimizer-suite-for-sybase/upgrade

See more here