IBM Support

SI57084 - OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI56760   00/00    0000
PRE  5770999  710  MF56160   00/00    0000
PRE  5770999  710  MF53181   00/00    0000
PRE  5770999  710  MF53178   00/00    0000
CO   5770SS1  710  SI55165   00/00    0000
CO   5770SS1  710  SI55166   00/00    0000
CO   5770SS1  710  SI53720   00/00    0000
CO   5770SS1  710  SI53721   00/00    0000
CO   5770SS1  710  SI50413   00/00    0000
CO   5770SS1  710  SI50412   00/00    0000
CO   5770SS1  710  SI49409   00/00    0000
CO   5770SS1  710  SI49405   00/00    0000
CO   5770SS1  710  SI48195   00/00    0000
CO   5770SS1  710  SI48199   00/00    0000
CO   5770SS1  710  SI46365   00/00    0000
CO   5770SS1  710  SI46284   00/00    0000
CO   5770SS1  710  SI46245   00/00    0000
CO   5770SS1  710  SI44825   00/00    0000
CO   5770SS1  710  SI43569   00/00    0000
CO   5770SS1  710  SI40611   00/00    0000
CO   5770SS1  710  SI40757   00/00    0000
CO   5770SS1  710  SI39069   00/00    0000
DIST 5770SS1  710  SI50366   00/00    0000
DIST 5770SS1  710  SI47594   00/00    0000
DIST 5770SS1  710  SI44237   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 job that is being monitored by STRDBMON HOSTVAR(*CONDENSED)
consumes a very large number of temporary spaces.

CORRECTION FOR APAR SE62046 :
-----------------------------
The problem occurs for each CALL statement with variable
parameters.  The space management problem has been corrected.

CIRCUMVENTION FOR APAR SE62046 :
--------------------------------
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 SI39342 :
=================================================

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


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI56980      OSP-DB Remove DRDA result set open capture in database monit
   SI56835      OSP-DB-OTHER-T/QSQRUN2-MSGCPF5257 SERVICEABILITY CHANGE
   SI56782      OSP-UNPRED SAVEPOINTS FOR INSERT STATEMENT NOT SET VIA DRDA
   SI56771      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
   SI56766      OSP-DB-MSGSQL7021-F/QSQROUTE RMV MSG PREVENTING EMB SQL DRDA
   SI56388      OSP-DB-OTHER-T/QSQRUN2-MSGSQL0501 MODULE QSQFETCH
   SI56220      OSP-DB-OTHER-LOOP JOB LOOPS AND CONSUMES HIGH CPU ON SET RES
   SI56218      OSP-DB-MSGMCH3601-F/QSQVALUE SQL SET OF LARGE GV TO STRING C
   SI56090      OSP-DB-OTHER-INCORROUT RETURNGLOBALVARIABLE VALUES ARE DIFFE
   SI56071      OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QSQRUN2-MSGMCH0601 A QUERY
   SI55883      OSP-DB-OTHER-WAIT SQL QUERY OVER A VIEW HANGS
   SI55619      OSP-DB-MSGSQL7021 Dont fail the use of SQL within instead of
   SI55418      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH1210 A MSGMCH1210 MAY
   SI55319      OSP-DB INTERNAL MAINTENANCE
   SI55313      OSP-MSGSQL0303 SQL FUNCTION W/SUBSELECT ASSIGNS BLANKS VIA C
   SI55269      OSP-DB-OTHER-T/QSQSBAS-MSGMCH1210 MODULE QSQVATTR PROCEDURE
   SI55255      OSP-DB-OTHER-INCORROUT DESCRIBE USING DESCRIPTOR STATEMENT -
   SI55164      OSP-DB-OTHER-RC2-MSGSQL7049
   SI55110      OSP-DB-OTHER-UNPRED QSQSVCDMP SPOOLED FILE CREATED
   SI54867      OSP-DB-MSGSQL0901 OPEN USING passing a lob global variable
   SI54582      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3601
   SI54497      OSP-DB-OTHER-T/QSQSBAS2-MSGMCH1210 MODULE QSQEXPEVAL
   SI54311      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3601
   SI54271      OSP-DB-OTHER-INCORROUT STRDBMON QQI6 VALUE IS TOO LARGE
   SI54133      OSP-DB DISPLAY LONG FIELD NAMES FOR SOME SQ MESSAGES
   SI54027      OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
   SI53992      OSP-DB-OTHER-RC540-MSGSQL0904 A MSGSQL0904 RESOURCE LIMIT TY
   SI53719      OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QSQROUTX-MSGMCH0601 MCH3601
   SI53658      OSP-DB-OTHER-F/QSQRUND-T/QSQRUN2-MSGSQL0901 MCH1210 F/QSQRUN
   SI53526      OSP-DB-OTHER-UNPRED SERVICEABILITY CHANGE
   SI53345      OSP-DB-OTHER-UNPRED SERVICEABILITY CHANGE
   SI53272      OSP-DB Internal Maintenance
   SI53270      OSP-DB-MSGCPF2471-F/QSQROUTE-MSGMCH1210-F/QSQFETCH UNINIT CU
   SI53216      OSP-DB-OTHER-UNPRED SERVICEABILITY CHANGE TO DIAGNOSE MSGMCH
   SI53177      OSP-DB-OTHER-F/QSQROUTQ-T/QSQROUTQ-MSGMCH1210 A MSGMCH1210 M
   SI53169      OSP-DB-MSGSQ20141 from truncation of parameter default value
   SI53008      OSP-DB-OTHER-UNPRED SERVICEABILITY CHANGE
   SI52970      OSP-DB-MSGSQL0517-F/QSQRUN3 PREPARE/EXEC STMT FAILURE USING
   SI52618      OSP-DB do not treat connect reset as set connection
   SI52615      OSP-DB-MSGSQL7971-F/QSQCONN CLT SPC REG INIT WSQG_DB2_MODULE
   SI52479      OSP-PERFM 1GB TERASPACE FILE EXTENDS CAUSING DRIVES TO BE BU
   SI52309      OSP-DB-OTHER-T/QQQQEXIT-MSGMCH0601
   SI52278      OSP-DB-OTHER-MSGSQL0443 SERVICEABILITY ENHANCEMENT
   SI52249      OSP-DB-SQL Support optionally setting indicator on truncatio
   SI51791      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
   SI51771      OSP-DB Internal Maintenance
   SI51599      OSP-DB-OTHER-T/QSQMSGAR-MSGCPF2499
   SI51572      OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGMCH1211 STRQMQRY
   SI51440      OSP-DB-SQL Support optionally setting indicator on truncatio
   SI51393      OSP-DB MCH1210 F/T: QSQSTATS/QSQSTATS
   SI51269      OSP-DB-OTHER-F/QSQCONN-T/QSQCONN-MSGSQL7022 MSGSQL7022 F/QSQ
   SI51213      OSP-DB-SQL Dynamic Compound Statement Support
   SI51077      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0301 INSERT FAILS WIT
   SI51074      OSP-DB TRUNCATION WARNING FOR SQL SET OF TIMESTAMP GLOBAL VA
   SI51063      OSP-DB-SQL Dynamic Compound Statement Support
   SI50960      OSP-DB-OTHER-INCORROUT SQL CLI NOT HANDLING BATCH UPDATE OPE
   SI50933      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0330 MERGE FAILED FOR
   SI50923      OSP-DB-SQL Dynamic Compound Statement Support
   SI50877      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0518 A MSGSQL0518 M
   SI50863      OSP-DB-OTHER-F/QSQCALLSP-T/QSQCALLSP-MSGSQL0303 SQL0303 ON C
   SI50640      OSP-DB-MSGCPF5035-F/QDBSIGEX-T/QDBCLOSE-RC17 QM QUERY FAILUR
   SI50635      OSP-DB-MSGCPF5035-F/QDBSIGEX-T/QDBCLOSE-RC17 QM QUERY FAILUR
   SI50631      OSP-DB-OTHER-F/QSQRUN2-MSGMCH3601 WHEN UDF IS CALLED RECURSI
   SI50619      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0330 MERGE FAILED FOR
   SI50555      OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGSQL0446 AFTER UPGRADING
   SI50468      OSP-DB-OTHER-T/QSQRUND-MSGMCH3601
   SI50436      OSP-DB INTERNAL MAINTENANCE
   SI50411      OSP-DB-OTHER-F/QDBIOERRQO-T/QQURB-RC1-MSGCPF503E UDF WITH TR
   SI50365      OSP-DB CLI JOB uses wrong nlss info
   SI50325      OSP-DB-MSGSQL0429 Using LOB variable within a SQL procedure
   SI50118      F/QSQROUTX-MSGSQL0392 MSGSQL0392 ASSIGNMENT OF LOB OR XML TO
   SI50021      OSP-DB Improve cache performance in SQ processing
   SI50019      OSP-DB-INCORROUT WRONG CLIENT REGISTER VALUES UNDER STRSQL
   SI50007      OSP-DB-OTHER-MSGCPF18BF QSQSVCDMP PRODUCED WITH ONLY CPF18BF
   SI50005      OSP-DB-INCORROUT Inconsistent current timestamp on default f
   SI49981      OSP-DB-OTHER-UNPRED Serviceability improvements
   SI49751      OSP-DB-MSGSQL0842 CONNECT RESET FAILS TO SET BACK TO LOCAL C
   SI49710      OSP-DB-OTHER-T/QSQROUTXX/17988-MSGMCH3601 JOBS STARTED TO FA
   SI49655      OSP-DB-MSGMCH3601-F/QSQENCPW SET ENCRYPTION PASSWORD FAILURE
   SI49620      OSP-DB MSGMCH0601 F/QSQRUN2 QSQFETCH F_BLKRCDS X/9102 T/QSQR
   SI49616      OSP-MSGSQL0901 A STORED PROCEDURE GETS AN MCH3601 AND SQL090
   SI49519      OSP-DB-OTHER-UNPRED RESTORE 21 HANGS ON THE SAME LIBRARY
   SI49410      OSP-DB INTERNAL MAINTENANCE
   SI49391      OSP-DB-MSGMCH1210-F/QSQROUTX EXECUTE OF SQL INSERT W PARAMET
   SI49347      OSP-DB-THREADS-PERFM EMBEDDED SQL WITH SERVER MODE
   SI49295      OSP-DB-F/#DBCPYFL-T/QSQPROC-MSGMCH3601 STORED PROCEDURE
   SI49267      OSP-DB-OTHER-PERFM BAD PERFORMANCE DUE TO SQL LONG NAME RESO
   SI49205      OSP-DB-OTHER-F/QSQCONN-T/QSQCONN-MSGSQL0842 ON SECOND RUNQRY
   SI49188      OSP-DB-OTHER-UNPRED UNDER SOME CIRCUMSTANCES PROGRAM ASSOCIA
   SI49187      OSP-DB-MSGMCH3601-F/QSQROUTA JAVA UDF THEN SELECT FAILURE
   SI49049      OSP-MSGSQL0904 JDBC APPLICATION USING BATCH UPDATES IS LEAKI
   SI48829      OSP-DB INTERNAL MAINTENANCE
   SI48797      OSP-DB QIBM_SRVRMODE_SBS environment variable adjustment
   SI48754      OSP-DB ADD CLIENT REGISTER SUPPORT TO STRQMQRY COMMAND
   SI48567      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
   SI48567      OSP-DB-OTHER-LOOP ADD CODE TO PREVENT LOOP IN QSQOPEN
   SI48552      OSP-DB-OTHER-T/QSQROUTA-MSGMCH3402 MCH3402 T/QSQROUTA MANY J
   SI48519      OSP-DB INTERNAL MAINTENANCE
   SI48442      OSP-DB-OTHER-RC8488-MSGSQL0901
   SI48415      OSP-DB debug messages are missing with 3 part names
   SI48400      OSP-DB-OTHER-F/DBPMBINARYOPERATIONZONEDASSIGN-T/QDBGETMQO- M
   SI48396      OSP-DB INTERNAL MAINTENANCE
   SI48315      OSP-DB SQL0204 FOR SEQUENCE OBJECT
   SI48275      OSP-DB-OTHER-INCORROUT A QUERY USING DRDA BETWEEN TWO V7R1 I
   SI48233      OSP-DB 3 part named objects not resolved from LIBL
   SI48218      OSP-DB Database monitor output for DRDA queries lacks the OP
   SI48191      OSP-DB-OTHER-RC480-MSGSQL0904
   SI48173      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGMCH3601 ON THE SECOND CA
   SI48146      OSP-DB INTERNAL MAINTENANCE
   SI48102      OSP-DB-OTHER-MSGCPF4167 PRODUCING DUMPS FOR MSGSQL0901 RC102
   SI48100      OSP-DB Add new SQL performance metrics to collection service
   SI48100      OSP-DB Database monitor support for prefiltering RUNSQL comm
   SI47892      OSP-DB QIBM_SQL_SERVICE dumps not produced
   SI47834      OSP-DB-OTHER STRQMQRY WITH RDB FROM R710 TO A R610 SYSTEM MA
   SI47695      OSP-DB-MSGSQL0804 Statement uses XML and is prepared and als
   SI47608      OSP-DB INTERNAL MAINTENANCE
   SI47475      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0918 MCH1809 DUPLIC
   SI47357      OSP-PAR JOB DOING SET STATEMENT IS IN LCKW
   SI47209      OSP-DB-OTHER-F/QQQSRVV1-T/QSQRUN3-MSGCPD4366 A MSGCPD4366 MA
   SI47145      OSP-DB INCORRECT RESULTS DISPLAYED WITH CLOB DATA.
   SI47089      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGMCH3601 MSGMCH3601 F/Q
   SI46974      OSP-F/QSQROUTS-T/QSQROUTS-MSGSQL0804 MERGE FUNCTION FAIL ON
   SI46957      OSP-DB-OTHER-F/QSQGTSPC-T/QSQGTSPC-MSGMCH0601 MSGMCH0601 F/Q
   SI46944      OSP-DB SPECIAL PACKAGE TO SWITCH NAMING MODE FOR SQL
   SI46909      OSP-DB-OTHER-F/EXSNDPM-T/QSQRUN2-MSGMCH5401 WHILE RUNNING SO
   SI46876      OSP-DB-OTHER-SAP400-THREADS-MSGCPF5257 QUERY FAILS WITH CPF5
   SI46720      OSP-DB-QSQPREP-MSGSQL0904 when preparing 3 part naming statm
   SI46710      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQ30020 CONNECT TO FAI
   SI46614      OSP-DB-MSGSQL7001 select using 3 part alias
   SI46475      OSP-DB internal maintenance
   SI46458      OSP-UNPRED STORED PROCEDURE RETURNS THE WRONG RESULT SET
   SI46445      OSP-INCORROUT GET DESCRIPTOR SHOWS UNDOCUMENTED VALUES FOR K
   SI46368      F/QSQXCUTE-MSGSQL0104-RIDS/CLEANUP SETTING AN SQL VARIABLE T
   SI46359      INCORROUT Variable length field not padded after FETCH when
   SI46355      OSP-DB-Other Internal Maintenance
   SI46320      OSP-DB INTERNAL MAINTENANCE
   SI46294      OSP-DB-OTHER-INCORROUT WRONG NUMBER OF COLUMNS RETURNED ON A
   SI46294      OSP-DB-OTHER-F/QSQCONN-MSGSQL0113 HOST VARIABLE PADDED WITH
   SI46285      OSP-OTHER-MSGSQL0519 AFTER CANCEL
   SI46246      OSP-DB INTERNAL MAINTENANCE
   SI46066      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0331 CPYTOIMPF GET MS
   SI45964      OSP-DB Support Insert with Remote Subselect
   SI45825      OSP-DB-QSQCMPDS-MSGMCH1210
   SI45825      OSP-DB-QRWXFDOCA-MSGMCH0601 occurs on SELECT * FROM alias ta
   SI45813      SP/QRWTBAS-MSGSQL0144-RC5-MOD/QRWTQRY-PRCS/5 NESTED SP WITH
   SI45760      OSP-DB-OTHER-MSGSQL0303 MSGSQL0303 MAY OCCUR WITH A USER DEF
   SI45625      OSP-DB-MSGSQL0501 with 3 part name to DB2 for Z
   SI45598      OSP-F/QSQROUTX-T/QSQROUTX-MSGSQ30000 MSGSQ30000 F/QSQROUTX T
   SI45490      OSP-DB-OTHER-PERFM Convert CCSID short to long form using ex
   SI45334      OSP-DB-OTHER-PERFM ENHANCEMENTS MADE TO RECOGNIZE STATEMENTS
   SI45187      OSP-DB-MSG MCH3601 QSQCALLSP calling procedure
   SI45073      OSP-DB-MSGSQL0843 ISQL DISCONNECT FAILURE USING OPTICONNECT/
   SI45029      OSP-DB-MSGSQL0084 repeated connect fails
   SI45016      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGSQL0305 CHARACTER CONV
   SI44990      OSP-DB DBCLOB to CLOB assignment fails
   SI44946      OSP-DB sql with alias using 3 part name fails
   SI44905      OSP-F/QSQROUTS-T/QSQROUTS-MSGMCH3601 MSGMCH3601 F/QSQROUTS F
   SI44863      OSP-DB-OTHER CODE UPDATES TO VERIFY USE OF EXPRESSION EVALUA
   SI44823      OSP-DB ADD Application information to SQL0901 logger
   SI44822      OSP-DB set connection statement fails from odbc
   SI44785      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0313 SQL0313 CALLING
   SI44785      OSP-DB-OTHER-F/QRWTBAS-T/QRWTBAS-MSGMCH3601 SOME STORED PROC
   SI44745      OSP-DB-OTHER-F/#CCEXCEP-T/QSQSBAS-MSGMCH5003 A MSGMCH5003 MA
   SI44743      OSP-DB table incorrectly searched on local sytem insted of r
   SI44467      OSP-DB-OTHER-T/QSQDSCPTX/6103-MSGSQL0904 FETCH NEXT FROM C1
   SI44415      OSP-DB internal maintenance
   SI44357      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGMSGSQL0204 DRDA CONNECTI
   SI44347      OSP-DB-OTHER-UNPRED SQLERRD5 NOT SET TO  100 WHEN FETCHING O
   SI44304      OSP-DB-INCORROUT SQL DETAILS FOR JOB DOES NOT REFRESH
   SI44304      OSP-DB-INCORROUT SQL DETAILS FOR JOB DOES NOT REFRESH
   SI44238      OSP-DB-OTHER-MSGCPF32A5 A MSGCPF32A5 CCSID 13488 FOR FIELD *
   SI44229      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGMCH3601 AFTER THE 2ND
   SI44124      OSP-DB-OTHER-UNPRED SQLERRD5 NOT SET TO  100 WHEN FETCHING O
   SI44086      OSP-DB-MSGMCH0601-T/QSQSBAS MODULE QSQCLSCR PROCEDURE SQCLOS
   SI44066      OSP-DB Allow GET DIAGNOSTICS MESSAGE_TEXT from external UDF/
   SI44008      OSP-DB OPEN/FETCH QUERY DATA PARTIAL ROW FIXES
   SI43801      OSP-DB-OTHER VARIOUS FIXES FOR SELECT FROM INSERT
   SI43734      OSP-F/QSQROUTX-T/QSQROUTX-MSGMCH3601 MSGMCH3601 F/QSQROUTX T
   SI43566      OSP-DB ADDITIONAL TCPIP FILTERING ENHANCEMENTS
   SI43318      OSP-DB-OTHER-INCORROUT SELECTING FIELD INTO VARCHAR WITH MIX
   SI43162      OSP-DB-MSGMCH5003 during SQL SET integer from character valu
   SI43129      OSP-DB-MSGSQL0204 when using an alias for 3 part name
   SI42999      OSP-DB-INCORROUT Array Support
   SI42981      OSP-DB Connect By support
   SI42854      OSP-DB-UNPRED Internal DRDA Maintenance
   SI42839      OSP-DB-QSQCMPDS High CPU during long running job
   SI42813      OSP-DB-OTHER-PERFM LOTS OF CPU TIME SPENT IN QSQCMPDS
   SI42724      OSP-DB-OTHER-INCORROUT SQL PACKAGE USAGE DATE NOT UPDATING.
   SI42720      OSP-DB SQL cancel improvements
   SI42679      OSP-DB-QSQROUTQ performance improvement
   SI42671      OSP-DB-MSGMCH3603 F/QSQSBAS QSQTHDTM
   SI42630      OSP-DB-MSGSQL0822 Using QSQPRCED API to run MERGE statement
   SI42508      OSP-DB-MSGMCH0601 F/QSQROUTQ PREPARE OF STATEMENT CONTAINING
   SI42280      OSP-DB-OTHER-F/QSQROUTS-MSGMCH3601 MODULE QSQSRVRC
   SI42275      OSP-DB-OTHER-F/QSQSBAS2-T/QSQSBAS2-MSGMCH3402 MCH3402 PRODUC
   SI42201      OSP-DB-OTHER-F/QSQSBAS-MSGMCH3601 WHEN RUNNING A STATEMENT W
   SI42174      OSP-DB-OTHER-F/QDBIOERRQO-T/QSQRUN2-MSGCPD5036 A MSGCPD5036
   SI42142      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0501 SQL0501 OCCURS
   SI42074      OSP-DB-OTHER-INCORROUT INVALID NULL INDICATORS RETURNED TO D
   SI41922      OSP-DB support atomicity in block merge
   SI41872      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGMCH3601 STORED PROCEDU
   SI41568      OSP-DB-MSGMCH3601-T/QSQROUTX
   SI41480      OSP-DB-UNPRED Retry of table to alias modification failing
   SI41467      OSP-DB-UNPRED Support QIBM_SQL_PASSIVE_UNQUALIFIED_RDB
   SI41441      OSP-MSGMCH3601-PAR-940XBASE SOME QUERIES ARE GENERATING MCH3
   SI41441      OSP-DB-OTHER-PERFM THE USE OF SQL UDF CALLS IS CAUSING HIGH
   SI41441      OSP-DB SQ EXIT PROGRAM FAILED AND ENDED QDBXRVXR2.
   SI41441      OSP-DB-OTHER-INCORROUT CPYTOIMPF RETURNS INCORRECT DATA ON B
   SI41441      OSP-DB SQL DELETE LOOPS WITH MSGSQL0918
   SI41295      OSP-DB-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
   SI41273      OSP-DB-MSGMCH3601-T/QSQROUTX intermittent problem
   SI41231      OSP-DB-UNPRED Reprepare of DRDA cursors when open attributes
   SI41061      OSP-DB-UNPRED Retry of three-part table to alias change fail
   SI41051      OSP-DB-F/QSQROUTQ-MSGMCH1210 CALL with expressions and XML g
   SI41043      OSP-DB-UNPRED Statistics causing three-part naming to corrup
   SI40977      OSP-DB-UNPRED Authorization failure retrieving stored proced
   SI40974      OSP-DB-OTHER-F/QDMCLOSE-MSGMCH6216
   SI40961      OSP-DB-INCORROUT Expressions in CALL Support
   SI40941      OSP-DB-MSGSQL0303 F/QSQRUN2/QSQFETCH RETURNING NULL XML IN R
   SI40941      OSP-DB-MSGSQL0901 F/QSQRUN2/QSQVALUE RC=1205 LOCK ESCALATION
   SI40930      OSP-DB-UNPRED Generated three-part naming queries failing
   SI40916      OSP-DB-UNPRED Implicit package creation failing for SQL proc
   SI40881      OSP-DB-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
   SI40791      OSP-DB simple insert fails in a long running job
   SI40737      OSP-DB-MSGCPF5153-T/QSQFETCH on complex merge
   SI40685      OSP-DB-INCORROUT Array Support Performance
   SI40675      OSP-DB-INCORROUT Expressions In CALL Support
   SI40610      OSP-DB-UNPRED Three part alias statement rewrite
   SI40602      OSP-DB Incorrect failure info for insert
   SI40531      OSP-DB-UNPRED Three part alias retry corrections
   SI40414      OSP-DB-OTHER-F/STRINGHIGHUSE-T/QSQRUN2-MSGMCH3601 SELECT STA
   SI40414      OSP-DB QM QUERY FAILS WITH MCH1210
   SI40384      OSP-DB-INCORROUT Array Support
   SI40342      OSP-DB-MSGSQ99999-T/QSQCLI procedure SQLGDF
   SI40304      OSP-DB-UNPRED SQL statements not picking up table to alias c
   SI40280      OSP-DB QSQSRVR jobs not running in QSYSWRK
   SI40260      OSP-DB-UNPRED DRDA errored connections not going to unconnec
   SI40236      OSP-DB-OTHER-INCORROUT SQL0803 ERROR RETURNS WRONG # OF ROWS
   SI40192      OSP-DB-OTHER-INCORROUT DRDA QUERY OUTPUT INCORRECT
   SI40173      OSP-DB-MSGSQL0501 on result set cursor
   SI40152      OSP-DB-OTHER Expressions in CALL Support
   SI40086      OSP-THREADS-F/QSQROUTS-T/QSQROUTS-RC423-MSGSQL0904 SQL0904 F
   SI40041      OSP-DB-OTHER-UNPRED  WRONG CURSOR SELECTED ON EXECUTE IMMEDI
   SI40000      OSP-DB various errros when using hetero client
   SI39993      OSP-DB MCH1210 F/QQQSRVE1 MODULE QQQOOOSETS PROCEDURE SETUP_
   SI39991      OSP-DB-OTHER-UNPRED 1000 3000 Storage Managment VLOGs
   SI39969      OSP-DB-QSQSTATS-MSGMCH3601
   SI39898      OSP-DB-QSQASLOC-MSGSQL0204 when using specific name on ASSOC
   SI39828      OSP A SQL COMING IN FROM DRDA IS USING THE WRONG CURSOR.
   SI39826      OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QSQXCUTE-MSGMCH0601
   SI39807      OSP-DB erroneous check constraint error msg
   SI39759      OSP-DB-MSGSQL0900 connect with global variable
   SI39734      OSP-DB-MSGMSQL0901-F/QSQFETCH Procedure BF_SET
   SI39710      OSP-DB-UNPRED Java stored procedure result sets failing over
   SI39691      OSP-DB-INCORROUT PERFORMANCE CLI FETCH RELEASE-TO-RELEASE
   SI39666      OSP-DB-MSGMCH3601-T/QSQPREP with inflate table
   SI39656      OSP-DB-UNPRED INTERNAL GLOBAL VARIABLE MAINTENANCE.
   SI39643      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0551 SQL PACKAGE STAT
   SI39635      OSP-DB-OTHER-INCORROUT RPGLE PROGRAM USING DESCRIPTORS RETUR
   SI39519      OSP-DB-OTHER-F/QSQFETCH-T/QSQFETCH-MSGMCH3601 F_MAPLOBLOC
   SI39516      OSP-DB-INCORROUT Array Support
   SI39507      OSP-DB multi value merge fixes
   SI39498      OSP-DB Internal Maintenance
   SI39491      OSP-DB-INCORROUT Expressions In CALL Support
   SI39446      OSP-DB-UNPRED Java stored procedure result sets failing over
   SI39357      OSP-DB extra diag item returned in drda job
   SI39351      OSP-DB-OTHER-UNPRED XML PROCESSING
   SI39342      OSP-DB-MSGMCH3601-F/QSQFETCH Array Support
   SI39329      OSP-DB-MSGSQL0508 in drda job
   SI39272      OSP-F/QSQRUN2-T/QSQRUN2-MSGSQL0303 MSGSQL0303 F/T/QSQRUN2
   SI39253      OSP-DB decfloat error not signalled
   SI39188      OSP-DB-QSQPREP-MSGMCH1210 when using result sets
   SI39176      OSP-DB Internal Maintenance
   SI39151      OSP-DB-MSGMCH0601-T/QSQDITEM in drda job updates
   SI39133      OSP-DB-MSGMCH3601-T/QSQVATTR with batch updates
   SI39116      OSP-DB-MSGMCH3601 f/t stringHighUse4K/QSQROUTE issued in enc
   SI39073      OSP-DB Internal Maintenance
   SI39062      OSP-DB Internal Maintenance
   SI39056      OSP-DB-OTHER-UNPRED MISSING SQL0364 DECLFOAT WARNING
   SI38966      OSP-DB fetch over drda return incorrect rows
   SI38910      OSP-DB Internal Maintenance
   SI38864      OSP-DB-OTHER-T/QSQCONN-MSGMCH6903
   SI38795      OSP-DB-OTHER-INCORROUT DRDA RETURNS LAST ROW TWICE
   SI38789      OSP-DB Internal Maintenance
   SI38787      OSP-DB-MSGMCH0601 F/STRINGHIGHUSE4K T/QSQCALLSP OPM PROGRAMS
   SI38785      OSP-DB-INCORROUT Array Support
   SI38750      OSP-DB-MSGSQ30000 Errors Running from V7R1 to V7R1/V6R1 Usin
   SI38675      osp-db-incorrout Stored Procedure Output Parameter is not up
   SI38672      OSP-DB Internal Maintenance
   SI38658      OSP-DB Internal Maintenance
   SI38589      OSP-DB-MSGMCH3601 F/QSQRUN2 MODULE/QSQVALUE F_MAP QUERY USIN
   SI38565      OSP-DB-OTHER-F/QSQFETCH-MSGMCH3601 PROCEDURE DTTERR
   SI38558      OSP-DB-QQQQEXIT-MSGMCH4417 in server mode
   SI38533      OSP-DB Internal Maintenance
   SI38504      OSP-DB Internal Maintenance
   SI38491      OSP-DB-OTHER LOB PROCESSING
   SI38427      OSP-DB-MSGMCH3601 T/QSQCLSCR NESTED STATEMENTS CONTAINING GL
   SI38403      OSP-DB multi row merge fails
   SI38345      OSP-DB-MSGMCH3601 F/QSQRUN2 MODULE/QSQVALUE PROCEDURE F_MAP_
   SI38308      OSP-DB Internal Maintenance
   SI38293      OSP-DB-MSGMCH3601 F/QSQROUTA SET GLOBAL VARIABLE = DEFAULT I
   SI38284      OSP-DB-INCORROUT Array Support
   SI38277      OSP-DB-OTHER-MSGSQL7953 MISSING LIBRARY NAME ON SQL DROP
   SI38189      OSP-DB-INCORROUT Array Support
   SI38137      OSP-DB-OTHER RESULT SET PROCESSING
   SI38122      OSP-DB-INCORROUT DRDA Array Support
   SI38118      OSP-DB failure in qsqrund
   SI38098      OSP-DB Internal Maintenance
   SI38027      OSP-DB-INCORROUT DRDA UPDATE WITH MIXTURE OF GLOBAL VARIABLE
   SI38018      OSP-DB Internal Maintenance
   SI38010      OSP-DB-MSGSQL0204 SET DESCRIPTOR references UDF in remote co
   SI38006      OSP-DB-INCORROUT SQL UPDATE WITH GLOBAL VARIABLES AND MIXTUR
   SI37981      OSP-DB-OTHER-F/QSQCONN-T/QSQCONN-MSGMCH3402 DISCONNECT IASP
   SI37979      OSP-DB-QSQVALUE-MSGMCH3601 when using descriptors
   SI37977      OSP-DB-OTHER-WAIT DLTLIB DOES NOT COMPLETE
   SI37968      OSP-DB No error message from program QSQ901
   SI37924      OSP-DB multi value updates
   SI37910      OSP-DB-INCORROUT VALUES INTO WITH GLOBAL VARIABLE
   SI37908      OSP-DB-MSGSQ20398-F/QSQCALLSP Array Support
   SI37857      OSP-DB-INCORROUT Array Support
   SI37856      OSP-DB-OTHER DRDA PROCESSING
   SI37820      OSP-DB Internal Maintenance
   SI37808      OSP-DB-OTHER-MSGSQL7953 MISSING LIBRARY NAME ON SQL DROP
   SI37796      OSP-DB multi value support
   SI37719      OSP-DB-OTHER-F/QSQRUN3-MSGSQL0404 WHEN INSERTING AN EMPTY ST
   SI37719      OSP-INCORROUT INCORRECT NUMBER OF RECORDS RETURNED WHEN RUNN
   SI37713      OSP-DB Internal Maintenance
   SI37631      OSP-DB-QSQVALUE MSGMCH3601
   SI37609      OSP-DB-INCORROUT VALUES INTO WITH MIXED GLOBAL VARIABLES AND
   SI37609      OSP-DB-INCORROUT SET GLOBAL VARIABLE=DEFAULT
   SI37609      OSP-DB-INCORROUT SET ENCRYPTION PASSWORD WITH GLOBAL VARIABL
   SI37576      OSP-DB-INCORROUT Array Support
   SI37575      OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QRWSQRY-RC00-MSGMCH0601 DDM
   SI37575      OSP-DB-OTHER-F/QRWSEXEC-T/QRWSEXEC-RC01-MSGCPF3E33 DRDA CONN
   SI37563      OSP-DB Internal Maintenance
   SI37558      OSP-DB-MSGSQL0313-F/QSQROUTA Array Support
   SI37537      OSP-DB-MSGMCH3601-F/QSQFETCH Toolbox JDBC
   SI37488      OSP-DB-OTHER XML PROCESSING
   SI37478      OSP-DB Internal Maintenance
   SI37476      OSP-DB Internal Maintenance
   SI37459      OSP-DB-INCORROUT REUSE OF STATEMENT CONTAINING GLOBAL VARIAB
   SI37395      OSP-DB-MSGSQL0501-F/QSQFETCH JDBC Toolbox
   SI37380      OSP-DB-INCORROUT EXECUTE USING MORE HOST VARIABLES THAN PARA
   SI37335      OSP-DB-MSGSQL0303-F/QSQVALUE Array Support
   SI37330      OSP-DB Internal Maintenance
   SI37325      OSP-DB-MSGMCH5003 F/QQQOOOSETS WHEN REUSING STATEMENTS REFER
   SI37306      OSP-DB-MSGSQL0420-F/QSQFETCH Array Support
   SI37251      OSP-DB-INCORROUT HOST VARIABLE NOT SET WHEN GLOBAL VARIABLE
   SI37251      OSP-DB-MSGMCH3601 F/QSQFETCH FOR GLOBAL VARIABLE PROCESSING
   SI37198      OSP-DB-MSGSQL0901-F/QSQVALUE Array Support
   SI37196      OSP-DB-MSGSQL0303 F/QSQROUTS WHEN SET TIMESTAMP GLOBAL VARIA
   SI37190      OSP-DB Internal Maintenance
   SI37188      OSP-DB-MSGSQL0302 F/QSQVALUE SELECT INTO GLOBAL VARIABLE
   SI37188      OSP-DB-MSGMCH3601 F/QSQCALLSP AFTER INSERTING GLOBAL VARIABL
   SI37168      OSP-DB-UNPRED Implicit package creation
   SI37156      OSP-DB CPD4374 MERGE with C-null terminated value for parame
   SI37090      OSP-DB-
   SI37090      OSP-DB-OTHER-PERFM A LOT OF TIME SPENT IN QSQCMPDS
   SI37090      OSP-DB-OTHER-INCORROUT 3RD OR SUBSEQUENT EXECUTION OF A SELE
   SI37018      OSP-DB Array Support
   SI36980      OSP-DB-UNPRED Failure to detect RDB not defined.
   SI36877      OSP-DB XML PROCESSING
   SI36866      OSP DB GLOBAL VARIABLE PROCESSING
   SI36862      OSP-DB-INCORROUT SQL0901 RETURNED TO JDBC RUNNING QUERY
   SI36804      OSP-DB INTERNAL MAINTENANCE
   SI36790      OSP-DB-UNPRED DRDA errors
   SI36784      OSP-DB INTERNAL MAINTENANCE
   SI36737      OSP-DB-MSGSQL0904 type 7 reason code 167
   SI36737      OSP-DB-OTHER-F/QSQCONN-T/QSQCONN-MSGSQL0751 TRIGGER RUNNING
   SI36737      OSP-DB-OTHER-UNPRED QQSPC* TEMPORARY SPACES KEEP INCREASING
   SI36735      OSP-DB XML PROCESSING
   SI36659      OSP-DB-UNPRED DRDA errors
   SI36627      OSP-DB XML processing of SQLXSR objects
   SI36615      OSP-DB-OTHER-F/SQLBC-T/SQLBC-MSGMCH3601 MCH3601 F/QSQCLI T/Q
   SI36615      OSP-OTHER-PERFM CLOSE OF SQL CURSOR TAKING LONGER AFTER UPGR
   SI36584      OSP-DB-UNPRED Server mode error handling
   SI36581      OSP-DB Array Support
   SI36552      OSP DB GLOBAL VARIABLE PROCESSING
   SI36547      OSP-DB-UNPRED Correct LOB override over DRDA
   SI36536      OSP-DB INTERNAL MAINTENANCE
   SI36526      OSP-DB XML PROCESSING
   SI36517      OSP-DB-UNPRED Correct LOB override over DRDA
   SI36446      OSP-DB-UNPRED Correct indicator check for LOBs over DRDA

Summary Information

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


System 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 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"},"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":""}}]

Document Information

Modified date:
26 June 2015