提供7*24专业Sybase数据库远程及现场技术支持,Sybase ASE及Sybase SQL Anywhere数据库修复服务,
请联系手机:(微信),QQ:289965371!
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371

SAP IQ的所有已知BUG列表

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

CR
Number
Description
297099 Adaptive Server IQ parsed a query incorrectly when the query

combined the CONTAINS predicate and an 'Into #temp' clause.

297235 A query takes 25min to get a query plan while the execution only need 1 seconds.

This happens in version 12.4.3 ESD7.

300063 The IQ server has 2 user event enabled. The event actions gete executed very 3 seconds and contain an INSERT... LOCATION statement. If you stop and start the IQ server the events cannot be executed because if the error:

Exception Thrown from hqm_con.cxx:102, Err# 1, tid 264 origtid 264

O/S Err#: 0, ErrID: 8192 (hqm_exception)

CtLibrary Error: 141, Severity: 0, Origin: 1, Layer: 1

Error Message: ct_con_props(SET,PASSWORD): user api layer: external error: buflen must be 0 or CS_UNUSED when buffer is NULL.

OS Error: 0, OS Message: .

-- (hqm_con.cxx 102)

Probelm reason:

The INSERT... LOCATION statement always takes the user and password from the

current connection to connect to an ASE server. The catalog stores the password

only as hash value created by an one-way algorithm for security reason.

So the password string is not available for the event execution before the end user

using this username has connected to ASIQ.

As soon as an user has connected using the username all subsequent INSERT... LOCATION

in events work file

Its not possible to fix this problem without added new syntax or an new feature.

i'm going to create an Enhancement Request for this. 阅读全文...

master数据库配置区域(configuration area)损坏的一种修复方法

本文提供master配置区域损坏的一种修复方法!

Sybase ASE master数据库的前2048字节存储着Sybase数据库服务器的configuration area(配置区域)。如果configuration area corrupt,那么Sybase服务器无法启动。

造成configuration area corrupt的原因一般为硬件故障。通过下面的案例分享configuration area corrupt的一种恢复方法。

背景:

版本:ASE 15.0.3 ESD#3

在通过临时设置参数upgrade version为492来重置sa口令为空时,忘记将upgrade version改回原值 (参考:将Sybase ASE登录sa的密码置为空NULL的方法)。之后重启Sybase服务器时报错:

Pre 10.0 database cannot work with this version of the server. Please upgrade the databases to 10.0 or above release and then try to start with this version of the server. Shutting down ***.

ASE配置文件(*.cfg)中大多数情况下不存在参数:upgrade version。在cfg中添加upgrade version=15000后,启动时仍然报上面的master数据库版本低于10.0的错误。

通过比较多个版本的configuration area,发现master数据库的第1805和第1806字节表示upgrade version,15000的十六进制形式为:0x3A98,则将第1805字节改为98,第1806字节改为3A(此处master为linux平台上的数据库)。改为之后启动报错:

The configuration area in device '/home/sybase/data/master.dat' appears to be corrupt. The server cannot continue and will shut down.

看来仅仅修改2个字节的内容无法验证通过,那么通过替换master数据库头部2048字节呢? 我测试是可行的! 阅读全文...

DB-Engines数据库排名 Sybase跌出前10(转)

【IT168 资讯】 DB-Engines于近日发布2014年12月份的数据库系统排名。这个排行榜和TIOBE编程语言排行榜一样权威,在每个月的上旬发布。根据数据库的受欢迎程度进行排名。与之前的比较,整个排名并无太大变化,尤其是前三位。

  根据排行榜显示,Oracle居首,而开源的MySQL数据库排名第二,SQL Server位列第三,原本第十名的Sybase ASE被非关系型数据库Redis所取代,而Sybase ASE则跌至第十一名。Redis是内存数据库,在本月的增长较大。到目前为止,前十名中的NoSQL数据库占了三席分别是MongoDB、Cassandra和Redis。 阅读全文...

Sybase Open Server各版本认证情况

在Sybase官方网站上存在页面Sybase Certifications: http://certification.sybase.com/ucr/search.do 可以查询Sybase产品在各操作系统平台上的认证情况。
随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
按照Sybase的惯例,在被原厂认证的操作系统平台上部署的Sybase产品才会得到支持。虽然某个版本在原厂未认证的一些操作系统平台上也能够成功安装,但还是建议在生产环境上使用认证的操作系统平台。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供Sybase部分产品在各操作系统平台上的认证情况。
下面是Sybase Open Server在各操作系统平台上的认证情况,根据Open Server版本号进行逆序排序的结果:(还有根据操作系统版本排序的结果)

 

