存档
2011年9月，Sybase公司将发布ASE的下一个版本V15.7。当前ASE最新版本为V15.5，版本号V15.6将被跳过，原因和从V15.0直接跳到V15.5或V12.5升到V15.0比较相似吧？有时候必须这么做。
即将推出的Sybase ASE V15.7中增加了很多的新特性。本博客将着重介绍其中一个比较实用的特性：MERGE命令。
ANSI- SQL2003标准中首次提到了MERGE这个命令，简单理解为：”向目标表中插入不存在的记录，更新已经存在的数据“。其它数据库管理系统，比如 Oracle在9i中就引入了MERGE命令，Sybase SQL Anywhere中也有该命令。迄今为止，Sybase ASE中只能使用类似的if update else insert的方法来实现MERGE的功能。
下面是一个使用MERGE的例子。表Customers中存储客户信息，每周需要将表Cust_updates_week_10中的数据更新到客户表Customers中。为了简化起见，本例子只更新address和number这2个字段。
存档数据库访问通过将数据库转储（“存档”）视作传统的只读数据库，从而允许数据库管理员验证或选择性地恢复数据库转储中的数据，此类数据库也称作“存档数据库”。
与传统数据库不同，存档数据库使用实际的数据库转储作为其主磁盘存储设备，利用最小的传统存储量来表示数据库转储恢复过程中产生的新页或修改页。由于数据库转储已包含许多（或大多数）数据库页的映像，因此不必使用 Backup Server 将页从存档转换为传统的数据库存储，就可以装载存档数据库。因此，装载速度明显快于传统数据库。
存档数据库的用途：
1.对从生产数据库生成的转储的最新副本运行数据库一致性检查。
2.检查数据库转储的完整性。
3.数据库转储的对象级别恢复。
使用存档数据库的典型步骤：
SAP ERP系统能够跑在ASE系统上了，对Sybase DBA来说或许是个好消息。
ORLANDO, FLA. — MAY 17, 2011 — SAP AG (NYSE: SAP) and Sybase, Inc., an SAP company and industry leader in enterprise and mobile software, today announced plans to make the enterprise resource planning (ERP) application SAP® ERP the first SAP® Business Suite application running on Sybase Adaptive Server Enterprise (ASE) — the same high-performance relational database management system (DBMS) that powers Wall Street. In combining SAP applications with Sybase technology, along with harmonized customer services and support, the companies aim to offer organizations worldwide a new database option for running SAP applications and accessing critical information, powering significant efficiency gains and cost reductions. The announcement was made at SAPPHIRE® NOW, being held in Orlando, Florida, May 15-18, 2011, where pilot customers will be showcasing how they are using SAP ERP on Sybase ASE.
see more:http://www.sybase.com/detail?id=1093155&contentOnly=true
Sybase ASE Editions Limits
|
|
EXPRESS |
DEVELOPER |
SMALL BUSINESS |
ENTERPRISE |
|
Number of CPUs |
1 |
1 |
4 |
No limit |
|
Max. Memory Size |
2GB |
No limit |
No limit |
No limit |
|
Max. Database Size |
5GB |
No limit |
No limit |
No limit |
|
Max. number concurrent connections |
No limit |
25 |
256 |
No limit |
|
System Management Suite |
Available |
Available |
Available |
Available |
|
Options & Option Packages |
Not Available |
Included |
Available |
Available |
|
* ASE Express Edition can be installed/deployed on machines of any size (multi-processor machines); ASE will only take advantage of one of those processors, 2GB memory and 5GB disk space. |
||||
ASE Express Edition:
在公司测试环境上执行sp_spaceused时报error：1151的错误。虽然这不是一个严重的错误，记得好像以前也出现过一次，故记录一下。
1> sp_spaceused
2> go
database_name
database_size
----------------------------------------------------
----------------------------------------------------
ultranms
600.0 MB(1 row affected)
Msg 1151, Level 11, State 1:
Server 'ASE', Procedure 'sp_spaceused', Line 308:
Object 460577698 passed to OAM builtin function no longer exists in database 5.
Msg 1151, Level 11, State 1:
Server 'ASE', Procedure 'sp_spaceused', Line 308:
Object 460577698 passed to OAM builtin function no longer exists in database 5.
Msg 1151, Level 11, State 1:
Server 'ASE', Procedure 'sp_spaceused', Line 308:
Object 460577698 passed to OAM builtin function no longer exists in database 5.
Msg 1151, Level 11, State 1:
Server 'ASE', Procedure 'sp_spaceused', Line 308:
Object 460577698 passed to OAM builtin function no longer exists in database 5.
reserved data
index_size unused
-------------------------------- ----------------------------
---------------------------------------- ----------------------------
9020 KB 1396 KB
1064 KB 6560 KB
(return status = 0)
出现错误1151的原因是：执行sp_spaceused统计数据库的空间使用情况的时候，其它会话正在执行删除表的操作。
Sybase ASE 15.5 新特性
|
Operating System |
Sol Sparc 32 |
Sol Sparc 64 |
HP PA RISC 64 |
AIX64 |
Linux x86 |
Windows x86 |
Linux Power |
Linux x64 |
Solaris x64 |
HP UX Itanium II |
Windows x64 |
|
|
Options |
|
|
|
|
|
|
|
|
|
|
|
|
|
High Availability |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
✔ |
|
✔ |
|
|
|
Security & Directory Services |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
Secure Socket Layer |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
✔ |
✔ |
✔ |
✔ |
|
|
Cybersafe Kerboros |
✔ |
✔ |
|
|
|
✔ |
|
|
|
|
|
|
|
MIT Kerberos |
✔ |
✔ |
✔ |
✔ |
✔ |
|
✔ |
✔ |
✔ |
✔ |
|
|
|
Platform Native Kerberos |
✔ |
✔ |
|
|
|
|
|
|
|
|
|
|
|
Fine Grained Access Control |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
Pluggable Authentication Module |
✔ |
✔ |
|
✔ |
✔ |
|
✔ |
✔ |
✔ |
✔ |
|
|
|
LDAP Server Directory |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
LDAP User Authentication |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
Encrypted Columns |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
✔ |
✔ |
✔ |
✔ |
|
|
Partitions |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
InMemory Database |
|
✔ |
✔ |
✔ |
|
|
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
Tivoli Storage Management |
|
✔ |
|
✔ |
|
|
|
✔ |
✔ |
✔ |
✔ |
|
|
Active Messaging |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
✔ |
✔ |
✔ |
✔ |
|
|
Features Included with ASE |
|
|
|
|
|
|
|
|
|
|
|
|
|
Cross Platform Dump and Load |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
DistributedTransaction |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
JobScheduler |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
IPv6 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
Java Option |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
Native XML |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
Web Services |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
|
Content Management |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
Archived Database Access |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
IMPORTANT NOTES
Sybase ASE 15.0.3新特性
|
Operating System |
Sol Sparc32 |
Sol Sparc 64 |
HP PA RISC 64 |
AIX64 |
Linux x86 |
Windows x86 |
Linux Power |
Linux x64 |
Solaris x64 |
HP UX Itanium || |
Windows x64 |
|
Options |
|||||||||||
|
High Availability |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
✔ |
|
✔ |
|
|
Security & Directory Services |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
Secure Socket Layer |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
✔ |
✔ |
✔ |
✔ |
|
Cybersafe Kerboros |
✔ |
✔ |
|
|
|
✔ |
|
|
|
|
|
|
MIT Kerberos |
✔ |
✔ |
✔ |
✔ |
✔ |
|
✔ |
✔ |
✔ |
✔ |
|
|
Platform Native Kerberos |
✔ |
✔ |
|
|
|
|
|
|
|
|
|
|
Fine Grained Access Control |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
Pluggable Authentication Module |
✔ |
✔ |
|
✔ |
✔ |
|
✔ |
✔ |
✔ |
✔ |
|
|
LDAP Server Directory |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
LDAP User Authentication |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
Encrypted Columns |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
✔ |
✔ |
✔ |
✔ |
|
Enhanced Full Text Search |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
✔ |
|
|
|
|
Partitions |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
Features Included with ASE |
|||||||||||
|
Cross Platform Dump and Load |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
Distributed Transaction |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
JobScheduler |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
ASE Replicator |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
IPv6 |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
Java Option |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
Native XML |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
Web Services |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
|
Content Management |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
|
Archived Database Access |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
✔ |
IMPORTANT NOTES
新一代数据库产品ASE 15.0是Sybase公司于2005年9月发布的，它融合了的数据管理技术，并增加了一些功能，如表分区技术、列加密技术、具有多项专利技术的查询引擎 以及对更大数据库容量的支持等等。ASE 15.0.1、ASE 15.0.2和ASE 15.0.3开始逐渐地为ASE 15x的产品线新增了越来越重要的新特性和新功能。
其中，最值得注意的是，ASE 15.0.2引入的许多新特性正好顺应了应用程序开发人员以及数据库管理员的需求，这些新特性包括诸如用户自定义SQL函数、替代触发器、系统目录行级 锁、XMLTable、新的统计聚合函数、数项安全和加密的提升以及监控和诊断特性的提升等等。
而相比ASE 15.0.2以上诸多新特性，ASE 15.0.3的新增功能更趋完美。例如，为了提高复制的性能，ASE 15.0.3还引入了SQL语句复制，其与Sybase复制服务器(Sybase Replication Server)一道，能极大地提高大型批量工作的效率。另外，ASE 15.0.3的QPTune实用工具和查询处理器的兼容模式(对ASE 12.5x)还能够支持客户对ASE 15的移植进行更好地管理。
在面对企业级关键任务对系统连续可用性、可扩展性的更高需求时，Sybase还推出了ASE15的共享磁盘集群版本——Sybase ASE Cluster Edition来帮助企业IT部门应对这些挑战。可以说，ASE 15.0.1 CE(集群版)的发布是Sybase多年研发的顶峰——它在ASE高稳定性和低运行成本的基础上，实现了新的数据库基础架构。这种新的数据库架构能够使 IT系统提高应用服务级别(ASL)，降低数据中心的开销，同时为满足未来的业务增长提供了数据基础架构。