Whether it means the end time of the SYBASE LICENSE

sybase

I want to know the meaning of "2013.03010/permanent/0C94 6187 B194 DF07", Whether it means the end time of the SYBASE LICENSE?

sybase log

00:00000:00016:2011/01/03 14:15:37.02 kernel SySAM: Checked in
license for 1 ASE_CORE (2013.03010/permanent/0C94 6187 B194 DF07).
00:00000:00000:2011/01/03 14:16:53.08 kernel SySAM: Using licenses
from: /home/sybase/SYSAM-2_0/licenses
00:00000:00000:2011/01/03 14:16:53.10 kernel SySAM: Checked out license for 1 ASE_CORE
(2013.03010/permanent/0C94 6187 B194 DF07).
00:00000:00000:2011/01/03 14:16:53.10 kernel This product is licensed
to: BEV CORPORATION, an OEM license from Sybase, Inc.
00:00000:00000:2011/01/03 14:16:53.10 kernel Checked out license
ASE_CORE 00:00000:00000:2011/01/03 14:16:53.10 kernel Adaptive
Server Enterprise (Enterprise Edition)

Best Answer

This message does not mean that the license is expired or something. It only states that sybase found a valid license and checked it out. More information about the sybase license manager you can find here: http://www.sybase.com/detail?id=1009350

Related Solutions

Sql-server – How compatible are Sybase and SQL Server clients connecting to the alternate back end

It's true that Sybase and the Microsoft SQL Server databases share common roots, but they are not any more compatible.

Yes, both engines support T-SQL, they have very similar syntax, even many functions looks and works the same. But this is not enough, between the two products have appeared too many differences at this moment. If you want to migrate between them you need to review code, it's easier because many similarities, but must be done.

Microsoft recommended to use SQL Server Migration Assistant (SSMA) for Sybase - it can help you migrate tables, views, indexes, triggers, and stored procedures. In most cases you need to perform just a few manual patches.

Microsoft provided many helpful resources within subject of Sybase and SQL Server:

Getting database usage of all the database at once in Sybase

Below is the script that I use --- master..sysdatabases& master..sysusages

--- Source : http://benohead.com/sybase-size-of-data-and-log-segments-for-all-databases/

select db_name(d.dbid) as db_name,
ceiling(sum(case when u.segmap != 4 then u.size/1048576.*@@maxpagesize end )) as data_size,
ceiling(sum(case when u.segmap != 4 then size - curunreservedpgs(u.dbid, u.lstart, u.unreservedpgs) end)/1048576.*@@maxpagesize) as data_used,
ceiling(100 * (1 - 1.0 * sum(case when u.segmap != 4 then curunreservedpgs(u.dbid, u.lstart, u.unreservedpgs) end) / sum(case when u.segmap != 4 then u.size end))) as data_used_pct,
ceiling(sum(case when u.segmap = 4 then u.size/1048576.*@@maxpagesize end)) as log_size,
ceiling(sum(case when u.segmap = 4 then u.size/1048576.*@@maxpagesize end) - lct_admin("logsegment_freepages",d.dbid)/1048576.*@@maxpagesize) as log_used,
ceiling(100 * (1 - 1.0 * lct_admin("logsegment_freepages",d.dbid) / sum(case when u.segmap in (4, 7) then u.size end))) as log_used_pct 
from master..sysdatabases d, master..sysusages u
where u.dbid = d.dbid  and d.status not in (256,4096)
group by d.dbid
order by db_name(d.dbid)

Best Answer

Related Solutions

Sql-server – How compatible are Sybase and SQL Server clients connecting to the alternate back end

Getting database usage of all the database at once in Sybase

Related Question