IBM Support

SI64211 - OSP-DB EXCESSIVE NATIVE OPENS OF QADBXRMTNM/QADBXRDBD FILES

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB EXCESSIVE NATIVE OPENS OF QADBXRMTNM/QADBXRDBD FILES


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI59891   00/00    0000
CO   5770SS1  710  SI64212   00/00    0000
CO   5770SS1  710  SI49316   00/00    0000
CO   5770SS1  710  SI48192   00/00    0000
CO   5770SS1  710  SI48194   00/00    0000
CO   5770SS1  710  SI48193   00/00    0000
CO   5770SS1  710  SI48195   00/00    0000
CO   5770SS1  710  SI48198   00/00    0000
CO   5770SS1  710  SI48199   00/00    0000
CO   5770SS1  710  SI47380   00/00    0000
CO   5770SS1  710  SI46027   00/00    0000
CO   5770SS1  710  SI46029   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  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

-----------------------------------------------
EXCESSIVE NATIVE OPENS OF QADBXRMTNM/QADBXRDBD FILES FOR SQL

CORRECTION FOR APAR SE66824 :
-----------------------------
SIGNIFICANTLY REDUCE NUMBER OF OPENS OF THESE TWO FILES

CIRCUMVENTION FOR APAR SE66824 :
--------------------------------
None.


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)

