V8.1 Z/os CM- how long NFM in non-prod before going NFM in prod ???

Chris Hoelscher

V8.1 Z/os CM- how long NFM in non-prod before going NFM in prod ???

good afternoon all

I know there is no right or wrong answer - but just trying to get a feel of
what others have done - how long did you stay in NFM in non-production
subsystems before going NFM in production? did anyone go NFM in production
first? (sounds intriguing but i do not think it would fly)

thanks again,

Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
[login to unmask email]



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.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Avram Friedman

Re: V8.1 Z/os CM- how long NFM in non-prod before going NFM in prod ???
(in response to Chris Hoelscher)
Both shops where I did this migration the time between NFM in test to NFM in
prod was under 1 month.

There is not much of an opertunity to drag this out. When Test and
Production are mismatched it invalidates your ability to do development,
maintance, adjustments and studies.

Calls about application roll outs failing because the test system does not
match production are no fun at all.

Best Wishes
Avram Friedman

On Wed, 16 Jan 2008 13:46:26 -0500, Chris Hoelscher
<[login to unmask email]> wrote:

>
>good afternoon all
>
>I know there is no right or wrong answer - but just trying to get a feel of
>what others have done - how long did you stay in NFM in non-production
>subsystems before going NFM in production? did anyone go NFM in production
>first? (sounds intriguing but i do not think it would fly)
>
>thanks again,
>
>Chris Hoelscher
>Senior IDMS & DB2 Database Administrator
>Humana Inc
>502-476-2538
>[login to unmask email]
>
>
>
>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.
>
>The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug
under the Listserv tab. While at the site, you can also access the IDUG
Online Learning Center, Tech Library and Code Place, see the latest IDUG
conference information, and much more. If you have not yet signed up for
Basic Membership in IDUG, available at no cost, click on Member Services at
http://www.idug.org/lsms
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Stephen Vagnier

Re: V8.1 Z/os CM- how long NFM in non-prod before going NFM in prod ???
(in response to Avram Friedman)
Hi Chris,
to minimize the chance that the applications groups
would start coding new features of NFM in development and try porting them
to production in compatibility mode,
I spent one week between upgrading the next
environment to NFM; assuming there were no problems. The decision really
comes down to a comfort level.
I considered going to NFM in production first; but
management thought it was too risky.

Also, please check APAR PK59305 to see if PTF UK31192
is applied in your environment. UK31192 went PE on us while trying to run
DSNTIJNE.
Very painful for us, but we got the problem resolved with a
usermod from IBM support.


Regards,

****************************************
Steve Vagnier
American Electric Power
One Riverside Plaza - 7th Floor
Columbus, Ohio 43215
Email: [login to unmask email]
Phone: 614-716-3677
Audinet: 200-3677




Chris Hoelscher <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
01/16/2008 01:46 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
[DB2-L] V8.1 Z/os CM- how long NFM in non-prod before going NFM in prod
???






good afternoon all

I know there is no right or wrong answer - but just trying to get a feel
of what others have done - how long did you stay in NFM in non-production
subsystems before going NFM in production? did anyone go NFM in production
first? (sounds intriguing but i do not think it would fly)

thanks again,

Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
[login to unmask email]



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.
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org under
the Listserv tab. While at the site, you can also access the IDUG Online
Learning Center, Tech Library and Code Place, see the latest IDUG
conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Jorg Lueke

Re: V8.1 Z/os CM- how long NFM in non-prod before going NFM in prod ???
(in response to Stephen Vagnier)
We did 2-3 weeks

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Myron Miller

Re: V8.1 Z/os CM- how long NFM in non-prod before going NFM in prod ???
(in response to Jorg Lueke)
We spent the first time about a month from test to production for NFM. But we
had to backout entirely that implementation due to serious problems with DB2
base code. (actually ended up backing out twice due to various serious
issues.)

Myron
--- Avram Friedman <[login to unmask email]> wrote:

> Both shops where I did this migration the time between NFM in test to NFM in
> prod was under 1 month.
>
> There is not much of an opertunity to drag this out. When Test and
> Production are mismatched it invalidates your ability to do development,
> maintance, adjustments and studies.
>
> Calls about application roll outs failing because the test system does not
> match production are no fun at all.
>
> Best Wishes
> Avram Friedman
>
> On Wed, 16 Jan 2008 13:46:26 -0500, Chris Hoelscher
> <[login to unmask email]> wrote:
>
> >
> >good afternoon all
> >
> >I know there is no right or wrong answer - but just trying to get a feel of
> >what others have done - how long did you stay in NFM in non-production
> >subsystems before going NFM in production? did anyone go NFM in production
> >first? (sounds intriguing but i do not think it would fly)
> >
> >thanks again,
> >
> >Chris Hoelscher
> >Senior IDMS & DB2 Database Administrator
> >Humana Inc
> >502-476-2538
> >[login to unmask email]
> >
> >
> >
> >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.
> >
> >The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
>
> archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug
>
> under the Listserv tab. While at the site, you can also access the IDUG
> Online Learning Center, Tech Library and Code Place, see the latest IDUG
> conference information, and much more. If you have not yet signed up for
> Basic Membership in IDUG, available at no cost, click on Member Services at
> http://www.idug.org/lsms
> >
>
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
> archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug
> under the Listserv tab. While at the site, you can also access the IDUG
> Online Learning Center, Tech Library and Code Place, see the latest IDUG
> conference information, and much more. If you have not yet signed up for
> Basic Membership in IDUG, available at no cost, click on Member Services at
> http://www.idug.org/lsms
>

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Raymond Bell

