PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-OTHER-INCORROUT ODBC SQLCOLUMNSW WILL FAIL WITH A CWBCO1
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
CO 5770SS1 V7R2M0 SI55642 00/00 0000
CO 5770SS1 V7R2M0 SI55641 00/00 0000
CO 5770SS1 V7R2M0 SI55644 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
-----------------------------------------------
After upgrade to V7R2 an ODBC application will fail to execute a
SQLColumnsW for the system and
a CWBCO1047 RC=8405 is posted. The QZDASOINIT joblog will show a
MSGMCH1210 F/QZDASRV T/QZDASRV.
CORRECTION FOR APAR SE67753 :
-----------------------------
The amount of redundant information returned on SQLColumns
request is limited with this fix. This will allow a large result
set to be successfully returned to ODBC. This fix is enabled by
creating a data area called QZDASQLCOL in the library list of
the qzdasoinit job. For example, the following command can be
used to create this data area.
CRTDTAARA DTAARA(QGPL/QZDASQLCOL) TYPE(*CHAR)
CIRCUMVENTION FOR APAR SE67753 :
--------------------------------
None.
Activation Instructions
None.
Special Instructions
None.
Default Instructions
THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.
Supersedes
PTF/FIX NO(S). APAR TITLE LINE
-------------- ------------------------------------------------------------
SI65462 OSP-DB STRDBMON FTRUSER including Close entries for other us
SI65177 OSP-DB Host Server servicability changes
SI65134 OSP-DB unlock ZDA Package when requested by user
SI64737 OSP-DB-OTHER-MSGSQL0904 A MSGSQL0904 MAY OCCUR WHEN A SQL PA
SI63825 OSP-DB unlock ZDA Package when requested by user
SI63688 OSP-OTHER-UNPRED TEMPORARY STORAGE IN QZDASOINT JOBS
SI63219 OSP QZDASOINIT JOBS STUCK IN JOBLOG PENDING STATE,
SI62479 OSP-DB INCORRECT FAIL FOR HOST SERVER EXIT PROGRAM ALTERNATI
SI60336 OSP-DBMSGMCH1210-F/QZDACMDP QZDASOINIT JOB FAIL TO SET REGIS
SI60294 OSP-DB DRDA query fails with incorrect cursor name error
SI60292 OSP-DB-MSGSQL0301 is seen intermittently
SI59433 OSP-HOSTSERVERS-OTHER-INCORROUT MSGCWBCO1047 FUNCTION USAGE
SI58182 OSP-DB Internal Maintenance
SI57488 OSP-HOSTSERVERS-OTHER-F/QZDASQL-MSGSQL7967 INCORRECT MESSAGE
SI56978 OSP-DB SYSTEM_USER register is not consistent
SI56746 OSP-HOSTSERVERS Missing Parameter Names
SI56641 OSP-DB-OTHER-F/DBBUILTINS-T/QDBGETMQO-MSGMSG0601 A MISMATCH
SI56640 OSP-DB-OTHER-RCVENDORCODE703-MSGPWS0042 RUNNING CONNECT TO W
SI55643 OSP-DB DNS LOOKUP DELAY FOR SQL CONNECT
SI55226 OSP-DB-OTHER-INCORROUT QZDASOINIT FAILS TO PROCESS ESCAPE CH
SI54552 OSP-DB-OTHER-INCORROUT ARRAY AS A PARM IN STORED PROCEDURE D
SI53970 OSP-HOSTSERVERS-PERFM QZDASRV PAGING
SI53794 OSP-DB-OTHER-INCORROUT WRONG ROW SIZE WITH UPDATABLE QUERIES
SI53153 OSP-HOSTSERVERS Input Compression Support
SI52993 OSP-MSGMCH3601 WORKING WITH POWERBUILDER AND ODBC MCH3601 AN
SI52877 OSP-HOSTSERVERS LIBRARY WITH LONG SCHEMA NAME NOT RETURNED U
SI52877 OSP-HOSTSERVERS-OTHER-INCORROUT MSGMCH0601 AND MSGSQL0904 FR
SI52877 OSP-DB-OTHER-F/QSQRUN2-MSGSQL0501 MSGSQL0501 F/QSQRUN2 X/221
SI52862 OSP-DB-OTHER-MSGSQL0189 MSGSQL0189 ISSUED WHEN CLICKED 'APPL
SI52862 OSP-DB-OTHER-MSGSQL0189 MSGSQL0189 ISSUED WHEN CLICKED 'APPL
SI52146 OSP-HOSTSERVERS Input Compression Support
SI51884 OSP-DB Internal Maintenance
SI51620 OSP-DB Internal Maintenance
Summary Information
System.............................. i
Models..............................
Release............................. V7R2M0
Licensed Program.................... 5770SS1
APAR Fixed.......................... View details for APAR SE67753
Superseded by:...................... View fix details for PTF SI85732
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C8032720
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, 2019, 2020, 2021, 2022, 2023, 2024 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:
12 March 2024