memory increase needed for v12 migration

william giannelli

memory increase needed for v12 migration

So I am confused as to whether or not the EDMPOOL and RIDPOOL should be increased PRIOR to v12 migration.

I now have had 2 IBM "experts" give advice contradicting each other. One says there is NO need to increase in v11 for v12 migration. Another "expert" recommends increasing EDMPOOL by up to 30% and RIDPOOL up to 60% in v11 PRIOR to v12 migration.

I'd like to know the experience out there......

What have people done for memory in v11 to prepare for v12?

thanks

Bill 

Roy Boxwell

memory increase needed for v12 migration
(in response to william giannelli)
I would just make sure when you get to db2 12 that you increase the RID pool as the RID size has increased and it can trigger fail over into work or even R-Scan in worst case.

Changing the ZPARMS in Db2 11 makes no real sense as you cannot then see what happens in the migration was caused by access path changes or zparm changes… Makes things confusing!



I would also recommend:

EDMSTMTC to be at least 1G as going to 4G is not recommended! (Just because you can does mean you should!)

EDM_SKELETON_POOL should be set to at least 102,400 (double the default)

SRTPOOL to 128,000 Maximum value

RIDPOOL to 2,000,000 Maximum value (default is 1,000,000 and was 400,000 in Db2 11)



EDMPOOL is gone is Db2 12 and should be set to 0 in Db2 11



Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Vagedesstrasse 19
40479 Dusseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

https://www.seg.de/corporate/rechtliche-hinweise/datenschutz Link zur Datenschutzerklärung


Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich



From: william giannelli <[login to unmask email]>
Sent: Thursday, June 11, 2020 5:26 PM
To: [login to unmask email]
Subject: [DB2-L] - memory increase needed for v12 migration



So I am confused as to whether or not the EDMPOOL and RIDPOOL should be increased PRIOR to v12 migration.

I now have had 2 IBM "experts" give advice contradicting each other. One says there is NO need to increase in v11 for v12 migration. Another "expert" recommends increasing EDMPOOL by up to 30% and RIDPOOL up to 60% in v11 PRIOR to v12 migration.

I'd like to know the experience out there......

What have people done for memory in v11 to prepare for v12?

thanks

Bill



-----End Original Message-----

Attachments

  • smime.p7s (5.1k)

Jorg Lueke

RE: memory increase needed for v12 migration
(in response to william giannelli)

Do increase your RID pool, or at least make sure you're not one some old override. The default should be the minimum you use on 12. 

https://www.linkedin.com/in/jorg-lueke-8b391b4/