IBM Support

SI63148 - OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN1-MSGCPD4308 CPD4308 F/QQQVFM

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN1-MSGCPD4308 CPD4308 F/QQQVFM


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770SS1  710  SI60272   00/00    0000
CO   5770SS1  710  SI58131   00/00    0000
CO   5770SS1  710  SI57581   00/00    0000
CO   5770SS1  710  SI57266   00/00    0000
CO   5770SS1  710  SI52858   00/00    0000
CO   5770SS1  710  SI50741   00/00    0000
CO   5770SS1  710  SI50047   00/00    0000
CO   5770SS1  710  SI50048   00/00    0000
CO   5770SS1  710  SI50044   00/00    0000
CO   5770SS1  710  SI50045   00/00    0000
CO   5770SS1  710  SI48080   00/00    0000
CO   5770SS1  710  SI48018   00/00    0000
CO   5770SS1  710  SI47544   00/00    0000
CO   5770SS1  710  SI44496   00/00    0000
CO   5770SS1  710  SI43995   00/00    0000
CO   5770SS1  710  SI41354   00/00    0000
DIST 5770999  710  MF60073   00/00    0000
DIST 5770999  710  MF54634   00/00    0000
DIST 5770999  710  MF53588   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

-----------------------------------------------
CPD4308 f/QQQVFMT t/QSQRUN1 followed by SQL0901

CORRECTION FOR APAR SE66167 :
-----------------------------
An issue was found where a numeric field could be assigned a
CCSID which caused a function check to trigger. A CCSID will no
longer be assigned to numeric fields.

