IBM Support

SI66154 - OSP-DB-OTHER-F/#CCCLAP-T/QSQRUN4-MSGMCH0601 JOB USING CCSID

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2.0","Product":{"code":"SWG60","label":"IBM i"},"Component":"5770SS1","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
12 March 2024