Migrating to DB2 v12 with SAP

Steven Lamb

Migrating to DB2 v12 with SAP

For the SAP users amonst us!

If you're running SAP and have migrated to DB2 v12, how did you deal with the FL100 /FL50x issue?

Did you stay at FL100 for a period in production or go straight to FL50x? The various sets of documentaion seem to differ slightly, in that some say go straight to an approved function level and others say to stop at FL100 and perform some testing before committing yourself.

 

Our application people are getting jittery at the thought of going all the way in one big bang, even though we went straight to NFM in v11. APPLCOMPAT will be set at M500 once we go to FL50x.

 

Regards,

Steve

Chris Hoelscher

Migrating to DB2 v12 with SAP
(in response to Steven Lamb)
>> perform some testing before committing yourself.

Believe me I did plenty of testing before committing myself …
The judge concurred …..

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

From: Steven Lamb <[login to unmask email]>
Sent: Tuesday, September 10, 2019 10:46 AM
To: [login to unmask email]
Subject: [DB2-L] - Migrating to DB2 v12 with SAP


For the SAP users amonst us!

If you're running SAP and have migrated to DB2 v12, how did you deal with the FL100 /FL50x issue?

Did you stay at FL100 for a period in production or go straight to FL50x? The various sets of documentaion seem to differ slightly, in that some say go straight to an approved function level and others say to stop at FL100 and perform some testing before committing yourself.



Our application people are getting jittery at the thought of going all the way in one big bang, even though we went straight to NFM in v11. APPLCOMPAT will be set at M500 once we go to FL50x.



Regards,

Steve

-----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)번으로 전화해 주십시오.

Javier Estrada Benavides

RE: Migrating to DB2 v12 with SAP
(in response to Chris Hoelscher)

Hey

   I recently talked to a few guys on that situation who successfully migrated with SAP + Db2 12. They did some testing on M100 but not for a long period of time, and then decided to stay in M500 and not to go beyond that. What they told me is this:

APPLCOMPAT zPARM: 500 always

APPLCOMPAT Bind option: same, 500 always

Function Level: Stay in 500

Catalog Level: Also stay in 500

Code level: Keep upgrading, but their environment doesn't allow for that many upgrades in a short period of time, so who knows..

JDBC NULLID Collection APPLCOMPAT: Stay in V11 and didn't rebind at all

 

Have a great day :)

 

 

Javier Estrada Benavides, Czech Republic / Mexico

IBM Champion for Analytics

IBM Certified System Administrator - Db2 12 for z/OS

IBM Db2 12 DBA for z/OS - 2018 (the ugly brown badge from IBM Open Badge Program)

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Database Administrator - DB2 11 DBA for z/OS

Andy Smith

RE: Migrating to DB2 v12 with SAP
(in response to Javier Estrada Benavides)

For NULLID and APPLCOMPAT I recommend reading:

Chris Crone blog:

https://www.idug.org/p/bl/et/blogaid=806

 

Paul McWilliams blog:
https://www.ibm.com/developerworks/community/blogs/897a7c98-57af-4523-9cfa-07ebc3f996b4/entry/Simplified_Db2_12_function_level_migration_for_IBM_Data_Server_Driver_applications?lang=en

 

Also, you might want to follow PH11251 & PH15092 

Roy Boxwell

Migrating to DB2 v12 with SAP
(in response to Javier Estrada Benavides)
Then you never move to Db2 12 with dynamic SQL at all... I would reconsider the NULLID decision...



Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: <mailto:[login to unmask email]> [login to unmask email]
Web http://www.seg.de http://www.seg.de

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


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



From: Javier Estrada Benavides [mailto:[login to unmask email]
Sent: Wednesday, September 11, 2019 8:55 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Migrating to DB2 v12 with SAP



Hey

I recently talked to a few guys on that situation who successfully migrated with SAP + Db2 12. They did some testing on M100 but not for a long period of time, and then decided to stay in M500 and not to go beyond that. What they told me is this:

APPLCOMPAT zPARM: 500 always

APPLCOMPAT Bind option: same, 500 always

Function Level: Stay in 500

Catalog Level: Also stay in 500

Code level: Keep upgrading, but their environment doesn't allow for that many upgrades in a short period of time, so who knows..

JDBC NULLID Collection APPLCOMPAT: Stay in V11 and didn't rebind at all



Have a great day :)





Javier Estrada Benavides, Czech Republic / Mexico

IBM Champion for Analytics

IBM Certified System Administrator - Db2 12 for z/OS

IBM Db2 12 DBA for z/OS - 2018 (the ugly brown badge from IBM Open Badge Program)

IBM Certified System Administrator - DB2 11 for z/OS

IBM Certified Database Administrator - DB2 11 DBA for z/OS



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

Attachments

  • smime.p7s (5.1k)

Steven Lamb

RE: Migrating to DB2 v12 with SAP
(in response to Roy Boxwell)

Chris - did you come across anything major in your testing?

 

The APPLCOMPAT value to use is "determined" by the level of SAP Netweaver software in use, so for us it WILL be 500 at the moment. There's a config file on the servers that run the application software that is set to contain this value.

The application doesn't use the NULLID collection, but one with a name based on the levels of DB2 Connect software and APPLCOMPAT.

 

The SAP documentation suggests going to higher Function Levels (and therefore Catalog Levels) once they're available and certified, rather than staying at 500. Most of the features introduced by these are controllable via ZPARMs or APPLCOMPAT changes, so can efectively be disabled until required.

 

Regards,
Steve