CIRCUMVENTION FOR APAR SE66167 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI62565      OSP-DB-OTHER-F/QQQDBLOG-T/QSQSTATS-MSGCPD4382 DBMON ON A HIG
   SI62000      OSP-DB-OTHER-F/QQQVEXPL-MSGMCH1210 TRYING TO OPEN VISUAL EXP
   SI61198      OSP-DB STRDBMON HOSTVAR(*CONDENSED) missing host variables w
   SI61084      OSP-DB-OTHER-THREADS-F/QC2UTIL1-T/QQQSVUSR-MSGMCH3601 TO_DAT
   SI60610      OSP-DB-OTHER-INCORROUT Plan Cache VE is showing 0 for rows f
   SI60273      OSP-DB Internal Database Maintenance
   SI60171      OSP-DB Ensure end job processing for cleans up all query obj
   SI60108      OSP-DB Internal Database Maintenance
   SI59706      OSP-DB Internal Database Maintenance
   SI59352      OSP-DB Internal Database Maintenance
   SI58333      OSP-DB-OTHER MSGMCH6903 T/QC2UTIL1 CAN BE SEEN WHEN THE REGE
   SI58130      OSP-DB-MSGSQL0443 MCH1210 When Visual Explaining a query wit
   SI58112      OSP-DB-OTHER-F/QQQUDFHL-T/QSQRUN3-MSGCPF426A A MSGCPF426A MA
   SI58006      OSP-DB-OTHER Additional Scalar Support
   SI57914      OSP-DB MUTEX BUILD UP DUE TO DATABASE CODE.
   SI57892      OSP-XTND-OTHER-F/QDBSIGEX-T/QDZXDBI-MSGCPF5257 CPF5257, SQL0
   SI57732      OSP-DB-MSGMCH3601 in QQQSETUP for query of laterally correla
   SI57580      OSP-DB STRDBMON Filter Operator Support
   SI57510      F/QQQQUERY-MSGCPD438C CPD438C REASON CODE 18 IS RECEIVED WHE
   SI57334      OSP-DB-OTHER Scalar Function Error Support
   SI57267      OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
   SI56926      OSP-DB-OTHER Scalar Function Support
   SI56809      OSP-FieldProc using wrong usrprf after PROFILE HANDLER (QSYG
   SI56664      OSP-DB-OTHER Scalar Function Support
   SI56227      OSP-DB-OTHER-THREADS-WAIT qqcatlup in THDW
   SI56212      OSP-DB-OTHER Scalar Function Support
   SI56093      OSP-DB-OTHER Scalar Function Support
   SI56060      OSP-DB-OTHER-F/QQQVEXPL-MSGMCH3601 ON VISUAL EXPLAIN OF A ME
   SI55913      OSP-DB-OTHER Scalar Function Support
   SI55325      OSP-DB-MSGMCH3601 f/QQQVFMT when using UDFs as parameters to
   SI55157      OSP-DB Internal Maintenance
   SI55107      OSP-DB-OTHER-MSGSQL0462 THE MESSAGE TEXT IN THE SQL0462 ERRO
   SI55079      OSP-DB-OTHER-F/MNRESOLVECONTEXT-T/QQQUDFAC-MSGMCH3401 A VARY
   SI54978      OSP-DB-INCORROUT Query of SQL view with lateral correlation
   SI54707      OSP-DB database monitor fixes for the STRDBMON HOSTVAR parm.
   SI54685      OSP-DB REGEXP Scalar Function Support
   SI54592      OSP-DB database monitor fixes for the STRDBMON HOSTVAR parm.
   SI54588      OSP-DB REGEXP Scalar Function Support
   SI54547      OSP-DB-INCORROUT Extra call to table function with CLOB outp
   SI54514      OSP-DB database monitor service option for the 3010 record
   SI54161      OSP-DB Support 10 User Profiles on the FTRUSER parameter on
   SI54161      OSP-DB Support HOSTVAR parameter on STRDBMON command
   SI54104      OSP-DB-OTHER-F/QQQEXIT-T/QQQEXIT-MSGMCH3402 MSGMCH3402 F/T/Q
   SI54037      OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
   SI53925      OSP-DB LPAD and RPAD Scalar Function Support
   SI53595      OSP-DB-OTHER Improved ability to change File Filtering choic
   SI53424      OSP-DB INTERNAL MAINTENANCE
   SI53288      OSP-DB CURSOR BEING HARD CLOSED.
   SI52857      OSP-DB-MSGCPD4301 f/QQQVFMT t/QSQRUN3 running query with lat
   SI52679      OSP-DB MSGMCH3402 F/QQQQEXIT on job completion
   SI51972      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4308 ON A SELECT FROM
   SI51375      OSP-DB Visual Explain, Not able to explain a query with very
   SI51368      OSP-DB Function & Procedure with same name not correctly reg
   SI51227      OSP-DB-MSGMCH3203 F/#DBRESEQ T/QDBGETM SQL query with scalar
   SI51157      OSP-DB-OTHER-INCORROUT INCORROUT IN QUERY WITH LOB DATA AND
   SI50971      OSP-DB-OTHER-F/QQQDBLOG-MSGCPD4382 STRDBMON *ALL FAILS WITH
   SI50821      OSP-DB-MSGMCH1210 when using DBMON with Filter
   SI50821      OSP-DB-OTHER- DBMON records are not being filtered out when
   SI50821      OSP-DB-MSGMCH1210 when using DBMON with Filter
   SI50740      OSP Database Field Procedure Enhancements
   SI50046      OSP-DB Support for Debug of Scalar UDFs with Data Studio
   SI49941      OSP-DB-INCORROUT External user-defined function with BINARY
   SI49836      OSP-DB-OTHER-PERFM SETTING THE INITIAL NUMBER OF RECORDS FIL
   SI49401      OSP-DB-MSGCPD4382 - Internal maintinence.
   SI49397      OSP-DB-OTHER-T/QSQRUN3X/36556-MSGCPF426A RUNNING SQL PROCS R
   SI49244      SQL-DB-PERFM Index advise for ORed predicates
   SI48905      OSP-DB-QQQUDFHL-MSGCPF426A Reason code 2 when invoking UDF
   SI48629      OSP-DB INTERNAL MAINTENANCE
   SI48585      OSP-DB-OTHER-LOOP WHEN TEMPORARY INDEX IS BEING USED IN A QU
   SI48585      OSP-DB-MSGMCH3401-QQQRYFTR DBMON QUERY FILTER
   SI48523      OSP-F/QSQEVENT-T/QQQSVDBG-RC1-MSGSQL0952 MSGSQL0952 F/QQQSVD
   SI48145      OSP-DB-MSGMCH3601 f/QQQVFMT t/QQQVFMT UDF sourced on built-i
   SI48145      OSP-DB INTERNAL MAINTENANCE
   SI48145      OSP-DB-MSGMCH3601-F/ExSndPm-T/QQQOOODBOP QQQOOOINV when File
   SI48067      OSP-DB-OTHER Changes to Parallel_Degree *OPTIMIZE percentage
   SI48019      OSP-DB INTERNAL MAINTENANCE
   SI47931      OSP-DB-OTHER-F/QDBCLRPF-T/QQQSTRDM-MSGCPF3156 CUSTOMER IS UN
   SI47750      OSP-DB-PERFM Database Monitor performance improvements
   SI47628      OSP-MSG"AREQUIREDROWISNOTFOUNDINTHEMONITORFILE." VISUAL EXPL
   SI47545      OSP-DB-OTHER-MSGSQL0681 SQL0681 FOR INSERT INTO TABLE WITH F
   SI47460      OSP-DB CPD4374 QQQOOOSETS fails with DATE function
   SI47402      OSP-DB CPD4318 F/QQQVFMT T/QSQCRTV - SQL0137 F/QSQCRTV T/QSQ
   SI47293      OSP-DB Add the real user to the database monitor 3018 record
   SI47181      OSP-DB-OTHER-UNPRED READS AND UPDATES CONSUME STORAGE FOR FL
   SI47114      OSP-DB-OTHER-F/QQQSTRDM-MSGCPF9898 MAXIMUM OF 10 MONITORS AL
   SI47045      OSP-DB Visual Explain, Not able to explain a query access pl
   SI46647      OSP-DB-OTHER-F/QQQSTRDM-MSGCPF9898 SERVICE AGENT MONITOR
   SI46645      OSP-DB-UNPRED Fieldproc problem with error handling
   SI46620      OSP-DB-MSGSQL0171 query with XMLTABLE syntax
   SI46597      OSP-DB-INCORROUT SYSIXADV table has bad data in MTI columns
   SI46464      OSP-DB INTERNAL MAINTENANCE
   SI46351      OSP-DB-MSGSQL0104 XMLTABLE support
   SI46318      OSP-DB INTERNAL MAINTENANCE
   SI45981      OSP-DB-OTHER-F/QSRSVPRE-T/QSRSVPRE-MSGCPF3719 A MSGCPF3719 M
   SI45981      OSP-DB-OTHER-F/QSRSVPRE-T/QSRSVPRE-MSGCPF3719 A MSGCPF3719 M
   SI45886      OSP-DB Incremental enhancement for field procs
   SI45828      OSP-DB Internal Maintenance
   SI45827      LIC-DB-OTHER Wrong host variables in VE diagram when PSEUDO_
   SI45680      OSP-DB-OTHER-INCORROUT INCORROUT USING INAV INDEX ADVISER WI
   SI45521      OSP-F/QSQEVENT-T/QQQSVDBG-RC1-MSGSQL0952 MSGSQL0952 F/QSQEVE
   SI45297      OSP-OTHER Internal Fieldproc maintenance
   SI45234      OSP-DB STRDBMON internal maintenance
   SI45233      OSP-DB STRDBMON internal maintenance
   SI44838      OSP-DB-MSGCPF4204 from to DbpmTranslateOperation
   SI44838      OSP-DB A SQL APPLICATION USING UDF AND FAILS WITH MSGCPD434A
   SI44838      OSP-DB-OTHER-INCORROUT DATABASE MONITOR FAILS TO COLLECT DAT
   SI44838      OSP-F/QQQSVDBG-T/QQQSVDBG-MSGMCH0601 MCH0601 F/QQQSVDBG-T/QQ
   SI44457      OSP-DB Support SQLCODE filter parameter on STRDBMON command
   SI42492      OSP-DB-OTHER-UNPRED "SQL_STMT_REUSE" VALUE TO 1, HOWEVER IT
   SI41937      OSP-DB-OTHER-F/EXSNDPM-T/QSQSTATS-MSGMCH3601 STRDBMON FAILS
   SI40306      OSP-DB-OTHER-F/QQQSTRDM-T/QWCCDSAC-MSGCPF9898 ENDDBMON DOES
   SI39101      OSP-DB Internal Maintenance for Database Monitor
   SI37800      OSP-DB Database monitor internal maintenance
   SI37082      OSP-DB Internal mainenance for database monitor
   SI44625      OSP-DB Internal Maintenance for UDFs
   SI44584      OSP-DB Internal Maintenance for Database Monitor
   SI44492      OSP-DB Use MTIs as a source of statistics
   SI44458      OSP-DB Support SQLCODE filter parameter on STRDBMON command
   SI44454      OSP-DB-MSGSQ16168 using XMLPARSE SQL scalar function
   SI43994      OSP-DB Internal Maintenance for Database Monitor
   SI43948      OSP-DB Support Group profiles on STRDBMON FTRUSER parameter
   SI43763      OSP-DB Internal Maintenance
   SI43622      OSP-DB-OTHER-F/QQQQUERY-T/QQQQUERY-MSGMCH1210 QUERIES THAT C
   SI43551      OSP-DB-OTHER Fieldproc invocation should not require authori
   SI42965      OSP-DB Connect by support
   SI42905      OSP-DB-INCORROUT Decimal and Numeric data preferred sign whe
   SI42534      OSP-DB-MSGMCH3601-f/QQQUDFHL when UDF in a view.
   SI42631      OSP-DB-OTHER-INCORROUT QSYCUSRA API ALWAYS RETURNS USER IS A
   SI42530      OSP-DB-MSGMCH0601 from QQQVEXPL
   SI42444      OSP-DB Internal maintenance
   SI42444      OSP-DB-MSGSQL0901 SQL expression evaluator  returned when ca
   SI42444      OSP-DB Visual Explain misspelling of Temporary Sorted List i
   SI42347      OSP-DB-OTHER-F/QQQSVRTN MCH0601 QUERY WITH RAISE_ERROR.
   SI41942      OSP-DB-OTHER wrong Fieldproc error code returned
   SI41853      OSP-DB Parameter marker support in TRANSLATE scalar function
   SI41846      OSP-DB-OTHER-INCORROUT INCORRET NUMBER OF RECORDS ARE WRITTE
   SI41829      OSP-MSGMCH3406-PAR-940XDISK QUERY GENERATES A TEMP FILE THAT
   SI41603      OSP-DB Parameter marker support in TRANSLATE scalar function
   SI41554      OSP-DB Parameter marker extensions support - iteration 4
   SI41460      OSP-DB-OTHER remove extra CPF504D messages
   SI41357      OSP-DB Internal Maintenance
   SI41194      OSP-DB Internal Maintenance
   SI41015      OSP-DB-UNPRED Too many Final Calls for Final Call UDFs
   SI40769      OSP-DB-PERFM Improved Fieldproc Performance
   SI40749      OSP-DB-SQL Varchar_format & Timestamp_format additional Form
   SI40677      OSP-DB-PERFM Fieldproc performance
   SI40448      OSP-DB-SQL Months_Between Consider time when parameters are
   SI40368      OSP-DB-INCORROUT FieldProcs and Lobs when CQE
   SI40339      OSP-DB Parameter marker extensions support - iteration 2
   SI40333      OSP-DB-PERFM Fieldproc performance
   SI40212      OSP-DB Internal Maintenance for Database Monitor
   SI40212      OSP-DB Internal Maintenance
   SI40165      OSP-DB SQL Scalar UDF Inlining - iteration 1
   SI40051      OSP-DB-SQL BITAND, BITANDNOT,BITOR,BITXOR, and BITNOT functi
   SI39964      OSP-DB-SQL BITAND, BITANDNOT,BITOR,BITXOR, and BITNOT functi
   SI39792      OSP-DB-INCORROUT Visual Explain of V5R4 DBMON
   SI39125      OSP-DB-OTHER-F/QQQQEXIT-T/QQQQEXIT-MSGMCH1210 ERROR OCCURRED
   SI38307      OSP-DB-OTHER-F/QQQVALID-T/QSQRUN3-MSGCPD4367
   SI37868      OSP-DB-OTHER-INCORROUT VISUAL EXPLAIN FAILS WITH A MESSAGE M
   SI37392      OSP-DB-MSGCPF9810 Visual Explain
   SI39729      OSP-DB-MSGMCH3203 F/QQQOOOUPCL T/QQQOOOUPCL WHEN INVOKING UD
   SI39725      OSP-DB Parameter marker extensions support - iteration 1
   SI39628      OSP-DB Database monitor internal maintenance.
   SI39500      OSP-DB-SQL  TIMESTAMP_FORMAT  NNNNNN  left justify microseco
   SI39412      OSP-DB-INCORROUT UDF with VARBINARY parameter
   SI39271      OSP-DB-SQL Support BIDI CCSID to UTF or UCS2 translation lon
   SI39290      OSP-DB-MSGMCH1210 ALTER TABLE unexpected MCH1210 from QQINVF
   SI39124      OSP-DB-UNPRED unexpected MCH1201 in QSQRESET
   SI39078      OSP-DB Sequence objects used in a Merge query returns incorr
   SI39078      OSP-DB-OTHER-UNPRED DBMON AFFECTING ODBC & JDBC CONNECTIONS
   SI38971      OSP-DB Database monitor internal maintenance.
   SI38717      OSP-DB-INCORROUT Insert into XML Column with Fieldproc
   SI38704      OSP-DB Internal Maintenance for Database Monitor
   SI38650      OSP-DB Internal Maintenance for Database Monitor
   SI38515      OSP-DB-OTHER-F/QQQUDFHL-T/QSQRUN3-MSGCPF426A INVOKING UDFS T
   SI37925      OSP-DB-SQL   Update internal  service tool
   SI37896      OSP-DB-MSGCPD5036 for UDTF with XML output parameters
   SI37863      OSP-DB-OTHER-PERFM QQQSVRTN CREATING BUT NOT CLEANING UP MUT
   SI37803      OSP-DB-OTHER-F/QQQSRVE1-T/QSQRUN3-RC8-MSGCPD4374
   SI37797      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0443 ENCOUNTED USING
   SI37639      OSP-DB-OTHER-F/EXSNDPM-T/QSQSTATS-MSGMCH3601 MSGMCH3601 F/EX
   SI37639      OSP-DB-MSGMCH1210 f/t QQQSVRTN/QQINVUDF/IMPLEMENTUDTFINSQE
   SI37639      OSP-DB-MSGSQL0204 SQL procedure not found
   SI37356      OSP-DB-MSGSQL0204 SQL procedure not found
   SI37241      OSP-DB Internal mainenance for database monitor
   SI37183      OSP-DB-MSGCPF9898 on Field Procedure error
   SI37152      OSP-DB Longer Schema Support
   SI37008      OSP-DB-MSGSQL0443 XSLTRANSFORM scalar function
   SI36798      OSP-DB-MSGMCH3402 t/QQQSVRTN for query with UDF and LOB loca
   SI36698      OSP-DB-INCORROUT Table function with LOB locator result para
   SI37081      OSP-DB Internal maintenance for database monitor
   SI40810      OSP-DB Internal Maintenance

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE66167
Superseded by:......................View fix details for PTF SI75298
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C7192710


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 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"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"5770SS1","Edition":""}]

Document Information

Modified date:
02 April 2021