Have a great god help solve this is why? Why will appear this problem? Why to narrow the field length is solved?
CodePudding user response:
No submit operation is calculated in the temporary table space, large quantities of data, of course, the temporary table spaceCodePudding user response:
The question for your colleague's most clearCodePudding user response:
Modify or reconstruct corresponding table space, the use of 32 k, this is the biggest,For example:
The db2 CREATE BUFFERPOOL USER_BP_32K IMMEDIATE SIZE 1000 PAGESIZE 32 k
Db2 "CREATE SYSTEM TEMPORARY in TABLESPACE TBS_SYSTEMP pagesize 32 k managed by the SYSTEM using ('/home/db2inst1/XXXDB/TPS/TBS_SYSTEMP dat ') BUFFERPOOL USER_BP_32K"