It's all about the answers!

Ask a question

Changing db2 database pagesize

Milan Krivic (9809171139) | asked Aug 25 '17, 2:30 a.m.


we stuck at one step of CLM 601 upgrading to CLM 604. 
Before that, we moved complete environment from OS Win Server 2008 to OS Win Server 2012.

The problem is in upgrading ccm/jazz configuration and adding tables to JAZZ/CCM database. We got following error: DB2 SQL Error: SQLCODE=-670, SQLSTATE=54010, SQLERRMC=8101;CONTENTTS;15361, DRIVER=4.21.29
The explanation is that we must change db2 pagesize (which is 8k), but we 've already created new database on Win Server 2012 with 16K and restored db2 backup.
Can anyone tell me what could be the problem in this?
How we can solve this?
Could command repotools-jazz.bat -export database content may help?

Kind regards,

One answer

permanent link
Donald Nong (14.5k414) | answered Aug 25 '17, 6:03 a.m.

IIRC, after you restore the DB2 backup, the pagesize will be converted to that of the backup. If the pagesize as 8K before the backup was taken, it will explain what you have encountered. Please double check.

Your answer

Register or to post your answer.