随着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配置区域损坏的一种修复方法!
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字节呢? 我测试是可行的! 阅读全文...
【IT168 资讯】 DB-Engines于近日发布2014年12月份的数据库系统排名。这个排行榜和TIOBE编程语言排行榜一样权威,在每个月的上旬发布。根据数据库的受欢迎程度进行排名。与之前的比较,整个排名并无太大变化,尤其是前三位。
根据排行榜显示,Oracle居首,而开源的MySQL数据库排名第二,SQL Server位列第三,原本第十名的Sybase ASE被非关系型数据库Redis所取代,而Sybase ASE则跌至第十一名。Redis是内存数据库,在本月的增长较大。到目前为止,前十名中的NoSQL数据库占了三席分别是MongoDB、Cassandra和Redis。 阅读全文...
标签:
在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官方网站上存在页面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官方网站上存在页面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官方网站上存在页面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官方网站上存在页面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 阅读全文... |