closed comment section

I closed the comment section today, as I am getting daily spam from this site. I have tried to delete the spam comments, but it's still took too much of my time. so I leave it for now. When I have time, will clean it up.

Nothing really exciting for me in the last little while, so I have no new post. The best news was probably the sybase buy out from SAP. Sybase will be safe for another 10-20 year, I guess. wish I had bought sybase stock before the buyout :)

What a historical year it is? I haven't posted for over a year now, simply because it's so many changes happened in the past 1 year, the fall of bear stern, lehman brothers, stock market crash, layoff, company strategy change ..... though I was not impacted, but it's amazing to watch all these happening around me and I am not too interested on the techinical stuff at this moment.

Sybase stock was up more than 20% in May

I noticed Sybase stock (symbol SY) was up more than 20% in May. That's pretty good run. Right now it's $31.47.

DDL for master..syslogins

The DDL for syslogins comes in handy when you work on syslogins related tasks, i.e. Migrate syslogins from Sybase 12.0 to Sybase 12.5. Most DBA tools reverse DDL for user tables only.

USE
tempdb
go
CREATE TABLE dbo.jx_syslogins
(
suid int NOT NULL,
status smallint NOT NULL,
accdate datetime NOT NULL,
totcpu int NOT NULL,
totio int NOT NULL,
spacelimit int NOT NULL,
timelimit int NOT NULL,
resultlimit int NOT NULL,
dbname sysname(30) NULL,
name sysname(30) NOT NULL,
password varbinary(30) NULL,
language varchar(30) NULL,
pwdate datetime NULL,
audflags int NULL,
fullname varchar(30) NULL,
srvname varchar(30) NULL,
logincount smallint NULL,
procid int NULL)
go

1> insert master..syslogins (suid, status, accdate , totcpu , totio , spacelimit , timelimit , resultlimit , dbname , name , password , language , pwdate , audflags , fullname , srvname , logincount )
2> select * from jx_syslogins
3> go

How to stop Oracle Archive log mode

startup mount;
alter database noachivelog;
alter database open;
archive log list;

How to move a datafile using disk mirroring in Sybase12.5

Example: move audit01 device from /dir1/datafile1 to /dir2/datafile2

sp_configure ‘disable disk mirroring’, 0
go
shutdown with nowait
go

- restart dataserver

disk mirror
name = audit01,
mirror = "/dir2/datafile2"
go

disk unmirror
name = audit01,
side = "primary",
mode = remove
go

sp_helpdevice audit01
go
sp_configure 'disable disk mirroring", 1
go
- restart dataserver

Sybase reports record First Quarter Results

Highlights:
Total revenue of $260.1 million, up 13% year over year
License revenue increased 13% year over year
Services revenue increased 8% year over year
Database license revenue increased 19% year over year
Messaging revenue increased 37% year over year
GAAP operating margin of 14%, versus 9% a year ago; non-GAAP operating margin of 19%, versus 15% a year ago
GAAP net income of $24.2 million, up 60% year over year; GAAP EPS up 65% year over year
Non-GAAP net income of $35.3 million, up 42% year over year; non-GAAP EPS up 46% year over year
Cash flow from operations of $94.6 million, up 36% year over year

I think the license increase are primarily due to the fact that license key is mandatory in version 15. The older version of sybase does not need to have a key to run. Many Sybase users have setup additional sybase servers without license. As they migrate to Sybase15, they have to buy extra licenses.