IBM Support

SI41427 - OSP-DB-OTHER-INCORROUT DRDA CONNECTION HANGS ON A SELECT STA

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-INCORROUT DRDA CONNECTION HANGS ON A SELECT STA


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770SS1  710  SI41337   00/00    0000
CO   5770SS1  710  SI41230   00/00    0000
CO   5770SS1  710  SI41007   00/00    0000
CO   5770SS1  710  SI39060   00/00    0000
CO   5770SS1  710  SI39064   00/00    0000
CO   5770SS1  710  SI39063   00/00    0000
CO   5770SS1  710  SI39069   00/00    0000
CO   5770SS1  710  SI39062   00/00    0000
CO   5770SS1  710  SI38843   00/00    0000



NOTICE:
-------
Application of this PTF may disable or render ineffective programs that
use system memory addresses not generated by the IBM translator,
including programs that circumvent control technology designed to limit
interactive capacity to purchased levels.  This PTF may be a prerequisite
for future PTFs.  By applying this PTF you authorize and agree to the
foregoing.

This PTF is subject to the terms of the license agreement which
accompanied, or was contained in, the Program for which you are obtaining
the PTF.  You are not authorized to install or use the PTF except as part
of a Program for which you have a valid Proof of Entitlement.

SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY
AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT
AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED,
INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT,
REGARDING THE PTF.

The applicable license agreement may have been provided to you in printed
form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR)
CL command.





APAR Error Description / Circumvention

-----------------------------------------------
Using Microsoft's OLE DB provider client to make a DRDA
connection to the IBM i server hangs when running certain SELECT
statements. A TRCCNN communications trace shows the client sends
a Open Query (OPNQRY) request to the IBM i, but the server does
not respond. The call stack for the QRWTSRVR prestart job on the
IBM i shows it is sitting on QSOSRV1 QSYS recv.

This only occurs for pre-SQLAM 7 clients querying an v6r1 or
v7r1 IBM i server when the particular table that is querying
reaches a non-specific amount.

CORRECTION FOR APAR SE45238 :
-----------------------------
Internal calculations for determination of query data length in
the query block were incorrect resulting in IBM i server
specifying that there is more query data than there actually is
in the current query block.  Since the length of the first query
block is incorrect, our send routines fail and never send the
data flows back to the client.

This only occurs when the server is fetching the last row of
data and has to place a SQLCA (which indicates the last row of
data) into a null row, and the null row does not fit in the
current query block.  At this point, the SQLCA is spanned across
the remaining space of the current query block and a new query
block.

This is something that will fail intermittently for users using
pre-SQLAM7 clients querying a v6r1 or v7r1 server depending on
the size of the row data and number of fields in the table.

Outside of varying the query data size amount and number of
fields in the table, there is no way for the end user to know
when the hang condition will occur.

CIRCUMVENTION FOR APAR SE45238 :
--------------------------------
Increasing or decreasing the row data or number of fields in the
table will circumvent.


Activation Instructions


None.




Special Instructions


If the DRDA "listener" server job QRWTLSTN is active in the
QSYSWRK subsystem when this PTF to be applied immediately, the server
job should be ended prior to applying the ptf:
ENDTCPSVR SERVER(*DDM)

Then after the ptf is applied, restart the QRWTLSTN server job:
STRTCPSVR SERVER(*DDM)

Restart the QRWTSRVR prestart jobs
ENDPJ SBS(QUSRWRK) PGM(QRWTSRVR) OPTION(*IMMED)
STRPJ SBS(QUSRWRK) PGM(QRWTSRVR)

Restart the QSQSRVR prestart jobs
ENDPJ SBS(QSYSWRK) PGM(QSQSRVR) OPTION(*IMMED)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)

