PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB dbmon records missing
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM REL NUMBER MIN/MAX OPTION
---- -------- --- ------- ------- ------
PRE 5770SS1 710 SI59610 00/00 0000
PRE 5770SS1 710 SI59344 00/00 0000
PRE 5770999 710 MF56160 00/00 0000
PRE 5770SS1 710 SI46308 00/00 0000
PRE 5770SS1 710 SI41677 00/00 0000
CO 5770SS1 710 SI58008 00/00 0000
CO 5770SS1 710 SI58010 00/00 0000
CO 5770SS1 710 SI58009 00/00 0000
CO 5770SS1 710 SI55164 00/00 0000
CO 5770SS1 710 SI53842 00/00 0000
CO 5770SS1 710 SI50949 00/00 0000
CO 5770SS1 710 SI50046 00/00 0000
CO 5770SS1 710 SI49848 00/00 0000
CO 5770SS1 710 SI49317 00/00 0000
CO 5770SS1 710 SI48195 00/00 0000
CO 5770SS1 710 SI48198 00/00 0000
CO 5770SS1 710 SI48080 00/00 0000
CO 5770SS1 710 SI48144 00/00 0000
CO 5770SS1 710 SI44868 00/00 0000
CO 5770SS1 710 SI43957 00/00 0000
CO 5770SS1 710 SI41046 00/00 0000
CO 5770SS1 710 SI40611 00/00 0000
CO 5770SS1 710 SI39903 00/00 0000
CO 5770SS1 710 SI39180 00/00 0000
CO 5770SS1 710 SI39377 00/00 0000
DIST 5770SS1 710 SI62645 00/00 0000
DIST 5770SS1 710 SI57814 00/00 0000
DIST 5770SS1 710 SI43062 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
-----------------------------------------------
When both public and private monitors were on, records were
missing in the private monitor
CORRECTION FOR APAR SE65954 :
-----------------------------
Code was changed to capture the missing dbmon records.
CIRCUMVENTION FOR APAR SE65954 :
--------------------------------
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
********************************************************************
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 SI56730 :
=================================================
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
-------------- ------------------------------------------------------------
SI62736 OSP-DB-MSGMCH3601 QZDASOINIT Job Termination Failing with MC
SI62644 OSP-DB-OTHER-INCORROUT DBMON WORK WITH SQL STATEMENT AND VAR
SI60934 OSP-DB INTERNAL MAINTENANCE
SI60391 OSP-DB-PERFM Slow performance when using SQL packages in mul
SI59799 OSP-DB-INCORROUT INLINED SQL FUNCTION
SI59647 OSP-DB INTERNAL MAINTENANCE
SI59457 OSP-DB Create table LIKE with 3-part name issues misleading
SI59356 OSP-DB INTERNAL MAINTENANCE
SI59342 OSP-DB REMOTE INSERT WITH AN ALIAS THAT HAS A 3 PART NAME FA
SI58792 OSP-DB-OTHER-F/QSQRUN3-MSGSQL0517
SI58139 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENTS
SI58129 OSP-DB Internal Maintenance
SI58007 OSP-DB-MSGSQL0206 when column not defined at precompile time
SI57864 OSP-DB-OTHER-T/QSQSBAS2-MSGCPD0018
SI57840 OSP-DB-OTHER-INCORROUT SPECIAL REGISTER VALUE INCORRECTLY RE
SI57816 OSP-DB-OTHER SQL0205 F/QSQRUN2 T/QSQRUN2
SI57813 OSP-DB Internal Maintenance
SI57642 OSP-DB-OTHER-MSGSQL0443 A MSGSQL0443 MAY OCCUR ON SERVER IBM
SI57262 OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
SI57159 OSP-DB-OTHER-INCORROUT 3010 RECORD MISSING FROM STRDBMON OUT
SI57086 OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON
SI56730 OSP-DB-OTHER-F/QXLXPCPARS-T/QXLXPCPARS-MSGMCH6801 FOR XMLVAL
SI56617 OSP-DB-OTHER-F/#AUEXCPTX/0C18-T/QSQSBAS/5018-MSGMCH1001 USIN
SI55887 OSP-DB-OTHER-F/QSQRUN4-MSGMCH0601 WHEN USING A QUERY DEFINED
SI55614 OSP-DB-OTHER-F/#DBDLVLB-T/QQQSRVE1-MSGMCH3203 UPDATE ON TABL
SI55526 OSP-DB QSQPRCED() creates package using a larger capacity *S
SI55267 OSP-DB-OTHER-T/QSQSBAS-MSGMCH1210 MODULE QSQVATTR PROCEDURE
SI55166 OSP-DB-OTHER-RC2-MSGSQL7049
SI55111 OSP-DB-OTHER-UNPRED QSQSVCDMP SPOOLED FILE CREATED
SI54965 OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
SI54583 OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3601
SI54554 OSP-DB INTERNAL MAINTENANCE
SI54531 OSP-DB-OTHER-T/QSQRUN2-MSGSQL0501 WHILE INVOKING TABLE FUNCT
SI54107 OSP-DB INTERNAL MAINTENANCE
SI54033 OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
SI53841 OSP-DB Internal Maintenance
SI53687 OSP-DB-OTHER-F/QYASP-MSGCPDB8E4 ASP VARY ON FAILS DUE TO LOC
SI53267 OSP-DB-OTHER-F/QSQSBAS-MSGMCH1210 A MSGMCH1210 F/QSQSBAS MAY
SI53247 OSP-DB CLIENT SPECIAL REG BRANDING FIX FOR LOCAL CONNECTION
SI52980 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
SI52928 OSP-DB-MSGMCH1210 QSQCKRDB For SQL statement with RDB qualif
SI52617 OSP-DB do not treat connect reset as set connection
SI52586 OSP-DB WHEN USING ALIAS NAME IN SQL THAT IS LONGER THAN 10 C
SI52429 OSP-DB-OTHER-MSGSQL0443 SERVICEABILITY ENHANCEMENT
SI52411 OSP-DB-OTHER-INCORROUT WHEN OVERRIDING A TABLE TO ANOTHER TA
SI52310 OSP-DB-OTHER-T/QQQQEXIT-MSGMCH0601
SI52256 OSP-DB-SQL Support optionally clearing SQLSTATE on truncatio
SI52238 OSP-DB-OTHER-MSGSQL0443 SERVICEABILITY ENHANCEMENT
SI51785 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
SI51678 OSP-DB-OTHER-F/QDMROUTE-T/QSQTRGIO-MSGCPF2207
SI51676 OSP-DB-OTHER-F/QSQSBAS-T/QSQCLOSE-RC461-MSGSQL0904 SQL0904 T
SI51447 OSP-DB-SQL Support optionally setting indicator on truncatio
SI51185 QSQXPATH is changed to *DEFER activation in QSQSBAS2
SI51033 OSP-DB-F/QSQXMLPV-MSGMCH3601 running XMLVALIDATE built-in fu
SI50951 OSP-DB-MSGSQL5001 Column qualified with RDB alias name
SI50755 OSP-DB Incomplete data in dbmon record
SI50627 OSP-DB-OTHER-T/QSQRUN4-MSGSQL0446 MODULE QSQCALLSP RC 1
SI50554 OSP-DB-OTHER-T/QSQRUN4-MSGSQL0446 MODULE QSQCALLSP RC 1
SI50281 OSP-DB Support for Debug of Scalar UDFs with Data Studio
SI50279 OSP-DB SQL serviceability enhancement
SI50254 SP/QSQSBAS2-MSGMCH0602-MOD/QSQQDTNV-RIDS/SQQDTNAV_GETNEXT ST
SI50234 OSP-DB-OTHER-T/QSQRUN1-MSGMCH3402 MODULE QSQPREP PROC PPBLDQ
SI50211 OSP-DB CNN LOOPING POSSIBLE WHEN ALIASED RDB USED IN 3PART D
SI50168 OSP-DB-MSGSQL0114 DRDA 3PART NAMING TO *LOCAL RDB FAILURE
SI50136 OSP-DB Find XML Schema based on target namespace and schema
SI50121 OSP-DB-OTHER-UNPRED DB OPERATION FAILING TO UNMASK
SI50047 OSP-DB Support for Debug of Scalar UDFs with Data Studio
SI50038 OSP-DB HANDLE STRDBMON OUTPUT WITH AN INSTEAD OF TRIGGER
SI50008 OSP-DB-OTHER-MSGCPF18BF QSQSVCDMP PRODUCED WITH ONLY CPF18BF
SI49956 OSP-DB-OTHER-INCORROUT INCORROUT MAY OCCUR WITH UNQUALIFIED
SI49847 OSP-DB ALLOW EXPLICIT USE OF RDB ALIAS WITH 3-PART SQL STATE
SI49406 OSP-DB INTERNAL MAINTENANCE
SI49316 OSP-DB DB2 Connect Management Support
SI49306 OSP-DB-OTHER-F/QSQROUTX-T/QSQROUTX-MSGMCH3601 MSGMCH3601 F/Q
SI49288 OSP-DB SQL serviceability enhancement producing dumps
SI49285 OSP-DB-OTHER-F/QQURA-T/QQUDA-MSGCPF503E IF A FUNCTION IS USE
SI49268 OSP-DB-OTHER-PERFM BAD PERFORMANCE DUE TO SQL LONG NAME RESO
SI48957 OSP-DB-MSGSQL0512 creating procedure with 3 part name and pa
SI48946 OSP-DB INTERNAL MAINTENANCE
SI48828 OSP-DB INTERNAL MAINTENANCE
SI48823 OSP-DB-MSGSQL0512 Create procedure with 3 part name and prog
SI48745 OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGSQL0330 RECEIVING SQL0
SI48564 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
SI48564 OSP-DB-OTHER-LOOP ADD CODE TO PREVENT LOOP IN QSQOPEN
SI48553 OSP-DB CALLING FUNCTION MAY FAIL WITH MSGCPF503E
SI48520 OSP-DB-INCORROUT XMLPARSE does not perserve whitespace corre
SI48505 OSP-DB-MSGSQL0901 running RCLSTG on an IASP
SI48416 OSP-DB debug messages are missing with 3 part names
SI48397 OSP-DB INTERNAL MAINTENANCE
SI48232 OSP-DB-OTHER-UNPRED QSQSRVR JOBLOGS ALWAYS CREATED IF AN SQL
SI48196 OSP-DB-OTHER-RC480-MSGSQL0904
SI48137 OSP-DB INTERNAL MAINTENANCE
SI48133 OSP-DB INTERNAL MAINTENANCE
SI48101 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
SI48078 OSP-DB INTERNAL MAINTENANCE
SI47741 OSP-DB support CREATE TABLE AS with a remote query
SI47364 OSP-DB-OTHER-UNPRED SERVICEABILITY
SI47338 OSP-DB ADD SQL_GVAR_BUILD_RULE QAQQINI OPTION
SI47290 OSP-DB-OTHER-T/QSQRSTAT-MSGMCH3402
SI47069 OSP-DB-OTHER-T/QSQCLOSE-MSGMCH1210 THEY WENT TO THE NEW LEVE
SI46992 OSP-DB-OTHER-INCORROUT QSQFETCH USED WRONG CURSOR, RESULTING
SI46956 OSP-DB-OTHER-F/QSQGTSPC-T/QSQGTSPC-MSGMCH0601 MSGMCH0601 F/Q
SI46903 OSP-DB-OTHER-T/QSQRLSPC-MSGMSGMCH3402
SI46581 OSP-DB-OTHER-T/QSQSFCRT-MSGCPF5183
SI46491 OSP-DB SQL/XML Fixes and Enhancements - Internal Interfaces
SI46366 F/QSQXCUTE-MSGSQL0104-RIDS/CLEANUP SETTING AN SQL VARIABLE T
SI46309 OSP-DB Additional infrastructure for SQL/XML
SI46115 OSP-DB INTERNAL MAINTENANCE
SI46013 OSP-DB-OTHER-INCORROUT WHEN USING SQL_DEFLATE_TABLE QAQQINI
SI45963 OSP-DB Support Insert with Remote Subselect
SI45926 SQL-RUN-INCORROUT GENERATE SQL ON A PROCEDURES THAT CONTAINS
SI45833 OSP-DB-MSGSQ20335 More than one XML schema exist identified
SI45542 OSP-DB-OTHER-RCAD-MSGSQL7917
SI45525 OSP-DB-OTHER-MSGSQL0913-MSGSQL0502 SERVICEABILITY ENHANCEMEN
SI45372 OSP-DB-MSGMCH3402 T/QSQPREP in QDBSxxxxxx system job
SI45138 OSP-DB-OTHER-INCORROUT UPDATE STMT FAILED TO UPDATE TWO COLU
SI44869 OSP-DB-OTHER CODE UPDATES TO VERIFY USE OF EXPRESSION EVALUA
SI44787 OSP-DB-OTHER-F/QRWTBAS-T/QRWTBAS-MSGMCH3601 SOME STORED PROC
SI44669 OSP-DB table incorrectly searched on local sytem insted of r
SI44464 OSP-DB-MSGSQL0206 issued for 3 part name on CALL
SI44437 OSP-DB-OTHER-UNPRED STORAGE LEAK USING SELECT FROM INSERT
SI44338 OSP-DB-OTHER-T/QSQSBAS-MSGMCH3601 MODULE QSQRLSPC CAUSES THR
SI44191 OSP-DB-QSQPREP-MSGMCH3402 when using a restored package
SI44083 OSP-DB-MSGMCH0601-T/QSQSBAS MODULE QSQCLSCR PROCEDURE SQCLOS
SI44067 OSP-DB Allow GET DIAGNOSTICS MESSAGE_TEXT from external UDF/
SI43956 OSP-DB-OTHER VARIOUS FIXES FOR SELECT FROM INSERT
SI43803 OSP-DB-OTHER VARIOUS FIXES FOR SELECT FROM INSERT
SI43803 OSP-DB-OTHER-T/QSQSBAS2-MSGCPF5813 MODULE QSQSFCRT
SI43785 OSP-DB-OTHER-T/QSQSBASX/3277-MSGMCH1401 INSERT STMT RESULTS
SI43697 OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0304 PREPARES DONE IN
SI43634 OSP-DB-OTHER-F/EXSNDPM-T/QSQRUN2-MSGMSGMCH3601 A QZDASOINIT
SI43400 OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH1210 AFTER UPGRADE
SI43063 OSP-DB-OTHER-INCORROUT STATEMENTS NOT ADDED TO AN SQL PACKAG
SI43063 OSP-DB-OTHER-UNPRED EXTENDED DYNAMIC SQL PACKAGE LAST CHANGE
SI42882 OSP-DB-UNPRED Internal DRDA Maintenance
SI42857 OSP-DB-OTHER-PERFM WHEN TRYING TO SEND A LARGE BLOB AS PARAM
SI42857 OSP-DB-OTHER-UNPRED REMOVE STATEMENTS FROM QZDAPKG
SI42842 OSP-DB-OTHER-F/QSQALTER-RC4-MSGSQL0685
SI42834 OSP-DB-QSQCMPDS High CPU during long running job
SI42541 OSP-DB-INCORROUT Inline UDF Support
SI42248 OSP-DB-MSGSQL0723 occurred calling trigger on long running j
SI42173 OSP-DB-OTHER-F/QDBIOERRQO-T/QSQRUN2-MSGCPD5036 A MSGCPD5036
SI42160 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-RC167-MSGSQL0904 QZDASOINIT
SI42123 OSP-DB Internal Maintenance
SI41891 OSP-DB-OTHER Internal Maintenance
SI41762 OSP-DB Internal Maintenance
SI41729 OSP-DB-INCORROUT Inline UDF Support
SI41657 OSP-DB Internal Maintenance
SI41620 OSP-DB-MSGSQL0443 From the TRANSLATE builtin function
SI41589 OSP-DB RCLSTG of IASP is not progressing
SI41477 OSP-DB-INCORROUT Inline UDF Support
SI41422 OSP-DB-UNPRED Support QIBM_SQL_PASSIVE_UNQUALIFIED_RDB
SI41353 OSP-DB Internal Maintenance
SI41317 OSP-DB-UNPRED Statement rewrite fails when alias name longer
SI41300 OSP-DB-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
SI41232 OSP-DB-UNPRED Reprepare of DRDA cursors when open attributes
SI41225 OSP-DB SQ EXIT PROGRAM FAILED AND ENDED QDBXRVXR2.
SI41225 OSP-DB-OTHER-F/QSQCLOSE-MSGCPF9898
SI41045 OSP-DB-OTHER-F/QXLXPCPARS-T/QXLXPCPARS-MSGMCH3601 DECOMPOSE
SI41006 OSP-DB-UNPRED Three-part aliases failing on rewrite of state
SI40962 OSP-DB-INCORROUT Inline UDF Support
SI40880 OSP-DB-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
SI40613 OSP-DB-UNPRED Three part alias statement rewrite
SI40412 OSP-DB QM QUERY FAILS WITH MCH1210
SI40355 OSP-DB-INCORROUT Inline UDF Support
SI40286 OSP-DB-UNPRED SQL statements not picking up table to alias c
SI40171 OSP-DB-MSGSQL0501 for result set cursor
SI40168 OSP-DB-OTHER-MSGMCH2601-T/QSQSBAS MODULE QSQUDTCK
SI40158 OSP-DB-OTHER-MSGMCH3601-T/QSQRUN3 MODULE QSQOPEN WHEN USING
SI40024 OSP-DB INTERNAL MAINTENANCE
SI39990 OSP-DB-OTHER-UNPRED 1000 3000 Storage Managment VLOGs
SI39904 OSP-DB-QSQASLOC-MSGSQL0204 when using specific name on ASSOC
SI39874 OSP-DB-UNPRED Use of DDM for SQL three-part aliases failing
SI39840 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT TO QIBM_SQL_S
SI39833 OSP-DB-MSGMCH3601 F/QQQSQCMP FROM SELECT FROM INSERT STATEME
SI39788 OSP-DB Internal Maintenance
SI39604 OSP-DB-MSGMCH5804-F/RmslLockSpaceLoc-T/QSQRUN1-MOD/QSQDESC S
SI39564 OSP-DB-INCORROUT Inline UDF Support
SI39510 OSP-DB-MSGMCH1210 F/QSQDBMHV RUNNING DATABASE MONITOR WITH L
SI39392 OSP-DB Extended indicators used in INSERT with subselect
SI39378 OSP-DB-OTHER-UNPRED XML LIMITS
SI39350 OSP-DB-OTHER-UNPRED XML PROCESSING
SI39349 OSP-DB-OTHER-F/QSQROUTX-T/QSQROUTX-MSGSQL0313 SELECT FROM FI
SI39162 OSP-DB Internal Maintenance
SI39157 OSP-DB Internal Maintenance
SI39129 OSP-DB Internal Maintenance
SI39117 OSP-DB-MSGMCH3601 f/t stringHighUse4K/QSQROUTE issued in enc
SI39058 OSP-DB Internal Maintenance
SI39024 OSP-DB implicit char to numeric conversion fails
SI38886 OSP-DB Internal Maintenance
SI38834 OSP-DB-OTHER XML PROCESSING
SI38756 OSP-DB Internal Maintenance
SI38697 OSP-DB-OTHER-UNPRED QIBM_SQL_SERVICE ENVIRONMENT VARIABLE NO
SI38569 OSP-DB-INCORROUT Array Support
SI38553 OSP-DB-MSGMCH5003-T/QSQSBAS
SI38441 OSP-DB Internal Maintenance
SI38425 OSP-DB-MSGCPD32D7 Attempting SELECT from INSERT
SI38336 OSP-DB-SQL Array Subcript exceeds bounds
SI38294 OSP-DB-MSGMCH3601 F/QSQROUTA SET GLOBAL VARIABLE = DEFAULT I
SI38225 OSP-DB-OTHER Internal Maintenance
SI38106 OSP-DB-OTHER XML PROCESSING
SI38100 OSP-DB Internal Maintenance
SI38007 OSP-DB-INCORROUT SQL UPDATE WITH GLOBAL VARIABLES AND MIXTUR
SI37956 OSP-DB Internal Maintenance
SI37911 OSP-DB-MSGSQL0901-F/QSQOPEN Array Support
SI37869 OSP-DB-OTHER XML PROCESSING
SI37775 OSP-DB Internal Maintenance
SI37678 OSP-DB Internal Maintenance
SI37629 OSP-DB-QSQRUN4-MSGMCH1210 on ASSOCIATE LOCATOR
SI37627 OSP-DB QSQSBAS2/QSQUDFPR LOOPING when FIELD PROC's are prese
SI37618 OSP-DB Internal Maintenance
SI37612 OSP-DB-PERFM ENHANCE SERVICEABILITY. TRAP WHEN SWSC DESTROYE
SI37591 OSP-DB-OTHER XML PROCESSING
SI37591 OSP-DB-OTHER XML PROCESSING
SI37407 OSP-DB-MSGSQL7049 when running with result sets
SI37389 OSP-DB Internal Maintenance
SI37258 OSP-DB Internal Maintenance
SI37214 OSP AFTER SEVERAL INSERTS BEING DONE IN A SINGLE JOB - THE J
SI37182 OSP-DB XML PROCESSING
SI37180 OSP-DB-UNPRED Failure to create sequence from within stored
SI37162 OSP-DB-UNPRED Failure to create sequence from within stored
SI37140 OSP-DB Internal Maintenance
SI37056 OSP-DB-MSGMCH1210-F/QSQEXPEVAL Array Support
SI36902 OSP-DB INTERNAL MAINTENANCE
SI36876 OSP-DB XML PROCESSING
SI36859 OSP-DB INTERNAL MAINTENANCE
SI36785 OSP-DB-UNPRED DRDA errors
SI36738 OSP-DB XML PROCESSING
SI36682 OSP-DB XML PROCESSING
SI36613 OSP-DB-QSQROUTE-MSGMCH3601 running in server mode
SI36582 OSP-DB Array Support
SI36555 OSP DB GLOBAL VARIABLE PROCESSING
SI36525 OSP-DB XML PROCESSING
SI36444 OSP-DB-UNPRED Three-part naming corrections
Summary Information
System.............................. | i |
Models.............................. | |
Release............................. | V7R1M0 |
Licensed Program............... | 5770SS1 |
APAR Fixed.......................... | View details for APAR SE65954 |
Superseded by:...................... | View fix details for PTF SI68438 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | NONE |
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 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 July 2017