Product Prod Version WordSize OS Version More Information
Open Server 16.0 32/64-bit HP-UX 11.31(ia) view more
Open Server 16.0 32/64-bit IBM AIX 6.1 view more
Open Server 16.0 32/64-bit IBM AIX 7.1 view more
Open Server 16.0 32/64-bit Red Hat EL 5.0 (AMD64/EM64T) view more
Open Server 16.0 32/64-bit Red Hat EL 5.0 (IBM POWER) view more
Open Server 16.0 32-bit Red Hat EL 5.0 (x86) view more
Open Server 16.0 32/64-bit Red Hat EL 6.0 (AMD64/EM64T) view more
Open Server 16.0 32/64-bit Red Hat EL 6.0 (IBM POWER) view more
Open Server 16.0 32-bit Red Hat EL6.0 (x86) view more
Open Server 16.0 32/64-bit SuSE SLES 11 (AMD64/EM64T) view more
Open Server 16.0 32/64-bit SuSE SLES 11 (IBM POWER) view more
Open Server 16.0 32-bit SuSE SLES 11 (x86) view more
Open Server 16.0 32/64-bit Sun Solaris 10 (SPARC) view more
Open Server 16.0 32/64-bit Sun Solaris 10 (x64) view more
Open Server 16.0 32-bit Sun Solaris 10 (x86) view more
Open Server 16.0 32/64-bit Sun Solaris 11 (SPARC) view more
Open Server 16.0 32/64-bit Sun Solaris 11 (x64) view more
Open Server 16.0 32/64-bit Windows 2008 R2 (x64) view more
Open Server 16.0 32/64-bit Windows 2012 (x64) view more
Open Server 16.0 32/64-bit Windows 7 (x64) 阅读全文...

Sybase Replication Server各版本认证情况

在Sybase官方网站上存在页面Sybase Certifications: http://certification.sybase.com/ucr/search.do 可以查询Sybase产品在各操作系统平台上的认证情况。
随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
按照Sybase的惯例,在被原厂认证的操作系统平台上部署的Sybase产品才会得到支持。虽然某个版本在原厂未认证的一些操作系统平台上也能够成功安装,但还是建议在生产环境上使用认证的操作系统平台。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供Sybase部分产品在各操作系统平台上的认证情况。
下面是Sybase Replication Server在各操作系统平台上的认证情况,根据Replication Server版本号进行逆序排序的结果:(还有根据操作系统版本排序的结果)

Product Prod Version WordSize OS Version More Information
Replication Server 15.7.1 64-bit Red Hat EL 5.0 (AMD64/EM64T) view more
Replication Server 15.7.1 64-bit Red Hat EL 6.0 (AMD64/EM64T) view more
Replication Server 15.7.1 64-bit Sun Solaris 11 (SPARC) view more
Replication Server 15.7.1 64-bit Sun Solaris 11 (x64) view more
Replication Server 15.7 64-bit HP-UX 11.31(ia) view more
Replication Server 15.7 64-bit IBM AIX 6.1 view more
Replication Server 15.7 64-bit IBM AIX 7.1 view more
Replication Server 15.7 64-bit Red Hat EL 5.0 (AMD64/EM64T) view more
Replication Server 15.7 64-bit Red Hat EL 5.0 (IBM POWER) view more
Replication Server 15.7 64-bit Red Hat EL 6.0 (AMD64/EM64T) view more
Replication Server 15.7 64-bit Red Hat EL 6.0 (IBM POWER) view more
Replication Server 15.7 64-bit SuSE SLES 10 (AMD64/EM64T) view more
Replication Server 15.7 64-bit SuSE SLES 10 (IBM POWER) view more
Replication Server 15.7 64-bit SuSE SLES 11 (AMD64/EM64T) view more
Replication Server 15.7 64-bit SuSE SLES 11 (IBM POWER) view more
Replication Server 15.7 64-bit Sun Solaris 10 (SPARC) view more
Replication Server 15.7 64-bit Sun Solaris 10 (x64) view more
Replication Server 15.7 32-bit Windows 2008 (x86) view more
Replication Server 15.7 64-bit Windows 2008 R2 (x64) view more 阅读全文...

Sybase Software Developer Kit各版本认证情况