Restart the QZDASOINIT prestart jobs
ENDPJ SBS(QUSRWRK) PGM(QZDASOINIT) OPTION(*IMMED)
STRPJ SBS(QUSRWRK) PGM(QZDASOINIT)


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI41420      OSP-DB-UNPRED Support QIBM_SQL_PASSIVE_UNQUALIFIED_RDB
   SI41412      OSP-DB-UNPRED Failure during error cleanup of DRDA connectio
   SI41399      OSP-DB-UNPRED SQLCAMESSAGE failing to process +20 SQL code
   SI41336      OSP-DB-UNPRED Auto create NULLID packages if not found
   SI41307      OSP-DB-UNPRED Allow auto package creation when some statemen
   SI41229      OSP-DB-UNPRED Reprepare of DRDA cursors when open attributes
   SI41215      OSP-DB-OTHER-QRYBLK SPLITTING INCORRECTLY CALCULATED FOR PRE
   SI41008      OSP-DB-UNPRED DRDA client synchronization failing
   SI40958      OSP-DB-UNPRED DRDA spaces not cleaned up at job termination
   SI40897      OSP-DB-UNPRED Pre-V7R1 descriptors need to be up converted
   SI40869      OSP-DB SQLCancel userid wrong
   SI40828      OSP-DB-UNPRED Correct multi-row insert looping
   SI40770      OSP-DB-MSGMCH3601-F/QCNSSPTH SQLCANCEL FAILURE
   SI40596      OSP-DB-UNPRED There was no control over the DRDA query block
   SI40586      OSP-DB-UNPRED double byte XML parameter failing length check
   SI40518      OSP-DB-UNPRED DRDA result set generating two +100/02000
   SI40468      OSP-DB-MSGSQL0312 HETRO BIND FAILURE OF SQL STT
   SI40452      OSP-DB-UNPRED DRDA clients running under 65535 failing on st
   SI40395      OSP-DB-UNPRED DRDA sending/checking wrong concurrent access
   SI40389      OSP-DB-UNPRED DRDA failing to send long statements
   SI40329      OSP-DB-UNPRED Prevent connects within XA transactions
   SI40323      OSP-DB-UNPRED Failing to propagate LOBs over three-part nami
   SI40321      OSP-DB-UNPRED Failing to signal warnings on prepare over DRD
   SI40301      OSP-DB-UNPRED DRDA spaces not cleaned up at job termination
   SI40289      OSP-DB-UNPRED LOBs not propagated over three-part naming con
   SI40279      OSP-DB-UNPRED Prevent statements that cannot be run over DRD
   SI40262      OSP-DB-MSGSQ30000 BIND FAILURE FOR SQLUDTGRP ON SQLVRBGRP
   SI40233      OSP-DB-UNPRED open options (?SQPREP OPENOPTS) sent to RW bei
   SI40199      OSP-DB-UNPRED DRDA errored connections not going to unconnec
   SI40202      OSP-DB-UNPRED open options (?SQPREP OPENOPTS) sent to RW bei
   SI40115      OSP-DB SQL ARRAY MISC FIXES
   SI39944      OSP-DB-MSGMCH3601-F/QRWTCMMT TWOPHASE FAIL
   SI39802      OSP-DB-MSGMCH3601-F/QRWTSYNC TWOPHASE FAIL
   SI39708      OSP-DB DBMON 1000 RECORD FIX
   SI39696      OSP-DB-MSGMCH1210-F/QRWSARDB LOCAL CNN FAILURE
   SI39678      OSP-DB SQL ARRAY MISC FIXES
   SI39452      OSP-DB-UNPRED Java stored procedure result sets failing over
   SI39345      OSP-DB Internal Maintenance
   SI39297      OSP-DB Internal Maintenance
   SI39282      OSP-DB-MSGSQL0901 -F/QSQRUND ERROR PATH BAD DIAG CALC
   SI39231      OSP-DB-UNPRED Select of large decimals from heterogeneous cl
   SI39193      OSP-DB-UNPRED MCH1210 when varying on iASP
   SI39071      OSP-DB Internal Maintenance
   SI39061      OSP-DB Internal Maintenance
   SI39055      OSP-DB Internal Maintenance
   SI39027      OSP-DB-MSGSQL0100-INCORROUT DRDA JOB SIGNALS LAST ROW TO SOO
   SI38990      OSP-DB Internal Maintenance
   SI38950      OSP-DB Internal Maintenance
   SI38938      OSP-DB SQL ARRAY MISC FIXES
   SI38922      OSP-DB Internal Maintenance
   SI38902      OSP-DB Internal Maintenance
   SI38868      OSP-DB Internal Maintenance
   SI38845      OSP-DB Internal Maintenance
   SI38838      OSP-DB Internal Maintenance
   SI38810      OSP-DB Internal Maintenance
   SI38807      OSP-DB Internal Maintenance
   SI38792      OSP-DB Internal Maintenance
   SI38748      OSP-DB Internal Maintenance
   SI38720      OSP-DB DISC TYPE NOT SET IN ALL CASES FOR ACT GRP EXIT
   SI38683      OSP-DB Internal Maintenance
   SI38656      OSP-DB Internal Maintenance
   SI38538      OSP-DB Internal Maintenance
   SI38536      OSP-DB MISC DRDA SQL ARRAY FiX
   SI38499      OSP-DB Internal Maintenance
   SI38466      OSP-DB Internal Maintenance
   SI38438      OSP-DB Internal Maintenance
   SI38359      OSP-DB SQL Array Misc fixes
   SI38335      OSP-DB Internal Maintenance
   SI38166      OSP-DB Internal Maintenance
   SI38136      OSP-DB Internal Maintenance
   SI38129      OSP-DB Internal Maintenance
   SI38117      OSP-DB Internal Maintenance
   SI38112      OSP-DB Internal Maintenance
   SI38110      OSP-DB Internal Maintenance
   SI38094      OSP-DB MISC DRDA SQL ARRAY FIX
   SI38071      OSP-DB Internal Maintenance
   SI38029      OSP-DB Internal Maintenance
   SI38015      OSP-DB Internal Maintenance
   SI37997      OSP-DB Internal Maintenance
   SI37951      OSP-DB DRDA SRVR PRT JOBLOG IN ERROR
   SI37936      OSP-DB Internal Maintenance
   SI37897      OSP-DB Internal Maintenance
   SI37852      OSP-DB-MSGMCH3402-F/QRWSARDB BROKEN PIPE CONNECT FAILURE
   SI37772      OSP-DB Internal Maintenance
   SI37734      OSP-DB Internal Maintenance
   SI37730      OSP-DB Internal Maintenance
   SI37663      OSP-DB Internal Maintenance
   SI37656      OSP-DB MISC DRDA SQL ARRAY FiX
   SI37621      OSP-DB-UNPRED DRDA client interrupt failing
   SI37578      OSP-DB Internal Maintenance
   SI37562      OSP-DB Internal Maintenance
   SI37546      OSP-DB Internal Maintenance
   SI37496      OSP-DB Internal Maintenance
   SI37486      OSP-DB Internal Maintenance
   SI37472      OSP-DB-UNPRED Misc DRDA fixes.
   SI37437      OSP-DBMCH3601-F/QRWTQRY MCH3601-F/QRWTQRY
   SI37394      OSP-DB BIND failure over DRDA
   SI37362      OSP-DB DRDA SQL ARRAY FIX
   SI37341      OSP-DB-OTHER-MSGSQL0901 RECEIVED ON EXCSQLSET
   SI37340      OSP-DB DRDA ARRAY CHANGES FOR LOBS
   SI37179      OSP-DB-UNPRED Misc DRDA fixes.
   SI37178      OSP-DB-UNPRED Misc DRDA fixes.
   SI37177      OSP-DB-UNPRED Misc DRDA fixes.
   SI37175      OSP-DB-UNPRED Misc DRDA fixes.
   SI37004      OSP-DB-UNPRED Misc DRDA fixes.
   SI37002      OSP-DB-UNPRED Misc DRDA fixes.
   SI36994      OSP-DB-UNPRED Misc DRDA fixes.
   SI36954      OSP-DB DRDA ARRAY CHANGES FOR MULTIPLE ARRAYS
   SI36775      OSP-DB-UNPRED Misc DRDA fixes.
   SI36758      OSP-DB SQL ARRAY NEEDS UDT INFO
   SI36709      OSP-DB-UNPRED Misc DRDA fixes.
   SI36680      OSP-DB DRDA ARRAY FIXES
   SI36548      OSP-DB-UNPRED Stored procedure result set corrections.
   SI36522      OSP-DB DRDA ARRAY CHANGES
   SI36521      OSP-DB-UNPRED Stored procedure result set corrections.
   SI36504      OSP-DB SQL FETCH RELATIVE HOMOGENOUS FAILS
   SI36496      OSP-DB DRDA ARRAY CHANGES
   SI36443      OSP-DB-UNPRED DRDA bind failure

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE45238
Superseded by:......................View fix details for PTF SI65565
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C1116710


System i Support

IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 November 2010