存档
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
本博客中关于isql和bcp这2个工具的文章有：
ISQL：
BCP：
本文介绍Sybase ASE V15.x版本中isql和bcp这两个工具的新特性。在前面的博文：ASE中的命令行实用工具isql的几个参数的使用方法 中介绍了isql的几个新特性。
将生产环境中AIX5.3平台上的Sybase ASE12.5.2迁移到备机作测试用，下面简单记录下主要步骤。
环境：
Sybase ASE version: 12.5.2 32bit
OS Version: AIX 5.3
$SYBASE: /home/syb123
Instance name: TEST
database name: testdb
备机上建立好了与主机相同的vg与lv
主要步骤：
1.将主机上的目录/home/syb123打包，拷贝到备机，解开tar包到备机的相同目录下。删除备机/home/syb123下的interfaces文件。
在AIX5.3上使用资源文件新建Sybase ASE12.5.2实例时，报如下的错误：
exec(): 0509-036 Cannot load program /home/sybase/ASE-12_5/bin/dataserver because of the following errors:
0509-130 Symbol resolution failed for /usr/ccs/lib/libc.a[aio_64.o] because:
0509-136 Symbol kaio_rdwr64 (number 0) is not exported from dependent module /unix.
0509-136 Symbol listio64 (number 1) is not exported from dependent module /unix.
0509-136 Symbol acancel64 (number 2) is not exported from dependent module /unix.
0509-136 Symbol iosuspend64 (number 3) is not exported from dependent module /unix.
0509-136 Symbol aio_nwait (number 4) is not exported from dependent module /unix.
0509-136 Symbol aio_nwait64 (number 5) is not exported from dependent module /unix.
0509-136 Symbol aio_nwait_timeout (number 6) is not exported from dependent module /unix.
0509-136 Symbol aio_nwait_timeout64 (number 7) is not exported from dependent module /unix.
0509-028 Symbol used in ? type does not match exported type.
0509-192 Examine .loader section symbols with the
'dump -Tv' command.
检查后发现AIX的异步IO没打开。修改参数后，重启机器。
期待已久的为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平台了。
Sybase官方网站提供最新版本软件的下载地址，对于ASE目前仅提供下载V15.5。要想下载早期版本的ASE服务器安装程序（比如：ASE v12.0,ASE v12.5,ASE 12.5.1 - ASE 12.5.4,ASE15.0.2,ASE15.0.3等版本的)，只能求助于google、百度、迅雷等网站或者向玩Sybase的老手索取。
基于Sybase ASE的客户端工具也同样不好获取，我打算在本博客上提供一些ASE服务器程序和客户端工具的下载服务。
因为本博客的空间有限，只能有选择的放一些ASE的服务器端和客户端程序。本文先上传一个我自己制作的Sybase ASE12.5附带的客户端工具Sybase Central的绿色免安装版。只需将压缩文件解压到d:\sybase里面就可以运行快捷方法“Sybase Central”了，简单吧~
本程序为Sybase ASE v12.5附带的Sybase Central的免安装版。
*************************************************************
免责声明
Sybase Central版权归Sybase公司所有！
我制作此Sybase Central版的绿色安装程序的目的是方便大家使用，
现在互联网上Sybase早期版本的客户端工具不好找了，希望此免安装
工具能够给大家带来工作上的便利。请勿将此工具用于商业用途，否则
产生的相应版权问题与本人无关！谢谢！
*************************************************************
使用方法：
在ASE15.x之前的所有版本中（包括ASE12.5.4），存储过程sp_helpdevcie无法显示设备的剩余空间以及设备上各个数据库的具体分配情况。
比如：在ASE12.5中，执行sp_helpdevice master的结果为：
1> sp_helpdevice master
2> go
device_name physical_name
description
status cntrltype device_number
low
high
----------------------------------------------------------------------------------------------------------------
master e:\sybase125\data\master.dat
special, dsync on, default disk, physical disk, 100.00 MB
3 0 0
0
51199(1 row affected)
(return status = 0)
上面输出结果中加粗标记出来的100.00MB表示master设备的总大小。至于master设备还剩余多少空间？master设备都分配给哪些数据库使用了？ASE15.x之前版本的存储过程sp_helpdevice不能给出答案。
今年9月，Sybase公司将发布下一个版本V15.7，该版本中增加了很多新特性，另外很多功能也得到了提升。
对于开发者来说，新版本将带来对Text & Image大文本内容新增的或者改进的支持，新增的并发选项，
对于流式化操作命令MERGE / UPSERT的新的DML支持，等等其它一些功能。数据库管理员们将很欣喜得看到ASE的管理灵活性得到了提升，
比如：压缩的改进，延迟更新表内容的alter table命令，在线REORG REBUILD命令，等等其它一些有用的特性。
V15.7是ASE被认证的可以运行SAP的商业套件ERP和CRM应用程序的第一个版本。