Home > database >  Why will be prompted to oracle to db2 temporary table space line size is insufficient
Why will be prompted to oracle to db2 temporary table space line size is insufficient

Time:09-28

Recently before a colleague responsible for the oracle had to transfer the project to db2, but run after conversion to temporary tablespace size was insufficient, according to another colleague to prompt, narrowing the field length solved,
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 space

CodePudding user response:

The question for your colleague's most clear

CodePudding 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"
  •  Tags:  
  • DB2
  • Related