PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER-F/#CCCLAP-T/QSQRUN4-MSGMCH0601 JOB USING CCSID
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
CO 5770SS1 V7R2M0 SI63433 00/00 0000
CO 5770SS1 V7R2M0 SI63435 00/00 0000
CO 5770SS1 V7R2M0 SI62290 00/00 0000
CO 5770SS1 V7R2M0 SI58740 00/00 0000
CO 5770SS1 V7R2M0 SI58741 00/00 0000
CO 5770SS1 V7R2M0 SI55644 00/00 0000
CO 5770SS1 V7R2M0 SI55643 00/00 0000
DIST 5770SS1 V7R2M0 SI63631 00/00 0000
DIST 5770SS1 V7R2M0 SI60029 00/00 0000
DIST 5770SS1 V7R2M0 SI54177 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
-----------------------------------------------
The customer has found if they attempt to use a procedure with
job CCSID 933 and the procedure has "IN P_CLOB CLOB(5242880)" -
the job posts an SQL0901 and an MCH0601. The odd thing is if the
customer changes their CCSID of the job to 37 -the same call
works. If size of the clob is changed to "IN P_CLOB
CLOB(1048576)" - both CCSID's work.
Sample errors in the joblog:
MCH0601 Escape 40 06/15/17 05:03:14.093937 #ccclap 000534
QSQRUN4 QSYS *STMT
From user . . . . . . . . . : US0G9339
To module . . . . . . . . . : QSQCALLSP
To procedure . . . . . . . : MAP
Statement . . . . . . . . . : 30861
Message . . . . : Space offset X'00000000' or
X'000004046F600000' is outside
current limit for object QZDASOINITQUSER 244682.
Cause . . . . . : A program tried to set a space pointer, tried
to use
storage outside a space, or tried to use an unallocated page in
teraspace.
The space class is X'07'. The space class designates the type of
space:
00-primary associated space (includes space objects).
01-secondary
associated space 0. 02-implicit process space for automatic
storage.
03-implicit process space for static storage in activation group
mark
X'0000000000000000'. 04-implicit process space for heap
identifier
X'00000000' in activation group mark X'0000000000000000'.
05-constant space.
06-space for handle-based heap identifier X'00000000'.
07-teraspace offset
X'000004046F600000'. 08-teraspace for System i5 PASE memory
address
X'000004046F600000'. Offset X'00000000' only applies to storage
outside
teraspace. X'8000000000000000000004046F600000' is a pointer to
the teraspace
page or the start of the implicit process space for the
allocation.
SQL0901 Diagnostic 50 06/15/17 05:03:14.094052 QSQRUN4 QSYS
*STMT QSQRUN4 QSYS *STMT
From user . . . . . . . . . : US0G9339
From module . . . . . . . . : QSQCALLSP
From procedure . . . . . . : CLEANUP
Statement . . . . . . . . . : 43923
To module . . . . . . . . . : QSQCALLSP
To procedure . . . . . . . : CLEANUP
Statement . . . . . . . . . : 43923
Message . . . . : SQL system error.
Cause . . . . . : An SQL system error has occurred. The current
SQL
statement cannot be completed successfully. The error will not
prevent
other SQL statements from being processed. Previous messages may
indicate
that there is a problem with the SQL statement and SQL did not
correctly
diagnose the error. The previous message identifier was MCH0601.
Internal
error type 7018 has occurred. If precompiling, processing will
not continue
beyond this statement. Recovery . . . : See the previous
messages to
determine if there is a problem with the SQL statement. To view
the
messages, use the DSPJOBLOG command if running interactively, or
the WRKJOB
command to view the output of a precompile. An application
program
receiving this return code may attempt further SQL statements.
Correct any
errors and try the request again.
CORRECTION FOR APAR SE68313 :
-----------------------------
The problem had to do with padding based on the host variable
when padding wasn't required. The problem is fixed with this
PTF.
CIRCUMVENTION FOR APAR SE68313 :
--------------------------------
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
-------------- ------------------------------------------------------------
SI65912 OSP-DB Generate SQL for default permissions not correct
SI65848 OSP-DB-OTHER-F/QZDGDBGS-T/QSQRUN4-MSGSQL0204 INAV GENERATE S
SI65790 OSP-DB INTERNAL MAINTENANCE
SI65668 OSP-DB-OTHER-F/QZDGDBGS-T/QSQRUN4-MSGMCH0601 GENERATE SQL FA
SI65460 OSP-DB-QSQCALLSP-MSGMCH3601 when using SQL descriptor with S
SI65452 OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGMCH1210 MSGMCH1210 F/QSQ
SI65221 OSP-DB-OTHER-INCORROUT TRUNCATE STATEMENT NOT CLEARING RECOR
SI65171 OSP-DB-OTHER-INCORROUT MERGE SHOULD INSERT 2 RECORDS, ONLY 1
SI65142 OSP-DB-OTHER-F/QSYRVAUT-T/QSQPROC-MSGCPF2236 WHEN JAVA UDF S
SI65035 OSP-DB DATETIME PRECISION SET TO MAX INSTEAD OF ACTUAL AFTER
SI64638 OSP-DB Generate_SQL does not generate KEEP IN MEMORY YES
SI63810 OSP-DB INTERNAL MAINTENANCE
SI63647 OSP-DB INTERNAL MAINTENANCE
SI63642 OSP-DB INTERNAL MAINTENANCE
SI63630 OSP-DB-OTHER-F/QSQRUN4-MSGMCH0601 WHEN USING A QUERY DEFINED
SI63620 OSP-DB Improve Index Advisor storage management
SI63436 OSP-DB-OTHER-F/QSQCONN-MSGSQL0751 USING 3 PART NAME FROM A T
SI62941 OSP-DB-INCORROUT RUNSQLSTM TARGET RELEASE INCORRECT
SI62724 OSP-DB INTERNAL MAINTENANCE
SI62552 OSP-DB-MSGSQL0206 Setting Global Variable to Default Value A
SI62291 OSP-DB INTERNAL MAINTENANCE
SI61124 OSP-DB Embedded Create trigger uses program target release
SI58204 OSP-DB Embedded Create trigger uses program target release
SI62165 OSP-F/QQQSRVI1-T/QQQSVRTN-MSGCPF9898 SAVE AND RESTORE OF RPG
SI62105 OSP-DB Associate locator statement fails with variable
SI61881 OSP-DB INTERNAL MAINTENANCE
SI61412 OSP-DB INFRASTRUCTURE
SI61280 OSP-DB-OTHER-INCORROUT WRONG RUSSIAN CHARACTERS AFTER AN SQL
SI60557 OSP-F/QSQRUN3-T/QSQRUN3-MSGSQL0180 SQL INSERT FAILS WITH MSG
SI60533 OSP-DB-OTHER-UNPRED EXTERNAL PROCEDURE CANNOT BE RESTORED
SI60475 OSP-DB-MSGMCH3601 External Procedure Call with Basic Default
SI60317 OSP-DB THREAD_ID same for entire job
SI60161 OSP-DB-OTHER-UNPRED EXTERNAL PROCEDURE CANNOT BE RESTORED
SI60062 OSP-DB-OTHER-MSGSQL0723 TRIGGER FIRE SQL0723 THE VALUE OF PA
SI59990 OSP-DB Add PROCESS_ID and THREAD_ID global variables
SI60025 OSP-DB-OTHER-PERFM QDBSRVxx JOBS SLOWED BY NATIVE OPENS
SI59850 OSP-DB-QSQCALLSP-MSGMCH3601 Calling stored procedure using d
SI59850 OSP-DB Describe Parameter Marker incorrect for CALL with nam
SI59531 OSP-DB Add PROCESS_ID and THREAD_ID global variables
SI59304 OSP-DB-F/QSQROUTS-MSGSQ20226 Looping on SQ20226 when running
SI59303 OSP-MSGSQL0204 ASSOCIATE LOCATOR STATEMENT FAILS WITH MSGSQL
SI58948 OSP-DB-SQL Support optionally clearing SQLSTATE on truncatio
SI58739 OSP-DB INFRASTRUCTURE
SI58276 OSP-DB Internal Maintenance
SI58152 OSP-DB-MSGSQL0482 not returned on remote procedure
SI58081 OSP-DB Internal Maintenance
SI58060 OSP-DB-OTHER-MSGSQL0011 QSQGNDDL PROBLEM WITH WRAPPED COMMEN
SI57904 OSP-DB-OTHER-T/QSQRUN4-MSGMCH0601 MODULE QSQCALLSP PROCEDURE
SI57810 OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGMCH1210 ON A CREATE PROC
SI57524 OSP-DB-JRN-INCORROUT NO AUDIT JOURNAL ENTRY FOR CREATE OR RE
SI57455 OSP-DB incorrect output with truncate table
SI57394 OSP-DB-OTHER-THREADS-UNPRED RDB() SHOWS BLANK FOR AN RPG PGM
SI57081 OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON
SI56938 OSP-DB Internal Maintenance
SI56758 OSP-DB CPYFRMIMPF CAN RUN SLOW IF OVRDBF IS USED.
SI56719 OSP-DB Internal Maintenance
SI56667 OSP-DB Update SYSTRIGGERS to correct REMARKS column
SI56314 OSP-DB QUERY OF INVALID SQL FIELD DELAYS IN DNS LOOKUP FOR G
SI56135 OSP-DB Extend QSQPRCED() to include some QAQQINI options
SI56025 OSP-DB-OTHER-LOOP-T/QSQCMTSP-MSGMCH0601
SI55997 OSP-DB-OTHER-F/QDBCRTFI-T/QSQCRTT-MSGCPF3204 DECLARE GLOBAL
SI55642 OSP-DB DNS LOOKUP DELAY FOR SQL CONNECT
SI55635 OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 RUNSQLSTM FAILS
SI55609 OSP-DB-OTHER-UNPRED AUDIT JOURNAL ENTRY FROM COMMENT ON FOR
SI55397 OSP-DB Improve LOB locator performance during commit or roll
SI55298 OSP-DB-INCORROUT-MSGMCH3601 QSQGNDDL GENERATE_SQL procedure
SI55282 OSP-DB Internal Maintenance
SI55221 OSP-DB Internal Maintenance
SI55167 OSP-DB-OTHER-RC2-MSGSQL7049
SI55113 OSP-DB-OTHER-UNPRED QSQSVCDMP SPOOLED FILE CREATED
SI55050 OSP-DB-MSGMCH3402-F/QSQFETCH ARRAY RESULT SET CURSOR FETCH F
SI54968 OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
SI54719 OSP-DB Internal Maintenance
SI54718 OSP-DB INTERNAL MAINTENANCE
SI54680 OSP-DB INTERNAL MAINTENANCE
SI54624 OSP-DB-OTHER-T/QSQRUN4-MSGMCH1210 MODULE QSQMERGE
SI54395 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
SI54330 OSP-DB-MSGSQL1506 Generate SQL of a DDS file
SI54320 OSP-DB-OTHER-F/QQQVSEL-T/QSQRUN3-MSGCPI431B A MSGCPI431B MAY
SI54317 OSP-DB-MSGSQL0901-F/QSQTRNOWN TRANSFER OWNERSHIP FAILURE WIT
SI54181 OSP-DB-MSGMCH3402-F/QSQSETUP SQL PGM/SRVPGM IN QTEMP QRWTSRV
SI54123 OSP-DB INTERNAL MAINTENANCE
SI54113 OSP COMMENT ON FOR STORED PROCEDURE CAUSES A SYSROUTINE SYNC
SI54112 OSP-DB-OTHER-F/QDBSIGEX-T/QSQPROCR-MSGCPF5009 MSGCPF5009 MSG
SI54044 OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
SI53985 OSP-DB CREATE OR REPLACE sourced function not replacing corr
SI53913 OSP-DB ADD LOCK TABLE SUPPORT MULTIPLE MEMBER FILES
SI53862 OSP-DB INTERNAL MAINTENANCE
SI53709 OSP-DB SQL procedure parameter DEFAULT value in SYSPARMS mis
SI53694 OSP-DB DBMON 1000 QVC1C EXPLAINABLE INCORRECT SET FOR SP PRE
SI53632 OSP-DB-MSGSQL0435 sent for a SIGNAL statement with a warning
SI53613 OSP-DB-MSGMCH3601-F/QQQSRVE1-T/QQQSRVE1 GLOBAL VAR FAIL ON V
SI53553 OSP-DB-MSGSQL0901 Calling procedure by program name when par
SI53375 OSP-DB Internal Maintenance
SI53250 OSP-DB INTERNAL MAINTENANCE
SI53222 OSP-DB-OTHER-F/QQQSRVE1-T/QSQRUN3-MSGCPD4373 A MSGCPD4373 MA
SI53141 OSP-DB Internal Maintenance
SI53112 OSP-DB INTERNAL MAINTENANCE
SI53068 OSP-DBMSGSQL0313-F/QSQRUN4 NULL SQL ARRAY VAR PROC OUTPUT FA
SI52974 OSP-DB-F/QSQVARSERV-MSGMCH3601 CPYF of table that uses row a
SI52900 OSP-DB Internal maintenance
SI52889 OSP-DB Internal Maintenance
SI52841 OSP-F/QSQRUN4-T/QSQRUN4-MSGMCH1210 SIGNAL STATEMENT TRIGGER
SI52830 OSP-DB-OTHER-INCORROUT GENERATE SQL TRANSLATING '/' TO '.'
SI52830 OSP-DB-OTHER-F/QZDGDBGS-T/QSQRUN4-MSGMCH1210 MSGMCH1210 F/QZ
SI52797 OSP-DB-SQL Dynamic Compound Statement Support
SI52682 OSP-DB-MSGSQL0423 running a SQL routine that has LOBs
SI52609 OSP-DB INTERNAL MAINTENANCE
SI52538 OSP-DB-OTHER-T/QSQPROC-MSGSQL0913 DROPPING A SQL PROCEDURE
SI52538 OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGMCH3601 A MSGMCH3601 F/Q
SI52509 OSP-DB CPF4101 SYSROUTINE NOT FOUND DURING CRTDUPOBJ
SI52463 OSP-DB INTERNAL MAINTENANCE
SI52463 OSP-DB SQL0180 Calling RPG External Stored Procedure
SI52341 OSP-DB-OTHER-T/QSQRUN4X/19306-MSGSQL0204 WITH OVRDBF, MERGE
SI52341 OSP-DB QIBM_SQL_NO_CATALOG_UPDATE should include Rename Libr
SI52341 OSP-DB-OTHER-T/QSQROUTX-MSGMCH0602
SI52269 OSP-DB INTERNAL MAINTENANCE
SI52269 OSP-DB-OTHER-MSGSQL0443 SERVICEABILITY ENHANCEMENT
SI52192 OSP-DB INTERNAL MAINTENANCE
SI52015 OSP-DB-MSGSQL0150 Running TRUNCATE against a SQL catalog tab
SI52013 OSP-DB INTERNAL MAINTENANCE
SI51983 OSP-DB Internal Maintenance
SI51925 OSP-DB Internal Maintenance
SI51909 OSP-DB INTERNAL MAINTENANCE
SI51889 OSP-DB INTERNAL MAINTENANCE
SI51823 OSP-DB-OTHER-MSGCPF5129-T/QSQRUN4 MODULE QSQMERGE
SI51823 OSP-DB Internal Maintenance
SI51756 OSP-DB Internal Maintenance
SI51756 OSP-DB-OTHER-INCORROUT truncating alias
SI51688 OSP-DB Generate SQL for EVI index with include columns not c
SI51688 OSP-UNPRED CRTDUPOBJ AND MOVOBJ OF PROGRAM REMOVES CATALOG R
SI51628 OSP-DB-OTHER-LOOP QSQAPIS/sqludf_create_locator
SI51595 OSP-DB Internal Maintenance
SI51530 OSP-DB Incremental Enhancement
SI51473 OSP-DB Internal Maintenance
SI51449 OSP-DB-MSGSQL0901-F/QSQGTSPC using LOBs in sql procedure
SI51431 OSP-DB-MSGSQL0901-F/QSQGTSPC using LOBs in sql procedure
SI51381 OSP-DB Internal Maintenance
SI51364 OSP-DB-OTHER-UNPRED SYSTEM SQL APPEARS IN STRDBMON WHEN INCS
SI51364 OSP-DB-OTHER-LOOP QSQRUN4/QSQCALLSP/MAP_WITH_CCSIDS
SI51283 OSP-DB Internal Maintenance
SI51236 OSP-DB-OTHER-MSGSQL0206 global variable is not found on the
SI51236 OSP-DB-OTHER-INCORROUT SETOPTION does not work with paramete
SI51236 OSP-DB Internal Maintenance
SI51236 OSP-DB Support compatible date/time strings in input arrays
SI51463 OSP-DB INTERNAL MAINTENANCE
Summary Information
System.............................. i
Models..............................
Release............................. V7R2M0
Licensed Program.................... 5770SS1
APAR Fixed.......................... View details for APAR SE68313
Superseded by:...................... View fix details for PTF SI85799
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C8249720
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