While the support for media preference in V5R4 and especially IBM I 6.1 was extensive, there were gaps.
尽管V5R4特别是IBMi 6.1中对媒介首选项的支持非常丰富,然而还存在一些不足之处。
If the SQL table was a partitioned table, each partition (member) could have a separate media preference.
如果sql表是一个分区表,每个分区(成员)都可以有一个单独的媒介首选项。
As mentioned earlier, all previous mechanisms of changing the media preference required an exclusive lock on the entire file.
如前所述,之前所有用于修改媒介首选项的方法都要求对整个文件使用互斥型锁。
The initial support for SSDs in V5R4 allowed users to specify a media preference at creation or altered later with a change command as shown in the following examples.
V 5 R 4中首次提供的SSD支持允许用户在创建时指定媒介首选项,或稍后使用如下所示的命令进行修改。
Media preference can also be specified on a table or physical file to request that data itself should be allocated on SSD storage.
也可以对表或物理文件指定媒介首选项,请求将数据本身分配到SSD存储设备。
Media preference can be specified for an index or keyed file to request that the underlying index object be allocated on SSD storage.
媒介首选项可以针对索引或键控文件指定,请求将底层索引对象分配到SSD存储设备。
Media preference could be controlled at the partition (member level) for SQL partitioned tables, but the same was not possible for DDS-created physical files with multiple members.
对于已分区的sql表来说,媒介首选项可以在分区(成员)级别进行控制,但是对于具有多个成员的DDS创建的物理文件则无法实现这一点。
Media preference could be controlled at the partition (member level) for SQL partitioned tables, but the same was not possible for DDS-created physical files with multiple members.
对于已分区的sql表来说,媒介首选项可以在分区(成员)级别进行控制,但是对于具有多个成员的DDS创建的物理文件则无法实现这一点。
应用推荐