Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Changing db2 database pagesize

Questions
Tags
Users
Badges
Milan Krivic
(980●13●176●143) Aug 25 '17, 2:30 a.m.

 Hi,


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:
com.ibm.db2.jcc.am.SqlException: 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,
Milan

0 votes

1 answer
4,071 views
0 votes

One answer

Permanent link
Donald Nong
(14.5k●6●14) 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.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,494
× 84

Question asked: Aug 25 '17, 2:30 a.m.

Question was seen: 4,071 times

Last updated: Aug 25 '17, 6:03 a.m.

Confirmation Cancel Confirm