Db2 12 FL100 V12R1M100 (CM that was)

Aurora Emanuela Dellanno

Db2 12 FL100 V12R1M100 (CM that was)

Hey all,

 

happy new year, we're off to a good start are we not.

 

Supposing the world has not disappeared with a bang and a puff of smoke, we are planning to start our Db2 12 upgrade in the next couple of weeks, and have been discussing how long to keep at FL100 before going forward - what's the word out there please?

 

We could really use some advice and input.

 

Thanks.

 

Aurora

Phil Grainger

Db2 12 FL100 V12R1M100 (CM that was)
(in response to Aurora Emanuela Dellanno)
Hi Aurora

I'm not sure there IS a single/simple answer

As FL100 is the ONLY place you can move back to Db2 11 from, the decision should be based on your (perceived) need to fall back from Db2 12

In other words, how long does it take to feel comfortable enough with Db2 12 to not EVER want to go back to Db2 11. Then (and only then) should you move away from FL100

Phil G

(Happily Retired, so the New Year IS a happy one :) )

On 13/01/2020 10:07, Aurora Emanuela Dellanno wrote:

Hey all,



happy new year, we're off to a good start are we not.



Supposing the world has not disappeared with a bang and a puff of smoke, we are planning to start our Db2 12 upgrade in the next couple of weeks, and have been discussing how long to keep at FL100 before going forward - what's the word out there please?



We could really use some advice and input.



Thanks.



Aurora

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

Aurora Emanuela Dellanno

Db2 12 FL100 V12R1M100 (CM that was)
(in response to Phil Grainger)
Hey Phil,

happy new year both to you and Nikki!

I am asking because I remember reading or hearing somewhere that FL100 is
in fact not like CM as in users should stay there for the shortest possible
time.

I know it's the how long is a piece of string question, I was just trying
to see if there are any users who did stay there for quite a while, or
whether they had issues doing it.

When are you off to chase comets?

On Mon, 13 Jan 2020 at 11:51, Phil Grainger <[login to unmask email]> wrote:

> Hi Aurora
>
> I'm not sure there IS a single/simple answer
>
> As FL100 is the ONLY place you can move back to Db2 11 from, the decision
> should be based on your (perceived) need to fall back from Db2 12
>
> In other words, how long does it take to feel comfortable enough with Db2
> 12 to not EVER want to go back to Db2 11. Then (and only then) should you
> move away from FL100
>
> Phil G
>
> (Happily Retired, so the New Year IS a happy one :) )
> On 13/01/2020 10:07, Aurora Emanuela Dellanno wrote:
>
> Hey all,
>
>
>
> happy new year, we're off to a good start are we not.
>
>
>
> Supposing the world has not disappeared with a bang and a puff of smoke,
> we are planning to start our Db2 12 upgrade in the next couple of weeks,
> and have been discussing how long to keep at FL100 before going forward -
> what's the word out there please?
>
>
>
> We could really use some advice and input.
>
>
>
> Thanks.
>
>
>
> Aurora
>
> -----End Original Message-----
>
>
> -----End Original Message-----
>

Chris Hoelscher

Db2 12 FL100 V12R1M100 (CM that was)
(in response to Aurora Emanuela Dellanno)
Our plan is:

Get thru a month-end and possibly quarter-end in fm100 to expose our subsystems to as many program and volume scenerios as feasible
Fm100 – march and april
Fm500+ - july and August
Current RSU - september



Thank You,
Chris Hoelscher| Lead Database Administrator | IBM Global Technical Services| T 502.476.2538 or 502.407.7266

From: [login to unmask email] <[login to unmask email]>
Sent: Monday, January 13, 2020 6:12 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 FL100 V12R1M100 (CM that was)

Hey Phil,

happy new year both to you and Nikki!

I am asking because I remember reading or hearing somewhere that FL100 is in fact not like CM as in users should stay there for the shortest possible time.

I know it's the how long is a piece of string question, I was just trying to see if there are any users who did stay there for quite a while, or whether they had issues doing it.

When are you off to chase comets?

On Mon, 13 Jan 2020 at 11:51, Phil Grainger <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Hi Aurora

I'm not sure there IS a single/simple answer

As FL100 is the ONLY place you can move back to Db2 11 from, the decision should be based on your (perceived) need to fall back from Db2 12

In other words, how long does it take to feel comfortable enough with Db2 12 to not EVER want to go back to Db2 11. Then (and only then) should you move away from FL100

Phil G

(Happily Retired, so the New Year IS a happy one :) )
On 13/01/2020 10:07, Aurora Emanuela Dellanno wrote:

Hey all,



happy new year, we're off to a good start are we not.



