PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER-T/QSQRUN3-MSGMCH3603 MODULE QSQOPEN PROCEDURE F
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM REL NUMBER MIN/MAX OPTION
---- -------- --- ------- ------- ------
PRE 5770SS1 710 SI45871 00/00 0000
PRE 5770SS1 710 SI45954 00/00 0000
PRE 5770SS1 710 SI43415 00/00 0000
CO 5770SS1 710 SI47695 00/00 0000
CO 5770SS1 710 SI46303 00/00 0000
CO 5770SS1 710 SI46309 00/00 0000
CO 5770SS1 710 SI46308 00/00 0000
CO 5770SS1 710 SI46298 00/00 0000
CO 5770SS1 710 SI46018 00/00 0000
CO 5770SS1 710 SI45230 00/00 0000
CO 5770SS1 710 SI44825 00/00 0000
CO 5770SS1 710 SI44667 00/00 0000
CO 5770SS1 710 SI44009 00/00 0000
CO 5770SS1 710 SI43957 00/00 0000
CO 5770SS1 710 SI42836 00/00 0000
CO 5770SS1 710 SI41357 00/00 0000
CO 5770SS1 710 SI40611 00/00 0000
CO 5770SS1 710 SI40612 00/00 0000
CO 5770SS1 710 SI40757 00/00 0000
CO 5770SS1 710 SI39900 00/00 0000
CO 5770SS1 710 SI39903 00/00 0000
CO 5770SS1 710 SI39887 00/00 0000
CO 5770SS1 710 SI39127 00/00 0000
DIST 5770SS1 710 SI45524 00/00 0000
DIST 5770SS1 710 SI43719 00/00 0000
DIST 5770SS1 710 SI43720 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
-----------------------------------------------
Long running job intermittently get MSGMCH3603 to procedure
FIXPGM in module QSQOPEN, srvpgm QSQRUN3.
CORRECTION FOR APAR SE52953 :
-----------------------------
The handling of temporary QDTs has been corrected to prevent
the error.
CIRCUMVENTION FOR APAR SE52953 :
--------------------------------
None.
Activation Instructions
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) OPTION(*IMMED)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)
To stop and restart the QRWTSRVR prestart jobs, run the following:
ENDPJ SBS(QUSRWRK) PGM(QRWTSRVR) OPTION(*IMMED)
STRPJ SBS(QUSRWRK) PGM(QRWTSRVR)
To stop and restart the DRDA TCPIP server jobs, run the following:
ENDTCPSVR SERVER(*DDM) OPTION(*IMMED)
STRTCPSVR SERVER(*DDM)
To stop and restart the Directory Services server job,
run the following:
ENDTCPSVR SERVER(*DIRSRV) OPTION(*IMMED)
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)
and if a non default prestart job configuration exists
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDAINIT)
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)
and if a non default prestart job configuration exists
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASSINIT)
If the above commands fail with CPF0921, nothing more needs
to be done (the prestarted jobs are already active).
Special Instructions
None.
Default Instructions
THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.
Supersedes
PTF/FIX NO(S). APAR TITLE LINE
-------------- ------------------------------------------------------------
SI47666 OSP-DB-MSGSQL0804 Statement uses XML and is prepared and als
SI47647 OSP-DB SFI returning incorrect results
SI47588 OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGSQL0440 MSGSQL0440
SI47540 OSP-DB-OTHER-INCORROUT WRONG DATA IN MQT OF A VIEW OVER A PA
SI47370 OSP-DB-OTHER-UNPRED SERVICEABILITY
SI47320 OSP-DB-OTHER-F/QQQSRVE1-T/QQQOOOSETS-MSGMCH1210 ODBC FAILS S
SI47320 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH3601 MSGMCH3601 F/QSQ
SI47276 OSP-DB-OTHER-MSGSQL0904RC167-F/QSQRUN1 MODULE QSQPREP
SI47257 OSP-DB CLOB field is truncated on INSERT
SI47203 OSP-DB-OTHER-F/QSQADITM-T/QSQSETTXT-MSGSQL0901 MULTIPLE SQL0
SI47203 OSP-DB-OTHER-INCORROUT SQLERRD2 IS NOT GETTING RESET WHEN 0
SI47008 OSP-DB-MSGMCH0601-T/QSQFETCH long running job
SI46911 OSP-DB-OTHER-INCORROUT A SQL QUERY MAY RESULT IN INCORRECT R
SI46866 OSP-DB CHECK NAMING MODE FOR CACHED QUALIFIED SQL STMTS AT P
SI46741 OSP-DB-OTHER-F/QQQVSEL-T/QSQOPEN-MSGCPD4324
SI46741 OSP-DB-OTHER-T/QSQRUN3-MSGSQL0545 INSERTING INTO PARTITION T
SI46714 OSP-DB-OTHER-MSGSQL0913 WHEN CURSORS ARE REUSED ACROSS ACTIV
SI46714 OSP-DB-OTHER-F/QDBSIGEX-T/QSQRUN3-RC20-MSGCPF5035 WHEN UPDAT
SI46649 OSP-DB MSGMCH3601 T/QSQPREP running MERGE repeatedly over DR
SI46613 OSP-DB-MSGSQL7001 select using 3 part alias
SI46580 OSP-DB-OTHER-T/QSQSFCRT-MSGCPF5183
SI46446 OSP-DB-MSGMCH1210-QZDASQL error from QSQRUN1 when using 3-pa
SI46422 OSP-DB-OTHER-F/#MNRNRL-T/QSQSBAS2-MSGMCH3401 A MSGMCH3401 MA
SI46302 OSP-DB Support XMLTABLE function
SI46299 OSP-DB ADD QQI1 FAST DELETE REASON CODE to DBMON 1000 record
SI46225 OSP-DB SURFACE SQLCODE AND SQLSTATE IN DBMON FETCH RECORDS
SI46210 OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGSQL0100 WHEN GETTING D
SI46151 OSP-DB-MSGSQ20398 insert with subselect using xml
SI46129 OSP-DB-QSQCLSCR-MSGMCH3601 when using 3 part naming
SI46072 OSP-DB-OTHER-F/SQL0404 SECOND PREPARED STATEMENT FAILS
SI46057 OSP-DB GET DIAGNOSTICS DB2_NUMBER_ROWS is zero for reused SQ
SI46033 OSP-DB-MSGSQL0313 insert with subselect
SI46012 OSP-DB-OTHER-INCORROUT WHEN USING SQL_DEFLATE_TABLE QAQQINI
SI45997 OSP-DB-MSGSQL0313 insert with subselect
SI45993 OSP-DB-MSGSQL0305 from repeated SELECT FROM INSERT
SI45962 OSP-DB Support Insert with Remote Subselect
SI45960 OSP-DB-OTHER-RCAD-MSGSQL7917
SI45891 OSP-DB V7R1 DRDA CONNECTION TO A V5R3 SYSTEM. SELECT FAILS M
SI45824 OSP-DB-OTHER-MSGSQL0470 MSGSQL0470 OCCURS WHEN EXEC A PARAME
SI45790 OSP-DB-OTHER-RCAD-MSGSQL7917
SI45790 OSP-DB-OTHER-LOOP IN MODULE QSQRCFHT after MSGCPF503E RC9
SI45624 OSP-DB-MSGSQL0501 with 3 part name to DB2 for Z
SI45523 OSP-DB-OTHER-MSGSQL0913-MSGSQL0502 SERVICEABILITY ENHANCEMEN
SI45467 OSP-DB-MSGSQL0511 with for update of clause
SI45349 OSP-MSGSQL0502 CURSOR ISSUES WHEN CHANGING LIBRARY LIST MULT
SI45231 OSP-DB EXTEND QRECOVERY/QSQ901S FOR INTERNAL USE
SI45172 OSP-DB-MSGMCH3601 TO QQQQUERY
SI45172 OSP-DB-OTHER-F/QSQROUTX-T/QSQROUTX-MSGSQL0332 USE OF SQL_ATT
SI45172 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0503 UPDATE STATEMENT
SI45172 OSP-DB-MSGCPD4374-T/QSQRUN3 MODULE QSQOPEN RC 7
SI45107 OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGMCH0601 MSGMCH0601 OCCUR
SI45106 OSP-DB-OTHER-PERFM ODPs not reused when using overrides
SI45106 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGMCH0601 MCH0601 AND SQL0
SI45078 OSP-DB-QQQVFILE MSGCPF4269 after table recreated
SI45044 OSP-DB PROGRAM IS NOT PICKING UP NEW FILE AFTER LIB LIST IS
SI45017 OSP-DB MSGSQL0501 F/QSQRUN4 T/QSQRUN4 MODULE QSQCLS PROCEDUR
SI44919 OSP-DB-OTHER-T/QSQRUN3-MSGMCH3601 MODULE QSQOPEN PROCEDURE
SI44919 OSP-DB-OTHER-F/QSQRUN2-MSGCPF5149 MODULE QSQFETCH
SI44919 OSP-DB-OTHER-MSGSQL0502 WHEN ODP/CURSOR IS REUSED IN A DIFFE
SI44919 OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGMCH3601 MSGMCH3601 F/Q
SI44884 OSP-DB-OTHER-F/QSQRUN4-MSGMCH0601 A MSGMCH0601 F/QSQRUN4 FMO
SI44824 OSP-DB-INCORROUT QRECOVERY/QSQ901S SQL statement text
SI44793 OSP-DB-MSGSQL0904 type 8 with 3 part named statements
SI44716 OSP-DB table incorrectly searched on local sytem insted of r
SI44668 OSP-DB table incorrectly searched on local sytem insted of r
SI44527 OSP-DB-OTHER-T/QSQJOBTM-MSGCPF5715
SI44436 OSP-DB-OTHER-UNPRED STORAGE LEAK USING SELECT FROM INSERT
SI44343 OSP-DB-OTHER-F/QSQFETCH-RC5521-MSGSQL0901
SI44215 OSP-DB-INCORROUT-MSGSQL0204 DELETE using an ALIAS
SI44190 OSP-DB-QSQPREP-MSGMCH3402 when using a restored package
SI44190 OSP-DB-OTHER-INCORROUT INCORROUT, SQL RUNS AGAINST WRONG FIL
SI44082 OSP-DB-MSGMCH0601-T/QSQSBAS MODULE QSQCLSCR PROCEDURE SQCLOS
SI44070 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0519 RUNNING A PROGRA
SI44010 OSP-DB OPEN/FETCH QUERY DATA PARTIAL ROW FIXES
SI43955 OSP-DB-OTHER VARIOUS FIXES FOR SELECT FROM INSERT
SI43849 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-RC3577-MSGSQL0901 SQL STATE
SI43802 OSP-DB-OTHER VARIOUS FIXES FOR SELECT FROM INSERT
SI43802 OSP-DB-OTHER-T/QSQSBAS2-MSGCPF5813 MODULE QSQSFCRT
SI43718 OSP-MSGSQL0913 MERGE INTO STATEMENT FAILS WITH SQL0913
SI43696 OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0304 PREPARES DONE IN
SI43682 OSP-DB-OTHER-INCORROUT SQL FROM FILE NOT GETTING DATA FROM C
SI43598 OSP-DB-QSQPREP-MSGSQL0904 Resource limit exceeded using DRDA
SI43592 OSP-OTHER-INCORROUT FETCH FROM A CURSOR RETURNS DATA THE FIR
SI43427 OSP-DB-OTHER-INCORROUT ADD CONSTRAINT NAME INFORMATION TO TH
SI43401 OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH1210 AFTER UPGRADE
SI43351 OSP-DB-OTHER-MSGSQL0913 SERVICEABILITY CHANGE
SI43351 OSP-DB-OTHER-T/QRWSQRY-MSGMCH3601
SI43351 OSP-DB JOB LOCKS PART OF AN ACCESS PLAN AND OTHER JOBS GET M
SI43290 OSP-DB-QSQOPEN File opens occur when setaspgrp is used
SI43130 OSP-DB-MSGSQL0204 when using an alias for 3 part name
SI43112 OSP-DB-PERFM Pseudo open failed
SI42982 OSP-DB Connect By support
SI42831 OSP-DB-QSQCMPDS High CPU during long running job
SI42814 OSP-DB-OTHER-INCORROUT ACCESSING FILE AFTER IT IS REDEFINED
SI42814 OSP-DB-OTHER-F/RMSLLOCKSPACELOC-T/QSQRUN1-MSGMCH5804 MSGMCH5
SI42814 OSP-DB ADD QSQBIGPSA data area support
SI42675 OSP-DB Incorrect column from CLOB in UPDATE WHERE CURRENT OF
SI42460 OSP-DB-OTHER-INCORROUT MISMATCH BETWEEN NUMBER OF FIELDS AND
SI42460 OSP-DB-QSQOPEN-MSGSQL0901 ALTER TABLE fails involving a long
SI42460 OSP-DB-MSGSQL0150 during ALTER MQT or REFRESH TABLE
SI42460 OSP-DB-MSGSQL0104 Diagnostic Message During Prepares
SI42460 OSP-DB-QSQPREP-MSGSQL0904 Resource Limit Exceeded error on l
SI42460 OSP-DB-QSQLOPEN-MSGMCH1210 on OPEN in SQL program
SI42340 OSP-DB-MSGCPF4268 SQL SET global variable to SELECT from INS
SI42276 OSP-DB-OTHER-WAIT LOCKING ISSUE TRYING TO GET A LENR LOCK ON
SI42247 SQL exception occurred calling trigger on long running job
SI42200 OSP-DB-OTHER-SAP400-F/QTNOPNCLS-RCX/5525-MSGCPF4327 UPGRADE
SI42107 OSP-DB-OTHER-MSGSQL0301 USING THE DB2 FOR WINDOWS IMPORT FUN
SI42088 OSP-DB-OTHER-F/QSQCRTT-T/QSQCRTT-MSGSQL0601 CALLING THE SAME
SI41959 OSP-DB-OTHER-UNPRED WRONG VALUE IN QQI4 WHEN QQRID = 1000
SI41959 OSP-DB-OTHER-T/QSQRUN3-MSGSQL0420 WITH MSGSQL0420 ISSUED, TH
SI41892 OSP-DB-MSGSQL7054
SI41873 OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGMCH3601 STORED PROCEDU
SI41714 OSP-DB-OTHER-F/QSQRUN3-RC2118-MSGSQL0901
SI41635 OSP-DB MSGSQL0501 F/QSQRUN4 MOD/QSQCLS PROC/CLEANUP STMT/479
SI41635 OSP-DB-OTHER-F/QSQRUN3-MSGSQL7917 MODULE QSQRUN3
SI41635 OSP-DB-OTHER-PERFM INSERTING INTO TABLE WITH LONG NAME
SI41635 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
SI41578 OSP-DB-UNPRED Three part statement text not displaying in DB
SI41542 OSP-DB-INCORROUT-MSGSQL5011 SQL did not fail when it should
SI41435 OSP-DB-OTHER-F/QQQVSEL-T/QSQRUN1-RC7-MSGCPD4329 SELECT FROM
SI41432 OSP-DB-OTHER-MSGSQL0304 SQL0304 ENCOUNTERED WITH USING DRDA.
SI41431 OSP-DB-UNPRED Universal driver for JDBC fails in static desc
SI41417 OSP-DB-INCORROUT VISUAL EXPLAIN OF MERGE FAILS
SI41417 OSP-DB-MSGMCH3402 F/QSQPREP SET GLOBAL VARIABLE EQUAL SELECT
SI41385 OSP-DB-UNPRED DRDA prepare attribute string invalid
SI41383 OSP-DB-INCORROUT Expressions in CALL Support
SI41354 OSP-DB Internal Maintenance
SI41316 OSP-DB-UNPRED Failure when repreparing three-part naming sta
SI41296 OSP-DP-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
SI41263 OSP-DB-INCORROUT Expressions in CALL support
SI41228 OSP-DB-OTHER-F/QSQCLOSE-MSGCPF9898
SI41230 OSP-DB-UNPRED Reprepare of DRDA cursors when open attributes
SI41219 OSP-DB-OTHER-PERFM INSERTING INTO TABLE WITH LONG NAME
SI41219 OSP-DB SQ EXIT PROGRAM FAILED AND ENDED QDBXRVXR2.
SI41219 OSP-DB-OTHER-UNPRED AF AUDIT JOURNAL ENTRIES FOR OBJECT QADB
SI41202 OSP-DB-MSGSQL0904 TYPE=7 RC=167 MERGE USING ONLY DELETE
SI41084 OSP-DB-INCORROUT DESCRIBE OF STATIC SELECT FROM INSERT RETUR
SI40973 OSP-DB-OTHER-F/QDMCLOSE-MSGMCH6216
SI40940 OSP-DB-MSGSQL0901 F/QSQRUN3/QSQINS FOR JOBS RUNNING MULTIPLE
SI40929 OSP-DB-INCORROUT Expressions in CALL Support
SI40807 OSP-DB-QSQDSCPR DB2_RESULT_SET_ROWS not set
SI40699 OSP-DB-UNPRED Three part alias statement rewrite
SI40667 OSP-DB-UNPRED Three part alias statement rewrite
SI40609 OSP-DB-UNPRED Three part alias statement rewrite
SI40527 OSP-DB Incorrect failure info for insert
SI40510 OSP-DB-INCORROUT Array Support
SI40503 OSP-DB-OTHER-MSGMCH1210 running SELECT after a SELECT FROM I
SI40499 OSP-DB-MSGMCH1210-T/QSQINS with sql application
SI40492 OSP-DB-OTHER-MSGMCH1210 running SELECT FROM INSERT and inser
SI40455 OSP-DB-UNPRED Describe three-part cursor failing
SI40443 OSP-DB-MSGMCH3402-T/QSQCLOSE with java application
SI40411 OSP-DB QM QUERY FAILS WITH MCH1210
SI40385 OSP-DB MSGMCH3601 T/QSQPREP running MERGE repeatedly
SI40372 OSP-DB-UNPRED SQL procedures using DRDA selecting wrong sect
SI40370 OSP-DB-QSQDSCPR-MSGSQL0206 on DESCRIBE PROCEDURE to LUW
SI40337 OSP-DB-INCORROUT Array Support
SI40317 OSP-DB-OTHER-PERFM HIGHER CPU USAGE ON QSQSRVR JOBS
SI40317 OSP-DB-OTHER-MSGSQL0511 WHEN STMT CONTAINS FOR UPDATE OF COL
SI40317 OSP-PERFM TEMPORARY STORAGE GROWTH/LEAK
SI40290 OSP-DB-MSGMCH3601 F/QQQQUERY PROCEDURE CHECK_RESTRICTIONS FO
SI40285 OSP-DB-UNPRED SQL statements not picking up table to alias c
SI40248 OSP-DB Internal Maintenance
SI40172 OSP-DB-MSGSQL0501 on result set cursor
SI40163 OSP-DB-MSGCPD4331 F/QQQSRVV1 QQQVFILE SELECT FROM INSERT OF
SI40153 OSP-DB-OTHER Expressions in CALL Support
SI40048 OSP-DB Internal Maintenance
SI39999 OSP-DB various errros when using hetero client
SI39998 OSP-DB-QSQPROC-MSGSQL0204 when dropping routine using specif
SI39957 OSP-DB-QSQLCLSE-MSGMCH3601
SI39952 OSP-DB Internal Maintenance
SI39896 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0502 WEB APPLICATION
SI39889 OSP-DB DB2ROW trigger inserts unexpected rows with MERGE sta
SI39888 OSP-DB Internal Maintenance
SI39836 OSP-DB-OTHER-T/QTNOPEN-MSGMCH3203
SI39836 OSP-DB-OTHER-T/QSQCLI-MSGMCH0601 MODULE SQLED
SI39836 OSP-DB-OTHER-F/#CCEXCEP-T/QSQSBAS-MSGMCH5003 INSERT USING SE
SI39832 OSP-DB-MSGMCH3601 F/QQQSQCMP FROM SELECT FROM INSERT STATEME
SI39827 OSP-DB Allow system triggers use SIGNAL to communicate with
SI39733 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0332 SELECT FROM INSE
SI39711 OSP-DB-UNPRED Java stored procedure result sets failing over
SI39707 OSP-DB-MSGSQL0518 when MERGE statement run repeatedly
SI39698 OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0518 SELECT FROM IN
SI39665 OSP-DB-MSGMCH1210-T/QQQQUERY with inflate table
SI39638 OSP-DB-MSGSQL0313 F/QSQRUN3 RPGLE PROGRAM USING DESCRIPTORS
SI39563 OSP-DB-MSGSQL0112 with xml functions
SI39552 OSP-DB-INCORROUT Array Support
SI39445 OSP-DB-UNPRED Java stored procedure result sets failing over
SI39424 OSP-DB-OTHER-F/QQQQUERY BUILDAP-T/QQQQUERY BUILDAP-MSGMCH060
SI39393 OSP-DB Extended indicators used in INSERT with subselect
SI39348 OSP-DB-OTHER-F/QSQROUTX-T/QSQROUTX-MSGSQL0313 SELECT FROM FI
SI39270 OSP-DB wrong count of parameter markers
SI39215 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGMCH3601 JOB FAILS WITH M
SI39210 OSP-DB-MSGMCH3601 F/QSQINS EX2401PTRDOESNOTEXIST INSERT FROM
SI39206 OSP-DB-OTHER-SAP400-F/QSQRUN3-T/QSQRUN3-MSGSQL0551 SQLPKG CO
SI39186 OSP-DB-QSQPREP-MSGSQL0904 Resource Limit Exceeded errors whe
SI39173 OSP-DB Internal Maintenance
SI39128 OSP-DB Internal Maintenance
SI39114 OSP-DB-OTHER-T/QSQSBAS-MSGMCH3601 MODULE QSQHDCLS
SI39092 OSP-DB-INCORROUT ADDITIONAL HARDCLOSES IN FROM DYNAMIC SQL S
SI39053 OSP-DB Temp storage grows inserting LOB
SI38982 OSP-DB Internal Maintenance
SI38923 OSP-DB Internal Maintenance
SI38921 OSP-DB Internal Maintenance
SI38916 OSP-DB-QSQDSCPR-MSGMCH1210 on DESCRIBE PROCEDURE or ASSOCIAT
SI38855 OSP-DB-MSGSQL0811 EXECUTE IMMEDIATE SET GLOBAL VARIABLE = SE
SI38813 OSP-DB Internal Maintenance
SI38801 OSP-DB-MSGSQL0303 replacement text wrong
SI38758 OSP-DB MCH5804 WILL SWITCH THE OUT QUEUE TO QEZDEBUG TO DUMP
SI38749 OSP-DB Internal Maintenance
SI38732 OSP-DB-OTHER SQ Internal Maintenance
SI38696 OSP-DB-MSGSQL0518 in drda job
SI38657 OSP-DB Internal Maintenance
SI38590 OSP-DB-MSGMCH3601 F/QSQRUN2 MODULE/QSQVALUE F_MAP QUERY USIN
SI38570 OSP-DB-OTHER-F/QDMIFERR-T/QSQRUN3-MSGCPF5149
SI38506 OSP-DB DESCRIBE parameter marker incorrect with INSERT in ME
SI38506 OSP-DB-MSGSQL0952 when using three part names with MERGE
SI38477 OSP-DB-MSGMCH3601-T/QSQPREP
SI38468 OSP-DB Internal Maintenance
SI38443 OSP-DB Internal Maintenance
SI38371 OSP-DB-INCORROUT Extended Indicator Support
SI38370 OSP-DB-INCORROUT Extended Indicator Support
SI38350 OSP-DB-MSGSQL0901 Repeated SELECT from INSERT
SI38295 OSP-DB-MSGMCH3601 F/QSQROUTA SET GLOBAL VARIABLE = DEFAULT I
SI38164 OSP-DB-OTHER-UNPRED DB2_NUMBER_ROWS SQLERRD2 NOT SET FOR SEN
SI38099 OSP-DB Internal Maintenance
SI38070 OSP-DB-OTHER-UNPRED DB2_NUMBER_ROWS SQLERRD2 NOT SET FOR SEN
SI38022 OSP-DB-OTHER CONCURRENT ACCESS RESOLUTION
SI38005 OSP-DB-INCORROUT SQL UPDATE WITH GLOBAL VARIABLES AND MIXTUR
SI37980 OSP-DB-QSQPREP-MSGSQL0101 with large query
SI37980 OSP-DB-OTHER-THREADS-F/QSQRUN3-T/QSQRUN3-MSGSQL0180 TRIGGER
SI37964 OSP-INCORROUT INCORRECT NUMBER OF RECORDS RETURNED WHEN RUNN
SI37888 OSP-DB-MSGSQL0518 repeatedly running prepared MERGE
SI37841 OSP-DB-MSGSQL0901-F/QSQOPEN Array Support
SI37804 OSP-DB-MSGSQL0901 when UDTF referenced in SELECT FROM INSERT
SI37756 OSP-DB-MSGMCH3601 T/QSQPREP for delayed PREPARE of MERGE sta
SI37710 OSP-DB-OTHER-F/QSQCLOSE-T/QSQCLOSE-MSGCPF9898
SI37689 OSP-F/QSQSTATS-T/QSQSTATS-MSGMCH1210 JOBS FAILING WITH MCH12
SI37661 OSP-F/QSQSTATS-T/QSQSTATS-MSGMCH1210 JOBS FAILING WITH MCH12
SI37642 OSP-DB-QSQCLOSE-MSGMCH1001 in QSQCLOSE
SI37611 OSP-DB-PERFM ENHANCE SERVICEABILITY. TRAP WHEN SWSC DESTROYE
SI37608 OSP-DB-INCORROUT GLOBAL VARIABLES IN DYNAMIC SET PATH AND EN
SI37595 OSP-DB DESCRIBE parameter marker in UPDATE of MERGE incorrec
SI37559 OSP-DB-OTHER-SAP400-UNPRED AFTER AN ALTER TABLE PRIMARY CONS
SI37458 OSP-DB-INCORROUT REUSE OF STATEMENT CONTAINING GLOBAL VARIAB
SI37403 OSP-DB-MSGSQL7049 when running with result sets
SI37388 OSP-DB Internal Maintenance
SI37378 OSP-DB Internal Maintenance
SI37373 OSP-DB-MSGMCH3601-F/QSQFETCH Array Support
SI37326 OSP-DB-MSGMCH5003 F/QQQOOOSETS WHEN REUSING STATEMENTS REFER
SI37254 OSP-DB CPF4272 SQL0901 when MERGE run repeatedly
SI37250 OSP-DB-MSGSQL0901 F/QSQPREP FOR A PREPARED STATEMENT AFTER G
SI37220 OSP AFTER SEVERAL INSERTS BEING DONE IN A SINGLE JOB - THE J
SI37219 OSP-DB Internal Maintenance
SI37199 OSP-DB-MSGSQL0901-F/QSQCALLSP Array Support
SI37170 OSP-DB XML PROCESSING
SI37130 OSP-DB-OTHER-MSGSQL0913 LOCK ON OBJECT SQLSWSCNNN
SI37130 OSP-DB-OTHER-F/QSQSBAS2-T/QSQSBAS2-MSGMCH0601 MSGMCH0601 SPA
SI37130 OSP-DB-OTHER-PERFM A LOT OF TIME SPENT IN QSQCMPDS
SI37122 OSP-DB SQL0137 running MERGE statement many times
SI37035 OSP-DB-MSGMCH3601-F/QSQNNNNN
SI37019 OSP-DB-MSGSQL0901-F/QSQOPEN Array Support
SI36978 OSP-DB-MSGMCH3601-F/QRWSDSCD Extended dynamic failures
SI36865 OSP DB GLOBAL VARIABLE PROCESSING
SI36806 OSP-DB INTERNAL MAINTENANCE
SI36777 OSP-DB-UNPRED DRDA errors
SI36727 OSP-DB-OTHER-INCORROUT INSERT USING JDBC REQUESTING GENERATE
SI36727 OSP-T/QSQRUN3-MSGMCH3203 MSGMCH3203 F/KEDCONVERT T/QSQRUN3 X
SI36658 OSP-DB-UNPRED DRDA errors
SI36629 OSP-DB XML processing of SQLXSR objects
SI36614 OSP-T/QSQRUN3-MSGSQL0502 JOB FAILING WITH MSGSQL0502 T/QSQRU
SI36614 DB issue 42286: MCH0601 f/t QSQCLI running complex queries u
SI36572 UPDATE with expression in MERGE does not change column value
SI36524 OSP-DB XML PROCESSING
SI36518 OSP-DB-UNPRED Force FDOCA mode for DATE/TIME in SPRS
SI36550 OSP DB GLOBAL VARIABLE PROCESSING
Summary Information
System.............................. | i |
Models.............................. | |
Release............................. | V7R1M0 |
Licensed Program............... | 5770SS1 |
APAR Fixed.......................... | View details for APAR SE52953 |
Superseded by:...................... | View fix details for PTF SI72424 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | C2279710 |
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 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:
06 March 2020