DB2 11 for z/os - what changes at applcompat V11R1

Chris Hoelscher

DB2 11 for z/os - what changes at applcompat V11R1
Would someone point me to a list (if such a list exists) of what changes when zparming applcompat V10R1 to V11R1?

I know misformed timestamp literals will generate -180; I guess I don't even know where to look for a comprehensive list

thanks

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

Michael Hannan

RE: DB2 11 for z/os - what changes at applcompat V11R1
(in response to Chris Hoelscher)

Chris,

Your question looks a little vague, like many on DB2-L. I guess you want to know a list of things the were not upwardly compatible, most of which were related to V9 to V10 and BIF_COMPAT?
 

I presume you are not asking about new functionality in V11?

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

Chris Hoelscher

DB2 11 for z/os - what changes at applcompat V11R1
(in response to Michael Hannan)
I am asking for a list of things that will behave differently in applcompat V11R1 than they did in applcompat V10R1

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Michael Hannan [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 3:35 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1


Chris,

Your question looks a little vague, like many on DB2-L. I guess you want to know a list of things the were not upwardly compatible, most of which were related to V9 to V10 and BIF_COMPAT?


I presume you are not asking about new functionality in V11?

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

-----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 or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

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

Roy Boxwell

DB2 11 for z/os - what changes at applcompat V11R1
(in response to Chris Hoelscher)
You could look at the IFCID list from the old 366 or the „new“ 376. That would tell you what Db2 is going to see as “changes in behaviour”.
Here’s my list:

Incompatible changes as of DB2 11:
• 1: V9 version of CHAR(DEC) executed
• 2: V9 version of VARCHAR(DEC) executed
• 3: Unsupported character string representation of a TIMESTAMP
• 4: V10 default SQL path used instead of V11
• 7: SQLCODE -301 from a DB2 11 server
• 8: Stored procedure data types
• 9: TIMESTAMP TIMEZONE from DRDA
• 10: V9 version of LTRIM, RTRIM, STRIP executed
• 11: SET operator with SELECT INTO
• 1101: INSERT into XML column w/o XMLDOCUMENT function
• 1102: XPATH evaluation resulted in error
• 1103: Dynamic SQL ASUTIME limit RLF issue
• 1104: CLIENT_ACCTNG longer than supported length pre-V11
• 1105: CLIENT_APPLNAME longer than supported length pre-V11
• 1106: CLIENT_USERID longer than supported length pre-V11
• 1107: CLIENT_WORKSTNNAME longer than supported length pre-V11
• 1108: CLIENT register longer than supported used for RLF
• 1109: CAST(STRING AS TIMESTAMP) using invalid string lengths as of V11
• 1110: Argument for SPACE function greater than 32764
• 1111: Optional integer argument of VARCHAR greater than 32764
• 1112: Empty XML element
• 1201: changed SQLCODE for POWER results out of range

Hope that helps!

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: Chris Hoelscher [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 11:33 AM
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1

I am asking for a list of things that will behave differently in applcompat V11R1 than they did in applcompat V10R1

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Michael Hannan [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 3:35 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1


Chris,

Your question looks a little vague, like many on DB2-L. I guess you want to know a list of things the were not upwardly compatible, most of which were related to V9 to V10 and BIF_COMPAT?


I presume you are not asking about new functionality in V11?

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

-----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 or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

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-----

Chris Hoelscher

DB2 11 for z/os - what changes at applcompat V11R1
(in response to Roy Boxwell)
Thanks – I didn’t know of there were things that might change that WEREN’T detected by ifcid366/376

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Boxwell, Roy [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 6:25 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1

You could look at the IFCID list from the old 366 or the „new“ 376. That would tell you what Db2 is going to see as “changes in behaviour”.
Here’s my list:

Incompatible changes as of DB2 11:
• 1: V9 version of CHAR(DEC) executed
• 2: V9 version of VARCHAR(DEC) executed
• 3: Unsupported character string representation of a TIMESTAMP
• 4: V10 default SQL path used instead of V11
• 7: SQLCODE -301 from a DB2 11 server
• 8: Stored procedure data types
• 9: TIMESTAMP TIMEZONE from DRDA
• 10: V9 version of LTRIM, RTRIM, STRIP executed
• 11: SET operator with SELECT INTO
• 1101: INSERT into XML column w/o XMLDOCUMENT function
• 1102: XPATH evaluation resulted in error
• 1103: Dynamic SQL ASUTIME limit RLF issue
• 1104: CLIENT_ACCTNG longer than supported length pre-V11
• 1105: CLIENT_APPLNAME longer than supported length pre-V11
• 1106: CLIENT_USERID longer than supported length pre-V11
• 1107: CLIENT_WORKSTNNAME longer than supported length pre-V11
• 1108: CLIENT register longer than supported used for RLF
• 1109: CAST(STRING AS TIMESTAMP) using invalid string lengths as of V11
• 1110: Argument for SPACE function greater than 32764
• 1111: Optional integer argument of VARCHAR greater than 32764
• 1112: Empty XML element
• 1201: changed SQLCODE for POWER results out of range

Hope that helps!

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: Chris Hoelscher [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 11:33 AM
To: '[login to unmask email]' <[login to unmask email]<mailto:[login to unmask email]>>
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1

I am asking for a list of things that will behave differently in applcompat V11R1 than they did in applcompat V10R1

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Michael Hannan [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 3:35 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1


Chris,

Your question looks a little vague, like many on DB2-L. I guess you want to know a list of things the were not upwardly compatible, most of which were related to V9 to V10 and BIF_COMPAT?


I presume you are not asking about new functionality in V11?

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

-----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 or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

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-----

-----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 or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

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

Roy Boxwell

DB2 11 for z/os - what changes at applcompat V11R1
(in response to Chris Hoelscher)
Well some things are well documented in the “Whats New book” Part 3. What’s changed in Db2 12 for example. Where you will find Chapter 11. Summary of changes in the Db2 12 base release as well. Just make sure you get the latest Db2 11 and 12 docu!!


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: Chris Hoelscher [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 2:22 PM
To: '[login to unmask email]' <[login to unmask email]>
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1

Thanks – I didn’t know of there were things that might change that WEREN’T detected by ifcid366/376

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Boxwell, Roy [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 6:25 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1

You could look at the IFCID list from the old 366 or the „new“ 376. That would tell you what Db2 is going to see as “changes in behaviour”.
Here’s my list:

Incompatible changes as of DB2 11:
• 1: V9 version of CHAR(DEC) executed
• 2: V9 version of VARCHAR(DEC) executed
• 3: Unsupported character string representation of a TIMESTAMP
• 4: V10 default SQL path used instead of V11
• 7: SQLCODE -301 from a DB2 11 server
• 8: Stored procedure data types
• 9: TIMESTAMP TIMEZONE from DRDA
• 10: V9 version of LTRIM, RTRIM, STRIP executed
• 11: SET operator with SELECT INTO
• 1101: INSERT into XML column w/o XMLDOCUMENT function
• 1102: XPATH evaluation resulted in error
• 1103: Dynamic SQL ASUTIME limit RLF issue
• 1104: CLIENT_ACCTNG longer than supported length pre-V11
• 1105: CLIENT_APPLNAME longer than supported length pre-V11
• 1106: CLIENT_USERID longer than supported length pre-V11
• 1107: CLIENT_WORKSTNNAME longer than supported length pre-V11
• 1108: CLIENT register longer than supported used for RLF
• 1109: CAST(STRING AS TIMESTAMP) using invalid string lengths as of V11
• 1110: Argument for SPACE function greater than 32764
• 1111: Optional integer argument of VARCHAR greater than 32764
• 1112: Empty XML element
• 1201: changed SQLCODE for POWER results out of range

Hope that helps!

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: Chris Hoelscher [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 11:33 AM
To: '[login to unmask email]' <[login to unmask email]<mailto:[login to unmask email]>>
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1

I am asking for a list of things that will behave differently in applcompat V11R1 than they did in applcompat V10R1

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Michael Hannan [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 3:35 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1


Chris,

Your question looks a little vague, like many on DB2-L. I guess you want to know a list of things the were not upwardly compatible, most of which were related to V9 to V10 and BIF_COMPAT?


I presume you are not asking about new functionality in V11?

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

-----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 or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

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-----

-----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 or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

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-----

Chris Hoelscher

DB2 11 for z/os - what changes at applcompat V11R1
(in response to Roy Boxwell)
Thank you – I will check the doc

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Boxwell, Roy [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 8:26 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1

Well some things are well documented in the “Whats New book” Part 3. What’s changed in Db2 12 for example. Where you will find Chapter 11. Summary of changes in the Db2 12 base release as well. Just make sure you get the latest Db2 11 and 12 docu!!


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: Chris Hoelscher [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 2:22 PM
To: '[login to unmask email]' <[login to unmask email]<mailto:[login to unmask email]>>
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1

Thanks – I didn’t know of there were things that might change that WEREN’T detected by ifcid366/376

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Boxwell, Roy [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 6:25 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1

You could look at the IFCID list from the old 366 or the „new“ 376. That would tell you what Db2 is going to see as “changes in behaviour”.
Here’s my list:

Incompatible changes as of DB2 11:
• 1: V9 version of CHAR(DEC) executed
• 2: V9 version of VARCHAR(DEC) executed
• 3: Unsupported character string representation of a TIMESTAMP
• 4: V10 default SQL path used instead of V11
• 7: SQLCODE -301 from a DB2 11 server
• 8: Stored procedure data types
• 9: TIMESTAMP TIMEZONE from DRDA
• 10: V9 version of LTRIM, RTRIM, STRIP executed
• 11: SET operator with SELECT INTO
• 1101: INSERT into XML column w/o XMLDOCUMENT function
• 1102: XPATH evaluation resulted in error
• 1103: Dynamic SQL ASUTIME limit RLF issue
• 1104: CLIENT_ACCTNG longer than supported length pre-V11
• 1105: CLIENT_APPLNAME longer than supported length pre-V11
• 1106: CLIENT_USERID longer than supported length pre-V11
• 1107: CLIENT_WORKSTNNAME longer than supported length pre-V11
• 1108: CLIENT register longer than supported used for RLF
• 1109: CAST(STRING AS TIMESTAMP) using invalid string lengths as of V11
• 1110: Argument for SPACE function greater than 32764
• 1111: Optional integer argument of VARCHAR greater than 32764
• 1112: Empty XML element
• 1201: changed SQLCODE for POWER results out of range

Hope that helps!

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: Chris Hoelscher [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 11:33 AM
To: '[login to unmask email]' <[login to unmask email]<mailto:[login to unmask email]>>
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1

I am asking for a list of things that will behave differently in applcompat V11R1 than they did in applcompat V10R1

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Michael Hannan [mailto:[login to unmask email]
Sent: Wednesday, February 21, 2018 3:35 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 11 for z/os - what changes at applcompat V11R1


Chris,

Your question looks a little vague, like many on DB2-L. I guess you want to know a list of things the were not upwardly compatible, most of which were related to V9 to V10 and BIF_COMPAT?


I presume you are not asking about new functionality in V11?

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

-----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 or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

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-----

-----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 or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

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-----

-----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 or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them differently
because of race, color, national origin, age, disability or sex.

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