DB2 v8.1 CM - ENFM mode issues

Michael Kaminski

DB2 v8.1 CM - ENFM mode issues


We finally have approval from the applications\business area to upgrade our production Db2 sub-system from CM to ENFM. We have been in CM mode for just over 1 yr. and our test\QA have been in ENFM for 3+ months with no reported issues. But senior management asked the question:

'Has anyone else experienced any other foreseen issues with going to ENFM from CM?'

Any feedback would be greatly appreciated.

Thanks,

Michael A. Kaminski
[login to unmask email]



NOTICE: This message and all attachments transmitted with it may contain confidential,
sensitive, or protected information intended solely for the use of the addressee. If the reader
of this message is not the intended recipient, you are hereby notified that any reading,
dissemination, distribution, copying, or other use of this message or its attachments is strictly
prohibited. If you have received this message in error, please notify the sender immediately
by telephone or by electronic mail and delete this message and all copies and backups thereof.
Thank you.



_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Chris Hoelscher

Re: DB2 v8.1 CM - ENFM mode issues
(in response to Michael Kaminski)
we chose not to stay at ENFM - we ran the jobs consecutively to go from
the CM to ENFM to NFM - we experienced no problems taking this path - we
did, as an aside, leave the compiler in NFM=NO for a week or two after the
NFM conversion however .....

Chris Hoelscher
IDMS/DB2 System & Database Architect
Humana Inc
502-476-2538
[login to unmask email]

I refuse to repeat gossip - so listen carefully the first time




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Cathy Taddei

Re: DB2 v8.1 CM - ENFM mode issues
(in response to Chris Hoelscher)
We also went from CM to ENFM to NFM in one day. No issues with that. All the vendors will advise you to stay in ENFM for a short time because most of their testing was geared towards CM and NFM.

When you go to NFM, beware of RRF if you use a vendor utility to recover from image copy from one subsystem to another -- it doesn't work if the source and target are not the same RRF vs. BRF. Back when we implemented DB2 9 it didn't give you a choice -- certain activities (such as reorg) automatically converted a BRF to RRF. Now you have a zparm to disable that if you want.

HTH,
Cathy Taddei

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Kaminski, Michael
Sent: Thursday, January 06, 2011 11:42 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 v8.1 CM - ENFM mode issues



We finally have approval from the applications\business area to upgrade our production Db2 sub-system from CM to ENFM. We have been in CM mode for just over 1 yr. and our test\QA have been in ENFM for 3+ months with no reported issues. But senior management asked the question:

'Has anyone else experienced any other foreseen issues with going to ENFM from CM?'

Any feedback would be greatly appreciated.

Thanks,

Michael A. Kaminski
[login to unmask email]


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

David Simpson

Re: DB2 v8.1 CM - ENFM mode issues
(in response to Cathy Taddei)
We're talking V8 here, not V9, right?

The RRF thing is a V9 issue.

The one thing that caused us a small bit of trouble in V8 ENFM was the
drop and recreate of the SYSIBM.SYSDUMMY1 table. This causes all
packages that use that table to be invalidated. Not a big deal if you
are expecting it, but you may want to put a step in your migration
process to rebind all those.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Taddei, Cathy
Sent: Thursday, January 06, 2011 5:17 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues

We also went from CM to ENFM to NFM in one day. No issues with that.
All the vendors will advise you to stay in ENFM for a short time because
most of their testing was geared towards CM and NFM.

When you go to NFM, beware of RRF if you use a vendor utility to recover
from image copy from one subsystem to another -- it doesn't work if the
source and target are not the same RRF vs. BRF. Back when we
implemented DB2 9 it didn't give you a choice -- certain activities
(such as reorg) automatically converted a BRF to RRF. Now you have a
zparm to disable that if you want.

HTH,
Cathy Taddei

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Kaminski,
Michael
Sent: Thursday, January 06, 2011 11:42 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 v8.1 CM - ENFM mode issues



