RFE for Db2 12 APPLCOMPAT

Roy Boxwell

RFE for Db2 12 APPLCOMPAT
Hi all!

I have another RFE that I think is really really really important:

116854 Allow REBIND of in-use Dynamic SQL Packages

The background is that in Db2 12 the complete introduction of Function Levels (FL) has been done at the package level and any SQL within that package *cannot* execute any FL above the level it was bound in. So far so good. Now think about all the dynamic SQL packages you all have in your shops. All the SYSSH, SYSSN, SYSLH and SYSLN style ones or even just Spufi! The same rule holds here so when you upgrade to FL501 you must rebind all the dynamic SQL packages to enable usage...this is nearly impossible these days... Then you could use a new Collection is the answer... except what if you have NULLID ? Then you must edit all the CLI.INI files and this could be 1000's !

My idea here is that these "empty shell" Packages should just be allowed to be rebound whenever we like - There is no need to stop their usage and then we can happily change FL levels really on-the-fly and actually be agile for a change!

If you agree - please go and vote!


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: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de http://www.seg.de

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

Roy Boxwell

RFE for Db2 12 APPLCOMPAT
(in response to Roy Boxwell)
And here is the url that I just forgot to paste...


http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=116854




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: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de http://www.seg.de

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

From: Boxwell, Roy [mailto:[login to unmask email]
Sent: Wednesday, February 28, 2018 9:19 AM
To: [login to unmask email]
Subject: [DB2-L] - RFE for Db2 12 APPLCOMPAT

Hi all!

I have another RFE that I think is really really really important:

116854 Allow REBIND of in-use Dynamic SQL Packages

The background is that in Db2 12 the complete introduction of Function Levels (FL) has been done at the package level and any SQL within that package *cannot* execute any FL above the level it was bound in. So far so good. Now think about all the dynamic SQL packages you all have in your shops. All the SYSSH, SYSSN, SYSLH and SYSLN style ones or even just Spufi! The same rule holds here so when you upgrade to FL501 you must rebind all the dynamic SQL packages to enable usage...this is nearly impossible these days... Then you could use a new Collection is the answer... except what if you have NULLID ? Then you must edit all the CLI.INI files and this could be 1000's !

My idea here is that these "empty shell" Packages should just be allowed to be rebound whenever we like - There is no need to stop their usage and then we can happily change FL levels really on-the-fly and actually be agile for a change!

If you agree - please go and vote!


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: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de http://www.seg.de

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


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

Michael Arlebrandt

RFE for Db2 12 APPLCOMPAT
(in response to Roy Boxwell)
Hi Roy,

I agree that it has been a lot more complicated with Db2 12 and higher FL than V12R1M500. But changing the ApplCompat value for the NULLID packages is really tricky.
Because it not only requires that the Db2 clients must have level Version 11.1 Modification 2 Fix Pack 2

Ref https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/apsg/src/tpc/db2z_applcompatclients.html

It also introduces a new ClientApplCompat configuration keyword which MUST be added to your db2cli.ini or db2dsdriver.cfg files or you'll get SQLCODE -30025
and I agree that is almost an impossible mission if you have some 1000's of clients to handle.

One option would be to use Profiles and you can govern Application Compatibility using profiles but you can't set it higher than the Nullid package APPLCOMPAT reflects.
And Profiles don't have any support for ClientApplCompat

I have been struggling with how to handle this when we start our v12 migration journey after the summer and the current conclusion is that we MUST keep NULLID at a level not higher than v12R1M500 in order to support all our Db2 client and java applications running at older levels. We'll probably not adapt IBMs idea with having a separate collection for each Function Level but most probably have a collection that reflects the current function level within Db2. I.e. we'll have a NULLID collection and a NULLID_SOE collection where SOE is our Standard Operating Environment which we deliver twice a year.

So don't touch NULLID unless you are sure all of your clients are at 11.1.2 or higher and have the appropriate parameters set which will take some years from now I assume. I believe we still have some old v8 clients hanging around.

Best regards
Michael Arlebrandt
HCL Sweden


From: Boxwell, Roy [mailto:[login to unmask email]
Sent: den 28 februari 2018 9:19
To: [login to unmask email]
Subject: [DB2-L] - RFE for Db2 12 APPLCOMPAT

Hi all!

I have another RFE that I think is really really really important:

116854 Allow REBIND of in-use Dynamic SQL Packages

The background is that in Db2 12 the complete introduction of Function Levels (FL) has been done at the package level and any SQL within that package *cannot* execute any FL above the level it was bound in. So far so good. Now think about all the dynamic SQL packages you all have in your shops. All the SYSSH, SYSSN, SYSLH and SYSLN style ones or even just Spufi! The same rule holds here so when you upgrade to FL501 you must rebind all the dynamic SQL packages to enable usage...this is nearly impossible these days... Then you could use a new Collection is the answer... except what if you have NULLID ? Then you must edit all the CLI.INI files and this could be 1000's !

My idea here is that these "empty shell" Packages should just be allowed to be rebound whenever we like - There is no need to stop their usage and then we can happily change FL levels really on-the-fly and actually be agile for a change!

If you agree - please go and vote!


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: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.seg.de%2F&data=02%7C01%7Cmichael.arlebrandt%40hcl.com%7C8f5412fbed2d47d3934808d57e83f206%7C189de737c93a4f5a8b686f4ca9941912%7C0%7C0%7C636554027612196108&sdata=kA9Efte89H%2BX3pUcMvrZQc%2FX9wN%2BG1DjCULjApjarmE%3D&reserved=0

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


-----End Original Message-----
::DISCLAIMER::
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Roy Boxwell

RFE for Db2 12 APPLCOMPAT
(in response to Michael Arlebrandt)
Thats what my RFE is all about - no change to NULLID just a “byte update” in the catalog and perhaps directory.
With your info it is even clearer that such a solution is urgently needed!!!

Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de

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

On 28 Feb 2018, at 10:27, Michael Arlebrandt <[login to unmask email]<mailto:[login to unmask email]>> wrote:

Hi Roy,

I agree that it has been a lot more complicated with Db2 12 and higher FL than V12R1M500. But changing the ApplCompat value for the NULLID packages is really tricky.
Because it not only requires that the Db2 clients must have level Version 11.1 Modification 2 Fix Pack 2

Ref https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/apsg/src/tpc/db2z_applcompatclients.html

It also introduces a new ClientApplCompat configuration keyword which MUST be added to your db2cli.ini or db2dsdriver.cfg files or you’ll get SQLCODE -30025
and I agree that is almost an impossible mission if you have some 1000’s of clients to handle.

One option would be to use Profiles and you can govern Application Compatibility using profiles but you can’t set it higher than the Nullid package APPLCOMPAT reflects.
And Profiles don’t have any support for ClientApplCompat

I have been struggling with how to handle this when we start our v12 migration journey after the summer and the current conclusion is that we MUST keep NULLID at a level not higher than v12R1M500 in order to support all our Db2 client and java applications running at older levels. We’ll probably not adapt IBMs idea with having a separate collection for each Function Level but most probably have a collection that reflects the current function level within Db2. I.e. we’ll have a NULLID collection and a NULLID_SOE collection where SOE is our Standard Operating Environment which we deliver twice a year.

So don’t touch NULLID unless you are sure all of your clients are at 11.1.2 or higher and have the appropriate parameters set which will take some years from now I assume. I believe we still have some old v8 clients hanging around.

Best regards
Michael Arlebrandt
HCL Sweden


From: Boxwell, Roy [mailto:[login to unmask email]
Sent: den 28 februari 2018 9:19
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RFE for Db2 12 APPLCOMPAT

Hi all!

I have another RFE that I think is really really really important:

116854 Allow REBIND of in-use Dynamic SQL Packages

The background is that in Db2 12 the complete introduction of Function Levels (FL) has been done at the package level and any SQL within that package *cannot* execute any FL above the level it was bound in. So far so good. Now think about all the dynamic SQL packages you all have in your shops. All the SYSSH, SYSSN, SYSLH and SYSLN style ones or even just Spufi! The same rule holds here so when you upgrade to FL501 you must rebind all the dynamic SQL packages to enable usage...this is nearly impossible these days... Then you could use a new Collection is the answer... except what if you have NULLID ? Then you must edit all the CLI.INI files and this could be 1000’s !

My idea here is that these “empty shell” Packages should just be allowed to be rebound whenever we like – There is no need to stop their usage and then we can happily change FL levels really on-the-fly and actually be agile for a change!

If you agree – please go and vote!


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: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.seg.de%2F&data=02%7C01%7Cmichael.arlebrandt%40hcl.com%7C8f5412fbed2d47d3934808d57e83f206%7C189de737c93a4f5a8b686f4ca9941912%7C0%7C0%7C636554027612196108&sdata=kA9Efte89H%2BX3pUcMvrZQc%2FX9wN%2BG1DjCULjApjarmE%3D&reserved=0

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


-----End Original Message-----
::DISCLAIMER::
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----End Original Message-----

James Campbell

RFE for Db2 12 APPLCOMPAT
(in response to Roy Boxwell)
Isn't there an option in V12 that allows a rebind to 'break' in on running transactions so the
rebind can happen at a COMMIT point? Also allows some DDL changes?

Can't find details at the moment.

James Campbell


On 28 Feb 2018 at 8:19, Boxwell, Roy wrote:

>
> Hi all!
>  
> I have another RFE that I think is really really really important:
>  
> 116854   Allow REBIND of in-use Dynamic SQL Packages
>  
> The background is that in Db2 12 the complete introduction of Function Levels (FL) has been
> done at the package level and any SQL within that package *cannot* execute any FL above the
> level it was bound in. So far so good. Now think about all the dynamic SQL packages you all have
> in your shops. All the SYSSH, SYSSN, SYSLH and SYSLN style ones or even just Spufi! The same
> rule holds here so when you upgrade to FL501 you must rebind all the dynamic SQL packages to
> enable usage...this is nearly impossible these days... Then you could use a new Collection is the
> answer... except what if you have NULLID ? Then you must edit all the CLI.INI files and this could
> be 1000´s !
>  
> My idea here is that these "empty shell" Packages should just be allowed to be rebound
> whenever we like - There is no need to stop their usage and then we can happily change FL
> levels really on-the-fly and actually be agile for a change!
>  
> If you agree -please go and vote!
>  
>  
> Roy Boxwell
>

---
This email has been checked for viruses by AVG.
http://www.avg.com

Raymond Bell

RFE for Db2 12 APPLCOMPAT
(in response to James Campbell)
I should be able to remember as I just looked into this a few weeks ago. I think the break-in is just to allow a reorg to effect pending DDL changes. It's not as useful as I'd hoped, as I envisaged being able to be able to get DDL statements run when some dynamic SQL was keeping dibs on the DBD, or when some release(deallocate) packages exist, but no such joy. Maybe that'll come in V2.00. :o)

Cheers,


Raymond

Raymond Bell
Db2
Hosting Services, Technology
Royal Bank of Scotland Group
3rd Floor Regents House
40-42 Islington High Street
London N1 8XL
Mob: +44 (0) 7894 608214
Email: [login to unmask email]

The content of this email is confidential unless stated otherwise.


-----Original Message-----
From: James Campbell [mailto:[login to unmask email]
Sent: 28 February 2018 09:46
To: [login to unmask email]
Subject: [DB2-L] - RE: RFE for Db2 12 APPLCOMPAT

*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************

Isn't there an option in V12 that allows a rebind to 'break' in on running transactions so the rebind can happen at a COMMIT point? Also allows some DDL changes?

Can't find details at the moment.

James Campbell


On 28 Feb 2018 at 8:19, Boxwell, Roy wrote:

>
> Hi all!
>  
> I have another RFE that I think is really really really important:
>  
> 116854   Allow REBIND of in-use Dynamic SQL Packages
>  
> The background is that in Db2 12 the complete introduction of Function Levels (FL) has been
> done at the package level and any SQL within that package *cannot* execute any FL above the
> level it was bound in. So far so good. Now think about all the dynamic SQL packages you all have
> in your shops. All the SYSSH, SYSSN, SYSLH and SYSLN style ones or even just Spufi! The same
> rule holds here so when you upgrade to FL501 you must rebind all the dynamic SQL packages to
> enable usage...this is nearly impossible these days... Then you could use a new Collection is the
> answer... except what if you have NULLID ? Then you must edit all the CLI.INI files and this could
> be 1000´s !
>  
> My idea here is that these "empty shell" Packages should just be allowed to be rebound
> whenever we like - There is no need to stop their usage and then we can happily change FL
> levels really on-the-fly and actually be agile for a change!
>  
> If you agree -please go and vote!
>  
>  
> Roy Boxwell
>

---
This email has been checked for viruses by AVG.
http://www.avg.com

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


The Royal Bank of Scotland plc. Registered in Scotland No 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 135 Bishopsgate, London EC2M 3UR. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (“RBS” or “us”) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you understand that the content of your message may be monitored.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.

Visit our website at www.rbs.com http://www.rbs.com

Roy Boxwell

RFE for Db2 12 APPLCOMPAT
(in response to James Campbell)
Yes indeed but you will be waiting forever and a day to break in at my customer sites!!!

Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de

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

> On 28 Feb 2018, at 10:45, James Campbell <[login to unmask email]> wrote:
>
> Isn't there an option in V12 that allows a rebind to 'break' in on running transactions so the
> rebind can happen at a COMMIT point? Also allows some DDL changes?
>
> Can't find details at the moment.
>
> James Campbell
>
>
>> On 28 Feb 2018 at 8:19, Boxwell, Roy wrote:
>>
>>
>> Hi all!
>>
>> I have another RFE that I think is really really really important:
>>
>> 116854 Allow REBIND of in-use Dynamic SQL Packages
>>
>> The background is that in Db2 12 the complete introduction of Function Levels (FL) has been
>> done at the package level and any SQL within that package *cannot* execute any FL above the
>> level it was bound in. So far so good. Now think about all the dynamic SQL packages you all have
>> in your shops. All the SYSSH, SYSSN, SYSLH and SYSLN style ones or even just Spufi! The same
>> rule holds here so when you upgrade to FL501 you must rebind all the dynamic SQL packages to
>> enable usage...this is nearly impossible these days... Then you could use a new Collection is the
>> answer... except what if you have NULLID ? Then you must edit all the CLI.INI files and this could
>> be 1000´s !
>>
>> My idea here is that these "empty shell" Packages should just be allowed to be rebound
>> whenever we like - There is no need to stop their usage and then we can happily change FL
>> levels really on-the-fly and actually be agile for a change!
>>
>> If you agree -please go and vote!
>>
>>
>> Roy Boxwell
>>
>
> ---
> This email has been checked for viruses by AVG.
> http://www.avg.com
>
> -----End Original Message-----
>

Walter Jani&#223;en

AW: RFE for Db2 12 APPLCOMPAT
(in response to Roy Boxwell)
Hi Roy

I understand your RFE differently. The RFE says that you want to rebind these packages with say APPLCOMPAT V12R1M500, but then it failures may occur, because statements use a timestamp-format, which is not supported anymore. Or do I miss anything?

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Boxwell, Roy [mailto:[login to unmask email]
Gesendet: Mittwoch, 28. Februar 2018 10:38
An: [login to unmask email]
Betreff: [DB2-L] - RE: RFE for Db2 12 APPLCOMPAT

Thats what my RFE is all about - no change to NULLID just a “byte update” in the catalog and perhaps directory.
With your info it is even clearer that such a solution is urgently needed!!!
Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de

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

On 28 Feb 2018, at 10:27, Michael Arlebrandt <[login to unmask email]<mailto:[login to unmask email]>> wrote:
Hi Roy,

I agree that it has been a lot more complicated with Db2 12 and higher FL than V12R1M500. But changing the ApplCompat value for the NULLID packages is really tricky.
Because it not only requires that the Db2 clients must have level Version 11.1 Modification 2 Fix Pack 2

Ref https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/apsg/src/tpc/db2z_applcompatclients.html

It also introduces a new ClientApplCompat configuration keyword which MUST be added to your db2cli.ini or db2dsdriver.cfg files or you’ll get SQLCODE -30025
and I agree that is almost an impossible mission if you have some 1000’s of clients to handle.

One option would be to use Profiles and you can govern Application Compatibility using profiles but you can’t set it higher than the Nullid package APPLCOMPAT reflects.
And Profiles don’t have any support for ClientApplCompat

I have been struggling with how to handle this when we start our v12 migration journey after the summer and the current conclusion is that we MUST keep NULLID at a level not higher than v12R1M500 in order to support all our Db2 client and java applications running at older levels. We’ll probably not adapt IBMs idea with having a separate collection for each Function Level but most probably have a collection that reflects the current function level within Db2. I.e. we’ll have a NULLID collection and a NULLID_SOE collection where SOE is our Standard Operating Environment which we deliver twice a year.

So don’t touch NULLID unless you are sure all of your clients are at 11.1.2 or higher and have the appropriate parameters set which will take some years from now I assume. I believe we still have some old v8 clients hanging around.

Best regards
Michael Arlebrandt
HCL Sweden


From: Boxwell, Roy [mailto:[login to unmask email]
Sent: den 28 februari 2018 9:19
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RFE for Db2 12 APPLCOMPAT

Hi all!

I have another RFE that I think is really really really important:

116854 Allow REBIND of in-use Dynamic SQL Packages

The background is that in Db2 12 the complete introduction of Function Levels (FL) has been done at the package level and any SQL within that package *cannot* execute any FL above the level it was bound in. So far so good. Now think about all the dynamic SQL packages you all have in your shops. All the SYSSH, SYSSN, SYSLH and SYSLN style ones or even just Spufi! The same rule holds here so when you upgrade to FL501 you must rebind all the dynamic SQL packages to enable usage...this is nearly impossible these days... Then you could use a new Collection is the answer... except what if you have NULLID ? Then you must edit all the CLI.INI files and this could be 1000’s !

My idea here is that these “empty shell” Packages should just be allowed to be rebound whenever we like – There is no need to stop their usage and then we can happily change FL levels really on-the-fly and actually be agile for a change!

If you agree – please go and vote!


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: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.seg.de%2F&data=02%7C01%7Cmichael.arlebrandt%40hcl.com%7C8f5412fbed2d47d3934808d57e83f206%7C189de737c93a4f5a8b686f4ca9941912%7C0%7C0%7C636554027612196108&sdata=kA9Efte89H%2BX3pUcMvrZQc%2FX9wN%2BG1DjCULjApjarmE%3D&reserved=0

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


-----End Original Message-----
::DISCLAIMER::
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----End Original Message-----

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

  • image001.png (2.6k)

Roy Boxwell

AW: RFE for Db2 12 APPLCOMPAT
(in response to Walter Janißen)
I hope you missed something! I mean just allow a REBIND of dynamic access packages even if they are in use.
Simple as that!

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: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de http://www.seg.de

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

From: Walter Janißen [mailto:[login to unmask email]
Sent: Thursday, March 1, 2018 1:36 PM
To: [login to unmask email]
Subject: [DB2-L] - AW: RE: RFE for Db2 12 APPLCOMPAT

Hi Roy

I understand your RFE differently. The RFE says that you want to rebind these packages with say APPLCOMPAT V12R1M500, but then it failures may occur, because statements use a timestamp-format, which is not supported anymore. Or do I miss anything?

Kind regards
Walter Janißen [standard_IBM+Champ+7+Yr+Analytics]

ITERGO Informationstechnologie GmbH
Anwendungsentwicklung
Technische Anwendungsarchitektur
Victoriaplatz 2
D-40198 Düsseldorf
[login to unmask email]<mailto:[login to unmask email]>

ITERGO Informationstechnologie GmbH
Vorsitzender des Aufsichtsrats: Christian Diedrich
Geschäftsführung: Dr. Bettina Anders (Vorsitzende),
Lothar Engelke, Ina Kirchhof, Dr. Michael Regauer
Sitz: Düsseldorf, Handelsregister: Amtsgericht Düsseldorf HRB 37996

Von: Boxwell, Roy [mailto:[login to unmask email]
Gesendet: Mittwoch, 28. Februar 2018 10:38
An: [login to unmask email]<mailto:[login to unmask email]>
Betreff: [DB2-L] - RE: RFE for Db2 12 APPLCOMPAT

Thats what my RFE is all about - no change to NULLID just a “byte update” in the catalog and perhaps directory.
With your info it is even clearer that such a solution is urgently needed!!!
Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de

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

On 28 Feb 2018, at 10:27, Michael Arlebrandt <[login to unmask email]<mailto:[login to unmask email]>> wrote:
Hi Roy,

I agree that it has been a lot more complicated with Db2 12 and higher FL than V12R1M500. But changing the ApplCompat value for the NULLID packages is really tricky.
Because it not only requires that the Db2 clients must have level Version 11.1 Modification 2 Fix Pack 2

Ref https://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/apsg/src/tpc/db2z_applcompatclients.html

It also introduces a new ClientApplCompat configuration keyword which MUST be added to your db2cli.ini or db2dsdriver.cfg files or you’ll get SQLCODE -30025
and I agree that is almost an impossible mission if you have some 1000’s of clients to handle.

One option would be to use Profiles and you can govern Application Compatibility using profiles but you can’t set it higher than the Nullid package APPLCOMPAT reflects.
And Profiles don’t have any support for ClientApplCompat

I have been struggling with how to handle this when we start our v12 migration journey after the summer and the current conclusion is that we MUST keep NULLID at a level not higher than v12R1M500 in order to support all our Db2 client and java applications running at older levels. We’ll probably not adapt IBMs idea with having a separate collection for each Function Level but most probably have a collection that reflects the current function level within Db2. I.e. we’ll have a NULLID collection and a NULLID_SOE collection where SOE is our Standard Operating Environment which we deliver twice a year.

So don’t touch NULLID unless you are sure all of your clients are at 11.1.2 or higher and have the appropriate parameters set which will take some years from now I assume. I believe we still have some old v8 clients hanging around.

Best regards
Michael Arlebrandt
HCL Sweden


From: Boxwell, Roy [mailto:[login to unmask email]
Sent: den 28 februari 2018 9:19
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RFE for Db2 12 APPLCOMPAT

Hi all!

I have another RFE that I think is really really really important:

116854 Allow REBIND of in-use Dynamic SQL Packages

The background is that in Db2 12 the complete introduction of Function Levels (FL) has been done at the package level and any SQL within that package *cannot* execute any FL above the level it was bound in. So far so good. Now think about all the dynamic SQL packages you all have in your shops. All the SYSSH, SYSSN, SYSLH and SYSLN style ones or even just Spufi! The same rule holds here so when you upgrade to FL501 you must rebind all the dynamic SQL packages to enable usage...this is nearly impossible these days... Then you could use a new Collection is the answer... except what if you have NULLID ? Then you must edit all the CLI.INI files and this could be 1000’s !

My idea here is that these “empty shell” Packages should just be allowed to be rebound whenever we like – There is no need to stop their usage and then we can happily change FL levels really on-the-fly and actually be agile for a change!

If you agree – please go and vote!


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: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de https://apac01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.seg.de%2F&data=02%7C01%7Cmichael.arlebrandt%40hcl.com%7C8f5412fbed2d47d3934808d57e83f206%7C189de737c93a4f5a8b686f4ca9941912%7C0%7C0%7C636554027612196108&sdata=kA9Efte89H%2BX3pUcMvrZQc%2FX9wN%2BG1DjCULjApjarmE%3D&reserved=0

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


-----End Original Message-----
::DISCLAIMER::
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----End Original Message-----

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

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