Troubleshooting
Problem
Partitioning product tables for database fails
Symptom
partition your Production tables for performance" fails with SQL Error code = -670
Message: THE RECORD LENGTH OF THE TABLE EXCEEDS THE PAGE SIZE LIMIT
Cause
Let us say the DB2 database is configured within SCC to create tables in Table Space
"USERSPACE1"
USERSPACE1 is configured to use the Buffer Pool IBMDEFAULTBP
and IBMDEFAULTBP has a page size of 32
If the page size is less than 32 and SCC tries to create table with too
large a record length you get the -670 error
Environment
Sterling Control Center 5.3.02 on z/Linux
Resolving The Problem
Either delete the database created and create a new one with corrected table size of 32
or
If you are using a Buffer Pool with a page size less than 32, then you will need to create a new Buffer Pool and update the Table Space to use it instead via the "ALTER TABLESPACE" command
Was this topic helpful?
Document Information
Modified date:
17 December 2019
UID
swg21596327