存档
1、准备环境
首先确保sql.ini中包含主、备服务器名称；
创建master设备所在的目录；
主服务器和备份服务器的RUN_file文件；
2、使用命令初始化master设备
D:\ASE\sybase157\ASE-15_0\bin\sqlsrvr.exe -dD:\ASE\sybase157\data2\master.dat -b100M -Z80M -z2048 -eD:\ASE\sybase157\ASE-15_0\install\ASE157_2K.log -sASE157_2K -MD:\ASE\sybase157\ASE-15_0
3、使用RUN_file启动新创建的服务
在windows创建的主服务的默认字符集为：cp850；
默认包含以下系统数据库：
1> select dbid,name from sysdatabases order by dbid
2> go
dbid name
------ ------------------------------
1 master
2 tempdb
3 model
31513 sybsystemdb
(4 rows affected)
4、创建sybsystemprocs数据库
Sybase ASE V15.7于9月下旬发布，10月上旬才提供开发版下载地址。先在Linux x86_64上体验并测试一把。ASE V15.7已不支持Linux x86和Solaris x86，但是仍然可以用win x86做开发测试用途。
操作系统环境为：CentOS 5.5，内核版本：2.6.18-194.el5 x86_64
一开始使用安装向导创建服务的时候，报错！所有服务均创建失败！
修改安装向导生成的资源文件，已备后面利用srvbuildres创建服务。
首先设置一个能够解决Linux下Segmentation fault错误的环境变量： LD_POINTER_GUARD=0
在sybase用户环境下，执行下面的命令创建主服务时，
[sybase@centos5 ASE-15_0]$ srvbuildres -r ./sqlsrv.res
Sybase ASE V15.7开发版的安装介质可以下载了。
ASE V15.7支持的平台有：Windows x86-64 bit, Windows x86-32 bit, Linux x86-64 bit, Linux on POWER 64-bit, Sun Solaris SPARC 64-bit, Sun Solaris x64, HP-UX Itanium 64-bit, AIX 64-bit.
不支持linux x86和 solaris x86平台！
从地址http://www.sybase.com/ase_1500devel 进入，点Register and Download Now!按钮，选择同意许可条款（有个复选框），简单填写一下个人信息就可以进入下载地址列表页面了。
The features fit into a few broad categories:
1. Dealing with large data sets. This includes better management of large objects, as well as enhancements to operational, storage, and data management tasks. With the costs of today’s high-end SANs, data compression may pay for the whole project.
2. Performance and scalability. New features here include better management of dynamic queries (I know that one is going to makefriends) as well as a variety of ways to compress data, and better kernel integration for parallel processing performance.
3. More ease of maintenance. ASE 15.7 supports fully recoverable DDL commands such as select into, alter table, and reorg rebuild. In addition, you can now shrink log space, diagnostic support has taken a major step forward, and alter table statements can now be performedwithout copying data (how about that for speed of internal applicationupgrades?).
4. Application and developer productivity, including a variety of transact-sql enhancements.
5. Security, including object ownership changing, login profiles, and single sign-on
(c) Sybase
PDF ：Upgrade-to-ASE-15.7-FA.pdf 下载
From:http://sybase.reygrobellet.com/news/whyyoullwanttoupgradetoase157
期待已久的为SAP商业套件(Business Suite)量身定做的Sybase ASE V15.7发布了。
对Sybase使用者来说是个不错的消息！:-D
可以参考下面的链接：
http://www.sybase.com/detail?id=1094783
http://www.sybase.com/asebuiltforbusiness
http://www.ctoedge.com/content/making-database-smarter
ASE 15.7 key features include:
Management of Large Datasets
- Compression— allows large databases to be stored more compactly and reduces I/O times to ensure high performance on even the largest databases.
- Reduced Query Latency— helps better handle large data sets, especially those which use dynamic SQL for interactive data retrieval.
- Replication Performance—increases the performance of Sybase’s industry-leading transaction replication and syncing technology.
- Enhancements for Parallel Hardware —improves optimization of multi-core/multi-threaded CPU architectures to get the maximum performance out of today’s latest processors
Simplified Administration
- Online Operations—increases data availability while allowing data to be optimized for application performance.
- Extended Diagnostics—allows DBAs to quickly pin-point performance bottlenecks and speed customer support requests.
- Strong Password Encryption—protects the database from external intrusion and hacking
- Single Sign-on & Login Profiles—makes it easier to manage large numbers of users and simplifies end-user access to the system
Ease of Application Development
- Efficient Management of Large Objects—inline management of large objects as well as enhanced application development features such as large objects as parameters to stored procedures.
- Enhanced Application Language Capabilities—many improved TransactSQL&™ language features to increase productivity of application developers as well as support for a variety of popular languages such as Python, PHP and Perl.
- An Enterprise-Class DB for ISV applications —enhanced business-critical performance for ISV applications out of the box, enabling ISVs to easily write and port their applications to ASE 15.7.
Sybase ASE 15.7 Availability
Sybase ASE 15.7 Enterprise Edition 安装介质将于2011年9月底可供下载。适用的平台包括： HP-UX 11i v3, AIX IBM Power 64-bit, Linux IBM Power 64-bit, Linux x86 64-bit, Solaris SPARC 64-bit, Solaris x86 64-bit, Windows x86 64-bit, Windows x86. 可以浏览：www.sybase.com/asebuiltforbusiness.
很可惜，可能不支持Linux x86平台了。
今年9月，Sybase公司将发布下一个版本V15.7，该版本中增加了很多新特性，另外很多功能也得到了提升。
对于开发者来说，新版本将带来对Text & Image大文本内容新增的或者改进的支持，新增的并发选项，
对于流式化操作命令MERGE / UPSERT的新的DML支持，等等其它一些功能。数据库管理员们将很欣喜得看到ASE的管理灵活性得到了提升，
比如：压缩的改进，延迟更新表内容的alter table命令，在线REORG REBUILD命令，等等其它一些有用的特性。
V15.7是ASE被认证的可以运行SAP的商业套件ERP和CRM应用程序的第一个版本。
2011年9月，Sybase公司将发布ASE的下一个版本V15.7。当前ASE最新版本为V15.5，版本号V15.6将被跳过，原因和从V15.0直接跳到V15.5或V12.5升到V15.0比较相似吧？有时候必须这么做。
即将推出的Sybase ASE V15.7中增加了很多的新特性。本博客将着重介绍其中一个比较实用的特性：MERGE命令。
ANSI- SQL2003标准中首次提到了MERGE这个命令，简单理解为：”向目标表中插入不存在的记录，更新已经存在的数据“。其它数据库管理系统，比如 Oracle在9i中就引入了MERGE命令，Sybase SQL Anywhere中也有该命令。迄今为止，Sybase ASE中只能使用类似的if update else insert的方法来实现MERGE的功能。
下面是一个使用MERGE的例子。表Customers中存储客户信息，每周需要将表Cust_updates_week_10中的数据更新到客户表Customers中。为了简化起见，本例子只更新address和number这2个字段。