PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
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 |
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.
Was this topic helpful?
Document Information
Modified date:
26 June 2015