Support Article
Pega 7.1.7 MLU issue. Pre-upgrade DDL generation throws error
SA-9700
Summary
User is getting tablespace exception while trying to do an upgrade.
Table: PR4_RULE_USECASE Original Table Size: 3465 Current Page Size: 4k Altered Table Size: 4205
Table PageSize must be increased from 4k to 8k
Before applying this upgrade SQL change
After applying this change, tablespace PGTS0118
will have a REORG-pending advisory status and a REORG
should be planned for optimal performance.
Error Messages
Upgraded tables will exceed their current page size.
Steps to Reproduce
I have updated the setDatabase.properties and DB2SiteDependent. properties. Files are attached.
Root Cause
Table: PR4_RULE_USECASE Original Table Size: 3465 Current Page Size: 4k Altered Table Size: 4205
Table: PR4_RULE_PROPERTY Original Table Size: 3820 Current Page Size: 4k Altered Table Size: 4417
Table PageSize must be increased from 4k to 8k ..
...... Before applying this upgrade SQL change .......
Resolution
As stated in the logs, recommended the user to increase the size of the following tables from 4k to 8K. The way to alter tablespace for DB2 is as below: ALTER TABLESPACE: The ALTER TABLESPACE statement changes the description of a table space at the current server
The ALTER TABLESPACE statement changes the description of a table space at the current server.
ALTER TABLESPACE--+----------------+-table-space-name--------+-BUFFERPOOL--bpname------+-+------>
'-database-name.-' +-CCSID--ccsid-value------+
- database-name.table-space-name
- Identifies the table space that is to be altered. The name must identify a table space that exists at the current server. Omission of database-name is an implicit specification of DSNDB04.
- BUFFERPOOL bpname
- Identifies the buffer pool that is to be used for the table space. bpname must identify an activated buffer pool.
- CCSID ccsid-value
- Identifies the CCSID value to be used for the table space. ccsid-value must identify a CCSID value that is compatible with the current value of the CCSID for the table space.
Published June 12, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.