IBM Support

SI47887 - OSP-DB-OTHER-PERFM MILLIONS OF SPACE LOCATION LOCKS LEFT IN

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-PERFM MILLIONS OF SPACE LOCATION LOCKS LEFT IN


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  SI47740   00/00    0000
CO   5770SS1  710  SI47741   00/00    0000
CO   5770SS1  710  SI47695   00/00    0000
CO   5770SS1  710  SI46303   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

-----------------------------------------------
Performance issue narrowed down to a large number of space
location locks orphaned.

CORRECTION FOR APAR SE53186 :
-----------------------------
The cleanup of the space location locks has been corrected.

CIRCUMVENTION FOR APAR SE53186 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI47763      OSP-DB-OTHER-MSGSQL0913-F/QSQRUN3 MODULE QSQOPEN PROCEDURE B
   SI47742      OSP-DB support CREATE TABLE AS with a remote query
   SI47730      OSP-DB INTERMITTENT MSGSQL0392 CAUSING 0 ROWS RETURNED FOR A
   SI47729      OSP-DB-OTHER-PERFM FULL OPENS WHEN SQL STATMENT HAS ALREADY
   SI47726      OSP-DB-OTHER-INCORROUT A SQL UPDATE MAY TRUNCATE A VALUE INS
   SI47677      OSP-DB-OTHER-T/QSQRUN3-MSGMCH3603 MODULE QSQOPEN PROCEDURE F
   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 SE53186
Superseded by:......................View fix details for PTF SI72424
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C2279710


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 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"},"Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1 environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
06 March 2020