Supposing the world has not disappeared with a bang and a puff of smoke, we are planning to start our Db2 12 upgrade in the next couple of weeks, and have been discussing how long to keep at FL100 before going forward - what's the word out there please?



We could really use some advice and input.



Thanks.



Aurora

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

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

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.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.

Michael Hannan

RE: Db2 12 FL100 V12R1M100 (CM that was)
(in response to Phil Grainger)

In Reply to Phil Grainger:

Hi Aurora

I'm not sure there IS a single/simple answer

As FL100 is the ONLY place you can move back to Db2 11 from, the decision should be based on your (perceived) need to fall back from Db2 12

In other words, how long does it take to feel comfortable enough with Db2 12 to not EVER want to go back to Db2 11. Then (and only then) should you move away from FL100

I like Phil's and Chris' answer. There is no need to go to 500 (NFM) in a big rush especially in production, even if some of us are very keen to try new functions. Your applications should not need new function desperately, in general. You get some very good performance improvements and new access paths possible in FL100.

Sites that want to try Db2AI with Machine Learning will need to progress, but again no rush. Its pretty new stuff, so try things in a sandbox environment first.

Just keep a good balance between safety for use of new function and having your site get too far behind. New Function for V11 still has faults or weaknesses being found for functions not widely used. New Function comes with faults in obscure scenarios that IBM did not think of to test. Maybe leave that most of that discovery to Beta-test and Gung Ho sites.

FL500 may be very reliable if you don't actually use any of the obscure new functions outside what every site has been using. I am not expert on that aspect. Haven't checked all the PTFs. Still I don't see a  requirement to rush to it.

If sites are desperate for 7 byte RIDs with huge tables, they may want to get there soon. Insert Algorithm 2 for Insert contention might be FL500. There are a few sexy SQL things, like new ways to code scroll reposition predicates succinctly, and advanced triggers.

So consider is there actually any reason why you need FL500 or later in a hurry. Each site is different. V11 has not reached end of service I think.

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

Russell Peters

RE: Db2 12 FL100 V12R1M100 (CM that was)
(in response to Aurora Emanuela Dellanno)

I agree with the other responses: stay at FL100 at least through a month-end process. I think we were at FL100 for about two months. The only new function we have used so far is the piece wise delete which helped a lot in a couple situations. By the way, we've been at FL500 since the end of July last year. I'm looking to move to FL502 sometime within the next couple months mainly just to try to keep from getting too far behind. There's a catmaint at FL502 so we'll stop there for a while.

Jorg Lueke

RE: Db2 12 FL100 V12R1M100 (CM that was)
(in response to Aurora Emanuela Dellanno)

There is no reason to rush FL500+. But Db2 really like to be on current maintenance so if you are on FL100 for 3-6 months you may want to consider maintenance before going to FL500 

Aurora Emanuela Dellanno

RE: Db2 12 FL100 V12R1M100 (CM that was)
(in response to Aurora Emanuela Dellanno)

thanks Chris, Michael, Russel and Jorg for your input.

 

I'll make my question a little more specific - are there any ideas AGAINST staying a long time in FL100 before we move to a higher level (with all the necessary maintenance, of course)?

 

We are actually planning to sit on FL100 for a bit.

 

And I'll add another question: who has had to fall back to 11 from FL100, and why?

 

Thanks again.

 

Aurora

 

Andy Smith

RE: Db2 12 FL100 V12R1M100 (CM that was)
(in response to Aurora Emanuela Dellanno)

Aurora

Before you Activate FL500 can I recommend that you have a read of PI86123 and consider whether you might be exposed to the -904 situation which is mentioned.....

Regards
Andy

Chris Hoelscher

Db2 12 FL100 V12R1M100 (CM that was)
(in response to Aurora Emanuela Dellanno)
Why to NOT sit on FL100? Overanxious DBAS/developers that want to exploit new features

Why to fall back to V11? – to prove that we can (seriously – part of our migration plan is to revert and re-migrate at each step)

Thank You,
Chris Hoelscher| Lead Database Administrator | IBM Global Technical Services| T 502.476.2538 or 502.407.7266

From: Aurora Emanuela Dellanno <[login to unmask email]>
Sent: Wednesday, January 15, 2020 5:07 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 FL100 V12R1M100 (CM that was)


thanks Chris, Michael, Russel and Jorg for your input.



I'll make my question a little more specific - are there any ideas AGAINST staying a long time in FL100 before we move to a higher level (with all the necessary maintenance, of course)?



We are actually planning to sit on FL100 for a bit.



And I'll add another question: who has had to fall back to 11 from FL100, and why?



Thanks again.



Aurora



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

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.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.

Philip Sevetson

