RTC2 upgrade to RTC3 - increase page size how?

Question

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).

Answer 1

1

permanent link

Donald Nong (14.5k●6●14) | answered Mar 09 '14, 10:09 p.m.

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

Comments

Christian Romeyke commented Mar 10 '14, 2:56 a.m. | edited Mar 10 '14, 2:57 a.m.

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.

Donald Nong commented Mar 10 '14, 7:27 p.m.

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?

Christian Romeyke commented Mar 10 '14, 7:57 p.m.

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.

It's all about the answers!

Related questions

RTC2 upgrade to RTC3 - increase page size how?

One answer

Your answer