k_murli_krishna
asked on
System temporary tablespace pagesize exceeded
1) We have a table whose row size exceeds 4K which is page size of regular tablespace. So creation of this table failed and I had to create a bufferpool of 8K and a tablespace.
2) Now, when we try to insert record, we get System temporary tablespace pagesize exceeded.
3) System tablespace means holds default data dictionary meta data which is SYSCATSPACE. Temporary tablespace is used for sorts only when there are ORDER BY, GROUP BY, DISTINCT, MAX, MIN, AVG.
4) Then why point on system temporary tablespace during an INSERT?
2) Now, when we try to insert record, we get System temporary tablespace pagesize exceeded.
3) System tablespace means holds default data dictionary meta data which is SYSCATSPACE. Temporary tablespace is used for sorts only when there are ORDER BY, GROUP BY, DISTINCT, MAX, MIN, AVG.
4) Then why point on system temporary tablespace during an INSERT?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the help and tips.
ASKER
Experts, can you please respond to points 3) and 4) of my original question. What is the name of default sytem temporary tablespace created by DB2 like it creates SYSCATSPACE, USERSPACE1, TEMPSPACE.
Whatever type but does not temporary tablespace means it is used for sorting after sort heap in RAM is used up?