在Sybase官方网站上存在页面Sybase Certifications: http://certification.sybase.com/ucr/search.do 可以查询Sybase产品在各操作系统平台上的认证情况。
随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
按照Sybase的惯例,在被原厂认证的操作系统平台上部署的Sybase产品才会得到支持。虽然某个版本在原厂未认证的一些操作系统平台上也能够成功安装,但还是建议在生产环境上使用认证的操作系统平台。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供Sybase部分产品在各操作系统平台上的认证情况。
下面是Software Developer Kit在各操作系统平台上的认证情况,根据Software Developer Kit版本号进行逆序排序的结果:(还有根据操作系统版本排序的结果)

Product Prod Version WordSize OS Version More Information
Software Developer Kit 16.0 32/64-bit HP-UX 11.31(ia) view more
Software Developer Kit 16.0 32/64-bit IBM AIX 6.1 view more
Software Developer Kit 16.0 32/64-bit IBM AIX 7.1 view more
Software Developer Kit 16.0 32/64-bit Red Hat EL 5.0 (AMD64/EM64T) view more
Software Developer Kit 16.0 32/64-bit Red Hat EL 5.0 (IBM POWER) view more
Software Developer Kit 16.0 32-bit Red Hat EL 5.0 (x86) view more
Software Developer Kit 16.0 32/64-bit Red Hat EL 6.0 (AMD64/EM64T) view more
Software Developer Kit 16.0 32/64-bit Red Hat EL 6.0 (IBM POWER) view more
Software Developer Kit 16.0 32-bit Red Hat EL6.0 (x86) view more
Software Developer Kit 16.0 32/64-bit SuSE SLES 11 (AMD64/EM64T) view more
Software Developer Kit 16.0 32/64-bit SuSE SLES 11 (IBM POWER) view more
Software Developer Kit 16.0 32-bit SuSE SLES 11 (x86) view more
Software Developer Kit 16.0 32/64-bit Sun Solaris 10 (SPARC) view more
Software Developer Kit 16.0 32/64-bit Sun Solaris 10 (x64) view more
Software Developer Kit 16.0 32-bit Sun Solaris 10 (x86) view more
Software Developer Kit 16.0 32/64-bit Sun Solaris 11 (SPARC) view more
Software Developer Kit 16.0 32/64-bit Sun Solaris 11 (x64) view more
Software Developer Kit 16.0 32/64-bit Windows 2008 R2 (x64) view more
Software Developer Kit 16.0 32/64-bit Windows 2012 (x64) view more
Software Developer Kit 16.0 32/64-bit Windows 7 (x64) view more
Software Developer Kit 16.0 32-bit Windows 7 (x86) view more
Software Developer Kit 16.0 32/64-bit Windows 8 (x64) view more
Software Developer Kit 15.7 32/64-bit HP-UX 11.31(ia) view more
Software Developer Kit 15.7 32/64-bit IBM AIX 6.1 view more
Software Developer Kit 15.7 32/64-bit IBM AIX 7.1 view more
Software Developer Kit 15.7 32/64-bit Red Hat EL 5.0 (AMD64/EM64T) view more
Software Developer Kit 15.7 32/64-bit Red Hat EL 5.0 (IBM POWER) view more 阅读全文...

Sybase SQL Anywhere各版本认证情况

在Sybase官方网站上存在页面Sybase Certifications: http://certification.sybase.com/ucr/search.do 可以查询Sybase产品在各操作系统平台上的认证情况。
随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
按照Sybase的惯例,在被原厂认证的操作系统平台上部署的Sybase产品才会得到支持。虽然某个版本在原厂未认证的一些操作系统平台上也能够成功安装,但还是建议在生产环境上使用认证的操作系统平台。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供Sybase部分产品在各操作系统平台上的认证情况。
下面是SQL Anywhere在各操作系统平台上的认证情况,根据SQL Anywhere版本号进行逆序排序的结果:(还有根据操作系统版本排序的结果)