Re: V8.1 Z/os CM- how long NFM in non-prod before going NFM in prod ???
(in response to Myron Miller)
Ah, what's wrong with ya? Suck it up! What's the worst that could
happen... er, good point.

Actually I wouldn't suggest going NFM in Prod first. It would be 2nd;
the first would be your playpen subsystem just to practice the task.
But Mr. Sevetson was right, my 'wait til you're happy' nonsense was more
appropriate to sitting in CM, less so for ENFM. If it were me (and it
isn't anymore, so what do I know?) I'd go CM everywhere in traditional
order (play, dev, QA, Prod), wait 'a bit', then ENFM everywhere (play,
dev, QA, Prod), then switch to NFM (play, prod, QA, dev), with about 10
seconds between ENFM and NFM on Prod i.e. when you go to ENFM for Prod,
go all the way in one hit. Having managed to turn it on in play first
at some stage.

Just an idea, like you say maybe not right or wrong, just perhaps not
right for everyone.

Have fun,


Raymond
PS. Hmmm... Rich Text by mistook. Will it work?

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Chris Hoelscher
Sent: 16 January 2008 18:46
To: [login to unmask email]
Subject: [DB2-L] V8.1 Z/os CM- how long NFM in non-prod before going NFM
in prod ???

good afternoon all

I know there is no right or wrong answer - but just trying to get a feel
of what others have done - how long did you stay in NFM in
non-production subsystems before going NFM in production? did anyone go
NFM in production first? (sounds intriguing but i do not think it would
fly)

thanks again,

Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
[login to unmask email]



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.
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Raymond Bell

Re: V8.1 Z/os CM- how long NFM in non-prod before going NFM in prod ???
(in response to Raymond Bell)
Ah, what's wrong with ya? Suck it up! What's the worst that could
happen... er, good point.

Actually I wouldn't suggest going NFM in Prod first. It would be 2nd;
the first would be your playpen subsystem just to practice the task.
But Mr. Sevetson was right, my 'wait til you're happy' nonsense was more
appropriate to sitting in CM, less so for ENFM. If it were me (and it
isn't anymore, so what do I know?) I'd go CM everywhere in traditional
order (play, dev, QA, Prod), wait 'a bit', then ENFM everywhere (play,
dev, QA, Prod), then switch to NFM (play, prod, QA, dev), with about 10
seconds between ENFM and NFM on Prod i.e. when you go to ENFM for Prod,
go all the way in one hit. Having managed to turn it on in play first
at some stage.

Just an idea, like you say maybe not right or wrong, just perhaps not
right for everyone.

Have fun,


Raymond
PS. Hmmm... Rich Text by mistook. Will it work?

________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Chris Hoelscher
Sent: 16 January 2008 18:46
To: [login to unmask email]
Subject: [DB2-L] V8.1 Z/os CM- how long NFM in non-prod before going NFM
in prod ???

good afternoon all

I know there is no right or wrong answer - but just trying to get a feel
of what others have done - how long did you stay in NFM in
non-production subsystems before going NFM in production? did anyone go
NFM in production first? (sounds intriguing but i do not think it would
fly)

thanks again,

Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
[login to unmask email]



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.
The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at www.idug.org
< http://www.idug.org/lsidug > under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information
< http://www.idug.org/lsconf > , and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services < http://www.idug.org/lsms >

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Jorg Lueke

Re: V8.1 Z/os CM- how long NFM in non-prod before going NFM in prod ???
(in response to Raymond Bell)
We had to back out the very first effort to go V8 CM mode because there
were too many distributed threads that ended up eating up all the storage.
After that the CM mode went fine.

The biggest issue we've had in NFM is that some access paths negatively
changed and could only be restored with correlated statistics. Since neither
the vendors nor IBM supports inline correlated stats in load jobs this has
created a bit more of a headache around runstats than I would like.

On Wed, 16 Jan 2008 16:02:28 -0800, Myron Miller
<[login to unmask email]> wrote:

>We spent the first time about a month from test to production for NFM. But
we
>had to backout entirely that implementation due to serious problems with DB2
>base code. (actually ended up backing out twice due to various serious
>issues.)
>
>Myron
>--- Avram Friedman <[login to unmask email]> wrote:
>
>> Both shops where I did this migration the time between NFM in test to NFM
in
>> prod was under 1 month.
>>
>> There is not much of an opertunity to drag this out. When Test and
>> Production are mismatched it invalidates your ability to do development,
>> maintance, adjustments and studies.
>>
>> Calls about application roll outs failing because the test system does not
>> match production are no fun at all.
>>
>> Best Wishes
>> Avram Friedman
>>
>> On Wed, 16 Jan 2008 13:46:26 -0500, Chris Hoelscher
>> <[login to unmask email]> wrote:
>>
>> >
>> >good afternoon all
>> >
>> >I know there is no right or wrong answer - but just trying to get a feel of
>> >what others have done - how long did you stay in NFM in non-production
>> >subsystems before going NFM in production? did anyone go NFM in
production
>> >first? (sounds intriguing but i do not think it would fly)
>> >
>> >thanks again,
>> >
>> >Chris Hoelscher
>> >Senior IDMS & DB2 Database Administrator
>> >Humana Inc
>> >502-476-2538
>> >[login to unmask email]
>> >
>> >
>> >
>> >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.
>> >
>> >The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list
>>
>> archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug
>>
>> under the Listserv tab. While at the site, you can also access the IDUG
>> Online Learning Center, Tech Library and Code Place, see the latest IDUG
>> conference information, and much more. If you have not yet signed up for
>> Basic Membership in IDUG, available at no cost, click on Member Services at
>> http://www.idug.org/lsms
>> >
>>
>> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
>> archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug
>> under the Listserv tab. While at the site, you can also access the IDUG
>> Online Learning Center, Tech Library and Code Place, see the latest IDUG
>> conference information, and much more. If you have not yet signed up for
>> Basic Membership in IDUG, available at no cost, click on Member Services at
>> http://www.idug.org/lsms
>>
>
>The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list
archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug
under the Listserv tab. While at the site, you can also access the IDUG Online
Learning Center, Tech Library and Code Place, see the latest IDUG conference
information, and much more. If you have not yet signed up for Basic
Membership in IDUG, available at no cost, click on Member Services at
http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Troy Coleman

Re: V8.1 Z/os CM- how long NFM in non-prod before going NFM in prod ???
(in response to Jorg Lueke)
I love your answer Raymond... I would do it the same way..
Is it Friday yet?

Ah in India it is. I'm on the phone with India support for Magellan as
I'm typing this and waiting and waiting...
The young lady tells me she is used to working all night. It is about
4:00am Friday for her and it is 4:00pm Thursday for me.

Cheers!
Troy Coleman

Bell, Raymond wrote:
>
> Ah, what’s wrong with ya? Suck it up! What’s the worst that could
> happen… er, good point.
>
> Actually I wouldn’t suggest going NFM in Prod first. It would be 2^nd
> ; the first would be your playpen subsystem just to practice the task.
> But Mr. Sevetson was right, my ‘wait til you’re happy’ nonsense was
> more appropriate to sitting in CM, less so for ENFM. If it were me
> (and it isn’t anymore, so what do I know?) I’d go CM everywhere in
> traditional order (play, dev, QA, Prod), wait ‘a bit’, then ENFM
> everywhere (play, dev, QA, Prod), then switch to NFM (play, prod, QA,
> dev), with about 10 seconds between ENFM and NFM on Prod i.e. when you
> go to ENFM for Prod, go all the way in one hit. Having managed to turn
> it on in play first at some stage.
>
> Just an idea, like you say maybe not right or wrong, just perhaps not
> right for everyone.
>
> Have fun,
>
> Raymond
>
> PS. Hmmm… Rich Text by mistook. Will it work?
>
> ------------------------------------------------------------------------
>
> *From:* DB2 Data Base Discussion List [mailto:[login to unmask email] *On
> Behalf Of *Chris Hoelscher
> *Sent:* 16 January 2008 18:46
> *To:* [login to unmask email]
> *Subject:* [DB2-L] V8.1 Z/os CM- how long NFM in non-prod before going
> NFM in prod ???
>
> good afternoon all
>
> I know there is no right or wrong answer - but just trying to get a
> feel of what others have done - how long did you stay in NFM in
> non-production subsystems before going NFM in production? did anyone
> go NFM in production first? (sounds intriguing but i do not think it
> would fly)
>
> thanks again,
>
> Chris Hoelscher
> Senior IDMS & DB2 Database Administrator
> Humana Inc
> 502-476-2538
> [login to unmask email]
>
>
> 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.
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list archives, the FAQ, and delivery preferences are at _ www.idug.org
> < http://www.idug.org/lsidug > _ under the Listserv tab. While at the
> site, you can also access the IDUG Online Learning Center, Tech
> Library and Code Place, see the latest _ IDUG conference information
> <%20 http://www.idug.org/lsconf > _, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available
> at no cost, click on _ Member Services <%20 http://www.idug.org/lsms > _
> The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
> list archives, the FAQ, and delivery preferences are at _ www.idug.org
> < http://www.idug.org/lsidug > _ under the Listserv tab. While at the
> site, you can also access the IDUG Online Learning Center, Tech
> Library and Code Place, see the latest _ IDUG conference information
> <%20 http://www.idug.org/lsconf > _, and much more.
> If you have not yet signed up for Basic Membership in IDUG, available
> at no cost, click on _ Member Services <%20 http://www.idug.org/lsms > _

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms