Support for solid-state disks (SSDs)
支持固态磁盘(solid-state disks,SSDs)
Using CHGPFM to move data to SSDS.
使用CHGPFM将数据移动到ssd。
SSDs shine really bright when random I/Os are being executed.
但在执行随机I/O 操作时,SSD的确更胜一筹。
Think about which tasks SSDs enable you to accomplish differently.
考虑SSD能让您出色完成哪些任务。
But SSDs are different from hard disk drives (HDDs) in that they are consumable.
但是SSD不同于硬盘驱动器(Hard Disk Drive,HDD),因为它们是可以消耗掉的。
So, what's the best way to determine which DB2 tables or indexes to place on SSDs?
那么,确定将哪些db2表或索引放在SSD上的最佳方式是什么?
In many cases, organizations will be able to place all of their databases on SSDs.
在很多情况下,组织可以把所有数据库放在SSD。
Tablespaces that have a lower sequentiality ratio also are better candidates for SSDs.
具有较低连续率的表空间也比较适合放在SSD上。
Figure 2: Identifying high-use data can help maximize the performance benefits of SSDS.
图2:挑出高使用率数据有助于将SSD带来的性能好处最大化。
But although SSD costs are declining every quarter, SSDs are still more expensive than HDDs.
但是,虽然SSD的成本每个季度都在递减,但是SSD仍然比HDD昂贵。
Figure 1: SSDs easily outpace the 15,000 RPM HDDs commonly used for enterprise applications.
图1:ssd轻松超过常用于企业应用的15,000rpmhdd。
We then tested several scenarios after migrating portions of the database application to SSDs.
然后,我们将数据库应用程序的一部分迁移到SSD,对一系列的场景进行测试。
All existing data is moved underneath the cover from regular disk drives to SSDs automatically.
所有现有数据都在后台从常规硬盘驱动器自动移动到SSD。
CHGLFM will move all the secondary indexes associated with a join logical file on or off of SSDs.
CHGLFM将把与连接逻辑文件有关的所有二级索引移入或移出ssd。
Silent operation - SSDs are completely silent when they are running, HDDs are most definitely not
工作静音——SSD运行时完全静音,硬盘驱动器则绝对不可能。
Figure 1 below shows this differences between regular disk drives and SSDs in terms of performance.
图1展示了常规硬盘驱动器与SSD之间的性能差异。
So consider embedding less free space when using SSDs, since the clustering sequence may not be so important.
因此考虑在使用SSD 时嵌入较少的空闲空间,因为集群顺序可能并不那么重要。
When you consider the purchase of SSDs for your enterprise-class storage array, think beyond speeds and feeds.
当您考虑为企业级存储阵列购买SSD时,不仅要考虑速度和容量。
The SSDs will sometimes fail as well, and the company is working on ways to ensure a foolproof wipe of stored data.
不过固态硬盘有时候也会出现故障,该公司正在寻求一种确保万无一失的清除硬盘数据的方式。
The easiest approach would be simply to replace all regular disk drives with SSDs and move over all objects and data.
最简单的方法是用SSD替换所有常规硬盘驱动器并移动所有对象和数据。
Additionally, DSNACCOX with DB2 10 has specific code to reduce the REORG requirements for table Spaces residing on SSDs.
另外,DB 210的DSNACCOX具有特定的代码来降低对驻留在SSD上的磁盘空间的REORG需求。
A potential course of action here is to reduce the size of the buffer pools supporting the table Spaces resident on SSDs.
这里,可能的动作是减小支持驻留在SSD上的表空间的缓冲池大小。
IBM I has all the characteristics and information to be able to identify and move certain most frequently used objects to SSDs.
IBMi拥有所有相关特征和信息,能够识别那些使用频率最高的对象并将其移动到SSD。
Due to the memory storage technology used in SSDs, the performance is an order of magnitude higher than regular hard disk drives.
由于SSD中采用了内存存储技术,SSD的性能比常规硬盘驱动器高出了一个数量级。
Use of SSDs drives are substantially faster than traditional disks and thus can provide performance benefits to most applications.
使用SSD硬盘要比使用传统磁盘快许多,因此可以为大多数应用程序提供性能增益。
Other graphs can be selected to show the total number of I/Os performed per second which will also indicate the improvement from SSDs.
还可以选择其他曲线图来显示每秒执行的I/O总量,这也能体现通过 SSD 实现的改进。
These dramatic improvements have made SSDs prime candidates for use in performance-sensitive or mission-critical database applications.
如此急剧的进步使得SSD成为性能敏感或关键任务数据库应用程序的首选。
There are multiple methods to place DB2 for I objects on SSDs, but one of the most efficient is to use the DB2 media preference attribute.
可以有多种方法将DB 2fori对象放到SSD中,但是效率最高的一种方法就是使用DB 2媒介首选项属性。
Improve buffer pool efficiency by dedicating minimal space to table Spaces on SSDs and reallocating the space thus saved to HDD buffer pools.
通过尽量将SSD上的表空间降到最低,并重新分配空间来提升缓冲池效率,从而节省hdd缓冲池。
Sequential access, as exhibited by data warehouse activities, does not produce as great a performance improvement with SSDs as does random access.
在数据仓库活动所用到的顺序存取中,SSD的性能提升没有随机访问那么大。
应用推荐