存档

2011年9月 的存档,文章数:10

本文转自: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 [...]

无法提供摘要。这是一篇受保护的文章。

本博客中关于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

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 Windows Sybase IQ 15.2 Evaluation Edition on Linux Sybase IQ 15.2 Linux x86-64 Sybase IQ 15.2 Linux on POWER Sybase IQ 15.2 Evaluation Edition on Solaris SPARC Sybase IQ 15.2 Solaris SPARC   Sybase IQ15.2英文版官方手册: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.help.iq.15.2/title.htm Sybase [...]

将生产环境中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 http://blogs.sybase.com/tradingandrisk/2011/09/sybase-unveils-latest-ase-at-techwave-2011-in-las-vegas/   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 [...]