Db2 12 FL100 V12R1M100 (CM that was)
(in response to Chris Hoelscher)
Chris,

Are they reverting _production_ as a _test_? What’s the contingency plan if that doesn’t work?

-phil s.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

From: Chris Hoelscher <[login to unmask email]>
Sent: Wednesday, January 15, 2020 8:08 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 FL100 V12R1M100 (CM that was)

Why to NOT sit on FL100? Overanxious DBAS/developers that want to exploit new features

Why to fall back to V11? – to prove that we can (seriously – part of our migration plan is to revert and re-migrate at each step)

Thank You,
Chris Hoelscher| Lead Database Administrator | IBM Global Technical Services| T 502.476.2538 or 502.407.7266

From: Aurora Emanuela Dellanno <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Wednesday, January 15, 2020 5:07 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 FL100 V12R1M100 (CM that was)


thanks Chris, Michael, Russel and Jorg for your input.



I'll make my question a little more specific - are there any ideas AGAINST staying a long time in FL100 before we move to a higher level (with all the necessary maintenance, of course)?



We are actually planning to sit on FL100 for a bit.



And I'll add another question: who has had to fall back to 11 from FL100, and why?



Thanks again.



Aurora



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

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.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)

Chris Hoelscher

Db2 12 FL100 V12R1M100 (CM that was)
(in response to Philip Sevetson)
No – at this point we would be reverting a sandbox and a testing environment – our change approval board requires proof that we can (and have) reverted via a published plan – so that we COULD immediately revert production if the need arose (not wasting time building the JCL on the fly)

Thank You,
Chris Hoelscher| Lead Database Administrator | IBM Global Technical Services| T 502.476.2538 or 502.407.7266

From: Sevetson, Phil <[login to unmask email]>
Sent: Wednesday, January 15, 2020 8:56 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 FL100 V12R1M100 (CM that was)

Chris,

Are they reverting _production_ as a _test_? What’s the contingency plan if that doesn’t work?

-phil s.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

From: Chris Hoelscher <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Wednesday, January 15, 2020 8:08 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 FL100 V12R1M100 (CM that was)

Why to NOT sit on FL100? Overanxious DBAS/developers that want to exploit new features

Why to fall back to V11? – to prove that we can (seriously – part of our migration plan is to revert and re-migrate at each step)

Thank You,
Chris Hoelscher| Lead Database Administrator | IBM Global Technical Services| T 502.476.2538 or 502.407.7266

From: Aurora Emanuela Dellanno <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Wednesday, January 15, 2020 5:07 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 FL100 V12R1M100 (CM that was)


thanks Chris, Michael, Russel and Jorg for your input.



I'll make my question a little more specific - are there any ideas AGAINST staying a long time in FL100 before we move to a higher level (with all the necessary maintenance, of course)?



We are actually planning to sit on FL100 for a bit.



And I'll add another question: who has had to fall back to 11 from FL100, and why?



Thanks again.



Aurora



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

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.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----

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.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.

Philip Sevetson

Db2 12 FL100 V12R1M100 (CM that was)
(in response to Chris Hoelscher)
Even though it’s not my shop, that’s a great relief.

-phil s.

From: Chris Hoelscher <[login to unmask email]>
Sent: Wednesday, January 15, 2020 9:03 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 FL100 V12R1M100 (CM that was)

No – at this point we would be reverting a sandbox and a testing environment – our change approval board requires proof that we can (and have) reverted via a published plan – so that we COULD immediately revert production if the need arose (not wasting time building the JCL on the fly)

Thank You,
Chris Hoelscher| Lead Database Administrator | IBM Global Technical Services| T 502.476.2538 or 502.407.7266

From: Sevetson, Phil <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Wednesday, January 15, 2020 8:56 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 FL100 V12R1M100 (CM that was)

Chris,

Are they reverting _production_ as a _test_? What’s the contingency plan if that doesn’t work?

-phil s.