We finally have approval from the applications\business area to upgrade
our production Db2 sub-system from CM to ENFM. We have been in CM mode
for just over 1 yr. and our test\QA have been in ENFM for 3+ months with
no reported issues. But senior management asked the question:

'Has anyone else experienced any other foreseen issues with going to
ENFM from CM?'

Any feedback would be greatly appreciated.

Thanks,

Michael A. Kaminski
[login to unmask email]


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2
information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Raymond Bell

Re: DB2 v8.1 CM - ENFM mode issues
(in response to David Simpson)
David, I think Cathy is getting at taking a V9 IC and laying it down on a V8 tablespace, DSN1COPY-stylie. Not an issue for you in the short-to-medium term if you're only going to V8 NFM now.

Cathy, not all vendors have that problem. Some time ago I did some pretty extensive testing for a UK customer that was considering all sorts of V7/V8/V9 data migration options and, for all the combos I could think to try, we didn't have an issue re: BRF/RRF; we'd always honour the source IC data format. But I'm skirting with [AD] here so I'll stop.

Cheers,


Raymond

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of David Simpson
Sent: 07 January 2011 01:01
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues

We're talking V8 here, not V9, right?

The RRF thing is a V9 issue.

The one thing that caused us a small bit of trouble in V8 ENFM was the
drop and recreate of the SYSIBM.SYSDUMMY1 table. This causes all
packages that use that table to be invalidated. Not a big deal if you
are expecting it, but you may want to put a step in your migration
process to rebind all those.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Taddei, Cathy
Sent: Thursday, January 06, 2011 5:17 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues

We also went from CM to ENFM to NFM in one day. No issues with that.
All the vendors will advise you to stay in ENFM for a short time because
most of their testing was geared towards CM and NFM.

When you go to NFM, beware of RRF if you use a vendor utility to recover
from image copy from one subsystem to another -- it doesn't work if the
source and target are not the same RRF vs. BRF. Back when we
implemented DB2 9 it didn't give you a choice -- certain activities
(such as reorg) automatically converted a BRF to RRF. Now you have a
zparm to disable that if you want.

HTH,
Cathy Taddei

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Kaminski,
Michael
Sent: Thursday, January 06, 2011 11:42 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 v8.1 CM - ENFM mode issues



We finally have approval from the applications\business area to upgrade
our production Db2 sub-system from CM to ENFM. We have been in CM mode
for just over 1 yr. and our test\QA have been in ENFM for 3+ months with
no reported issues. But senior management asked the question:

'Has anyone else experienced any other foreseen issues with going to
ENFM from CM?'

Any feedback would be greatly appreciated.

Thanks,

Michael A. Kaminski
[login to unmask email]


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2
information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Cathy Taddei

Re: DB2 v8.1 CM - ENFM mode issues
(in response to Raymond Bell)
Sorry, somehow I missed the v8.1 so prominent in the subject line, and was talking about DB2 9. I still think it prudent to keep ENFM as short as reasonable before converting to NFM. Our v8 CM-ENFM-NFM conversion was also trouble-free, and happened in one day.

Raymond, that's good to know about BMC Recover Plus, I will bear that in mind.

Thanks,
Cathy Taddei

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bell, Raymond
Sent: Friday, January 07, 2011 12:36 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues

David, I think Cathy is getting at taking a V9 IC and laying it down on a V8 tablespace, DSN1COPY-stylie. Not an issue for you in the short-to-medium term if you're only going to V8 NFM now.

Cathy, not all vendors have that problem. Some time ago I did some pretty extensive testing for a UK customer that was considering all sorts of V7/V8/V9 data migration options and, for all the combos I could think to try, we didn't have an issue re: BRF/RRF; we'd always honour the source IC data format. But I'm skirting with [AD] here so I'll stop.

Cheers,


Raymond

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of David Simpson
Sent: 07 January 2011 01:01
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues

We're talking V8 here, not V9, right?

The RRF thing is a V9 issue.

