临时表空间要求创建索引的大小 [英] temporary tablespaces requirement size for creating indexes
问题描述
全部。
我有一个关于在db2中创建索引的问题。
a表有44236333行
计划构建的索引包括2个字段(6个字节)
符合db2文档
临时表空间要求大小将是
(6 + 9)* 44236333 * 3.2 / 1024/1024 / 1024 = 1.98G
现在,我有6G的临时表空间,我仍然无法创建
这个指数,说文件系统已满
任何帮助? thx ...
hi , all .
I got a question about creating indexes in db2 .
a table has 44236333 rows
an index planed to be build include 2 field ( 6 byte )
accordding to db2 document
temporary tablespaces requirement size will be
(6+9)*44236333*3.2/1024/1024/1024 = 1.98G
now , i have 6G of my temporary tablespaces , i still fail to create
this index , saying " file system is full "
any help ?? thx ...
推荐答案
rawu写道:
rawu wrote:
所有。
我有一个关于在db2中创建索引的问题。
a表有44236333行
一个索引计划构建包括2个字段(6个字节)
符合db2文件
临时表空间要求大小将是
(6 + 9) * 44236333 * 3.2 / 1024/1024 / 1024 = 1.98G
现在,我有6G的临时表空间,我仍然无法创建
这个索引,说文件系统已满
hi , all .
I got a question about creating indexes in db2 .
a table has 44236333 rows
an index planed to be build include 2 field ( 6 byte )
accordding to db2 document
temporary tablespaces requirement size will be
(6+9)*44236333*3.2/1024/1024/1024 = 1.98G
now , i have 6G of my temporary tablespaces , i still fail to create
this index , saying " file system is full "
你还有足够的空间用于日志吗?
-
Knut Stolze
DB2 z / OS实用程序开发
IBM德国
Do you have enough space for the logs as well?
--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
5月8日下午2:34,rawu < Herma ... @ gmail.comwrote:
On May 8, 2:34 pm, rawu <Herma...@gmail.comwrote:
全部。
我有一个关于创建索引的问题在db2。
a表有44236333行
计划构建的索引包括2个字段(6个字节)
符合db2文件
临时表空间要求大小将是
(6 + 9)* 44236333 * 3.2 / 1024/1024 / 1024 = 1.98G
现在,我有6G的临时表空间,我仍然无法创建
这个索引,说文件系统已满
任何帮助? thx ...
hi , all .
I got a question about creating indexes in db2 .
a table has 44236333 rows
an index planed to be build include 2 field ( 6 byte )
accordding to db2 document
temporary tablespaces requirement size will be
(6+9)*44236333*3.2/1024/1024/1024 = 1.98G
now , i have 6G of my temporary tablespaces , i still fail to create
this index , saying " file system is full "
any help ?? thx ...
对于这种错误,
文件系统已满的可能性非常大在db2diag.log中指出。这个文件是
默认位于〜/ sqllib / db2dump。
for this kind of error, there''s a very big possibility that which
file system is full is pointed out in the db2diag.log. this file is
located at ~/sqllib/db2dump by default.
On 5 ??8è?,??? ?7 *±33·?,哈迪< wyh ... @ gmail.comwrote:
On 5??8è?, ????7ê±33·?, Hardy <wyh...@gmail.comwrote:
5月8日下午2:34,rawu< Herma .. 。@ gmail.comwrote:
On May 8, 2:34 pm, rawu <Herma...@gmail.comwrote:
全部。
hi , all .
我有一个关于在db2中创建索引的问题。
I got a question about creating indexes in db2 .
a table有44236333行
计划构建的索引包括2个字段(6个字节)
符合db2文件
临时表空间要求大小将是
(6 + 9)* 44236333 * 3.2 / 1024/1024 / 1024 = 1.98G
a table has 44236333 rows
an index planed to be build include 2 field ( 6 byte )
accordding to db2 document
temporary tablespaces requirement size will be
(6+9)*44236333*3.2/1024/1024/1024 = 1.98G
现在,我有6G的临时表空间,我仍然无法创建
这个索引,说文件系统已满
now , i have 6G of my temporary tablespaces , i still fail to create
this index , saying " file system is full "
任何帮助? thx ...
any help ?? thx ...
对于这种错误,
文件系统已满的可能性非常大在db2diag.log中指出。这个文件是
默认位于〜/ sqllib / db2dump。
for this kind of error, there''s a very big possibility that which
file system is full is pointed out in the db2diag.log. this file is
located at ~/sqllib/db2dump by default.
这篇关于临时表空间要求创建索引的大小的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!