建表：drop table tmp_tmp;commit;create table tmp_tmp ( id varchar(4000),id_02 varchar(1)) in datats1;执行查询语句：select * from tmp_tmp order by id;报错：[Error Code: -1585, SQL State: 54048] DB2 SQL Error: SQLCODE=-1585, SQLSTATE=54048, SQLERR...
显示全部
建表：drop table tmp_tmp;commit;
create table tmp_tmp
( id varchar(4000)
,id_02 varchar(1)
) in datats1;
执行查询语句：
select * from tmp_tmp order by id;
报错：[Error Code: -1585, SQL State: 54048] DB2 SQL Error: SQLCODE=-1585, SQLSTATE=54048, SQLERRMC=null, DRIVER=4.15.82. 2) [Error Code: -727, SQL State: 56098] DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-1585;54048;, DRIVER=4.15.82
数据库相关配置：
bufferpool：DATABP32 size 294912 pagesize 32k
临时表空间：大小10g，pagesize 32k
请高手帮忙解答下。
先谢了！
收起