存档

Archive by ,文章数:326

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 

环境:

硬件: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:

  1. Sybase ASE中用isql连接数据库失败时的错误信息所反馈的信息
  2. ASE中的命令行实用工具isql的几个参数的使用方法

BCP:

  1. 关于BCP工具的使用,介绍三个方面的东西
  2. 关于Sybase中的快bcp
  3. ASE15.x的bcp能够实现按照条件导出表内数据
  4. bcp导出数据时禁止字符集转化
  5. 快速生成bcp in导表命令行的方法

本文介绍Sybase ASE V15.x版本中isql和bcp这两个工具的新特性。在前面的博文:ASE中的命令行实用工具isql的几个参数的使用方法 中介绍了isql的几个新特性。

1 BCP

1.1 Skip number of rows: --skiprows (SDK 12.5.1 ESD #19)

1.2 Partition support for multiple-partition, multiple-file operations (ASE 15.0)

1.3 Computed columns: --hide-vcc / --show-fi (ASE 15.0)

1.4 Encrypted columns: -C (ASE 15.0 ESD #1 / SDK 12.5.1 ESD #5)

1.5 Initialization strings: --initstring (ASE 15.0 ESD #5)

1.6 Discard file support for rejected rows: -d (ASE 15.0 ESD #8)

1.7 Alternate Sybase home: -y (New Features in 15.0.2 ESD#5 / SDK 15.0 ESD#2)

1.8 bcp64 for 64-bit products on UNIX platforms (New Features in 15.5 ESD #9)

1.9 Usage

2 ISQL

2.1 isql external error status return: --retserverror (ASE 15.0.2 ESD#4 / SDK 15.0 ESD#10)

2.2 Alternate Sybase home: -y (ASE 15.0.2 ESD#5 / SDK 15.0 ESD#2)

2.3 Redirects/Append the output of the T-SQL command to file_name (ASE 15.0.2 ESD#5 / SDK 15.0 ESD#12)

2.4 Pipes the output of the T-SQL command to an external command (ASE 15.0.2 ESD#5 / SDK 15.0 ESD#12)

2.5 Obfuscated input: --conceal (ASE 15.0 ESD #13)

2.6 Verbose usage: --help (ASE 15.0 ESD #14)

2.7 Application name: --appname (ASE 15.0.3 ESD#4 / OCS 15.0 ESD#17 / OCS 15.5)

2.8 Command history: --history (ASE 15.0.3 ESD#4 / OCS 15.0 ESD#18 / OCS 15.5)

2.8.1 Command history

2.8.2 Listing command history

2.8.3 Recalling and reissuing commands

2.9 isql64 for 64-bit products on UNIX platforms (New Features 15.5 ESD #9)

2.10 Usage

3 Sources

3.1 New Features Open Server™ 15.5 and SDK 15.5 for Windows, Linux, UNIX, and Mac OS X

3.2 New Features Open Server™ 15.0 and SDK 15.0 for Microsoft Windows, Linux, UNIX, and Mac OS X