********************************************************************
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 SI50525 :
=================================================

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)ructions&task=tabselected&formSessionId=1106723319137338
21490870&scrollX=0&scrollY=0&pageTitle=null


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI64012      OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QRWSQRY-MSGMCH0601 RETRIEVI
   SI63293      OSP-DB-MSGSQL0206-F/QRWSEXEC 3-PART FAIL WHEN SET CURRENT DE
   SI62918      OSP-DB-MSGSQL0206-F/QRWSEXEC GLOBAL VAR FAIL HETERO 3PART SQ
   SI62902      OSP-DBMSGSQL0805-F/QRWTEXEC CLI PKG AUTO GENERATION FAILURE
   SI62891      OSP-DB-MSGMCH1210 F/QRWTQRY Substitution Characters with SEL
   SI62043      OSP-DBMSGSQL0901-F/QSQICPKG CLI PKG AUTO GENERATION FAILURE
   SI60897      OSP-DB-OTHER-MSGCPF9810 UNEXECPTED SWAP TO SYSBAS FROM IASP
   SI59894      OSP-DB-MSGSQL0900 IMPLICITLY CONNECT RESET FOR SQL DRDA CNN
   SI59622      OSP-DB ALLOW FETCH NEXT/FETCH PRIOR FOR N ROWS TO LUW
   SI59413      OSP-DBMSGMCH3601-F/QRWXENV SNDENVUPDS ACCRDB PTR NOT SET
   SI59222      OSP-DB-MSGSQL0332-F/QSQXCUTE TRANS ERROR SQLCA W/ MULTIPLE M
   SI59098      OSP-OTHER-F/#HMALCMI-T/QWVAGSRV-MSGMCH6903 HEAP SPACE STORAG
   SI58592      OSP-DB INCORRECT RDB VALUE PASSED TO ARDPGM FOR DESCRIBE TAB
   SI58149      OSP-DB-MSGMCH3601-F/QSQPCPKG CRTSQLPKG FAILURE DDM/DRDA CNN
   SI57768      OSP-DB INTERNAL MAINTENANCE
   SI56996      OSP-DB-MSGMCH3401-F/MnResolveContext-T/QRWTSYNC BRMS BACKUP
   SI56994      OSP-DB-MSGCPF9160-F/QRWSPROT FAILURE ON 2-PHASE COMMIT OVER
   SI56760      OSP-DB-MSGCPF9201-F/QRWTARDB USERID NOT FILLED IN ON MSG
   SI56438      OSP-DB NO ASP CNN AFTER DRDA REROUTING TO USER SPECIFIED SBS
   SI56081      OSP-DB-MSGCPF3E06 TARGET-SIDE ALIASING TO SYSBAS CNN FAILURE
   SI55724      OSP-DB TARGET-SIDE ALIAS RDB TO IASP CNN TO SYSBAS
   SI55437      OSP-DB INTERNAL MAINTENANCE
   SI46420      OSP-DB QRWOPTIONS DEBUG OPTIONS DATA AREA FIX FOR IP FILTERI
   SI55349      OSP-DB-MSGCPF9160-F/QRWSBIND DRDA AUTO-PKG GEN FAILS W/SPECI
   SI55337      OSP-DB DRDA/DDM DIFFERING CNN BEHAVIOR WHEN IASP STATUS CHAN
   SI54649      OSP-DB DRDA ROW CHANGE TIMESTAMP DESCRIBED INCORRECTLY
   SI54593      OSP-DB-MSGSQ30061-F/QSQCONN DRDA TARGET-SIDE ALIAS PREVENTIN
   SI54081      OSP-DB FETCH OVER DRDA OF NON-NULLABLE LOB INCLUDES NULLABIL
   SI53874      OSP-DB SP ARRAY RESULT SETS OVER DRDA INCORRECT NULL COLUMNS
   SI53246      OSP-DB CLIENT SPECIAL REG BRANDING FIX FOR LOCAL CONNECTION
   SI53095      OSP-DB-MSGCPD3E06 SQL0969 SELECT OVER ARD RETURNS ERROR FOR
   SI52561      OSP-DB-MSGSQL0330 DRDA CONNECTION REUSE CLT SPC REG FAILURE
   SI52543      OSP-DB BRAND DRDA CONNECTIONS WITH DEFAULT CLIENT SPECIAL RE
   SI52427      OSP-DB-MSGSQ20398 XML PARSE FAILURE FOR NULL STREAMED XML/LO
   SI52401      OSP-DB-MSGSQL0805 LUW CLIENT SPC REG PASSING DUMMY PACKAGE C
   SI52221      OSP-DBMSGMCH3601-F/QRWXENV DRDA CLIENT FLOWS REUSE RLSCONV O
   SI51951      OSP-DB COLUMN NAME INCORRECT OVER DRDA
   SI51784      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
   SI51708      OSP-DB-MSGCPF3E86-F/QRWTERR FILE REFERENCE VARIABLE FIX FOR
   SI51691      OSP-DB SQL CALL EXPECTING OUTPUT ARD INDICATOR FAILURE FOR N
   SI51478      OSP-DB DRDA ARD CNN SQLSTATE SQLCODE CONFLICT
   SI51401      OSP-DB DRDA CONNECTION PERFORMANCE IMPROVEMENT
   SI51247      OSP-DB-MSG DRDA HETERO FAILURE WHEN PASSING DEC DELIMITER TO
   SI51214      OSP-DB INTERNAL MAINTENANCE
   SI51070      OSP-DB LONG CORRELATION NAME SHOWS INCORRECTLY IN SELECT RES
   SI50996      OSP-DBMSGSQL7022 DUW SQL CONN TO SAME DB OVER DRDA DIFF USER
   SI50994      OSP-DB-MSGMCH3601-F/QRWDSCD DRDA DESCRIBE TABLE FAILURE
   SI50717      OSP-DB SPECIAL REGISTER CURRENT CLIENT_ACCTNG FIX
   SI50672      OSP-DB-MSGMCH3601-F/QRWSPP SP/QRWSPROT FAILURE WITH ARD PROG
   SI50662      OSP-DB SPECIAL REGISTER CURRENT CLIENT_ACCTNG FIX
   SI50593      OSP-DB-MSGMCH1210-F/QSQDSCPT ARD PREPARE/DESCRIBE FAILURE
   SI50547      OSP-DB DRDA ORPHANED ENCRYPTION OBJECT CLEANUP
   SI46748      OSP-DB DRDA ORPHANED ENCRYPTION OBJECT CLEANUP
   SI50525      OSP-DB SET STMTS USING INCORRECT PACKAGE
   SI50450      OSP-DB HETRO DRDA OUTPUT LOBS NOT RETURNING WHEN RESULT SETS
   SI50222      OSP-DB-MSGMCH3402-F/QSQRXOPM DRDA CNN SEVERED CAUSES ISQL FA
   SI50059      OSP-DB-MSGSQL0107 CREATE PACKAGE OVER DRDA TO ZOS/LUW AS FAI
   SI50017      OSP-DB-MSGSQL0843-F/QSQCONN ARD SET CONNECTION FAILURE
   SI50010      OSP-DB-MSGSQL0020 OPTION(*QUOTE) WARNING DURING SQL BIND OVE
   SI49899      OSP-DB-MSGMCH3601-F/QSQUNCON FAILURE AFTER RMT CNN RELEASED,
   SI49871      OSP-DB-MSGSQ20226 QUERYING TOO MUCH MALFORMED DATA FAILS OVE
   SI49683      OSP-DB TWO-PHASE RESYNC OVER DRDA TO IP ADDR FAILURE
   SI49639      OSP-DB-OTHER-INCORROUT 5761 F/QRWSPP SP/QRWSPROT FLDS/DDM VA
   SI49317      OSP-DB DB2 Connect Management Support
   SI49437      OSP-DB-MSGSQ30073-F/QRWTERR DDM CODE POINT '2130' NOT SUPPOR
   SI49078      OSP-DBMSGMCH3402-F/QQQVALID FAILURE TO RETRIEVE SPECIAL REGI
   SI48977      OSP-DBMSGMCH3402-F/QQQVALID FAILURE TO RETRIEVE SPECIAL REGI
   SI48931      OSP-DBMSGSQL7940 F/T QSQMSGAR/QSQMSGAR
   SI48923      OSP-DB SQL 3-PART CONNECTION FAIL FOR LONG SCHEMA NAME
   SI48800      OSP-DB ARD PGM OVER DRDA NOT USING SERVER AUTHENTICATION ENT
   SI48767      OSP-DB-MSGMCH1210-F/QRWTQRY LARGE QUERY FAILS OVER DRDA\DDM
   SI48501      OSP-COMM-DDM-F/QRWTERR-T/QRWTBAS-MSGSQ30061 CPD3E03, CPF3E06
   SI48428      OSP-DB-MSGSQL0804 BIGINT AND DECFLOAT TYPES FAIL OVER ARD
   SI48297      OSP-DB NO WARNING FOR INVALID SPECIAL REGISTER UNLESS LAST S
   SI48291      OSP-DB-OTHER-T/QQQSRVE1X/24605-MSGMCH3203X UPDATE STMT FAILS
   SI48197      OSP-DB-OTHER-RC480-MSGSQL0904
   SI48135      OSP-DB INTERNAL MAINTENANCE
   SI47811      OSP-DB ATOMIC MULTI-ROW FAILURE OVER HETEROGENEOUS DRDA
   SI47600      OSP-DB-MSGMCH1210-F/QRWSDSCD DECFLOAT FIELD DESCRIBE FAILURE
   SI47379      OSP-DB SET NULLID COLLECTION OWNER QSYS PROFILE AT BIND TIME
   SI47148      OSP-DB INTERNAL MAINTENANCE
   SI47147      OSP-DB INCORRECT RESULTS DISPLAYED WITH CLOB DATA.
   SI47006      OSP-DB-MSGSQL0802 ARRAY RESULT SET FAILING OVER DRDA
   SI46943      OSP-DB SPECIAL PACKAGE TO SWITCH NAMING MODE FOR SQL
   SI46777      OSP-DB-MSGSQL0518-F/QSQROUTS 3-PART DRDA SELECT FAILURE
   SI46664      OSP-DB INTERNAL MAINTENANCE FOR DRDA
   SI46612      OSP-DB-MSGMCH3601-F/QSQVATTR GLOBAL VARIABLE DRDA HETERO FAI
   SI46585      OSP-DB-MSGSQL0501 DRDA EXECUTE FAILURE CONTAINING PARAMETER
   SI46474      OSP-DB INTERNAL DRDA MAINTENANCE
   SI46358      OSP-DB-MSGMCH3601-F/QRWTBIND PACKAGE BIND FAILURE PRE-SQLAM6
   SI46264      OSP-DB-MSGMCH3601-F/QRWSSYNC-F/QCNSSPTH CNN DETACH DURING RE
   SI46127      OSP-DB-MSGMCH0601-F/QRWSEXEC C NULL TERMINATED STRING END OF
   SI46026      OSP-DB DRDA INTERNAL MAINTENANCE
   SI46004      OSP-DB-MSGMCH3402-F/QRWSARDB-T/QRWSARDB INITIALIZATION CLEAN
   SI45879      OSP-DB DRDA INTERNAL MAINTENANCE
   SI45866      OSP-DB-MSGSQL0805-F/QRWTQRY TARGET-SIDE ALIAS W/ STORED PROC
   SI45407      OSP-DB DRDA HETERO FAILURE USING DOUBLE BYTE DATATYPES
   SI45385      OSP-DB HETRO DRDA SQL ARRAY MISC FIXES
   SI45348      OSP-DB INCORRECT QRYDTA PARTIAL ROW DETERMINATION FOR EXACT
   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 SE66824
Superseded by:......................View fix details for PTF SI65565
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................NONE


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:
26 July 2017