Philip Sevetson
Computer Systems Manager
FISA-OPA
5 Manhattan West
New York, NY 10001
[login to unmask email]<mailto:[login to unmask email]>
212-857-1688 w
917-991-7052 m
212-857-1659 f
[cid:[login to unmask email]

From: Chris Hoelscher <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Wednesday, January 15, 2020 8:08 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 FL100 V12R1M100 (CM that was)

Why to NOT sit on FL100? Overanxious DBAS/developers that want to exploit new features

Why to fall back to V11? – to prove that we can (seriously – part of our migration plan is to revert and re-migrate at each step)

Thank You,
Chris Hoelscher| Lead Database Administrator | IBM Global Technical Services| T 502.476.2538 or 502.407.7266

From: Aurora Emanuela Dellanno <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Wednesday, January 15, 2020 5:07 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: Db2 12 FL100 V12R1M100 (CM that was)


thanks Chris, Michael, Russel and Jorg for your input.



I'll make my question a little more specific - are there any ideas AGAINST staying a long time in FL100 before we move to a higher level (with all the necessary maintenance, of course)?



We are actually planning to sit on FL100 for a bit.



And I'll add another question: who has had to fall back to 11 from FL100, and why?



Thanks again.



Aurora



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

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.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----

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.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**

Jorg Lueke

RE: Db2 12 FL100 V12R1M100 (CM that was)
(in response to Aurora Emanuela Dellanno)

Not really. I had a couple that sat 9-12 months. The one draw back would be if you are paying someone else to do the whole migration and staying on FL100 extends the project and the cost. Otherwise there's no hurry depending on your thirst for the new features some of which are pretty nice.
 
In Reply to Aurora Emanuela Dellanno:

thanks Chris, Michael, Russel and Jorg for your input.

 

I'll make my question a little more specific - are there any ideas AGAINST staying a long time in FL100 before we move to a higher level (with all the necessary maintenance, of course)?

 

We are actually planning to sit on FL100 for a bit.

 

And I'll add another question: who has had to fall back to 11 from FL100, and why?

 

Thanks again.

 

Aurora

 

Russell Peters

RE: Db2 12 FL100 V12R1M100 (CM that was)
(in response to Chris Hoelscher)

Same here as Chris. I reverted a sandbox just to prove we could. We also have a replicated DR box that we can use for testing at times and I migrated our prod system on that box to FL100, reverted, and remigrated.

Shay Miller

RE: Db2 12 FL100 V12R1M100 (CM that was)
(in response to Russell Peters)

My two cents:

1. As stated before, there is no need to rush into FL500 (formerly known as NFM).

at my shop we also try to do at least one monthly batch cycle and one quarterly cycle in a new version (CM or FL 100) before moving on.

in V11, the move to NFM in production was exactly 13 months after the move to CM so we even tested our yearly workload :-)

2. we also do a migrate-fallback-re migrate on at least a sandbox environment.

    we use db2 cloning tool quite a lot so we have a clone of our sandbox system as well.
    we upgrade the sandbox-source, clone it, fallback, clone again, re migrate, clone again.
   
     this serves 2 goals: 

     a. if something goes wrong in the fallback process or after,
         then you just restore the subsystem again from the source (re-clone), no harm done.

      b. this is also a check for the clone product to see if everything is done ok, 

 

3. Even if you move to FL 500+, there is still more steps you need to do to use the new syntax (pre-compiler settings, applcompat zparm and bind options), so the move is even more gradual.

 

Regards,

Shay

Mark Vickers

Db2 12 FL100 V12R1M100 (CM that was)
(in response to Shay Miller)
Hi Shay,
Sounds like you have insight into a good cloning tool.

We are on DB2 z/OS v10.1 CM8* (did the skip level migration from 8 to 10)

Now looking to upgrade or do a fresh install of v12 and possibly use a cloning tool like BCV5.
We have < 1.5 TB of user data and the vendor seems positive we can do that in under an hour.

This is unchartered waters for our systems folks, and I am nervous about this approach.

Your thoughts would be appreciated.

From: Shay Miller [mailto:[login to unmask email]
Sent: Sunday, February 02, 2020 10:28 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 12 FL100 V12R1M100 (CM that was)


My two cents:

1. As stated before, there is no need to rush into FL500 (formerly known as NFM).

at my shop we also try to do at least one monthly batch cycle and one quarterly cycle in a new version (CM or FL 100) before moving on.

in V11, the move to NFM in production was exactly 13 months after the move to CM so we even tested our yearly workload :-)

2. we also do a migrate-fallback-re migrate on at least a sandbox environment.

we use db2 cloning tool quite a lot so we have a clone of our sandbox system as well.
we upgrade the sandbox-source, clone it, fallback, clone again, re migrate, clone again.

this serves 2 goals:

a. if something goes wrong in the fallback process or after,
then you just restore the subsystem again from the source (re-clone), no harm done.

b. this is also a check for the clone product to see if everything is done ok,



3. Even if you move to FL 500+, there is still more steps you need to do to use the new syntax (pre-compiler settings, applcompat zparm and bind options), so the move is even more gradual.



Regards,

Shay

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

Aurora Emanuela Dellanno

RE: Db2 12 FL100 V12R1M100 (CM that was)
(in response to Aurora Emanuela Dellanno)

just to say, thanks again to all who are taking time to pour their suggestions into this thread - I am keeping an eye on it :)