排序报错Error Code: -1585, SQL State: 54048

建表：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

请高手帮忙解答下。
先谢了！收起