IBM Support

SI45348 - OSP-DB INCORRECT QRYDTA PARTIAL ROW DETERMINATION FOR EXACT

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB INCORRECT QRYDTA PARTIAL ROW DETERMINATION FOR EXACT


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770SS1  710  SI45183   00/00    0000
CO   5770SS1  710  SI45204   00/00    0000
CO   5770SS1  710  SI45073   00/00    0000
CO   5770SS1  710  SI44233   00/00    0000
CO   5770SS1  710  SI44010   00/00    0000
CO   5770SS1  710  SI43510   00/00    0000
CO   5770SS1  710  SI43568   00/00    0000
CO   5770SS1  710  SI43569   00/00    0000
CO   5770SS1  710  SI41337   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



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

-----------------------------------------------
When querying large large amounts of query data, heterogeneous
servers returning the data in a large object DSS using the exact
blocking protocol may not trigger a partial row warning flag
which could potentially give data mismatch errors.

CORRECTION FOR APAR SE50227 :
-----------------------------
When query block size is ramped up automatically, the larger DSS
have to take into account the two byte length within the DSS for
the next query block.  This can occur anywhere in the DSS and at
most there will be two 2 byte length's in a 32k DSS flow.

CIRCUMVENTION FOR APAR SE50227 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI45265 :
=================================================

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
--------------  ------------------------------------------------------------
   SI45265      OSP-DB HETRO DRDA SQL ARRAY MISC FIXES
   SI45203      OSP-DB TIMEOUT DDM RECV WAIT FOR CLOSE NORMAL TERMINATION CL
   SI45145      OSP-DB-MSGMCH3601-F/QRWTDSCD SQL PREPARE/DESCRIBE OF CALL SQ
   SI45074      OSP-DB-MSGMCH3601-F/QRWXFDOCA FAILURE WHEN CONNECTING TO NON
   SI45028      OSP-DB-MSGCPFADC0 ISQL CONNECT FAILURE USING OPTICONNECT FAS
   SI44949      OSP-DB-OTHER-MSGSQL0818 SQL0805 RETURNED WHEN PACKAGE CONSIS
   SI44853      OSP-DB-MSGCPF93B5-RC'B7'X-F/QRWSSYNC FFDC FAILURE
   SI44721      OSP-DB INCORRECT FD:OCA DATATYPE USED FOR BINARY XML
   SI44641      OSP-DB-MSGCPF9160-F/CNSPTH-T/QRWSPROT DDM COMMIT FAILURE
   SI44577      OSP-DB INCORRECT FIELD NAMES RETURNED FOR CLI SQLCOLUMNS FUN
   SI44565      OSP-DB-LOOP LOOPING WHILE RETURNING QUERY DATA OVER DRDA
   SI44557      OSP-DB-MSGSQL0305 MAINFRAME PROGRAM CALLS STORED PROCEDURE O
   SI44517      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0501 INTERMITTENTLY A
   SI44460      OSP-DB-MSGCPF3E81-F/QRWXPRSF XML OVER DRDA INVALID DESCRIPTO
   SI44452      OSP-DB-OTHER-INCORROUT DRDA MSGSQL0104 ENCOUNTERED ON PREPAR
   SI44418      OSP-DB MULTI-ROW INSERT DIAGNOSTIC AREA NOT INITIALIZED
   SI44341      OSP-DB SQL CURSOR QUERY FAILURE TO RETURN ALL ROWS OVER DRDA
   SI44322      OSP-DB-MSGSQL0305 MAINFRAME PROGRAM CALLS STORED PROCEDURE O
   SI44306      OSP-DB-MSGMCH3601-F/QSQPPDS JOB TERMINATION DIAG AREA NOT GU
   SI44231      OSP-DB INTERNAL MAINTENANCE FOR DRDA
   SI44176      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0189 WHEN INSERTING
   SI44106      OSP-DB DRDA/DDM UNPROTECTED DFM RESOURCES NOT SETTING CMT DF
   SI44009      OSP-DB OPEN/FETCH QUERY DATA PARTIAL ROW FIXES
   SI43906      OSP-DB INTERNAL MAINTENANCE
   SI43890      OSP-DB-MSGSQL0428-F/QSQCONN CPYFRMIMPF DISCONNECT FAILURE
   SI43835      OSP-DB ADD USAGE COUNT TRACEPOINTS
   SI43641      OSP-DB-MSGMCH3602-F/QSQROUTA DRDA CONNECT FAIL FOR DROP
   SI43626      OSP-DB SQLDIAGCN CONNECTION ARRAY BUILT INCORRECTLY
   SI43509      OSP-DB ADDITIONAL TCPIP FILTERING ENHANCEMENTS
   SI43395      OSP-DBMSGSQL0804-F/QSQROUTA HETRO SQL ARRAY ON CALL FAILURE
   SI43356      OSP-DB INTERNAL DRDA MAINTENANCE
   SI43333      OSP-DB DRDA SPACE CLEANUP
   SI43320      OSP-DB-MSGSQ20398-F/QSQRUN3 XML PARSER FAILURE DUE TO INVALI
   SI43305      OSP-DB INTERNAL DRDA MAINTENANCE
   SI43300      OSP-DB-MSGSQL0428 CPYTOIMPF FAILURE TO DISCONNECT DRDA CNN
   SI43246      OSP-DB-MSGMCH1210-F/QRWXFDOCA CURSOR OPEN ON TABLE CONTAININ
   SI43060      OSP-DB ADD TRACEPOINTS/FFDC ENHANCEMENTS
   SI42878      OSP-DB-UNPRED Internal DRDA Maintenance
   SI42658      OSP-DB DRDA INVALID SYNCLOG FAILING RESYNC
   SI42312      OSP-DB DEFERRED BINDING IN DRDA SERVICE PROGRAMS
   SI42233      OSP-DB-MSGSQL0204 SEEING ASP GROUP CHANGED TO *NONE FOR CNN
   SI42119      OSP-DB-MSGMCH3601-F/QRWXENV DB2 CLI DRDA CONN POOLING FAILUR
   SI42044      OSP-COMM-DDM-F/QRWSARDB-T/QRWSARDB-RCX'01'-MSGCPF3E33 CPF3E3
   SI42032      OSP-DB-MSGMCH3402-F/QRWSQRY 3 PART CONN FAILURE W SAVEPOINTS
   SI42011      OSP-DB-MSGMCH3601-F/QRWSEXEC SQLDARD PROC INCORRECT
   SI41890      OSP-DB INITIALIZE SYNCLOG SPACE
   SI41863      OSP-DB-MSGCPI83E0 RESYNC FAILURE INVALID PORT
   SI41734      OSP-DB INITIALIZE SYNCLOG SPACES
   SI41548      OSP-DB-MSGCPI83E0 RESYNC FAILURE INVALID PORT
   SI41427      OSP-DB-OTHER-INCORROUT DRDA CONNECTION HANGS ON A SELECT STA
   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 SE50227
Superseded by:......................View fix details for PTF SI65565
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C2115710


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.

[{"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":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1 environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
05 December 2011