DB2 V10 LUW new features

本文介绍了DB2 10 for LUW版本的十大关键特性,包括自适应压缩、星型模式优化、变更历史事件监视器等,这些特性旨在提高可用性、可靠性和性能,并简化安全性,降低成本。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

Top 10 Reasons to Consider DB2 10 for LUW
Blog: DB2 News | By: Vijay Sitaram | Released: Apr 03, 2012 02:42 PM

It seems like yesterday when we took the wraps of DB2 V9.7 for LUW. I admit it is a kid in the candy store moment every time I get my hands on a newer version of DB2. The new features and enhancements in this new release address the needs of our business, directly improving availability, reliability and performance. This release also has enhancements that simplify security and reduce cost in several areas.

DB2 on LUW has evolved over years and continues to deliver rich features resulting in cost effective management of databases. This release is well thought-out, feature rich and the best release yet. There is something for everybody; looking to upgrade from a previous version or migrate from another vendor database.

IDUG DB2 Tech Conference in Denver, CO [May 14-18 2012] is offering Deep-Dive sessions in all the features listed below. The conference is packed with over 20 hours of DB2 10 for LUW education and is a must for everyone looking to upgrade or break free from other vendor databases.

DB2 10 for LUW is a significant release and will be talked about in detail for several years to come. To give you a taste of what it has to offer, here is my take at Top 10 features in DB2 10 for LUW.

Feature #1: Adaptive Compression

DB2 for LUW has supported table compression since V9, via the “Row Compression” feature. New to this release is the “Page Compression” feature. As you may remember, DB2 also supports ADC (Automatic Dictionary Creation) which automates row compression. In this new release, the same automatic feature is available for page level compression.

Benefit: Savings in storage, no more reorgs to compress table, improve buffer pool usage, reduce I/O request to read the same amount of data and deliver better performance.

Feature #2: Star Schema Optimization

As a Warehouse customer, optimizing star schema queries is critical for delivering reliable query performance. There are several techniques to address this in previous releases (using statistical views and column-group statistics). In DB2 10 for LUW, the all-new zigzag join accomplishes this. Zigzag join is effective in cardinality estimate when optimizing inner joins with skew along dimension. The new zigzag join method can be used to join one or more fact tables with two or more dimension tables.

Benefit: Time and Effort in tuning adhoc queries.

Feature #3: Change History Event Monitor

A new feature to track changes without enabling db2audit. I call this “Soft Audit”. This is a gift for the DBA in keeping track of changes when presented with a performance problem. Usually, when there is a performance problem, the first question that’s asked is “What Changed”? So, this feature is to our rescue. With change history event monitor, we can capture changes related to database and database manager configuration and registry settings, execution of DDL statements, and execution of utilities.

Benefit: Ability to track database related changes without taking a performance hit.

Feature #4: HADR Supports Multiple Standby

This is probably the most asked feature for transactional systems. It’s finally here with impressive features. The high availability disaster recovery (HADR) feature now allows up to three HADR standby databases. You can have your primary and one of your standby databases in the same location, with one or two additional standbys a long distance away. These distant standbys automatically run in SUPERASYNC mode, so the distance does not have an impact on activity on the primary database.

Benefit: Distance is no longer an issue for the standby database, which improves high availability and disaster recovery.

Feature #5: Continuous Data Ingest (CDI)

We are used to using import and load. Using these utilities impacted throughput, recoverability and/or concurrency. Especially for data warehouses running batch loads with large data sets. The ingest utility is a new client-side DB2 utility specializing in the high speed, continuous ingestion of data from sources like files and pipes into DB2 target tables and for frequently populating data warehouse tables with minimal impact on concurrent user workload and data server resources. The ingest utility allows you to roll-in business-critical data, even while long-running queries are accessing the table. In other words, there is no trade-off between data concurrency and data availability.

Benefit: Load large data sets using CDI without sacrificing performance, concurrency and/or recoverability.

Feature #6: Fine Grain Access Control (FGAC)

DB2 10 for LUW introduces row and column access control (RCAC) as a solution to help you further secure your data. RCAC is sometimes referred to as fine-grained access control or FGAC. Row and column access control allows you to regulate data access at the row level, column level, or both. RCAC can be used to complement the table privileges model. You can rely upon row and column access control to ensure that your users have access to only the data that is required for their work. Setup is quick and simple, and security is easy to handle even for complex enterprise systems.

