IBM Support

SI62554 - OSP-DB-OTHER TIMESTAMP_FORMAT AND VARCHAR_FORMAT REVALIDATIO

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER TIMESTAMP_FORMAT AND VARCHAR_FORMAT REVALIDATIO


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF60698   00/00    0000
PRE  5770999  710  MF60683   00/00    0000
PRE  5770999  710  MF60718   00/00    0000
PRE  5770SS1  710  SI46389   00/00    0000
CO   5770SS1  710  SI60273   00/00    0000
CO   5770SS1  710  SI60274   00/00    0000
CO   5770SS1  710  SI59985   00/00    0000
CO   5770SS1  710  SI59356   00/00    0000
CO   5770SS1  710  SI58134   00/00    0000
CO   5770SS1  710  SI48080   00/00    0000
CO   5770SS1  710  SI48126   00/00    0000
CO   5770SS1  710  SI48127   00/00    0000
CO   5770SS1  710  SI45231   00/00    0000
CO   5770SS1  710  SI36909   00/00    0000
DIST 5770SS1  710  SI59350   00/00    0000
DIST 5770SS1  710  SI59349   00/00    0000
DIST 5770999  710  MF50492   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

-----------------------------------------------
A function check could occur when running TIMESTAMP_FORMAT or
VARCHAR_FORMAT with an access plan that has not been revalidated
since enhancements to these functions was shipped.

CORRECTION FOR APAR SE65797 :
-----------------------------
TIMESTAMP_FORMAT and VARCHAR_FORMAT UDFs saved in an access plan
will be forced to revalidate one time to account for new UDF
parameters that were added when their functionality was recently
enhanced.

CIRCUMVENTION FOR APAR SE65797 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI42907 :
=================================================

This PTF will not fix any currently existing SQL indexes created over
columms that reference fieldprocs and that specify derived keys, the
WHERE clause, or the RCDFMT clause.  These indexes must be recreated
after this PTF has been applied.


To ensure the fix goes into effect immediately, use the command:

ENDPJ SBS(QSYSWRK) PGM(QSYS/QSQSRVR)

before doing an immediate apply of the PTF.

STRPJ SBS(QSYSWRK) PGM(QSYS/QSQSRVR)

After the PTF has been applied to restart the QSQSRVR prestart jobs.

To ensure the fix goes into effect immediately, use the command:

ENDPJ SBS(QSYSWRK) PGM(QSQSRVR)

before doing an immediate apply of the PTF.

To properly enable this PTF for prestarted server jobs,
you will need to stop and restart the SQL server jobs,
the Directory Services server jobs, the DRDA TCPIP server
jobs, and the host server jobs.  Otherwise,
the prestarted server jobs may continue to use older versions
of programs and unexpected results may occur.  Applying this
PTF as delayed would achieve the same results.

To stop and restart the SQL server jobs, run the following:

ENDPJ SBS(QSYSWRK) PGM(QSQSRVR)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)

To stop and restart the DRDA server jobs, run the following:

ENDPJ SBS(QUSRWRK) PGM(QRWTSRVR)
STRPJ SBS(QUSRWRK) PGM(QRWTSRVR)

To stop and restart the DRDA TCPIP server jobs, run the following:

ENDTCPSVR SERVER(*DDM)
STRTCPSVR SERVER(*DDM)

To stop and restart the Directory Services server job,
run the following:

ENDTCPSVR SERVER(*DIRSRV)
STRTCPSVR SERVER(*DIRSRV)

To stop and restart the host server jobs, the following directions
must be followed.

The database server prestart jobs (QZDAINIT, QZDASOINIT, and
QZDASSINIT) by default are shipped to run in subsystem QSERVER
(QZDAINIT) and QUSRWRK (QZDASOINIT and QZDASSINIT).  However,
systems
can be customized to allow the database server prestart jobs to run
in other subsystems.

SYSTEMS WITH DEFAULT CONFIGURATION (database server prestart jobs
run
ONLY in the QSERVER and QUSRWRK subsystems).

---------------------------------------------------------------------

1) To ensure that the database server prestart jobs are ended,
issue the requests:

QSYS/ENDPJ SBS(QSERVER) PGM(QSYS/QZDAINIT) OPTION(*IMMED)
and
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT) OPTION(*IMMED)
and
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QZDASSINIT) OPTION(*IMMED)

If the above commands fail with CPF0922, nothing more needs
to be done (the prestarted jobs are already inactive).

2) To re-enable the function after the PTF is applied, issue the
requests:

QSYS/STRPJ SBS(QSERVER) PGM(QSYS/QZDAINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASSINIT)

If the above commands fail with CPF0921, nothing more needs
to be done (the prestarted jobs are already active).

3) To re-enable the function for each subsystem "subsystem-name"
identified, issue the following requests after the PTF is
applied:

QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDAINIT)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASOINIT)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASSINIT

ENDPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT)
STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT)


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI62149      OSP-DB Internal Database Maintenance
   SI62149      OSP-DB-OTHER RRN function in Common Table Expression with un
   SI60739      OSP-DB-OTHER-F/QQQSRVE1-MSGMCH3601 A MSGMCH3601 F/QQQSRVE1 F
   SI60334      OSP-DB Internal Database Maintenance
   SI60272      OSP-DB Internal Database Maintenance
   SI60172      OSP-PAR PRESTART JOBS ARE NOT CLEANING UP MUTEXES WHEN ENDIN
   SI60034      OSP-DB-OTHER-F/QQQSRVE1-MSGMCH3601 A MSGMCH3601 F/QQQSRVE1 F
   SI59705      OSP-DB Internal Database Maintenance
   SI59610      OSP-DB Internal Database Maintenance
   SI59555      OSP-DB INCORRECT INFORMATION IN THE DESCRIPTORS PARAMTERS RE
   SI59541      OSP-DB Internal Database Maintenance
   SI59446      OSP QIBM_QQQ_QUERY_GOVR EXIT PROGRAM PASSED INCORRECT SQL ST
   SI59377      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F
   SI59353      OSP-DB Internal Database Maintenance
   SI58470      OSP-DB-MSGMCH3601 in QQQVALID /proc BUILDIELIST using SQL LA
   SI58451      OSP-F/QSQRUN4-T/QSQRUN4-MSGSQL0788 Duplicate row when view o
   SI58332      OSP-DB-OTHER MSGMCH6903 T/QC2UTIL1 CAN BE SEEN WHEN THE REGE
   SI58223      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-RC1720-MSGMCH3203 STATE
   SI58202      OSP-DB-OTHER-INCORROUT INCORRECT OUTPUT DEPENDING ON THE SPA
   SI58135      OSP-DB-OTHER Query INI Option ALLOW_EVI_ONLY_ACCESS support
   SI58093      OSP-DB-OTHER Internal Maintenance
   SI58004      OSP-DB-OTHER Additional Scalar Support
   SI57951      OSP-DB-OTHER Query INI Option ALLOW_EVI_ONLY_ACCESS support
   SI57891      OSP-DB-OTHER-INCORROUT WHEN USING THE GROUPING FUNCTION FIEL
   SI57841      OSP-DB-OTHER-INCORROUT SPECIAL REGISTER VALUE INCORRECTLY RE
   SI57731      OSP-DB-MSGMCH3601 in QQQSETUP for query of laterally correla
   SI57576      OSP-INCORROUT SQL GET DESCRIPTOR RETURNS ERRONEOUS VALUES FO
   SI57575      OSP-DB-OTHER-THREADS-F/QQQSRVE1-T/QQQSRVE1-MSGMCH3601 MCH360
   SI57511      F/QQQQUERY-MSGCPD438C CPD438C REASON CODE 18 IS RECEIVED WHE
   SI57263      OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
   SI57113      OSP-DB-OTHER CAST TIMESTAMP TO CLOB SUPPORT
   SI56925      OSP-DB-OTHER Scalar Function Support
   SI56896      OSP-DB-OTHER-PERFM SQL QUERY PERFORMS POORLY AFTER BEING ROU
   SI56736      OSP-DB QQQQUERY receives MCH3402 Object Destroyed during obj
   SI56680      OSP-DB-MSGMCH3203 on query using ICU srtseq
   SI56663      OSP-DB-OTHER Scalar Function Support
   SI56618      OSP-DB-OTHER-F/#MNRNRL-T/QQQVWCMP-MSGMCH3401 WITH SELECT FAI
   SI56613      OSP-DB-INCORROUT GRAPHIC and VARGRAPHIC scalar functions wit
   SI56557      OSP-DB - SUPPORT SHARED AND PUBLIC MEMORY POOL NAMES IN QAQQ
   SI56407      OSP-OTHER-PERFM COGNOS QUERY IS TAKING TOO LONG TO COMPLETE
   SI56154      OSP-DB-OTHER-LOOP A QUERY WITH NESTED NULLIF, AND MULITPLE O
   SI56092      OSP-DB-OTHER Scalar Function Support
   SI56014      OSP-DB JOBS RUNNING SQL CAN SEE ERROR MSGCPF9898
   SI56014      OSP-DB-OTHER Database Internal Maintenance
   SI55983      OSP-DB-OTHER-F/QQOOOINV-T/QQQOOODBOP-MSGMCH3202 Function Err
   SI55912      OSP-DB-OTHER Scalar Function Support
   SI55626      OSP-DB-OTHER-F/QQQVWCMP-T/QQQVWCMP-MSGMCH1210 SELECT OVER VI
   SI55553      OSP-DB-MSGMCH0601 f/stringHighUse4K t/QQQVFMT for query with
   SI55324      OSP-DB-MSGMCH3601 f/QQQVFMT when using UDFs as parameters to
   SI55296      OSP-DB Internal Maintenance
   SI55288      OSP-DB-MSGSQL0191 using LOB in SQL Stored Procedure
   SI55288      OSP-DB-INCORROUT INSTEAD OF trigger not fired when open of S
   SI55158      OSP-DB Internal Maintenance
   SI55078      OSP-DB-OTHER-F/MNRESOLVECONTEXT-T/QQQUDFAC-MSGMCH3401 A VARY
   SI55010      OSP-DB-MSGCPF9898 Bad QQ heap request length invalid.
   SI54980      OSP-DB-OTHER-F/QQQVWCMP-MSGMCH3601 WHEN CREATING A VIEW WITH
   SI54980      OSP-OTHER-F/LOCKMIOBJECT-T/QQQSRVI1-MSGMCH5802 SQL0443 CPF43
   SI54977      OSP-DB-OTHER-F/QQQQUERY/BUILDAP-T/QQQQUERY/BUILDAP-MSGMCH360
   SI54977      OSP-DB-OTHER-LOOP RUNQRY OVER A VIEW LOOPS
   SI54784      OSP-DB-INCORROUT Query of SQL view with lateral correlation
   SI54784      OSP-DB-OTHER-F/MNRESOLVECONTEXT-T/QQQVWCMP-MSGMCH3401 OSP-DB
   SI54739      OSP-DB REGEXP Scalar Function Support
   SI54703      OSP-DB-OTHER-UNPRED UNABLE TO CREATE VIEWS THAT CONTAIN CTES
   SI54688      OSP-DB-OTHER-F/QQQVWCMP-T/QQQVWCMP-MSGMCH1210 SQL CREATE VIE
   SI54684      OSP-DB REGEXP Scalar Function Support
   SI46482      OSP-DB-OTHER-F/QQQVWCMP-T/QQQVWCMP-MSGMCH1210 MCH1210 F/QQQV
   SI54587      OSP-DB REGEXP Scalar Function Support
   SI54496      OSP-DB-OTHER QAQQINI file options not being honored
   SI54324      OSP-F/QQQOOODBOP-T/QQQOOODBOP-MSGMCH1210 SQL SELECT FAILS WI
   SI54304      OSP-DB-MSGSQL0332 not returned when using CCSID 937/935/1208
   SI54215      LIC-PERFM QUERIES AT R710 ARE RUNNING SLOWER UNLESS THE INLI
   SI54122      OSP-DB-OTHER-F/T/QQQUDFBI-QQQDAYNAME-MSGMCH0601
   SI53926      OSP-DB LPAD and RPAD Scalar Function Support
   SI53792      OSP-DB-OTHER-F/QQQVFMT-T/SAME-MSGMCH3601 CREATE TABLE AS SEL
   SI53770      OSP-DB-OTHER Encoded Vector Index Include Case with Aggregat
   SI53769      OSP HOST VARIABLE WITH TRAILING BLANKS USED IN LIKE CLAUSE C
   SI53604      OSP-DB-INCORROUT CEILING and FLOOR SQL scalar functions may
   SI53602      OSP-DB-OTHER-F/DBPMTRAP-MSGMCH3203 TRIGGER PROGRAM FAILS WIT
   SI53602      OSP-DB-OTHER-MSGSQL0443 MSGCPF503E DOUPLE QUOTE '"' BECOME '
   SI53237      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-RC11-MSGCPD4318 A MSGCPD431
   SI53226      OSP-DB-MSGCPD4305 in QQQVFMT UPDATE involving OLAP function
   SI53226      OSP-DB-OTHER-F/QAQQINI MSGMCH3601 after lock operation not s
   SI53149      OSP-DB-OTHER-F/QQQQUERY-T/QSQOPEN-RC11-MSGCPD438C Query with
   SI53047      OSP-DB-OTHER-F/QQQVFMT-T/QQQVFMT-MSGMCH0601 WHEN CREATING A
   SI53047      OSP-DB-MSGCPD4348 F/T:QQQVALID/QSQCRTV (901) when create vie
   SI52855      OSP-DB EVI WITH INCLUDE CAUSES JOBS TO HANG AFTER IPL
   SI52705      OSP-DB-OTHER-F/QQQSVUSR-T/QQQSVUSR-MSGMCH3601 RESTORED VIEW
   SI52506      OSP-DB STRDPRAPY FAILS MSGMCH3203 X/1720
   SI52434      OSP-DB MSGMCH3601 F/QQQSRVE1 from module QQQEVEXP.
   SI52414      OSP-DB-OTHER-INCORROUT WHEN OVERRIDING A TABLE TO ANOTHER TA
   SI52024      OSP-DB-OTHER-T/QQQVFMTX/14739-MSGMCH3601 CREATE ALIAS SQL ST
   SI51971      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4308 ON A SELECT FROM
   SI51905      OSP-DB-OTHER-PERFM QUERY CONTAINING MULTIPLE COMMON TABLE EX
   SI51716      OSP-DB InCorrOut Sequence object doens't return expected res
   SI51716      OSP-DB-msgSQL0204 or msgSQL0440 UDF not resolved properly
   SI51616      SQL-RUN-MSGCPI433ACPI433A EXPERIENCE LONG RUNNING PROCESSES.
   SI51616      OSP-DB-OTHER-T/QQQQUERYX/16860-MSGMCH3402 RUNNING A INSERT I
   SI51616      OSP-DB Incorrout with S/O logical file and NULL capable fiel
   SI51616      OSP ORDERING NOT CORRECT WHEN USING OLAP FUNCTION ROW_NUMBER
   SI51167      OSP-MSGMCH3203 AFTER UPGRADE TO 7.1, VIEW FAILS WITH FUNCTIO
   SI51156      OSP-DB-OTHER-INCORROUT INCORROUT IN QUERY WITH LOB DATA AND
   SI51091      OSP-DB-OTHER VALUES() NOT WORKING WITH DECRYPT_CHAR
   SI51032      OSP-OTHER CPD4318 WITH RC13 ON A PROGRAM THAT WORKED ON V5R4
   SI50957      OSP-DB Temporary storage keeps growing
   SI50759      OSP-DB-OTHER-INCORROUT ODBC SELECT OF DATE WILL NOT RETURN N
   SI50670      OSP-DB-MSGMCH3203 f/DbpmTrap t/QDBCRTME when creating encode
   SI50656      OSP-DB-OTHER-MSGCPD432B -  global variable object not found
   SI50595      F/QQQVALID-MSGMCH3601 POINTER NOT SET IN QUERY VALIDATION CO
   SI50549      OSP-MSGSQL0802 DATA MAPPING ERROR WHEN SELECTING DATA FROM A
   SI50549      OSP-MSGSQL0802 DATA MAPPING ERROR WHEN SELECTING DATA FROM A
   SI50537      OSP-DB QIBM_QDB_OPEN BEHAVIOR CHANGED SINCE THEY INSTALLED T
   SI50534      OSP-DB-OTHER-F/QQVSEL-T/QQVSEL-MSGCPD4321 WHEN CREATING A VI
   SI50534      OSP-DB-MSGMCH1211 f/QQQVFMT t/QQQVFMT proc/GETPARMCOMMOFFSET
   SI50534      OSP-DB-MSGMCH3203 f/DbpmTrap t/QQQSRVE1 for SQL expression w
   SI50301      OSP-DB-OTHER-F/QQQSVUSR-T/QQQSVUSR-RC2-MSGMCH3601 VIEW WITH
   SI50180      OSP-DB-OTHER-F/ Translations not done in QQDBCLOB1 field for
   SI50066      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-RC1720-MSGMCH3203 PROBL
   SI50042      OSP-OTHER SELECT * FROM "COMPLEX LOGICAL FILE" REPORT -901 5
   SI50013      OSP-DB-OTHER-INCORROUT QSQFETCH DOES WRONG CCSID TRANSLATION
   SI49772      OSP-DB-MSGSQL0332 - Character conversion between CCSID xxxx
   SI49518      OSP-DB-OTHER Contention on the QSQPTABL when running COPR on
   SI49484      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH1202 MSGMCH1202 F/QSQ
   SI49400      OSP-DB-OTHER-T/QQQOOODBOPX/12-MSGMCH3601 CONVERSION BETWEEN
   SI49400      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4301 A MSGSQL0901 (MS
   SI49400      OSP-DB-MSGSQL7917 - Access plan not updated.
   SI49291      OSP-DB-OTHER-INCORROUT SQL STATEMENT 'GET DESCRIPTOR' WITH '
   SI49291      OSP-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F/DBPMTRAP
   SI49258      OSP-DB-OTHER-F/QQQSRVE1-T/QSQRUN3-RC7-MSGCPD4374 'CPYFRMIMPF
   SI49255      OSP-DB-SQL query support of mixed CCSID conversions
   SI49255      OSP-DB-MSGCPD434A f/QSQCRTV t/QQQVFMT on CREATE VIEW
   SI49255      OSP-DB-MSGCPF4268 f/QQQSRVV1 t/QSQRUN3 SQL INSERT INTO DEFLA
   SI49075      OSP-DB-OTHER-F/QDBIOERRQO-T/QSQRUN2-RC84-MSGCPD5036 MSGCPD50
   SI49075      OSP-DB-OTHER-F/QQQOOODBOP-T/QQQOOODBOP-MSGMCH3601 QUERY WITH
   SI48903      OSP-DB DROP TABLE .. CASCADE FAILS MCH3601 F/QQQVWCMP T/QQQV
   SI48857      OSP-DB-OTHER-F/QQQQUERY-T/QSQPREP-MSGCPF428E QZDASOINIT JOB
   SI48817      OSP-DB Query open exit program changes - Stage 2
   SI48762      OSP-DB Grouping results not correct with *UNIQUE SRTSEQ tabl
   SI48630      OSP-DB Incorrect output using a view with a global variable.
   SI48544      OSP-DB-OTHER-INCORROUT "ERROR IN HOST SERVER DATA STREAM" WI
   SI48414      OSP-DB INTERNAL MAINTENANCE
   SI39094      OSP-F/QQQVALID-T/QQQVALID-MSGMCH3601 RESTORE OPERATION FAILS
   SI48274      OSP-DB INTERNAL MAINTENANCE
   SI48143      OSP-DB-OTHER-THREADS LONG_COMMENT FIELD GETS CORRUPT
   SI48143      OSP-DB INTERNAL MAINTENANCE
   SI48087      OSP-DB-OTHER-F/EXSNDPM-T/QQQOOODBOP-MSGMCH1819 AN SQL STATEM
   SI48065      OSP-DB-OTHER Changes to Parallel_Degree *OPTIMIZE percentage
   SI48032      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F
   SI48016      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0443 QUERY OF DB2 E
   SI47927      OSP-DB CPD4392 F/QQQSRVE1 T/QSQSBAS2 SQL_EXPRESSION_EVALUATO
   SI47915      OSP-DB *FC Query with grouping set expression and NLSS
   SI47803      OSP-DB *FC with Extra AnyOf on Query with Order By and Group
   SI47455      OSP-DB-PERFM DataBase Monitor performance problems
   SI47455      OSP-DB CPD4374 QQQOOOSETS fails with DATE function
   SI47455      OSP-DB-OTHER-F/QQQVFMT-T/QQQVFMT-MSGMCH3601 A QUERY AGAINST
   SI47427      OSP-DB-OTHER-INCORROUT A SQL QUERY MAY RESULT IN INCORRECT R
   SI47417      OSP-DB-OTHER-INCORROUT A PROGRAM WITH SQL COMPILED WITHOUT T
   SI47401      OSP-DB CPD4318 F/QQQVFMT T/QSQCRTV - SQL0137 F/QSQCRTV T/QSQ
   SI47389      OSP-OTHER-RC4-MSGCPI433A JOB RUNNING QUERIES INTERMITTENLY S
   SI47339      OSP-DB ADD SQL_GVAR_BUILD_RULE QAQQINI OPTION
   SI47050      OSP-DB-MSGSQ20398 Query with XMLTABLE
   SI46875      OSP-DB-OTHER MOVING/RENAMING Derived Indexes may not update
   SI46695      OSP-OTHER-MSGMCH3402-QQQSRVI1/QQQAINI - queries fail
   SI46695      OSP-DB-OTHER-F/QQQSRVI1-T/QQQSRVI1-MSGMCH1210 ERROR INVOKING
   SI46619      OSP-DB-MSGSQL0171 query with XMLTABLE syntax
   SI46488      OSP-DB-MSGSQ20058 CREATE MQT over XMLTABLE
   SI46480      LIC-DB-PERFM LONG OPTIMIZATION TIMES WITH HIGH NUMBER OF SEL
   SI46462      OSP-DB SQL Scalar UDF inline maintenance.
   SI46390      OSP-DB-OTHER MOVING DERIVED INDEXES FROM 1 LIBRARY TO ANOTHE
   SI46350      OSP-DB-MSGSQL0104 XMLTABLE support
   SI46348      OSP-DB-OTHER-PERFM MQT gets invalidated.
   SI46317      OSP-DB INTERNAL MAINTENANCE
   SI46317      OSP-DB INTERNAL MAINTENANCE
   SI46315      OSP-DB MSGSQL0901 CREATE OR REPLACE view failure
   SI46267      OSP-DB-OTHER-F/QQQQUERY*STMT-MSGMCH0801 AFTER APPLYING DB FI
   SI46074      OSP-DB Inline UDF changes for Expression Evaluator
   SI45949      OSP-DB-OTHER-INCORROUT NOT PROPERLY CONVERTING CYRILLIC DATA
   SI45949      OSP-DB-OTHER-T/QQQSRVE1X/9573-MSGMCH1212 SELECT STMT FAISL W
   SI45949      OSP-INCORROUT-CRT-D/T5250 VISUAL EXPLAIN ONLY AND INSERT
   SI45949      OSP-DB-OTHER-INCORROUT NOT PROPERLY CONVERTING CYRILLIC DATA
   SI45821      OSP-DB-OTHER COLUMN LABEL INCORRECT WHEN USING COLUMN LABEL
   SI45769      OSP-DB MSGMCH3601 WHEN YOU COMBINE ROW NUMBER WITH MAX
   SI45738      OSP-DB-MSGMCH3601 from create or replace alias SQL robots
   SI45738      OSP-DB-OTHER-F/QQQQUERY/X4602-T/QSQRUN3X/35743-MSGCPF4277 AF
   SI45677      OSP-MSGMCH5003-PAR RUNQRY RESULT IN MSGMCH5003 F/#CCEXCEP T/
   SI45617      OSP-DB-OTHER-INCORROUT NOT PROPERLY CONVERTING CYRILLIC DATA
   SI45548      OSP-DB-OTHER-F/QQQVALID-T/QSQRUN3-MSGCPD4340 SELECT STATEMEN
   SI45548      OSP-DB-OTHER-INCORROUT CAST RETURNED INCORRECT RESULT AGAINS
   SI45548      OSP-DB-OTHER-T/QQQQUERY-MSGMCH1820 MSGMCH1820 T/QQQQUERY WHE
   SI45477      OSP-DB-OTHER-INCORROUT OSP-DB-OTHER-INCORROUT MULTIPLE UNION
   SI45477      OSP-DB-OTHER-MSGSQL10120 SQL0120 ON CERTAIN QUERIES CONTAINI
   SI45477      F/DBPMTRAP-MSGMCH3203 OSP-DB-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3
   SI45317      OSP-DB Allow UDFs that are inlined to use Expression Evaluat
   SI45283      OSP-DB-MSGMCH2605  Lock not released when querying a view.
   SI45282      OSP-DB-MSGCPD439C on internal function during restore or upg
   SI45230      OSP-DB EXTEND QRECOVERY/QSQ901S FOR INTERNAL USE
   SI45205      OSP-DB A SQL APPLICATION USING UDF AND FAILS WITH MSGCPD434A
   SI45142      OSP-DB A SQLRPG PGM GETS INTERMTTENT SQL0901 FOR MCH2601 F/#
   SI45142      OSP-DB-OTHER-F/EXSNDPM-T/QQQQUERY-RC3483-MSGMCH1819 MSGMCH18
   SI45041      OSP-DB-OTHER-INCORROUT ENABLE QUERY OPTIMIZATION DEFINED MQT
   SI44973      OSP-DB-MSGC2M1601 query with XML function and same code page
   SI44611      OSP-DB-MSGCPD432B-f/QQQVFMT Global variable over distinct ty
   SI44611      OSP-DB-OTHER-F/QQQSRVV1-T/QSQRUN3-MSGCPD4354 COMPLEX SQL STA
   SI44841      OSP-DB-OTHER-F/QSQXCUTE-MSGSQL0122 SELECT WITH GROUPING A SU
   SI44826      OSP-DB Query open exit program changes
   SI44819      OSP-DB-OTHER-F/QQQOOODBOP-T/QQQOOODBOP-MSGMCH3601 OSP-DB-OTH
   SI44591      OSP-DB-OTHER-F/QQQVSEL-T/QSQRUN3-MSGCPD4307 SELECT USING UNI
   SI44520      OSP-DB-MSG3601 from QQQOOODBOP/QQQOOOSTRM
   SI44453      OSP-DB-MSGSQ16168 using XMLPARSE SQL scalar function
   SI44453      OSP-DB-OTHER ACCESS PLAN CHANGES
   SI44369      OSP-DB RSTLIB view with UDF not restored.
   SI44251      LIC-DB-PERFM Add PSEUDO_OPEN_CHECK_HOST_VARS QAQQINI option
   SI44247      OSP-DB-OTHER-F/QQURA-T/QQURA-MSGCPD4350 QRY/400 OVER SQL VIE
   SI44247      OSP-DB-OTHER MSGCPD4301 ON CREATE VIEW USING KEYWORD CYCLE
   SI44218      OSP-DB Internal Maintenance for Database Monitor
   SI44151      OSP-DB-OTHER-T/QQQOOODBOP-MSGMSG3203 SQL FAILING WITH MSGMCH
   SI44115      OSP-DB-MSGMCH3402-f/QQQSRVI1 when using a sequence object th
   SI44075      OSP-DB-OTHER-F/QQQSRVE1-T/QSQSBAS2-MSGCPD4392 SQL PROCEDURE
   SI44075      OSP-MSGMCH3402-D/TQDBGETM MCH3402 F/CFXLMB T/QDBGETM
   SI44071      OSP-DB-OTHER-INCORROUT INCORROUT FOR CERTAIN CHARACTERS IN A
   SI44031      OSP-DB-OTHER-F/#CFOCHKR-T/QQQVALID-MSGMCH3601 UPDATE STATEME
   SI44001      OSP-DB-OTHER- Switch for forcing all Access Plans to tempora
   SI44001      OSP-F/QQQOOODBOP-T/QQQOOODBOP-MSGMCH3601 QUERY FAILS WITH MS
   SI43882      OSP-DB-OTHER-MSGSQL0150 CREATE VIEW ON R710 OR R610 PRODUCES
   SI43710      OSP-DB Internal Maintenance
   SI43710      OSP-DB-OTHER-INCORROUT CLOB DATA MAY NOT BE TRANSLATED WHEN
   SI43710      OSP-DB PROCEDURES THAT CONTAIN IF SYNTAX WITH CHARACTER NOT
   SI43710      OSP-DB-OTHER-F/QQQVALID-T/QQQVALID-MSGMCH3601 MSGMCH3601 ON
   SI43710      OSP-DB-PERFM QQQ_TEXTSEARCH_KEY change to calculate result l
   SI43624      OSP-DB-OTHER-F/QQQSRVE1-T/QSQRUN3-RC13-MSGCPD4374 RECEIVED O
   SI43619      OSP-DB-OTHER-F/QQQQUERY-T/QQQQUERY-MSGMCH1210 QUERIES THAT C
   SI43616      OSP-DB-OTHER-LOOP CREATE FUNCTION LOOPS
   SI43544      OSP-DB-PERFM QQQ_TEXTSEARCH_KEY result length change to 1638
   SI43544      OSP-DB-MSGMCH3402-f/QQQSRVI1 when using a sequence object th
   SI43544      OSP-DB-OTHER-F/QQQVFMT JDBC MCH3601 QQQVFMT
   SI43544      OSP-DB-OTHER-F/QQQVALID-T/QQQVALID-MSGMCH3601 RESTORE OF SQL
   SI43544      OSP-DB-OTHER ACCESS PLAN CHANGES
   SI43489      OSP-F/CECONCRETE-T/QQQOOODBOP-MSGMCH3601 AFTER UPGRADE TO R7
   SI42907      OSP-DB-INCORROUT - FieldProc program not called while doing
   SI43457      OSP-DB Change the s/o query processing to not build duplicat
   SI43443      OSP-DB-OTHER-T/QQQITEMPX/10641-MSGMCH3601 SELECT * STMT FAIL
   SI43374      OSP-DB MSGMCH0602 from QQQQUERY on query with UDF.
   SI43259      OSP-DB-MSGMCH1210 F/QQQVFILE during upgrade from V5R4M5 to V
   SI43242      OSP-DB-OTHER-UNPRED LOCATE CODE USING MAX INSTEAD OF CASE
   SI43242      OSP-DB-OTHER-UNPRED MCH1210 F/QQQOOODBOP
   SI43226      OSP-DB-MSGMCH1210 from QQQOOOUPCL from omnifind query
   SI42963      OSP-DB Connect by support
   SI42884      OSP-DB-OTHER-F/QQQVALID-T/QQQVALID-MSGMCH0601 SQL SELECT FAI
   SI42824      OSP-DB-OTHER-T/QQQSRVE1-MSGMCH1210 Module/QQQGTSPC CREATESPA
   SI42799      OSP-DB Excessive optimization for nested UDFs that were inli
   SI42747      OSP-DB-OTHER-INCORROUT INCORROUT WHEN USING SO JOIN LOGICAL
   SI42635      OSP-DB-MSGCPD4307 from QQQVFMT when prepare with host variab
   SI42632      OSP-DB-OTHER-F/QQQQUERY-T/QQQQUERY-MSGMCH0601 RPG PROGRAM AC
   SI42632      OSP-DB-OTHER-F/QQQSRVE1-T/QSQSBAS2-MSGCPD4392 SQL PROCEDURE
   SI42632      OSP-DB INCORROUT OUTPUT FROM A SELECT OVER A SELECT/OMIT IND
   SI42632      OSP-DB-OTHER-F/QQQVALID-T/QQQVALID-MSGCPD4318 SQL UPDATE STA
   SI42467      OSP-DB Support of SQL Scalar UDF Inlining
   SI42549      OSP-DB-MSGMCH1211  from QQQVFMT while vary on IASP
   SI42442      OSP-DB Internal maintenance
   SI42442      OSP-DB-MSGSQL0901 SQL expression evaluator returned when cal
   SI42408      OSP-DB-MSGMCH3601 t/QQQQUERY proc/CHECK_LOB_LOCKING
   SI42325      OSP-MSGMCH4429-f/QQQVFMT when inlining a UDF that calls itse
   SI42325      OSP-DB Internal maintenance
   SI42246      OSP-DB Internal maintenance
   SI42246      OSP-DB-MSGMCH3203 from QQQOOODBOP when casting numeric to pu
   SI42246      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH1819 JAVA PROGRAM RECEIVES M
   SI42230      OSP-INCORROUT WRONG OUTPUT WITH JOIN SELECT/OMIT LOGICAL FIL
   SI42198      OSP-DB Internal maintenance
   SI42141      OSP-DB-MSGMCH3203 from QQQOOODBOP with CCSID translation
   SI41987      OSP-DB-MSGMCH3601-f/QQQVAP when inlining a sql scalar udf
   SI41987      OSP-DB SQE Support of Multi dataspace logical
   SI41978      OSP-DB SQE Support of Logical Files - one spec, no case
   SI41960      OSP-DB-MSGMCH5003 F/T QQQVFMT when using LAND/LOR/XOR with p
   SI41933      OSP-DB Internal maintenance
   SI41933      OSP-DB Remove substitution character msg on EBCDIC translate
   SI41915      OSP-DB Parameter marker enhancement in COALESCE/VALUE scalar
   SI41856      OSP-DB-MSGMCH3601 from QQQVAP - inline UDF fix
   SI41852      OSP-DB Parameter marker support in TRANSLATE scalar function
   SI41840      OSP-DB-OTHER-F/EXSNDPM-T/QQQQUERY-RC01-MSGMCH1819 SELECT QUE
   SI41840      OSP-DB-OTHER-T/QSQRUN3X/26628-MSGSQL0420 AFTER INSTALLING CU
   SI41840      OSP-DB Internal maintenance
   SI41767      F/QQQVAP-MSGMCH1201-MOD/QQQVAP F/QQQVAP-MSGMCH1201-MOD/QQQVA
   SI41767      OSP-DB-OTHER-F/QQQVAP-T/QQQVAP-MSGMCH1210 SQL CCSID CONVERSI
   SI41767      OSP-DB-MSGSQL0403 when using Date, Time, or Timestamp types
   SI41767      OSP-DB QQQQUERY: initialize QDT fields on ?CRTQAP
   SI41751      OSP-DB-MSGMCH3402  From DpbmTranslateOperation
   SI41750      OSP-DB-OTHER-F/QQQVFMTX/2880-MSGCPD4363RC17 SELECT STMT ERRO
   SI41750      OSP-DB-OTHER-F/QQQSRVI1-T/QQQSRVI1-MSGMCH1210 RUNNING APP FO
   SI41731      OSP-DB-OTHER-F/QDBSIGEX-T/QSQRUN3-RC20-MSGCPF5035 CPF5035 RC
   SI41674      OSP-DB Internal maintenance
   SI41639      OSP-DB-MSGCPF9898 f/QQQFNCHK NQE: ICU operand is not utf16/u
   SI41612      SMU-DB-OTHER-MSGSQL7054 MSGSQL7054 AND MSGCPF428E FOR QIBM_Q
   SI41602      OSP-DB Parameter marker support in TRANSLATE scalar function
   SI41588      OSP-DB Internal maintenance
   SI41553      OSP-DB Parameter marker extensions support - iteration 4
   SI41518      OSP-DB Internal maintenance
   SI41518      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F
   SI41499      OSP-DB-MSG-F/QQQVALID-T/QQQVALID QUERY LOGICAL FILE WITH FIE
   SI41490      OSP-DB Internal maintenance
   SI41445      OSP-DB Internal Maintenance
   SI41438      OSP-DB-OTHER-F/QQQIMPLE-T/QQQIMPLE-MSGMCH3601 MCH3601 DURING
   SI41438      OSP-DB-MSGSQL0243 on sensitive cursor
   SI41374      OSP-DB inlining udfs authority considerations
   SI41356      OSP-DB OVRDBF function to support buffer length for query
   SI41314      OSP-DB-MSGCPD4329 from QQQVSEL
   SI41286      OSP-DB-OTHER-INCORROUT OVRDBF OVERRIDES A SQL ALIAS
   SI41249      OSP-DB Incorrect length using a parameter markers and a dbcl
   SI41212      OSP-DB Parameter marker extensions support - iteration 3 (pa
   SI41212      OSP-DB Internal maintenance
   SI41190      OSP-DB Internal Maintenance
   SI41168      OSP-DB Internal maintenance
   SI41138      OSP-DB Parameter marker extensions support - iteration 3 (pa
   SI41066      OSP-DB Internal maintenance
   SI41042      OSP-DB-MSGMCH3601-f/QQQVFMT when running subquery
   SI41031      OSP-DB-OTHER-PERFM INSTEAD OF INSERT TRIGGER PERFORMANCE IN
   SI41019      OSP-DB-MSGMCH1210 from QQQITEMP
   SI40963      OSP-DB Parameter marker extensions support - iteration 3 (pa
   SI40963      OSP-DB inlining udfs with parameters
   SI40944      OSP-DB SQE Support of Multi dataspace logicals
   SI40888      OSP-DB-MSGMCH1819 F/T ExSndPm/QQQQUERY
   SI40860      OSP-DB-SQL  Timestamp_format use of Apostrophe fails
   SI40833      OSP-DB-MSGCPD4302 when trying to inline a udf
   SI40833      OSP-DB-MSGMCH3601 from QQQGET
   SI40833      OSP-DB-MSGCPD4002 Key mapping error in field *N member EVITB
   SI40809      OSP-DB-OTHER-INCORROUT FORMAT LEVEL ID DIFFERENCES BETWEEN T
   SI40799      OSP-DB-OTHER-F/QDBDLTFI-T/QSQBAS2-MSGCPF3220 MSGCPF3220 F/QD
   SI40747      OSP-DB-SQL Varchar_format & Timestamp_format additional Form
   SI40747      OSP-DB QAQQINI SQL_SCALAR_UDF_INLINE not valid
   SI40631      OSP-DB Send substitution character msg on EBCDIC translates
   SI40479      OSP-DB SQE Support of Multi dataspace logicals
   SI40450      OSP-DB compilation error from QQQVALID
   SI40447      OSP-DB-SQL Months_Between Consider time when parameters are
   SI40338      OSP-DB Parameter marker extensions support - iteration 2
   SI40312      OSP-DB SQL Scalar UDF Inlining - iteration 1
   SI40312      OSP-DB SQE Support of Multi dataspace logicals
   SI40214      OSP-DB-MSGMCH5003 f/#ccexcep t/QQQVFMT ASCII scalar function
   SI40214      OSP-DB-MSGMCH1819 IN predicate with date/time operand
   SI40214      OSP-DB-MSGMCH1819 T/QQQQUERY INAV SHOW TABLE INDEXES
   SI40124      OSP-DB-INCORROUT XMLrow with double-bytes characters in row-
   SI40097      OSP-DB Internal Maintenance QQQQUERY: initialize QDT fields
   SI40085      OSP-DB-MSGMCH1819 COALESCE function with UTF-8 and UCS-2 ope
   SI40073      OSP-DB QQQQUERY: initialize QDT fields on ?CRTQAP
   SI40050      OSP-DB-SQL BITAND, BITANDNOT,BITOR,BITXOR, and BITNOT functi
   SI40039      OSP-DB-SQL-MSGMCH3203  Queries with GROUP BY
   SI40029      OSP-DB-MSGCPD4301 from QQQVFMT on select from insert
   SI40015      OSP-DB bndpgm QQQQEXIT failed to create
   SI40015      OSP-DB-MSGCPD4318 Query with concatenation involving unicode
   SI39963      OSP-DB-SQL BITAND, BITANDNOT,BITOR,BITXOR, and BITNOT functi
   SI39921      OSP-DB-MSGCPF9812 OPNQRYF of DDM file
   SI39921      OSP-DB-MSGMCH3203 XML functions with double byte character n
   SI39921      OSP-DB-MSGMCH2603-f/QQQSRVE1 when using global variables and
   SI39835      OSP-DB-MSGCPF5032 f/QDBIOERRQO t/QSQFETCH MERGE using VALUES
   SI39835      OSP-DB-MSGCPD4349 order by fields are too long
   SI39800      OSP-DB-MSGCPF5035 Data mapping error on INSERT or UPDATE of
   SI39724      OSP-DB Parameter marker extensions support - iteration 1
   SI39585      OSP-DB incorrect refresh count for database monitor records
   SI39554      OSP-DB-MSGMCH3203 XMLAGG function with XMLAGG in order-by cl
   SI39547      OSP-DB-MSGCP9898 f/QQQSRVI1 t/QQQVSEL
   SI39547      OSP-DB-MSGCPD5036 Data mapping error when Logical file and f
   SI39509      OSP-DB-SQL   DEGREES and RADIAN functions internally restruc
   SI39472      OSP-DB-MSGCPD434C f/QQQQUERY t/QSQALTER altering SQL view
   SI39417      OSP-DB-MSGMCH0601 from qq module on Select from insert
   SI39380      OSP-DB-MSGMCH3601 from QQQDTQRO
   SI39380      OSP-DB-MSGMCH5003 From QQQSRVE1
   SI39353      OSP-DB-MSGCPD4318 from QQQVFMT for XMLFOREST when the job CC
   SI39353      OSP-DB-MSGCPD4301 Field not found on Select from insert
   SI39311      OSP-DB-MSGMCH3601-f/QQQVAP while validating index
   SI39311      OSP-DB-MSGMCH3203  Fix grouping sets problems
   SI39168      OSP-DB-OTHER-F/QQQQUERY-T/QQQQUERY-MSGMCH1210 CPYF FAILS WIT
   SI39168      OSP-DB-MSGMCH1820 in QQQQUERY for query with IN predicate
   SI39168      OSP-DB-MSGMCH3601 f/DbstMdDadDataSpaceConcrete t/QQQOOODBOP
   SI39168      OSP-DB-MSGCPF4268 f/QQQSRVV1 t/QSQRUN3 after refresh of MQT
   SI39168      OSP-DB-OTHER-F/QQQVSEL-T/QQQQRY-MSGCPF4278 WRKQRY CREATE FAI
   SI39168      OSP-DB EVI with include recovery
   SI39120      OSP-F/QQQVALID-T/QSQRUN3-MSGCPD4346 QUERY WITH SCALAR SUBSEL
   SI39120      OSP-DB-OTHER-F/QQQVFMT-MSGCPD4307 SELECT RRN IN UNIONS RESUL
   SI39029      OSP-DB Sequence objects used in a Merge query returns incorr
   SI39028      OSP-DB-OTHER-INCORROUT DRDA CLIENT CALLING FUNCTION THAT RET
   SI39028      OSP-DB-OTHER-F/QQQVFMT-T/QQQVFMT-MSGMCH1210 SQL UPDATE FAILS
   SI39019      OSP-DB-MSGMCH1819 CQE queries using fieldprocs
   SI38986      OSP-DB-SQL ORDER BY sort sequence and UTF-8 multiple levels
   SI38932      OSP-DB-MSGCPF7304 f/QDBINFLT t/QQQSRVV1
   SI38870      OSP-DB-MSGMCH1211 t/QQQVFMT/GETPARMCOMMOFFSET
   SI38854      OSP-DB-MSGMCH3601 creating procedure with array unnest funct
   SI38814      OSP-DB-SQL   DEGREES and RADIAN functions use DECFLOAT when
   SI38753      OSP-DB-INCORROUT CEILING and FLOOR scalar functions
   SI38707      OSP-DB-MSGMCH3601 in QQQVALID procedure TEMPSET
   SI38707      OSP-DB-MSGMCH1222 from QQQIOTMP
   SI38655      OSP-DB-SQL LOB column in query consumes temporary storage
   SI38655      OSP-DB-OTHER-INCORROUT DECIMAL SETTING DIFFERENCE CAUSES WRO
   SI38655      OSP-DB-OTHER-INCORROUT JT400 APPLICATION RETURNS INCORRECT R
   SI38612      OSP-DB-MSGMCH3601 Re-usable queryies using SQL Arrays
   SI38603      OSP-DB Internal Maintenance
   SI38535      OSP-DB USING A FUNCTION FAILS MSGCPD43AB F/QQQVSEL T/QSQRUN1
   SI38535      OSP-DB Incorrect output using a global variable path set to
   SI38535      OSP-DB-INCORROUT CEILING and FLOOR scalar functions
   SI38470      OSP-DB-MSGMCH3601 Query Logical File Field Procedure field
   SI38470      OSP-DB-SQL LOB column in query consume Temporay Space
   SI38414      OSP-DB-MSGCPF4268 Format not found for derived table query
   SI38414      OSP-DB-MSGMCH1210 length of order by fields is larger than 2
   SI38414      OSP-DB-MSGMCH3601 f/t cmpptra/QQQOOODBOP
   SI38338      OSP-DB-OTHER-F/QQQPDCMP-T/QQQPDCMP-MSGMCH1210 AN INTERNAL QU
   SI38338      OSP-DB-SQL- MSGMCH1210 DBCLOB parameter of ARRAY_AGG
   SI38338      OSP-SQL SQ20425 for CONTAINS and SCORE functions
   SI38338      OSP-DB-MSGCPD4363 Query with numeric compared to character s
   SI38338      OSP-DB-MSGCPD434A Cast of character string to BLOB
   SI38173      OSP-DB-MSGCPD4318 from QQQVFMT with binary data in XML funct
   SI38114      OSP-DB-SQL   Array_AGG fails when underlying table is change
   SI38105      OSP-DB-MSGMCH3601 From QQQOOODBOP select from insert
   SI38062      OSP-DB-MSGCPI4323 Excessive access plan rebuilds
   SI38062      OSP-DB-INCORROUT wrong CCSID for XML result from XMLAGG func
   SI38002      OSP-DB-SQL   Parameter Markers with types of Date,Time, and
   SI37940      OSP-DB-MSGCPF9898 function with XML CAST FROM
   SI37922      OSP-DB-MSGMCH3601 from QQQOOODBOP with CHAR function
   SI37879      OSP SQL IS FAILING WITH DATA MAPPING ERRORS.
   SI37834      OSP-DB-MSGMCH5003-f/QQQSRVE1 when using arrays
   SI37826      OSP-DB-OTHER-T/QDBOPEN-MSGMCH3601 INTERMITTENTLY ON OPNDBF
   SI37806      OSP-DB Database monitor internal maintenance
   SI37806      OSP-DB-MSGCPD439C  during create EVI index
   SI37806      OSP-DB Internal Maintenance
   SI37737      OSP-DB-MSGMCH1210 f/t QQQSVRTN/QQINVUDF/IMPLEMENTUDTFINSQE
   SI37721      OSP-DB-MSGSQL0901 Select from insert statement with user def
   SI37702      OSP-DB-SQl  IS NULL Predicates with Host Variable Array as t
   SI37633      OSP-DB-OTHER OLAP functions not working properly.
   SI37615      OSP-DB-OTHER-F/#DBCOMMIT-T/QTNOPNCLS-RC1716-MSGMCH3203 QUERY
   SI37615      OSP-DB-MSGMCH1819 CQE Grouping query with fieldprocs
   SI37544      OSP-DB-MSGMCH3601-F/QDMGETOV during restore of files
   SI37523      OSP-DB-MSGMCH3601-f/QQQSRVE1 when using database monitor and
   SI37479      OSP-DB CRTDUPOBJ of aggregate EVI is incorrect
   SI37464      OSP-DB-MSGCPD4392 using a date global variable
   SI37460      OSP-DB- INCORROUT result CCSID of SOUNDEX function
   SI37424      OSP-DB-MSGMCH1210 Using database monitor and Expression eval
   SI37398      OSP-DB-OTHER-PERFM NEW QAQQINI OPTION, DETERMINISTIC_UDF_SCO
   SI37398      OSP-DB-MSGCPD434A CAST of CURRENT SERVER to unicode CCSID
   SI37361      OSP-DB-MSGMCH0601 F/T QQQSVIMP/QQQSVIMP when CQE and fieldpr
   SI37353      OSP-DB-MSGMCH5003-f/QQQSRVE1 when using lobs
   SI37334      OSP-DB-F/QQQSRVE1-MSG1210 5 or more Array_agg function in a
   SI37328      OSP-DB Internal Maintenance
   SI37261      OSP-DB-MSGMCH3601-f/QQQOOODBOP when using a UDTF and right o
   SI37240      OSP-DB Database monitor maintenance
   SI37195      OSP-DB-F/QQQSRVE1-MSG1210 Date/Time/Timestamp with UNNEST Fu
   SI37151      OSP-DB Longer Schema Support
   SI37151      OSP-DB-MSGMCH3203 query with values clause
   SI36867      OSP-DB-OTHER-F/QQQOOOUPCL-T/QQQOOOUPCL-MSGMCH0601 AFTER SOME
   SI37007      OSP-DB-MSGSQL0443 XSLTRANSFORM scalar function
   SI36934      OSP-DB-PERFM Slow performance for query with SQL view or tab
   SI36906      OSP-DB-INCORROUT XSLTRANSFORM returns incorrect results
   SI36871      OSP-DB-MSGMCH3401 f/qqqvfmt on QSQPTABL during RSTLIB
   SI36839      OSP-DB-INCORROUT XML publishing funtion
   SI36736      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0443 ENCOUNTED USING
   SI36695      OSP-DB-INCORROUT UDF XML output parameter
   SI36505      OSP-DB-MSGMCH3601 with XML publishing functions
   SI36467      OSP-DB-MSGCPF4268 format not found
   SI36462      OSP-DB-t/QQQSRVV1-MSGMCH3402 when using the contains functio

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE65797
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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG15V","label":"PTF Cover Letters - IBM i General"},"Component":"5770SS1","Edition":""},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1"},"Component":"5770SS1","Edition":""}]

Document Information

Modified date:
02 April 2021