PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
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 |
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.
Was this topic helpful?
Document Information
Modified date:
11 November 2010