Product Prod Version WordSize OS Version More Information
Adaptive Server Anywhere 9.0.2 32/64-bit Sun Solaris 10 (SPARC) view more
Adaptive Server Anywhere 9.0.2 32/64-bit Sun Solaris 2.7 (SPARC) view more
Adaptive Server Anywhere 9.0.2 32/64-bit Sun Solaris 2.8 (SPARC) view more
Adaptive Server Anywhere 9.0.2 32/64-bit Sun Solaris 2.9 (SPARC) view more
Adaptive Server Anywhere 9.0.2 32/64-bit SuSE Prof. 9.1 (AMD64/EM64T) view more
Adaptive Server Anywhere 9.0.2 32/64-bit Windows 2003 (ia64) view more
Adaptive Server Anywhere 9.0.2 32/64-bit Windows 2003 (x64) view more
Adaptive Server Anywhere 9.0.2 32/64-bit Windows 2003 (x86) view more
Adaptive Server Anywhere 9.0.2 32-bit HP-UX 11.0 PA-RISC view more
Adaptive Server Anywhere 9.0.2 32-bit HP-UX 11i PA-RISC view more
Adaptive Server Anywhere 9.0.2 32-bit NetWare 5.1 view more
Adaptive Server Anywhere 9.0.2 32-bit NetWare 6.0 view more
Adaptive Server Anywhere 9.0.2 32-bit NetWare 6.5 view more
Adaptive Server Anywhere 9.0.2 32-bit Red Hat EL 2.1 (x86) view more
Adaptive Server Anywhere 9.0.2 32-bit Red Hat EL 3.0 (x86) view more
Adaptive Server Anywhere 9.0.2 32-bit Red Hat EL 4.0 (AMD64/EM64T) view more
Adaptive Server Anywhere 9.0.2 32-bit Red Hat EL 4.0 (x86) view more 阅读全文...

Sybase IQ各版本认证情况

在Sybase官方网站上存在页面Sybase Certifications: http://certification.sybase.com/ucr/search.do 可以查询Sybase产品在各操作系统平台上的认证情况。
随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
按照Sybase的惯例,在被原厂认证的操作系统平台上部署的Sybase产品才会得到支持。虽然某个版本在原厂未认证的一些操作系统平台上也能够成功安装,但还是建议在生产环境上使用认证的操作系统平台。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供Sybase部分产品在各操作系统平台上的认证情况。
下面是Sybase IQ在各操作系统平台上的认证情况,根据Sybase IQ 版本号进行逆序排序的结果:(还有根据操作系统版本排序的结果)

Product Prod Version WordSize OS Version More Information
IQ Enterprise Edition 12.7 64-bit HP-UX 11.23 PA-RISC view more
IQ Enterprise Edition 12.7 64-bit HP-UX 11.23(ia) view more
IQ Enterprise Edition 12.7 64-bit HP-UX 11.31 PA-RISC view more
IQ Enterprise Edition 12.7 64-bit HP-UX 11.31(ia) view more
IQ Enterprise Edition 12.7 64-bit IBM AIX 5.3 view more
IQ Enterprise Edition 12.7 64-bit IBM AIX 6.1 view more
IQ Enterprise Edition 12.7 64-bit Red Flag 5.0 (IBM POWER) view more
IQ Enterprise Edition 12.7 32-bit Red Flag 5.0 (x86) view more
IQ Enterprise Edition 12.7 64-bit Red Hat EL 3.0 (IBM POWER) view more
IQ Enterprise Edition 12.7 64-bit Red Hat EL 3.0 (AMD64/EM64T) view more
IQ Enterprise Edition 12.7 32-bit Red Hat EL 3.0 (x86) view more
IQ Enterprise Edition 12.7 64-bit Red Hat EL 4.0 (AMD64/EM64T) view more
IQ Enterprise Edition 12.7 64-bit Red Hat EL 4.0 (IBM POWER) view more
IQ Enterprise Edition 12.7 32-bit Red Hat EL 4.0 (x86) view more
IQ Enterprise Edition 12.7 64-bit Red Hat EL 5.0 (AMD64/EM64T) view more
IQ Enterprise Edition 12.7 64-bit SuSE SLES 10 (AMD64/EM64T) view more
IQ Enterprise Edition 12.7 64-bit SuSE SLES 10 (IBM POWER) view more
IQ Enterprise Edition 12.7 32-bit SuSE SLES 10 (x86) view more
IQ Enterprise Edition 12.7 64-bit SuSE SLES 9.0 (AMD64/EM64T) view more
IQ Enterprise Edition 12.7 64-bit SuSE SLES 9.0 (IBM POWER) view more
IQ Enterprise Edition 12.7 32-bit SuSE SLES 9.0 (x86) view more
IQ Enterprise Edition 12.7 64-bit Sun Solaris 10 (SPARC) view more
IQ Enterprise Edition 12.7 64-bit Sun Solaris 10 (x64) view more 阅读全文...