IBM Support

SI68550 - OSP-DB-OTHER-F/#CFOCHKR-T/QSQRUN3-MSGMCH3603 MCH3603 SQL0901

PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-F/#CFOCHKR-T/QSQRUN3-MSGMCH3603 MCH3603 SQL0901


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770SS1  V7R2M0    SI65955   00/00    0000
CO   5770SS1  V7R2M0    SI68409   00/00    0000
CO   5770SS1  V7R2M0    SI65934   00/00    0000
CO   5770SS1  V7R2M0    SI65933   00/00    0000
CO   5770SS1  V7R2M0    SI65781   00/00    0000
CO   5770SS1  V7R2M0    SI55801   00/00    0000
CO   5770SS1  V7R2M0    SI53866   00/00    0000
DIST 5770SS1  V7R2M0    SI66169   00/00    0000
DIST 5770SS1  V7R2M0    SI64148   00/00    0000
DIST 5770SS1  V7R2M0    SI60514   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

-----------------------------------------------
Specific SQL statements fail with MCH3603 F/#CFOCHKR T/QSQRUN3
and SQL0901 since PTF maintenance.

CORRECTION FOR APAR SE70121 :
-----------------------------
The problem is fixed with this PTF.

CIRCUMVENTION FOR APAR SE70121 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI68428      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH3402 MSGMCH3402 F/QSQ
   SI68408      OSP-DB-OTHER-UNPRED SERVICEABILITY CHANGE-PROGRAM GROWTH INF
   SI68408      Intermittent MCH3203 to QSQRUN2, MODULE QSQFETCH after repea
   SI68408      OSP-MSGSQL0913 LONG LOCK WAIT ON PROGRAM DUE TO ACCESS PLAN
   SI68357      OSP-DB-OTHER-T/QQQSRVE1-MSGMSGMCH3601 STORED PROCEDURE CALLS
   SI68035      OSP-DB-OTHER-F/QSQRUN3X/33243-MSGSQL0519 INSERT INTO ...SELE
   SI67980      OSP-DB INFRASTRUCTURE
   SI67956      OSP-DB-MSGMCH0601-T/QSQINS Procedure CLEANUP
   SI67932      OSP-DB thread scoped locks keep increasing
   SI67846      OSP-DB-OTHER-WAIT LCKW
   SI67679      OSP-DB-MSGSQL0511 with prepare attributes
   SI67489      OSP-DB-OTHER-INCORROUT INCORROUT SQL PROGRAM WITH STATIC SQL
   SI67444      OSP-DB-QSQSFCLS-MSGMCH1210 and looping after error on Select
   SI67217      F/#DBDDS-MSGMCH3406 MCH3406 F/#DBDDS T/QDBDLTFI TP/DLTMEM ON
   SI67003      OSP-DB Incorrect ALWCPYDTA value used
   SI66639      OSP-DB-PERFM-Improvement in extended dynamic prepares with l
   SI66613      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0509 WHEN STORED PROC
   SI66581      OSP-DB-MSGMCH3603 with multiple nesting of triggers
   SI66574      OSP-DB-OTHER INSERTS OF BLOB FIELDS TO IBM I DATABASE FROM A
   SI66573      OSP SQL INSERT WRITING INTO THE WRONG MEMBER IN APPLICATION
   SI66561      OSP-MSGSQL0138-D/TQSQRUN3-PAR WHEN CALLING A STORED PROCEDUR
   SI66514      OSP-DB-OTHER-F/QSQRUN1X/19980-T/T/SAME-MSGMCH3601 BANKING AP
   SI66507      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0519 PREPARE LOCK PAC
   SI66501      OSP-MSGMCH3601-PAR-940XBASE RPG SQL APPLICATION RETURNS MCH3
   SI66483      OSP-DB-MSGSQL0171 with insert statement
   SI66382      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGMCH3601 SQL0901 MCH3601
   SI66175      F/QSQRUN1-MSGSQL0904-RC160-MOD/QSQDESC F/QSQRUN1-MSGSQL0904-
   SI66171      OSP-DB-OTHER-UNPRED MERGER STATEMENT WITH AN UPDATE OPERATIO
   SI66134      OSP-DB-MSGMCH3601 and SQL0901 from Update Attempt of Not Yet
   SI66066      F/#CFOCHKR-MSGMCH3603 MSGMCH3603 MCH3603 F/#CFOCHKR X/000C2C
   SI66001      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4301 CPD4301 SQL0901
   SI65935      OSP-DB-OTHER-UNPRED DUPLICATE STATEMENT NAMES IN SQLPKG
   SI65881      OSP-DB FETCH N ROWS clause with PREPARE ATTRIBUTE
   SI65858      OSP-DB INTERNAL MAINTENANCE
   SI65782      OSP-DB INTERNAL MAINTENANCE
   SI65572      OSP-DB Internal Maintenance
   SI65518      OSP-F/QSQROUTS-T/QSQROUTS-MSGSQL0518 REUSE OF SELECT FROM IN
   SI65507      OSP-DB INTERNAL MAINTENANCE
   SI65450      OSP-DB-OTHER-INCORROUT FRENCH CHARATER ' ' ('C0'X) IS DISPLA
   SI65325      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0913 SELECT FOR FET
   SI65158      OSP-DB Performance improvement of Insert with remote subsele
   SI65045      OSP-DB INTERNAL MAINTENANCE
   SI65034      OSP-DB-PERFM Improve performance of OPEN statements in stati
   SI64952      OSP-DB-OTHER-F/#COMOOBJ-T/QTNOPNCLS-MSGMCH6221 VLF000702
   SI64910      OSP-DB-MSGSQL0206 with GVAR in remote drda job
   SI64783      OSP-DB Internal Maintenance
   SI64748      OSP-DB-OTHER-MSGMCH3601-T/QSQPREP PROCEDURE CLEANUP
   SI64721      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0913 CODE ADDED TO AI
   SI64524      OSP-OTHER-UNPRED CURSOR IS BEING HARD CLOSED DUE TO INTERNAL
   SI64524      OSP SEVERAL QSQSVCDMP DUMPS FROM QZDASOINIT JOBS.
   SI64524      OSP-MSGCPD4306-D/TQSQOPEN-PAR DECLARE CURSOR STATEMENT IN EM
   SI64524      OSP-DB-OTHER-PERFM OSP-DB-OTHER-PERFM
   SI64285      OSP-DB-OTHER-INCORROUT INTERMITTENT PROBLEM INCORROUT OUTPUT
   SI64222      OSP-DB-MSGMCH0601-F/QSQSTATS CREATE TABLE AS statement WITH
   SI64147      OSP-UNPRED ENDDBMON OF DBMON WITH PARM HOSTVAR(*CONDENSED) L
   SI64137      OSP-DB-OTHER-INCORROUT STORED PROCEDURE WITH IDENTITY_VAL_LO
   SI63973      OSP-DB-OTHER-T/QSQSBAS2-MSGMCH1210 MODULE QSQSFCRT
   SI63864      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0904 SQL JOB FAILS WI
   SI63789      OSP-DB Intermittent SQL failures with JDE workloads
   SI63785      OSP-DB-OTHER-PERFM POOR ESTIMATE FOR UDTFS USED BY OBJECT_ST
   SI63640      OSP-DB INTERNAL MAINTENANCE
   SI63295      F/QSQRUN2-MSGSQL0326 SQL RPG PROGRAM FAILS WITH SQL0326. SEL
   SI63435      OSP-DB-OTHER-F/QSQCONN-MSGSQL0751 USING 3 PART NAME FROM A T
   SI63381      OSP-DB-OTHER-F/QSQLOPEN-MSGMCH3601 WHEN ANOTHER PROGRAM WAS
   SI63381      OSP-DB-OTHER-UNPRED EMBEDDED SQL STATEMENTS IN RPGLE PROGRAM
   SI63282      OSP-DB-OTHER-T/QSQRUN3-MSGMCH3601 MODULE QSQOPEN PROCEDURE D
   SI63254      OSP-DB-OTHER MSGMCH0601 F/< INGHIGHUSE X/000118 T/QSQRUN3
   SI63248      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGMCH3601 MCH3601 MCH1210
   SI63214      OSP-DB-OTHER-UNPRED INFORMATIONAL QSQSVCDMP SPOOL FILES ARE
   SI63064      OSP-DB Internal Maintenance
   SI62909      OSP-DB-MSGCPF3272 long running cli job
   SI62772      OSP-DB-OTHER-T/QSQSBAS2-MSGMCH5804 SQL0901 LOCK SQL PACKAGE
   SI62259      OSP-DB-OTHER-THREADS-PERFM SPACE LOCATION LOCKS ARE NOT BEIN
   SI62163      F/QRWSQRY-MSGCPD3E06 F/QRWSQRY-MSGCPD3E06
   SI62113      OSP-DB Incorrect diagnostics from stored procedure
   SI61903      OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
   SI61405      OSP-DB INFRASTRUCTURE
   SI61068      OSP-DB-OTHER-F/EX3E06COMMITRESOURCELIMITEXCEEDED-T/QDBGETMQO
   SI61056      OSP-DB reuse remote server job for 3 part SQL
   SI60881      OSP-DB-QSQOPEN-MSGMCH3601 on EXECUTE IMMEDIATE with DRDA
   SI60881      OSP-DB-OTHER-F/QSQRUN3/QSQINS-MSGSQL0913X/31981 UPDATE FAILS
   SI60785      OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH1210 MCH1210 F/QQQS
   SI60740      OSP-DB-MSGMCH0601 insert with remote subselect
   SI60716      OPS - DB MCH3601 instead of SQL0503 when Attempting to Updat
   SI60615      OSP GET DIAGNOSTICS SQL STATEMENT DOES NOT RETURN CORRECT SQ
   SI60554      OSP-F/QSQRUN3-T/QSQRUN3-MSGSQL0180 SQL INSERT FAILS WITH MSG
   SI60478      OSP-DB-PERFM Slow performance when using SQL packages in mul
   SI59955      OSP-DB-OTHER-F/QSQPREP-MSGSQL0580 when 3rd argument of TIMES
   SI59917      OSP-DB Return DB2_ROW_LENGTH on OPEN
   SI59848      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0518 SECOND STORED
   SI59848      OSP-DB-OTHER-F/QSQSBAS2X/2815-T/SAME-MSGMCH1210 CPYF RSULTS
   SI59848      OSP-DB-QQQOOOSETS-MSGMCH5003 using CURRENT DECFLOAT ROUNDING
   SI59666      OSP-OTHER-PERFM SELECT FROM INSERT QUERY STARTED PERFORMING
   SI59623      OSP-DB-OTHER ADD PACKAGE INFORMATION TO SYSLIMITS CATALOG
   SI59593      OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
   SI59526      OSP-DB-OTHER-F/QSQRUND-T/QSQRUN3-MSGSQL0901 A MSGSQL0901 F/Q
   SI59499      OSP-HOSTSERVERS-OTHER-INCORROUT RANDOM DATA TYPRE MISMATCH
   SI59124      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-RC2-MSGSQL0101 SQL RPG OBJE
   SI59093      OSP-DB-MSGMCH3601-F/QSQDESC SET STATEMENT FAILURE
   SI59014      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4301 ON RUNNING A PRO
   SI58978      OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
   SI58970      OSP-DB-OTHER-F/QSQRUN3-MSGSQL0517
   SI58965      OSP-DB Wrong DB2_NUMBER_ROWS WITH OFFSET
   SI58950      OSP-DB-SQL Support optionally setting indicator on truncatio
   SI58929      OSP-DB-OTHER-RC8-MSGCPDB8E4 TRYING TO VARY OFF IASP
   SI58647      OSP-DB-OTHER-MSGCPF3220 TRYING TO DELETE A TEMP TABLE AFTER
   SI58366      OSP-DB-OTHER-THREADS-MSGMCH0601 MCH0601
   SI58277      OSP-DB-OTHER-T/QQQIMPLEX/16106-MSGCPF4287 USING 3-PART NAMIN
   SI58225      OSP-DB-OTHER-INCORROUT QSQSVCDMP DOESN'T GO TO THE QEZDEBUG
   SI58190      OSP-DB-OTHER-F/QQQQUERY-T/QQQQUERY-MSGMCH3601 OCCURRING INTE
   SI58172      OSP-DB insert with source table is in IASP
   SI58078      OSP-DB Internal Maintenance
   SI58075      OSP-DB-OTHER-SAP400-F/#CFOCHKR-T/QSQRUN1-MSGMCH3402 MSGMCH58
   SI58002      OSP-DB-OTHER-MSGSQL0335 NOT ISSUED AS WARNING
   SI57937      OSP-INCORROUT AFTER INSERT EXTERNAL TRIGGER FIRED BY AN INSE
   SI57919      OSP-DB-OTHER-MSGSQL0335 NOT ISSUED AS WARNING
   SI57836      OSP-DB-OTHER-F/QSQCONN-T/QSQCONN-MSGSQL0950 MSGSQL0950 AND M
   SI57603      OSP-DB-OTHER-T/QSQRUN1-MSGMCH3601 ON SECOND PREPARE OF A MER
   SI57490      OSP-MSGCPF4268 DIFFERENT BEHAVIORS FOR BATCH VS INTERACTIVE
   SI57261      OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
   SI57217      OSP-DB-OTHER-THREADS-F/QSQRUN1-T/QSQRUN1-MSGSQL0904 SQL0904
   SI57217      OSP-DB-OTHER-INCORROUT HETEROGENEOUS DRDA CONNECTION NOT GET
   SI57167      OSP-DB INSERT OF VARGRAPHIC DATA RESULT IN SQL0404
   SI57108      F/QSQCONN-MSGSQL0950 SQL0950 ERROR HIT WHEN RPG WITH EMBEDDE
   SI57099      OSP-DB-OTHER-T/QSQDDL1-MSGMCH1210 MODULE QSQACTNM ON AN INSE
   SI57080      OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON
   SI56949      OSP-DB-OTHER-F/QQQISVSU-T/QSQRUN3-MSGCPD4372 A MSGCPD4372 MA
   SI56834      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
   SI56548      OSP-OTHER-INCORROUT UNICODE TRANSLATION INTERMITTENTLY FAILS
   SI56337      OSP-DB-OTHER-INCORROUT INCORRECT DATA IN CLOB FIELD.
   SI56185      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0407 INSERT STATEMENT
   SI56138      OSP-DB Extend QSQPRCED() to include some QAQQINI options
   SI56010      OSP-DB-OTHER-UNPRED MSGSQL0104 FOR VALID SQL STATEMENT AFTER
   SI55932      OSP-DB incorrect sqlcode returned on INSERT
   SI55798      OSP-DB DRDA SERVER IMPLICIT COMMIT AFTER IMPLICIT QUERY CLOS
   SI55651      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4302 ON A QUERY FROM
   SI55528      OSP-DB QSQPRCED() creates package using a larger capacity *S
   SI55517      OSP-DB Internal Maintenance
   SI55441      OSP-DB SQL Statement Operation blank in SQL Plan Cache
   SI55420      OSP-DB-OTHER-T/QSQRUN3-MSGCPD4301 AFTER ALTER TABLE
   SI55309      OSP-DB-OTHER-T/QSQSBAS2-MSGMCH3603 MODULE/QSQHDCLSm PROCEDUR
   SI55284      OSP-DB Internal Maintenance
   SI55271      OSP-DB-OTHER-T/QSQSBAS-MSGMCH1210 MODULE QSQVATTR PROCEDURE
   SI55220      OSP-DB Internal Maintenance
   SI55116      OSP-DB-OTHER-UNPRED QSQSVCDMP SPOOLED FILE CREATED
   SI54941      OSP-DB-MSGSQL0502 after query with 3 part name
   SI54869      OSP-DB-OTHER-UNPRED UPDATING A TABLE WITH BOTH A NULLABLE FI
   SI54696      OSP-DB Internal Maintenance
   SI54622      OSP-DB APPLICATIONS GETTING MSGMCH0601 T/QSQRUN2 MOD/QSQFETC
   SI54585      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3601
   SI54310      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3601
   SI54090      OSP-DB-MSGSQL0407-F/QSQINS SQL INSERT OR UPDATE MISSING MSG
   SI54068      OSP-DB DISPLAY LONG FIELD NAMES FOR SOME SQ MESSAGES
   SI54061      OSP-DB DISPLAY LONG FIELD NAMES FOR SOME SQ MESSAGES
   SI54038      OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
   SI53987      OSP-DB-MSGSQ20478 after DEACTIVATE COLUMN ACCESS CONTROL
   SI53865      OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QSQROUTX-MSGMCH0601 MCH3601
   SI53849      OSP-DB-OTHER-UNPRED PROGRAM WITH EMBEDDED SQL CONTINUALLY GR
   SI53593      OSP-DB-OTHER-UNPRED SERVICEABILITY CHANGE
   SI53437      OSP-DB-OTHER-T/QSQALCDS-RC542-MSGSQL0904
   SI53363      OSP-MSGSQL0312 STORED PROCEDURE RUNNING INSERT W/SUBSELECT W
   SI53066      OSP-DB-OTHER-F/QSQSBAS2-T/QSQSBAS-MSGSQL0901 MSGSQL0901 F/QS
   SI52868      OSP-DB-OTHER COMPRESS OF PACKAGE NOT OCCURRING
   SI52848      OSP-DB-OTHER-INCORROUT SQL CALL LEVEL INTERFACE GRAPHIC PARA
   SI52833      OSP-DB-F/QSQUPDAT-MSGMCH3601 processing SQ20478 error during
   SI52833      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH0601 MSGMCH0601 F/QSQ
   SI52833      OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QSQRUN2/QSQFETCH-MSGMCH0601
   SI52791      SP/QSQRUN3-MSGSQL0511-MOD/QSQOPEN-OPCS/CLEANUP SQL SELECT UN
   SI52537      OSP-DB Internal Maintenance
   SI52340      OSP-DB INTERNAL MAINTENANCE
   SI52340      OSP-DB DRDA AS detail in the SQL Plan Cache is incomplete
   SI52251      OSP-DB-OTHER-F/QDBIOERRQO-T/QDBIOERRQO-MSGCPF503E UDF RUNNIN
   SI52229      OSP-DB Internal Maintenance
   SI51981      OSP-DB Internal Maintenance
   SI51824      OSP-DB Internal Maintenance
   SI51776      OSP-DB Internal Maintenance
   SI51681      F/QSQROUTS-MSGSQL0404 MSGSQL0404 F/QSQROUTST/QSQROUTS
   SI51578      OSP-DB Internal Maintenance
   SI51560      OSP-DB INTERNAL MANTENANCE
   SI51523      OSP-DB Internal Maintenance
   SI51468      OSP-DB Internal Maintenance
   SI51390      OSP-DB MCH1210 F/T: QSQSTATS/QSQSTATS
   SI51367      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-RC'0100E'-MSGSQL0464 SQL0
   SI51284      OSP-DB Internal Maintenance
   SI51238      OSP-DB Internal Maintenance
   SI51238      OSP-DB-MSGMCH3601-F/QSQCONN MIXING DDM/DRDA CNN FIX
   SI51238      OSP-DB INTERNAL MAINTENANCE

Summary Information

System.............................. i
Models..............................
Release............................. V7R2M0
Licensed Program............... 5770SS1
APAR Fixed.......................... View details for APAR SE70121
Superseded by:...................... View fix details for PTF SI69621
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C9123720


IBM 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, 2019 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.

Document information

More support for: i family

Software version: V7R2M0

Operating system(s): OS/400

Reference #: SI68550

Modified date: 08 November 2018