不存在足够的页面大小 - DB2 插入 [英] sufficient page size does not exist - DB2 insert

问题描述

我有一个尝试插入大约 27 列的 DB2 查询(简单插入语句).在这些列中，第 1 列是 Clob，问题就在那里.对于我的 Clob 列，有时该值甚至可能包含 28K 个字符.在这种极端情况下，我收到以下错误，

I am having a DB2 query(simple insert statement) which is trying to insert some 27 columns. Out of those columns 1 is Clob and the issue is there. For my Clob column, sometimes the value might even contain 28K characters. And in such extreme cases, I am getting the below error,

 A system temporary table space with sufficient page size does not exist .. SQLCODE=-1585, SQLSTATE=54048, DRIVER=3.64.82

当我搜索并浏览了一些页面时，有一个名为 System Temporary Table Space 的实体将在执行查询时被数据库使用.(我不确定，但很少有页面说它将仅用于排序和加入，但我的查询中没有).

As I googled and gone through some pages, there is an entity called System Temporary Table Space which will be used by the DB when executing the query.(I am not sure, but few pages says that it will be used only for sorting and joining, but i don't have either in my query).

经过一些建议后，我使用以下查询创建了一个页面大小为 32K 的 系统临时表空间，

After going through few suggestions I created a System Temporary Table Space with the page size of 32K, using the below query,

CREATE SYSTEM TEMPORARY TABLESPACE STB PAGESIZE 32K MANAGED BY SYSTEM USING ( 'C:DB2NODE0005') BUFFERPOOL BP32K

我的问题还在继续.执行我的查询的正确方法是什么.我试图了解 System Temporary Table Space、Page Size 等的重要性.但任何帮助可以暂时解决此问题将不胜感激.

Still my issue continues. What would be the proper way to have my query executed. I am trying to understand the importance of System Temporary Table Space, Page Size,etc.. But any help that could fix this issue for now would be greatly appreciated.

推荐答案

您可以为每个页面创建一个系统临时表空间作为 SMS(System Managed).在这种情况下，您的查询将始终找到具有适当页面大小的表空间.

You can create a system temporary tablespace for each page as SMS (System Managed). In that case, your query will always find a tablespace with the appropriate page size.

CREATE SYSTEM TEMPORARY TABLESPACE STB_4 PAGESIZE 4K 
CREATE SYSTEM TEMPORARY TABLESPACE STB_8 PAGESIZE 8K 
CREATE SYSTEM TEMPORARY TABLESPACE STB_16 PAGESIZE 16K 
CREATE SYSTEM TEMPORARY TABLESPACE STB_32 PAGESIZE 32K 

在创建 SMS 时，表空间不会在磁盘中预先分配空间，它们只会随着使用而增长.

When creating SMS, the tablespace will not preallocate space in the disk, and they only growth as they are used.

这篇关于不存在足够的页面大小 - DB2 插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！