Db2 z/OS V12 FL501 - IFCID 376 Incompatibility Report

Balasubramaniyan Rengan

Db2 z/OS V12 FL501 - IFCID 376 Incompatibility Report

Esteemed List,

We have the following configuration.

Db2 : Version 12 FL506 (test) , FL506 (prod).

Db2 connect gateway and IBM Data Server client version : V11.1 Fix Pack 3

ZPARM APPLCOMPAT : V12R1M506 (test) , V12R1M501(prod)

Application uses Websphere to make connection to Db2 z/OS via connect gateway.

Before we migrate to FL506 in production, I wanted to run IFCID 376 to see any incompatibility. We turned on trace for IFCID 376 and produced CA SYSVIEW batch report BTRINCMT (SQL Incompatibility Trace).

We see some incompatibilities reported for the IBM Data Server Driver package NULLID.SYSLH200.

We did not REBIND/BIND this package after the upgrade. The idea is to use separate collection id for each APPLCOMPAT if there is a need (application wanting to use a v12 feature etc.,)

No one complained about a failed transaction/process so far.

Following is a portion of IFCID 376 report. There are additional messages for long CLIENT_APPLNAME, CLIENT_USERID & CLIENT_WRKSTNNAME. The workstation in this case is the Websphere Application Server IP address.

===============================

EVENT: 04/22/20 12:37:13.3265 INCOMPATIBILITY REASON: Long CLIENT_ACCTNG SR REASON CODE: 1104
AUTH ID : XXXXXXX CONNECTION ID: SERVER
PLAN NAME : DISTSERV CORRELATION ID: db2jcc_appli
LOCATION : DB2T
WORKSTATION : XX.XXX.XX.XXX
TRANSACTION : db2jcc_application
ENDUSER : XXXXXXX
COLLECTION ID : NULLID
PROGRAM NAME : SYSLH200
CONTOKEN (HEX): 5359534C564C3031
STMT ID (HEX) : 000000000000055B STMT NUMBER: 1 SECTION: 1 STMT TYPE: Dynamic

======================

My understanding is that NULLID packages does NOT need any change unless application wants to use a new feature.

Questions:

1) Why do i see this in the report? Is this because the package NULLID.SYSLH200 was last bound in V10 (APPLCOMPAT and FUNCTION_LVL for this package is blank) and we see V10R1 behavior?


The following link says these special register values will be truncated to V10 maximum length padded with blanks.

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/wnew/src/tpc/db2z_applcompatv10r1.html

2) Should I just ignore these as warnings and assume they will go away when we start using different set of IBM Data Server Driver packages with latest APPLCOMPAT ?

I have attached the full incompatibility report for reference.

Thanks very much in advance.

Regards

Bala

 

Attachments

  • BTRINCMT_IFCID_376.TXT (15.2k)

Roy Boxwell

Db2 z/OS V12 FL501 - IFCID 376 Incompatibility Report
(in response to Balasubramaniyan Rengan)
1. Yes indeed, the NULLID package is Db2 10 and so you get Db2 11 ICIs being issued
2. It depends… Most shops I know just REBIND the NULLID packages at the highest desired level and then loads of these ICIs just disappear. The real question is whether that is good or not at this point in time and that is much tougher to answer! If the data is being “used” somewhere and it is assumed to be longer than it is then you have a problem but then you have had this problem for a while and not noticed it… Basically forget the 1104 – 1107 messages



Roy Boxwell

SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-

Vagedesstrasse 19
40479 Dusseldorf/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: Balasubramaniyan Rengan <[login to unmask email]>
Sent: Thursday, April 30, 2020 2:40 AM
To: [login to unmask email]
Subject: [DB2-L] - Db2 z/OS V12 FL501 - IFCID 376 Incompatibility Report



Esteemed List,

We have the following configuration.

Db2 : Version 12 FL506 (test) , FL506 (prod).

Db2 connect gateway and IBM Data Server client version : V11.1 Fix Pack 3

ZPARM APPLCOMPAT : V12R1M506 (test) , V12R1M501(prod)

Application uses Websphere to make connection to Db2 z/OS via connect gateway.

Before we migrate to FL506 in production, I wanted to run IFCID 376 to see any incompatibility. We turned on trace for IFCID 376 and produced CA SYSVIEW batch report BTRINCMT (SQL Incompatibility Trace).

We see some incompatibilities reported for the IBM Data Server Driver package NULLID.SYSLH200.

We did not REBIND/BIND this package after the upgrade. The idea is to use separate collection id for each APPLCOMPAT if there is a need (application wanting to use a v12 feature etc.,)

No one complained about a failed transaction/process so far.

Following is a portion of IFCID 376 report. There are additional messages for long CLIENT_APPLNAME, CLIENT_USERID & CLIENT_WRKSTNNAME. The workstation in this case is the Websphere Application Server IP address.

===============================

EVENT: 04/22/20 12:37:13.3265 INCOMPATIBILITY REASON: Long CLIENT_ACCTNG SR REASON CODE: 1104
AUTH ID : XXXXXXX CONNECTION ID: SERVER
PLAN NAME : DISTSERV CORRELATION ID: db2jcc_appli
LOCATION : DB2T
WORKSTATION : XX.XXX.XX.XXX
TRANSACTION : db2jcc_application
ENDUSER : XXXXXXX
COLLECTION ID : NULLID
PROGRAM NAME : SYSLH200
CONTOKEN (HEX): 5359534C564C3031
STMT ID (HEX) : 000000000000055B STMT NUMBER: 1 SECTION: 1 STMT TYPE: Dynamic

======================

My understanding is that NULLID packages does NOT need any change unless application wants to use a new feature.

Questions:

1) Why do i see this in the report? Is this because the package NULLID.SYSLH200 was last bound in V10 (APPLCOMPAT and FUNCTION_LVL for this package is blank) and we see V10R1 behavior?


The following link says these special register values will be truncated to V10 maximum length padded with blanks.

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/wnew/src/tpc/db2z_applcompatv10r1.html

2) Should I just ignore these as warnings and assume they will go away when we start using different set of IBM Data Server Driver packages with latest APPLCOMPAT ?

I have attached the full incompatibility report for reference.

Thanks very much in advance.

Regards

Bala





_____

Attachment Links: BTRINCMT_IFCID_376.TXT (16 k) https://www.idug.org/p/fo/do/?download=1&fid=11838
Site Links: View post online https://www.idug.org/p/fo/st/?post=192204&anc=p192204#p192204 View mailing list online https://www.idug.org/p/fo/si/?topic=19 Start new thread via email <mailto:[login to unmask email]> Unsubscribe from this mailing list <mailto:[login to unmask email]?Subject=Unsubscribe> Manage your subscription https://www.idug.org/p/us/to

This email has been sent to: [login to unmask email] <mailto:[login to unmask email]>

Try BCV5, the BCV5 Masking Tool, & XDM a rapid Refresh/Clone/TDM Suite for Db2 z & distributed.
DBARS -Audit,record,& block Db2 accesses to sensitive data real-time, NO audit trace or log required
http://www.ESAIGroup.com/IDUG


Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2

_____

Attachments

  • smime.p7s (5.1k)

Balasubramaniyan Rengan

RE: Db2 z/OS V12 FL501 - IFCID 376 Incompatibility Report
(in response to Roy Boxwell)

Hi Roy, Thanks very much for the reply, very helpful.

Regards

Bala