Benefits: Centralized security model, understands privacy data sets and no code changes.

Feature #7: Temporal Tables and Time Travel Query (TTQ)

How would you like to go back in time and query the past? In this release, we can assign time-based state information to data in tables. These tables are called Temporal Tables and use Time Travel Query (TTQ) to view previous state of data. Data in tables that do not use temporal support represents the present, while data in temporal tables is valid for a period defined by the database system, customer applications, or both. There is a business reason to store history of data. Without Temporal Tables, it is difficult to store historical data to meet business needs, such as audit trail and regulatory compliance.

Benefits: Provides built-in support for temporal infrastructure, address critical business requirements and ability to query previous state of data.

Feature #8: Multi-temperature storage

This feature is important for every customer strapped with paying top dollars for their storage needs, particularly for large data warehouse customers, for instance when 10% of data (most recent data) is used for reporting and the remaining 90% of data is retained to meet compliance. Why leave the 90% of data on expensive storage? Can they be stored on less-expensive storage?

The answer is Yes.

Multi-temperature storage classifies data into Hot, Warm, Cold, and Dormant. Hot data is the active data set and should be stored in high-speed storage, while warm, cold, and dormant data can be stored on less-expensive storage and still be available to database.

Benefit: Lower storage cost, efficient storage manage and consistent database performance.

Feature #9: New Tools, Bye Bye Control Center! Hello DataStudio V3.1.1

The Control Center tools and all related components such as wizards and advisors are discontinued. IBM Data Studio is available for FREE and replaces IBM Optim Administrator and IBM Optim Developer tools. IBM® Data Studio and IBM Optim™ tools perform similar tasks that you used to perform with the Control Center tools. For more on IBM Data Studio, visit: http://www-01.ibm.com/support/docview.wss?uid=swg27021898

Benefits: Data Studio V3.1.1 is a significant release and provides features aimed at simplifying development and administration.

Feature #10: DB2 pureScale

In DB2 10 for LUW, the DB2 pureScale feature includes several enhancements such as support for Range Partitioned Tables, easier Installation and Configuration, Better Recovery, addition of Workload Management and Enhanced Monitoring capabilities.

Benefits: Handle capacity needs as you go and only pay for what you use.[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23937368/viewspace-1060369/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/23937368/viewspace-1060369/

资源下载链接为: https://pan.quark.cn/s/1bfadf00ae14 在ASP.NET开发中,定时任务是一种常见功能,用于在固定时间间隔内执行特定操作,比如数据同步、清理缓存或发送通知等。以下是实现ASP.NET定时任务的详细步骤和关键要点: ASP.NET定时任务通常通过System.Threading.Timer或System.Timers.Timer实现,二者都能周期性触发事件。在ASP.NET中,可以利用后台线程或HttpApplication生命周期事件来启动定时器。 System.Threading.Timer:适合在独立线程上运行任务,避免阻塞主线程,适合轻量级任务。 System.Timers.Timer:在多线程环境下,它会自动管理线程,更适合服务器端复杂任务。 创建定时器对象,设置Interval属性为10000毫秒(10秒),并注册Elapsed事件。该事件会在每个时间间隔结束时触发。 在Elapsed事件中编写要执行的代码,确保代码执行效率高,避免阻塞,因为长时间运行的任务可能影响其他请求。 通过Timer.Start()启动定时器,Timer.Stop()停止定时器。在ASP.NET中,可以在Application_Start和Application_End事件中控制定时器的启动和停止,确保服务器启动时定时器开始运行,关闭时停止。 在多用户环境下,如果定时任务会修改共享状态,必须考虑线程安全问题,可以使用锁或其他同步机制来确保数据一致性。 将应用程序部署到IIS时,需设置应用程序池的回收策略,避免定时任务因应用程序回收而中断。同时,确保IIS配置支持长时间运行的请求。 为定时任务添加日志记录非常重要,可以帮助排查问题并监控任务执行情况。 定时任务过于频繁可能会影响服务器性能,进而影响其他请求的响应时间。可根据需求调整时间间隔,或
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值