存档
本文转自:http://www.fwolf.com/blog/post/357 作者:Fwolf
开始之前
先把ubuntu装上,用7.04的server安装盘默认安装即可,先装i386的,如果sybase安装顺利,再试试64位的sybase是否好用。
从sybase网站上注册免费用户之后,可以下载免费的ASE Express Edition(下载页面),目前的版本是15.0.2,限制只能使用1个cpu,2G内存和管理5G数据,更详细的资料在快速安装手册中。
如果您也想自己装一个试试,建议您先跳过下面这一段。
安装
下载后的ase1502_xe_linux.tgz
,直接解压到一个目录,比如ase1502
中,然后运行./setup
就可以开始安装了。默认的安装是java图形界面的,而我是远程ssh上去装的,所以加上-console
参数运行setup。首先是欢迎信息:
Welcome to the InstallShield Wizard for Sybase Adaptive Server Enterprise Suite
version 15.0.2 GA
The InstallShield Wizard will install Sybase Adaptive Server Enterprise Suite
on your computer. Shut down all Sybase products, then click Next to begin
installation.
Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]
按1继续,接着是选择用户协议类型:
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的几个新特性。
Sybase IQ分析型数据库的license控制很严格,安装介质也不好获得。想试用IQ的话,需要通过公司的名义联系Sybase公司取得一个月、三个月或者更长的免费试用期。
本文提供针对Sybase IQ15.2的可以免费试用一个月的体验版的下载地址。
首先需要到sybase网站上注册,否则下载不了。
在注册页面上简单填写一下就可以了。
http://response.sybase.com/forms/NAO10AUGDWNLDIQ152
下面是windows、linux、solaris三个平台上的IQ15.2的一个月体验版的下载地址:
Sybase IQ 15.2 Evaluation Edition on Windows
Sybase IQ 15.2 Evaluation Edition on Linux
Sybase IQ 15.2 Evaluation Edition on Solaris SPARC
Sybase IQ15.2英文版官方手册:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.help.iq.15.2/title.htm
Sybase IQ15.2中文版官方手册:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.help.iqzh.15.2/title.htm
最近Sybase官方上的下载链接失效了,只能到SAP官方下载IQ 15.2了。
将生产环境中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平台了。