存档
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
1. Oracle发展历史
环境:
硬件:hp 6910p 笔记本,intel T7300 CPU(EM64T,VT-x)
软件:CentOS6.0 x86_64
问题:
使用网络方式(PXE)安装CentOS6.0 x86_64的时候,屏幕上输出waiting for hardware to initialize信息后,一直黑屏,无法继续安装!
解决:
在boot选项中,尝试acpi=off解决。
修改文件:/tftpboot/pxelinux.cfg/default ,在append行添加:acpi=off
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!按钮,选择同意许可条款(有个复选框),简单填写一下个人信息就可以进入下载地址列表页面了。
本文转自: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的几个新特性。