Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us