DB2 9 sessions

Mark Labby

DB2 9 sessions
Phil,

I am hoping to catch up with you in Tampa and get some of your updates
before we migrate to DB2 9 this year. I wish I could get to your full day
session on Monday, I have heard a lot of good things about it. What are the
the biggest issues people need to know about before they start this upgrade?

Mark



_____________________________________________________________________

If you need to change settings or wish to leave the list, please visit the list subscription page:
http://idugdb2-l.org/cgi-bin/wa?SUBED1=DB2-NA-IDUG-CONF-PARTICIPANT

Phil Grainger

Re: DB2 9 sessions
(in response to Mark Labby)
Hi Mark,

You mean you want to tell people what's in my class BEFORE they decide whether to attend :)

Seriously, there is ONE item that does catch people out and its serious enough to warrant a few moments here

And this is to do with the changes to the use of work file space (in DSNDB07)

DB2 V8 will use 4K work file space unless records to be sorted are too long to fit, at which point 32K space will be used

DB2 9 uses 32K space for ALL sorts, unless the sort records are so short the maximum number of rows will fit on a 4K page

SO

People who have large 4K work space and small ("just in case") 32K space will suddenly find that many (most? all?) sorts will fail with a -904 when DB2 fills up the small 32K space allocation

Those with NO 32K space will be fine, as DB2 will continue to use 4K space - it is only people with both 4K and 32K allocations that are affected

Oh, and this is CM behaviour too - so it hits you immediately on upgrading to DB2 9 . Of course, most testing will not uncover this either - who sorts loads of data in their test environments.

A very vague rule of thumb is to allocate AT LEAST as much 32K space as you have 4K space in DB2 V8 - AND (in case you need to fall back), don't just "steal" it from the 4K allocation either

Also, take a look at PK70060 which introduces a change in behaviour for work file space usage depending on whether secondary allocations are allowed or not
Phil Grainger
Cogito Ltd.
[login to unmask email]
+44 (0) 1298 872 148
+44 (0) 7505 266 768
www.cogito.co.uk <blocked:: http://www.cogito.co.uk >

Attend IDUG 2010 - Europe, the premiere event for DB2 professionals.
8-12 November 2010, Vienna
Learn more at http://www.idug.org < http://www.idug.org/ >


From: IDUG NA [mailto:[login to unmask email] On Behalf Of Mark Labby
Sent: 18 April 2010 03:13
To: [login to unmask email]
Subject: [IDUG-NA] DB2 9 sessions

Phil,

I am hoping to catch up with you in Tampa and get some of your updates before we migrate to DB2 9 this year. I wish I could get to your full day session on Monday, I have heard a lot of good things about it. What are the the biggest issues people need to know about before they start this upgrade?

Mark
_____________________________________________________________________

If you need to change settings or wish to leave the list, please visit the list subscription page: http://idugdb2-l.org/cgi-bin/wa?SUBED1=DB2-NA-IDUG-CONF-PARTICIPANT

_____________________________________________________________________

If you need to change settings or wish to leave the list, please visit the list subscription page:
http://idugdb2-l.org/cgi-bin/wa?SUBED1=DB2-NA-IDUG-CONF-PARTICIPANT