Skip to main content

Question

 Surabhi Ashdia (Surabhi Ashdia) Coforge DPA
Coforge DPA
IN
Surabhi Ashdia Member since 2023 1 post
Coforge DPA
Posted: Oct 23, 2023
Last activity: Oct 26, 2023
Posted: 23 Oct 2023 4:31 EDT
Last activity: 26 Oct 2023 11:01 EDT

Upgrade Script loading the tables into a default schema in DB2 for Pega 7.1 to Pega 8.8 upgrade

Hi All While performing the upgrade scripts for Pega 7.1 to Pega 8.8.3, it is selecting a default table space . This is causing the upgrade script to fail as this table space doesn't have enough table space and throws the below error .   

com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-614, SQLSTATE=54008, SQLERRMC=PR_ARCHIVAL_EXCLUDED_IDX3

We can run the DDLs manually to create the tables in the tablespace with increased size.  Is there any way to direct the PegaRules and PegaData schema to create tables in the tablespace with increased size while we run the migrate script so that we dont have to run the DDLs manually?

***Edited by Moderator: Aiswarya Sudhakar to add capability tags*** 
To see attachments, please log in.
Pega Platform 8.8.3 Updates System Administration Financial Services Lead System Architect

  • Reply
Posted: 10 months ago
Posted: 26 Oct 2023 11:01 EDT
Anthony Gourtay (Anthony_Gourtay) Proximus Expert Engineer - PEGA Application Management
Proximus
BE

@Surabhi Ashdia

Hello, 

What kind of upgrade are doing? in/out place? New rules schema? New data schema?

I don't know DB2, but upgrade will only work with schema information and not tablespace info.

For me, a schema is linked to a default tablespace and any changes during upgrade will indeed be applied to this schema so to the linked tablespace.

Knowing our PEGA upgrade works, you should consider preparing your DB the way upgrade will use it.

DBA can then re-organise things the way they want but if you want to use OOTB upgrade SQL/Scripts, then adapt your DB.

Regards

Anthony

To see attachments, please log in.

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

Pega Collaboration Center 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