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

RTC2 upgrade to RTC3 - increase page size how?

Hi,

I'm currently upgrading from RTC2 to RTC3 (as preparation for the RTC4 upgrade) and just stumbled over a remark in the interactive upgrade guide:
Note: If you re-use your Rational Team Concert database with a lower page size than 16K, you must increase the page size to 16K.
However my DBA tells me this cannot be done in DB2 (except for creating a new tablespace with a bigger size and moving every single table to that new tablespace). Are we missing something here? I suppose I could export / import into a new DB using repotools prior to performing the upgrade, but is this really the only option? (I'd like to avoid this because I'm fearing it'll take days, especially since I would have to perform this from a remote host).

(I have also asked this in a comment to an existing question here, but figured it would be better suited as a separate new question, so sorry for double-posting).

0 votes



One answer

Permanent link
I cannot find from which document you quoted the page size. Which document did you refer to?
Regardless the document, what your DBA told you is true. And I think it's better (and normally quicker) to move the data on the database side, rather than the applications side (using repotools). Here are two tools for moving the data but you need to ask your DBA to evaluate them first.
http://www.ibm.com/developerworks/data/library/techarticle/dm-0906datamovement/
https://www.ibm.com/developerworks/community/groups/service/html/communityview?communityUuid=05901c97-75b2-47a1-9c32-25f748855913

1 vote

Comments

Donald, thanks a lot for your answer, we'll be looking into these tools. The quotation is from the "interactive upgrade guide", available here:

http://pic.dhe.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Froadmap_clm_upgrade.html

If you choose RTC v2 and DB2, there will be a step "Create new databases for the Jazz Team Server application" (step 7 in my case). The note is near the top of that step.

OK, found it. Put it in context, I think what it means is that the instruction does not force you to create new databases for the upgrade, and you can stick to the existing databases. But the 16K page size is a must for the new version, so you have to make it as such "somehow". Given the any existing databases can be in varied configuration, it will be difficult to give exact and consistent steps in this regard. Does it make sense?

Well, kind of. Although since the setup instructions for RTC 2 explicitly mention 8K pages, I guess that's what most people (running DB2) will have to deal with when they upgrade, so I wonder why this seems to be such a rare issue.

The other thing I don't quite understand is that, apart from the interactive upgrade guide, the 16K requirement is only ever mentioned in instructions for DB2 on z/OS, for example here:

http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0/index.jsp?topic=%2Fcom.ibm.jazz.install.doc%2Ftopics%2Fc_rtcz_upgrading_plan.html

or here:

https://jazz.net/help-dev/clm/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/t_rtcz_setting_up_db2.html&scope=null

Could it be that there simply is no such requirement for DB2 LUW? For what it's worth, I have completed the upgrade without increasing the page size, and the application seems fine.

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.

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,486

Question asked: Mar 07 '14, 3:59 p.m.

Question was seen: 4,224 times

Last updated: Mar 10 '14, 7:57 p.m.

Confirmation Cancel Confirm