The one thing that caused us a small bit of trouble in V8 ENFM was the
drop and recreate of the SYSIBM.SYSDUMMY1 table. This causes all
packages that use that table to be invalidated. Not a big deal if you
are expecting it, but you may want to put a step in your migration
process to rebind all those.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Taddei, Cathy
Sent: Thursday, January 06, 2011 5:17 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues

We also went from CM to ENFM to NFM in one day. No issues with that.
All the vendors will advise you to stay in ENFM for a short time because
most of their testing was geared towards CM and NFM.

When you go to NFM, beware of RRF if you use a vendor utility to recover
from image copy from one subsystem to another -- it doesn't work if the
source and target are not the same RRF vs. BRF. Back when we
implemented DB2 9 it didn't give you a choice -- certain activities
(such as reorg) automatically converted a BRF to RRF. Now you have a
zparm to disable that if you want.

HTH,
Cathy Taddei

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Kaminski,
Michael
Sent: Thursday, January 06, 2011 11:42 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 v8.1 CM - ENFM mode issues



We finally have approval from the applications\business area to upgrade
our production Db2 sub-system from CM to ENFM. We have been in CM mode
for just over 1 yr. and our test\QA have been in ENFM for 3+ months with
no reported issues. But senior management asked the question:

'Has anyone else experienced any other foreseen issues with going to
ENFM from CM?'

Any feedback would be greatly appreciated.

Thanks,

Michael A. Kaminski
[login to unmask email]


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2
information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Raymond Bell

Re: DB2 v8.1 CM - ENFM mode issues
(in response to Roger Miller)
Ooh, you said a product name! Miss! Miss! Cathy said a rude word!

Well, tradition dictates a bit of humo(u)r on a Friday.

Cheers,


Raymond

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Taddei, Cathy
Sent: 07 January 2011 16:30
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues

Sorry, somehow I missed the v8.1 so prominent in the subject line, and was talking about DB2 9. I still think it prudent to keep ENFM as short as reasonable before converting to NFM. Our v8 CM-ENFM-NFM conversion was also trouble-free, and happened in one day.

Raymond, that's good to know about BMC Recover Plus, I will bear that in mind.

Thanks,
Cathy Taddei

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Roger Miller

Re: DB2 v8.1 CM - ENFM mode issues
(in response to Cathy Taddei)
Very few customers stayed in ENFM for long. Have you read the book carefully on this change? We have made lots of book changes as customers found new ways through the process. See all the change bars in this section.
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2.doc.inst/bjnninfm1006457.htm#bjnninfm1006457
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2.doc.inst/djtip03.htm#djtip03

V8 has been out and GA for almost 7 years now, and is out of service in just over a year. You need to get to NFM and then work on the next migration.

Roger Miller, DB2 for z/OS

-----Original Message-----

Sorry, somehow I missed the v8.1 so prominent in the subject line, and was talking about DB2 9. I still think it prudent to keep ENFM as short as reasonable before converting to NFM. Our v8 CM-ENFM-NFM conversion was also trouble-free, and happened in one day.

Raymond, that's good to know about BMC Recover Plus, I will bear that in mind.

Thanks,
Cathy Taddei

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bell, Raymond
Sent: Friday, January 07, 2011 12:36 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues

David, I think Cathy is getting at taking a V9 IC and laying it down on a V8 tablespace, DSN1COPY-stylie. Not an issue for you in the short-to-medium term if you're only going to V8 NFM now.

Cathy, not all vendors have that problem. Some time ago I did some pretty extensive testing for a UK customer that was considering all sorts of V7/V8/V9 data migration options and, for all the combos I could think to try, we didn't have an issue re: BRF/RRF; we'd always honour the source IC data format. But I'm skirting with [AD] here so I'll stop.

Cheers,


Raymond

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of David Simpson
Sent: 07 January 2011 01:01
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues

We're talking V8 here, not V9, right?

The RRF thing is a V9 issue.

The one thing that caused us a small bit of trouble in V8 ENFM was the
drop and recreate of the SYSIBM.SYSDUMMY1 table. This causes all
packages that use that table to be invalidated. Not a big deal if you
are expecting it, but you may want to put a step in your migration
process to rebind all those.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Taddei, Cathy
Sent: Thursday, January 06, 2011 5:17 PM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues

We also went from CM to ENFM to NFM in one day. No issues with that.
All the vendors will advise you to stay in ENFM for a short time because
most of their testing was geared towards CM and NFM.

When you go to NFM, beware of RRF if you use a vendor utility to recover
from image copy from one subsystem to another -- it doesn't work if the
source and target are not the same RRF vs. BRF. Back when we
implemented DB2 9 it didn't give you a choice -- certain activities
(such as reorg) automatically converted a BRF to RRF. Now you have a
zparm to disable that if you want.

HTH,
Cathy Taddei

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Kaminski,
Michael
Sent: Thursday, January 06, 2011 11:42 AM
To: [login to unmask email]
Subject: [DB2-L] DB2 v8.1 CM - ENFM mode issues



We finally have approval from the applications\business area to upgrade
our production Db2 sub-system from CM to ENFM. We have been in CM mode
for just over 1 yr. and our test\QA have been in ENFM for 3+ months with
no reported issues. But senior management asked the question:

'Has anyone else experienced any other foreseen issues with going to
ENFM from CM?'

Any feedback would be greatly appreciated.

Thanks,

Michael A. Kaminski
[login to unmask email]

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Max Scarpa

Re: DB2 v8.1 CM - ENFM mode issues
(in response to Raymond Bell)
Hi all

Wow 1 year in CM, it's a real long time.

We moved to ENFM-->NFM very quickly as suggested by IBM and as suggested
by users experience. After a so long time I don't expect real big issues
moving to NFM in a very short period, your V8 'foundations' are stable and
solid and all DB2+z/OS related issues should have been resolved after a
year (and at least 1 IPL), there're few modifications (with respect
V7-->V8 CM migration) moving to ENFM/NFM.

We removed NFM=NO after a short interval of time, we left it upon
programmers' request, but I think it'd be better to remove it ASAP.

Just my experience.

Max Scarpa

Certiflu(ed) DB2 sysprog

“May the Force be with you. Or at least good DB2 sysprog"


IDUG DB2-L <[login to unmask email]> wrote on 06/01/2011 20.41.51:

> From: "Kaminski, Michael" <[login to unmask email]>
> To: [login to unmask email]
> Date: 06/01/2011 20.42
> Subject: [DB2-L] DB2 v8.1 CM - ENFM mode issues
> Sent by: IDUG DB2-L <[login to unmask email]>
>
>
>
> We finally have approval from the applications\business area to
> upgrade our production Db2 sub-system from CM to ENFM. We have been
> in CM mode for just over 1 yr. and our test\QA have been in ENFM for
> 3+ months with no reported issues. But senior management asked the
question:
>
> 'Has anyone else experienced any other foreseen issues with going to
> ENFM from CM?'
>
> Any feedback would be greatly appreciated.
>
> Thanks,
>
> Michael A. Kaminski
> [login to unmask email]
>
>
>
> NOTICE: This message and all attachments transmitted with it may
> contain confidential,
> sensitive, or protected information intended solely for the use of
> the addressee. If the reader
> of this message is not the intended recipient, you are hereby
> notified that any reading,
> dissemination, distribution, copying, or other use of this message
> or its attachments is strictly
> prohibited. If you have received this message in error, please
> notify the sender immediately
> by telephone or by electronic mail and delete this message and all
> copies and backups thereof.
> Thank you.
>
>
>
>
> _____________________________________________________________________
> * IDUG North America * Anaheim, California * May 2-6 2011 * http://
> IDUG.ORG/NA *
> * Your only source for independent, unbiased, and trusted DB2
> information. *
> ** The most DB2 technical sessions of any conference
> ** Access IBM experts and developers
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
> is the home of IDUG's Listserv


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Avram Friedman

Re: DB2 v8.1 CM - ENFM mode issues
(in response to Max Scarpa)
I argee with Max, may the force be with you.

I experienced many problems migrating from V8 CM to ENFM

Some or all may not be meainingful to you.

Let me point out what is at work here, as has been done many times since the introduction of V8

DB2 services that my shop uses may not be in use by your shop or vice versa.
Some problems experienced 3 years ago may now of been fixed, new ones may of been created.
DB2 V8 today can not be compared to DB2 V8 3 years ago.
3 years ago migration was expected today it is not.
3 years ago there was no V9 and V9+ functionality retrofitted to V8 AT ALL

There is a reason to stay current.

My suggestion is to go for it before V8 goes EOS in 15 months.
If you think its bad today you can rest assured that it will be worse, not better tomorrow.

Regards
Avram Friedman

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Max Scarpa

Re: DB2 v8.1 CM - ENFM mode issues
(in response to Avram Friedman)
Hi Avram

I heard some collegues had many issues as well after migration to V8 (they
had to fallback), but it was in CM. They happily migrated to NFM after
they applied all needed fixes/updates. I heard other collegues having
troubles after they moved to NFM when they started to use new V8
features, and it was a long way to reach a stable DB2. But it was some
years ago. We migrated in year 2009
and, apart an increase in cpu usage in DIST space (as %), we had few
troubles and cpu consumption were similar to V7, at least for normal and
daily workloads.
We collected few PTFs left before migrating prod DB2s so I presume V8 was
enough stable. But, as I usually point out, we were 'current' with hipers
in z/OS as well (and more I think), after 'BLOBs rage' I decided to have a
look with z/OS sysprogs to the level of maintenance in z/OS system. I
think it's now a best practice as DB2 and z/OS interact more in every
version (and Db2 10 isn't an exception) .
We stayed in CM for 35-36 days in prod, if I remeber well, after a
significant period for our shop (which is different in almost every other
shop).

Just my later experience, along the same track.

Max Scarpa

Certiflu(ed) DB2 sysprog





From: Avram Friedman <[login to unmask email]>
To: [login to unmask email]
Date: 10/01/2011 12.06
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues
Sent by: IDUG DB2-L <[login to unmask email]>



I argee with Max, may the force be with you.

I experienced many problems migrating from V8 CM to ENFM

Some or all may not be meainingful to you.

Let me point out what is at work here, as has been done many times since
the introduction of V8

DB2 services that my shop uses may not be in use by your shop or vice
versa.
Some problems experienced 3 years ago may now of been fixed, new ones may
of been created.
DB2 V8 today can not be compared to DB2 V8 3 years ago.
3 years ago migration was expected today it is not.
3 years ago there was no V9 and V9+ functionality retrofitted to V8 AT
ALL

There is a reason to stay current.

My suggestion is to go for it before V8 goes EOS in 15 months.
If you think its bad today you can rest assured that it will be worse, not
better tomorrow.

Regards
Avram Friedman

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2
information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv


_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Avram Friedman

Re: DB2 v8.1 CM - ENFM mode issues
(in response to Max Scarpa)
In the move between V8 CM and V8 ENFM
We had lots of problems with old DBDs built many versions ago.
There is currently an active thread that deals with someone elses DBD problems
(Hanging view)

In the move to CM our biggest problems were with DIST
Perhaps in second place CCID issues

Through out the conversion period sometimes in both CM and ENFM we had
Reserved word issues
New zparms and zparm meanings esp with DIST and Stored procedure control
Changes in the way utilities worked esp but not only those sites that were not users of IBM sort
People who expected new features like XML to work auto-magicly.

I am still doing conversions to V8, Im in the out sourcing business and out of date software is very common.
May be one of the reasons why some shops look for outsourcers.

The biggest problem I run into today is the assumption that experiences recorded 3 or 8 years ago are vaild today.
Not wanting to beat a dead horse but often they are not vaild.
DB2 V8 has changed from ready to install product to ready to be upgraded product.

Thanks and best wishes Max
Avram Friedman

PS in the last quarter the shop I work for upgraded our last DB2 V4 system. It is now V9.
We do, however, still have a number of DB2 V3 systems.

On Mon, 10 Jan 2011 13:17:23 +0100, Max Scarpa <[login to unmask email]> wrote:

>Hi Avram
>
>I heard some collegues had many issues as well after migration to V8 (they
>had to fallback), but it was in CM. They happily migrated to NFM after
>they applied all needed fixes/updates. I heard other collegues having
>troubles after they moved to NFM when they started to use new V8
>features, and it was a long way to reach a stable DB2. But it was some
>years ago. We migrated in year 2009
>and, apart an increase in cpu usage in DIST space (as %), we had few
>troubles and cpu consumption were similar to V7, at least for normal and
>daily workloads.
>We collected few PTFs left before migrating prod DB2s so I presume V8 was
>enough stable. But, as I usually point out, we were 'current' with hipers
>in z/OS as well (and more I think), after 'BLOBs rage' I decided to have a
>look with z/OS sysprogs to the level of maintenance in z/OS system. I
>think it's now a best practice as DB2 and z/OS interact more in every
>version (and Db2 10 isn't an exception) .
>We stayed in CM for 35-36 days in prod, if I remeber well, after a
>significant period for our shop (which is different in almost every other
>shop).
>
>Just my later experience, along the same track.
>
>Max Scarpa
>
>Certiflu(ed) DB2 sysprog
>
>
>
>
>
>From: Avram Friedman <[login to unmask email]>
>To: [login to unmask email]
>Date: 10/01/2011 12.06
>Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues
>Sent by: IDUG DB2-L <[login to unmask email]>
>
>
>
>I argee with Max, may the force be with you.
>
>I experienced many problems migrating from V8 CM to ENFM
>
>Some or all may not be meainingful to you.
>
>Let me point out what is at work here, as has been done many times since
>the introduction of V8
>
>DB2 services that my shop uses may not be in use by your shop or vice
>versa.
>Some problems experienced 3 years ago may now of been fixed, new ones may
>of been created.
>DB2 V8 today can not be compared to DB2 V8 3 years ago.
> 3 years ago migration was expected today it is not.
> 3 years ago there was no V9 and V9+ functionality retrofitted to V8 AT
>ALL
>
>There is a reason to stay current.
>
>My suggestion is to go for it before V8 goes EOS in 15 months.
>If you think its bad today you can rest assured that it will be worse, not
>better tomorrow.
>
>Regards
>Avram Friedman
>
>_____________________________________________________________________
>* IDUG North America * Anaheim, California * May 2-6 2011 *
>http://IDUG.ORG/NA *
>* Your only source for independent, unbiased, and trusted DB2
>information. *
>_____________________________________________________________________
>http://www.IDUG.org/mentor
>Mentoring should be a rewarding experience for everyone...
>IDUG is offering up to 80% off when you both come to the conference!
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
>the home of IDUG's Listserv
>
>
>_____________________________________________________________________
>* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
>* Your only source for independent, unbiased, and trusted DB2 information. *
>_____________________________________________________________________
>http://www.IDUG.org/mentor
>Mentoring should be a rewarding experience for everyone...
>IDUG is offering up to 80% off when you both come to the conference!
>_____________________________________________________________________
>
>If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv
>

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Michael Kaminski

Re: DB2 v8.1 CM - ENFM mode issues
(in response to Avram Friedman)
Thanks to all for sharing your experiences and knowledge.

Mike Kaminski

________________________________
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Max Scarpa
Sent: Monday, January 10, 2011 6:17 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues

Hi Avram

I heard some collegues had many issues as well after migration to V8 (they had to fallback), but it was in CM. They happily migrated to NFM after they applied all needed fixes/updates. I heard other collegues having troubles after they moved to NFM when they started to use new V8 features, and it was a long way to reach a stable DB2. But it was some years ago. We migrated in year 2009
and, apart an increase in cpu usage in DIST space (as %), we had few troubles and cpu consumption were similar to V7, at least for normal and daily workloads.
We collected few PTFs left before migrating prod DB2s so I presume V8 was enough stable. But, as I usually point out, we were 'current' with hipers in z/OS as well (and more I think), after 'BLOBs rage' I decided to have a look with z/OS sysprogs to the level of maintenance in z/OS system. I think it's now a best practice as DB2 and z/OS interact more in every version (and Db2 10 isn't an exception) .
We stayed in CM for 35-36 days in prod, if I remeber well, after a significant period for our shop (which is different in almost every other shop).

Just my later experience, along the same track.

Max Scarpa

Certiflu(ed) DB2 sysprog





From: Avram Friedman <[login to unmask email]>
To: [login to unmask email]
Date: 10/01/2011 12.06
Subject: Re: [DB2-L] DB2 v8.1 CM - ENFM mode issues
Sent by: IDUG DB2-L <[login to unmask email]>
________________________________



I argee with Max, may the force be with you.

I experienced many problems migrating from V8 CM to ENFM

Some or all may not be meainingful to you.

Let me point out what is at work here, as has been done many times since the introduction of V8

DB2 services that my shop uses may not be in use by your shop or vice versa.
Some problems experienced 3 years ago may now of been fixed, new ones may of been created.
DB2 V8 today can not be compared to DB2 V8 3 years ago.
3 years ago migration was expected today it is not.
3 years ago there was no V9 and V9+ functionality retrofitted to V8 AT ALL

There is a reason to stay current.

My suggestion is to go for it before V8 goes EOS in 15 months.
If you think its bad today you can rest assured that it will be worse, not better tomorrow.

Regards
Avram Friedman

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA < http://idug.org/NA > *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor < http://www.idug.org/mentor >
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv


________________________________

[ http://www.idug.org/images/stories/db2/db2_10_savings.jpg ] < http://www-01.ibm.com/software/data/db2/zos/db2-10/ >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

NOTICE: This message and all attachments transmitted with it may contain confidential,
sensitive, or protected information intended solely for the use of the addressee. If the reader
of this message is not the intended recipient, you are hereby notified that any reading,
dissemination, distribution, copying, or other use of this message or its attachments is strictly
prohibited. If you have received this message in error, please notify the sender immediately
by telephone or by electronic mail and delete this message and all copies and backups thereof.
Thank you.



_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Anil Kumar

Re: DB2 v8.1 CM - ENFM mode issues
(in response to Michael Kaminski)
Hi All,

Thanks again for all these hints for migration. I have a small request. Can I request the estemeed listers to send across a migration plan document (migration from DB2 V7 to DB2 V8).Basically I would like to know about the technical issues that were faced during the migration through NFM and their solution , so that we could be well prepared to take on the migration .

If there are any such migration plans documents / best practices , request to please guide me through those links.

Thanks all,
Anil.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Roger Miller

Re: DB2 v8.1 CM - ENFM mode issues
(in response to Anil Kumar)
Migration to V8 requires the wayback machine.

Here is a paper Willie Favero wrote about four years ago. http://www.ibm.com/support/docview.wss?uid=swg27010814
ftp://ftp.software.ibm.com/software/data/db2zos/DB2zOS_v8_upgrade082407.pdf

Here is a collection of resources on migration to V8, DB2 9, and DB2 10: presentations, papers, ...
ftp://ftp.software.ibm.com/software/data/db2/zos/presentations/migration/

Google DB2 for z/OS Version 8 migration for many thousands more

Roger Miller, DB2 for z/OS

Hi All,

Thanks again for all these hints for migration. I have a small request. Can I request the esteemed listers to send across a migration plan document (migration from DB2 V7 to DB2 V8).Basically I would like to know about the technical issues that were faced during the migration through NFM and their solution , so that we could be well prepared to take on the migration .

If there are any such migration plans documents / best practices , request to please guide me through those links.

Thanks all,
Anil.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv