PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
SQL-RUN-F/QDBSSUDF2-T/QDBSSUDF2-MSGMCH3601 IN A SYSTEM WITHO
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
PRE 5770999 V7R2M0 MF64983 00/00 0000
PRE 5770SS1 V7R2M0 SI68003 00/00 0000
PRE 5770SS1 V7R2M0 SI67583 00/00 0000
PRE 5770SS1 V7R2M0 SI67302 00/00 0000
PRE 5770SS1 V7R2M0 SI64289 00/00 0000
PRE 5770SS1 V7R2M0 SI64633 00/00 0000
PRE 5770SS1 V7R2M0 SI63977 00/00 0000
PRE 5770SS1 V7R2M0 SI63810 00/00 0000
PRE 5770SS1 V7R2M0 SI63605 00/00 0000
PRE 5770SS1 V7R2M0 SI60220 00/00 0000
PRE 5770SS1 V7R2M0 SI57646 00/00 0000
PRE 5770SS1 V7R2M0 SI57382 00/00 0000
PRE 5770SS1 V7R2M0 SI55893 00/00 0000
PRE 5770SS1 V7R2M0 SI56193 00/00 0000
PRE 5770SS1 V7R2M0 SI55390 00/00 0000
PRE 5770SS1 V7R2M0 SI54648 00/00 0000
PRE 5770SS1 V7R2M0 SI54401 00/00 0000
PRE 5770SS1 V7R2M0 SI54038 00/00 0000
PRE 5770SS1 V7R2M0 SI54042 00/00 0000
PRE 5770SS1 V7R2M0 SI54043 00/00 0000
PRE 5770SS1 V7R2M0 SI54045 00/00 0000
PRE 5770SS1 V7R2M0 SI54046 00/00 0000
PRE 5770SS1 V7R2M0 SI54047 00/00 0000
PRE 5770SS1 V7R2M0 SI54049 00/00 0000
PRE 5770SS1 V7R2M0 SI56596 00/00 0000
PRE 5770SS1 V7R2M0 SI55505 00/00 0000
PRE 5770SS1 V7R2M0 SI54494 00/00 0000
CO 5770SS1 V7R2M0 SI68503 00/00 0000
CO 5770SS1 V7R2M0 SI68505 00/00 0000
CO 5770SS1 V7R2M0 SI67787 00/00 0000
CO 5770SS1 V7R2M0 SI62738 00/00 0000
CO 5770SS1 V7R2M0 SI57229 00/00 0000
CO 5770SS1 V7R2M0 SI57227 00/00 0000
CO 5770SS1 V7R2M0 SI58741 00/00 0000
CO 5770SS1 V7R2M0 SI54305 00/00 0000
DIST 5770SS1 V7R2M0 SI67985 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 there aren't any existing iASP on the system,
SELECT * FROM QSYS2.VARY_INFO returns
MCH3601 Pointer not set for location referenced
From program QDBSSUDF2
From module . . . . . . . . : YASPSQVRYP
From procedure . . . . . . :
cleanupClass__FR24YaspVaryInfoScratchPad_t
Statement . . . . . . . . . : 1
To program QDBSSUDF2
To module . . . . . . . . . : YASPSQVRYP
To procedure . . . . . . . :
cleanupClass__FR24YaspVaryInfoScratchPad_t
Statement . . . . . . . . . : 1
CPF503E Diagnostic 30 12/18/18 11:15:00.953787 QQURB QSYS 1741
QQUDA QSYS 03FA
Message . . . . : User-defined function error on member
VARY_INFO.
Cause . . . . . : An error occurred while invoking user-defined
function ASP_VARY_INFO in library QSYS2. The error occurred
while invoking associated external program or service program
QDBSSUDF2 in library QSYS, program entry point or external name
yaspRetrieveIaspVaryPerformance, specific name VARYINFO. The
error occurred on member VARY_INFO file VARY_INFO in library
QSYS2. The error code is 2.
CORRECTION FOR APAR SE70378 :
-----------------------------
The code has been fixed to return the correct SQL state when
there are no IASPs to be processed.
CIRCUMVENTION FOR APAR SE70378 :
--------------------------------
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 SI68584 :
=================================================
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
-------------- ------------------------------------------------------------
SI68829 OSP-DB INTERNAL MAINTENANCE
SI68719 OSP-DB-OTHER-MSGSQL0206
SI68584 OSP-DB-OTHER-F/QmExtend-T/QYASPOL-MSGMCH2804 ASP_INFO PROBLE
SI68584 OSP-DB-OTHER-F/QSQSBAS-T/QSQSBAS-MSGMCH3601 IASP RCLSTG SELE
SI68534 OSP-DB Handle failures in QSYS2/PTF_INFO
SI68507 OSP-DB-OTHER-UNPRED APYJRNCHG IGNORES CHGPF MAXMBRS AND ADDP
SI68501 OSP-DB INCORROUT OBJECT_PRIVILEGES SERVICE
SI68494 OSP-DB-OTHER ACTIVE_JOB_INFO INCORRECT INFORMATION RETURNED
SI68453 OSP-DB-OTHER-INCORROUT OBJECT_STATISTICS RETURNS SQL0100 WHE
SI68436 OSP-OTHER-INCORROUT PLAN CACHE SNAPSHOT DISPLAY IS INCORRECT
SI68412 OSP-DB INTERNAL MAINTENANCE
SI68353 OSP-DB-PERFM IASP VARY ON
SI68170 OSP-DB-OTHER ASP_INFO INCORRECT INFORMATION RETURNED
SI68170 OSP-DB QSQSQLCAT BETTER HANDLE INVALID IASP PARAMETER
SI68133 OSP-DB-OTHER-THREADS-WAIT IASP VARY OFF HUNG, DEADLOCK BETWE
SI67859 OSP-DB INTERNAL MAINTENANCE
SI67859 OSP-DB INTERNAL MAINTENANCE
SI67857 OSP-DB QSYS2.SYSDISKSTAT IS RETURNING A BINARY VALUE (X'01')
SI67788 OSP-DB-OTHER-RC1-MSGCPF503E GET_BLOB_FROM_FILE FAILS WHEN FI
SI67585 OSP-DB Improve SYSPROC.SYSAUDIT_START_BATCH
SI67585 OSP-DB-OTHER-F/QDBSSUDF2-T/QDBSSUDF2-MSGMCH1210 FROM QSYS2.D
SI67459 OSP-DB HISTORY_LOG_INFO SYSLOG_EVENT
SI67315 OSP-DB INTERNAL MAINTENANCE
SI67299 OSP-DB Improve error handling for QSYS2.AUTHORIZATION_LIST_I
SI67248 OSP-DB INDEX ADVICE SQL SERVICE UPDATE
SI67123 OSP-DB INTERNAL MAINTENANCE
SI67040 OSP-DB-OTHER-MSGSQL0206
SI66957 OSP-DB-OTHER-INCORROUT QUERYING THE SQL VIEW QSYS2.MESSAGE_Q
SI66941 OSP-DB INTERNAL MAINTENANCE
SI66930 OSP-DB-OTHER-INCORROUT INCORROUT ON SOME PRODUCTS FOR THE PT
SI66811 OSP-DB Add transaction column to SYSPARTITIONSTAT
SI66627 OSP-DB ENHANCE NETSTAT SERVICES ERROR DATA CAPTURE
SI66612 OSP-DB QSYS2.USER_INFO internal change
SI66557 OSP-DB ENHANCE NETSTAT SERVICES ERROR DATA CAPTURE
SI66520 OSP-DB Internal Maintenance
SI66512 OSP-DB-OTHER-F/QDBRGZPF-MSGCPF3181 RGZPFM ON QSYS2/SYSAUDIT
SI65374 OSP-DB INTERNAL MAINTENANCE
SI65352 OSP-DB-OTHER-F/QSQRUN3X/19728-T/T/QSQRUN3X/19728-MSGSQL0607
SI64453 OSP-DB INTERNAL MAINTENANCE
SI60126 OSP-DB INTERNAL MAINTENANCE
SI59195 OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4X/42334-MSGSQL0443 INAV SHOW
SI58434 OSP-DB-INCORROUT-MSGMCH0601 QSQPDMON Proc/getmsgrsn
SI57936 OSP-DB-INCORROUT Database monitor reconstruction of statemen
SI57496 OSP-DB-MSGSQL0311 F/QSQROUTS T/QSQROUTS
SI56987 OSP OPERATIONS SUMMARY FOR ANALYZED MONITOR DATA HAS INCORRE
SI56807 OSP-DB-OTHER-MSGSQL0913 CALLING QSYS2.EXTRACT_STATEMENTS
SI56666 OSP-DB Access Plan Rebuild summary is incorrect under Analyz
SI56305 OSP-DB INTERNAL MAINTENANCE
SI55977 OSP-DB-OTHER-MSGSQL0104 USING VISUAL EXPLAIN
SI55084 OSP-DB-MSGSQL0443-T/QSQPDMON Compare SQL Plan Cache
SI54769 OSP-DB-MSGMCH1210-T/QSQSBAS QSQRCFHT using QSYS2/EXTRACT_STA
SI54404 OSP-DB INTERNAL MAINTENANCE
SI53994 OSP-DB INTERNAL MAINTENANCE
SI52337 OSP-DB-MSGSQL0443 Token ONLYORDER on Navigator column reorde
SI52150 OSP-DB-INCORROUT-MSGSQL0122 Column QQUCNT
SI51893 OSP-DB INTERNAL MAINTENANCE
SI51226 OSP-DB INTERNAL MAINTENANCE
SI51226 OSP-DB INTERNAL MAINTENANCE
SI66465 OSP-DB INTERNAL MAINTENANCE
SI66424 OSP-INCORROUT Update QPM_QAPMCONF function table as the upda
SI66407 OSP-DB QSYS2.JVM_INFO RETURNS NULL FOR JAVA_THREAD_COUNT WHE
SI66118 OSP-DB-Improve install asynchronous processing
SI66105 OSP-DB ENHANCE NETSTAT SERVICES PORT NAME SUPPORT
SI66080 OSP-DB INTERNAL MAINTENANCE
SI65940 OSP-DB INTERNAL MAINTENANCE
SI65922 OSP-DB INTERNAL MAINTENANCE
SI65866 OSP-DB Internal Maintenance
SI65830 OSP-DB INTERNAL MAINTENANCE
SI65821 OSP-DB NEW STACK_INFO SERVICE
SI65813 OSP-DB INTERNAL MAINTENANCE
SI65798 OSP-DB INTERNAL MAINTENANCE
SI65732 OSP-DB-OTHER-MSGSQL0205 S-TAP UPGRADE. SQL0205 F/QSQRUN3 COL
SI65697 OSP-DB CATALOG FIX FOR BLANK ROUTINE NAMES
SI65697 OSP-DB INTERNAL MAINTENANCE
SI65615 OSP-DB-OTHER-UNPRED QSQXRLF SETASPGRP ALTERNATIVE FILE NAME
SI65581 OSP-DB-OTHER-INCORROUT INCORROUT FOR IASP WHEN USING QSYS2/U
SI65566 OSP-DB INTERNAL MAINTENANCE
SI65395 OSP-DB INTERNAL MAINTENANCE
SI65368 OSP-DB NEW JOB_QUEUE_INFO SERVICE
SI65363 OSP-DB-OTHER-INCORROUT QSYS2.OUTPUT_QUEUE_ENTRIES SERVICE GI
SI65363 OSP-OTHER-F/QDMSIGNL-T/QDBSSUDF-RC01-MSGCPF4101 SQL QUERY OF
SI65237 OSP-DB-OTHER *SHRRD lock left on library after select from O
SI65020 OSP-DB-PERFM Improved performance of USER_INFO catalog
SI64998 OSP-DB QSYS2/PTF_INFO supersede detail
SI64960 OSP-DB INTERNAL MAINTENANCE
SI64956 OSP-DB INTERNAL MAINTENANCE
SI64937 OSP-DB-OTHER-UNPRED A QUERY OF QSYS2/OBJECT_PRIVILEGES MAY R
SI64769 OSP-MSGSQL0443 QUERY AGAINST QSYS2.DISPLAY_JOURNAL RESULTS I
SI64507 OSP-DB GROUP_PTF_CURRENCY fails with PSP INFORMATION NOT AVA
SI64459 OSP-DB Add check for SYSTOOLS objects to QSQIBMCHK
SI64446 OSP-DB JOB_INFO should issue error for filter combination
SI64393 OSP-DB INTERNAL MAINTENANCE
SI64281 OSP-DB OBJECT_PRIVILEGES performance
SI64111 OSP-DB Updates for SYSTOOLS not happening in CCSID 290
SI64011 OSP-DB PARSE_STATEMENT table function returning delimited na
SI63980 OSP-DB INTERNAL MAINTENACE
SI63886 OSP-DB INCORROUT FROM NETSTAT_INTERFACE_INFO FOR PROXY_ARP_E
SI63884 OSP-DB SQL services not updated in SYSTOOLS on IGC system
SI63815 OSP-DB INTERNAL MAINTENANCE
SI63753 OSP-DB INTERNAL MAINTENANCE
SI63753 OSP-DB INTERNAL MAINTENANCE
SI63737 OSP-DB INTERNAL MAINTENANCE
SI63632 OSP-DB Internal Maintenance
SI63511 OSP-F/QDBIOERRQO-T/QDBIOERRQO-RC1-MSGCPF503E CPF503E RC1 ON
SI63501 OSP-DB INTERNAL MAINTENANCE
SI63428 OSP-DB INTERNAL MAINTENANCE
SI63371 OSP-DB INTERNAL MAINTENANCE
SI63189 OSP-WAIT THIS IS AN ENHANCEMENT FIX SO THAT IF AN ENDJOB *IM
SI63181 SOP-DB Missing ROWID in QSYS2/SYSTYPES after RCLSTG
SI62744 OSP-DB-F/QSQFETCH-MSGSQL0904 Reading File Using QSQGTXML, QS
SI63124 OSP-DB MSGMCH3601-QDBSSUDF-QSQJOBINFO querying JOB_INFO
SI62887 OSP-DB INTERNAL MAINTENANCE
SI62883 OSP-DB-OTHER-INCORROUT SQLCOLUMNS JDBC types incorrect
SI62880 OSP-DB SYSTOOLS/HTTP FUNCTIONS ARE DOING CASE SENSITIVE COMP
SI62763 OSP-DB-OTHER-LOOP LOOP WITH QDBRGZMV CALLING QDMCOPEN WITH B
SI62797 OSP-DB INTERNAL MAINTENANCE
SI62729 OSP-DB INTERNAL MAINTENANCE
SI62522 OSP-DB Running QSQSQLCAT tool may fill job message queue and
SI62492 OSP-DB INTERNAL MAINTENANCE
SI62440 OSP-DB INTERNAL MAINTENANCE
SI62263 OSP-DB INTERNAL MAINTENANCE
SI62191 OSP-DB Change QSYS2/DISPLAY_JOURNAL() to apply RCAC
SI61967 OSP-DB-PERMF Improve the performance of QSYS2/OBJECT_LOCK_IN
SI61894 OSP-DB INTERNAL MAINTENANCE
SI61625 OSP-DB INTERNAL MAINTENANCE
SI61556 OSP-DB-PERMF Improve the performance of QSYS2/OBJECT_LOCK_IN
SI61272 OSP-DB Improve SYSTOOLS.GROUP_PTF_CURRENCY for pending appli
SI61227 OSP-DB INTERNAL MAINTENANCE
SI61172 OSP-DB Add prestart job detail to QSYS2.GET_JOB_INFO()
SI60971 OSP-DB INTERNAL MAINTENANCE
SI60885 OSP-DB INTERNAL MAINTENANCE
SI60777 OSP-DB SQL SHIPPED OBJECTS SHOULD BE OWNED BY QSYS
SI60424 OSP-DB-OTHER-INCORROUT Plan Cache VE is showing 0 for rows f
SI60236 OSP-DB VARBINARY missing from QSQ2/SYSTYPES
SI60124 OSP-DB INTERNAL MAINTENANCE
SI60029 OSP-DB INTERNAL MAINTENANCE
SI60029 OSP-DB Add PROCESS_ID and THREAD_ID global variables
SI59957 OSP-DB-OTHER-INCORROUT HTTP FUNCTIONS USE JDBC CONNECTION
SI59919 OSP-DB INTERNAL MAINTENANCE
SI59796 OSP-DB INTERNAL MAINTENANCE
SI59664 OSP-DB-OTHER-INCORROUT SQL...COL JDBC types incorrect
SI59664 OSP-DB-OTHER-INCORROUT SQLTYPEINFO JDBC types incorrect
SI59664 OSP-DB NETSTAT SERVICES ADD NEW COLUMNS
SI59617 OSP-DB Add QSYS2.ENVIRONMENT_VARIABLE_INFO service
SI59617 OSP-DB INTERNAL MAINTENANCE
SI59530 OSP-DB Add PROCESS_ID and THREAD_ID global variables
SI59253 OSP-DB ADD columns to QSYS2/SYSLIMITS
SI59134 OSP-DB internal maintenance
SI58917 OSP-DB ADD columns to QSYS2/SYSLIMITS
SI58742 OSP-DB INFRASTRUCTURE
SI58466 OSP-DB-OTHER-THREADS-INCORROUT SELECT FROM QSYS2/LIB_LIST_IN
SI58450 OSP-DB INTERNAL MAINTENANCE
SI58438 OSP-DB-MSGCPF3D95 Vary on of iASP
SI58433 OSP-DB-OTHER-MSGSQL4302 MSGSQL4302 FOR HTTPPOSTCLOB WITH CON
SI58421 OSP-DB-MSGCPD439C Function INDEX_PARTITION_STATISTICS not fo
SI58350 OSP-DB-MSGCPD439C Function INDEX_PARTITION_STATISTICS not fo
SI58133 OSP-DB INTERNAL MAINTENANCE
SI58085 OSP-DB INTERNAL MAINTENANCE
SI58067 OSP-DB INTERNAL MAINTENANCE
SI58057 OSP-DB INTERNAL MAINTENANCE
SI58024 OSP-DB INTERNAL MAINTENANCE
SI58003 OSP-DB INTERNAL MAINTENANCE
SI57853 OSP-DB ADD ELAPSED_TIME to ACTIVE_JOB_INFO
SI57848 OSP-DB INTERNAL MAINTENANCE
SI57754 OSP-DB INTERNAL MAINTENANCE
SI57427 OSP-DB INTERNAL MAINTENANCE
SI57379 OSP-DB INTERNAL MAINTENANCE
SI57274 OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
SI57231 OSP-DB Table Function DATABASE_MONITOR_INFORMATION
SI57144 OSP-DB-OTHER-INCORROUT INVALID DATE_FMT RETURNED BY SYSPROGR
SI56921 OSP-DB INTERNAL MAINTENANCE
SI56817 OSP-DB INTERNAL MAINTENANCE
SI56808 OSP-DB-OTHER-MSGSQL0913 CALLING QSYS2.EXTRACT_STATEMENTS
SI56778 OSP-DB INTERNAL MAINTENANCE
SI56744 OSP-DB Remove TEMPORARY_STORAGE from QSYS2.ACTIVE_JOB_INFO
SI56668 OSP-DB Update SYSTRIGGERS to correct REMARKS column
SI56434 OSP-DB ADD ACTIVE_JOB_INFO, SCHEDULED_JOB_INFO, DRDA_AUTHENT
SI56404 OSP-DB INTERNAL MAINTENANCE
SI56339 OSP-DB-MSGSQL0204 Function REGEXP_LIKE not found during a va
SI56288 OSP-DB ENHANCE QSYS2/GET_JOB_INFO
SI56241 OSP-DB-OTHER-T/QSQCRTVX/2424-MSGSQL0205 COLUMN CREATE_TIMEST
SI56197 OSP-DB INTERNAL MAINTENANCE
SI56070 OSP-DB Table Function DATABASE_MONITOR_INFORMATION.
SI55871 OSP-DB Table Function DATABASE_MONITOR_INFORMATION.
SI55793 OSP-DB ADD DB2 for i services for Java
SI55754 OSP-DB-INCORROUT qsys2/syspackagestat system_package_name
SI55610 OSP-DB SQLTYPEINFO TIMESTAMP INVALID COLUMN_SIZE & CREATE_PA
SI55597 OSP-DB INTERNAL MAINTENANCE
SI55533 OSP-DB INTERNAL MAINTENANCE
SI55509 OSP-SQ-RUN Support CLEAR_PLAN_CACHE
SI55406 OSP-DB ROUTING DRDA CONNECTIONS TO USER SPECIFIED SBS BY USE
SI55368 OSP-DB-OTHER-F/#AUEXCPT-T/QSQSYSIBM/QSQCCSID-MSGMCH1001
SI55300 OSP-DB INTERNAL MAINTENANCE
SI54938 OSP-DB JOBLOG_INFO table function
SI54770 OSP-DB-MSGMCH1210-T/QSQSBAS QSQRCFHT using QSYS2/EXTRACT_STA
SI54618 OSP-DB ADD SYSTOOLS/GROUP_PTF_CURRENCY VIEW
SI54597 OSP-DB INTERNAL MAINTENANCE
SI54495 OSP-DB INTERNAL MAINTENANCE
SI52545 OSP-DB PRE-GA CPF32F9 during vary-on
SI54139 OSP-DB LIBRARY_LIST_INFO AND REPLY_LIST_INFO views with asso
SI54105 OSP-DB JOURNAL_INFO view and associated table function
SI53972 OSP-DB Set internal CCSID for literals correctly for Turkish
SI53932 OSP-DB INTERNAL MAINTENANCE
SI53802 OSP-DB ADD Procedures to import plan cache into Navigator
SI53565 OSP-DB Internal Maintenance
SI53517 OSP-DB Set internal CCSID for literals correctly for Turkish
SI53447 OSP-DB INTERNAL MAINTENANCE
SI53430 OSP-DB Set internal CCSID for literals correctly for Turkish
SI53376 OSP-DB Internal Maintenance
SI52746 OSP-DB QSQSQLCAT add *FIXEXT parameter
SI53221 OSP-DB Add Last Used column to USER_INFO catalog
SI53093 OSP-DB INTERNAL MAINTENANCE
SI52901 OSP-DB ENHANCE QSYS2/GET_JOB_INFO
SI52874 OSP-DB-Other Enable additional Plan Cache Properties and opt
SI52759 OSP-DB-OTHER-UNPRED INTERNAL MAINTENAINCE
SI52641 OSP-DB Incremental Enhancement
SI52535 OSP-DB INTERNAL MAINTENANCE
SI52457 OSP-DB INTERNAL FIXES FOR VARYON CATALOG PROCESSING
SI52270 OSP-DB Internal Maintenance
SI52270 OSP-DB INTERNAL MAINTENANCE
SI51999 OSP-DB-PERFM CHANGE SYSLIMTBL PRUNER IMPLEMENTATION
SI51906 OSP-DB INTERNAL MAINTENANCE
SI51753 osp-db internal maintenance
SI51462 osp-db internal maintenance
SI53144 OSP-DB SQLCODE 20474 RC 35
SI52505 OSP-DB PRE-GA OPTION 1 INSTALL CLEANUP
SI51992 OSP-DB PRE-GA FIXES RELATED TO CATALOGS AND INSTALL
SI51605 OSP-DB Internal Maintenance
SI51233 OSP-DB Pre-GA fixes for Option 1 Install
SI51279 OSP-DB PRE-GA OPTION 1 INSTALL FIXES
SI57438 OSP-DB-OTHER-INCORROUT SYSIBM PROCEDURES ESCAPE INCORRECT
SI57147 OSP-DB INTERNAL MAINTENANCE
SI56122 OSP-DB-OTHER-THREADS-T/QSQRUN1X/11214-MSGSQL0104 WITH CCSID
SI51372 OSP-DB Support returning cursor from SQLStatistics, SQLProce
SI62636 OSP-DB INTERNAL MAINTENANCE
SI62625 OSP-DB INTERNAL MAINTENANCE
SI62562 OSP-DB INTERNAL MAINTENANCE
SI62453 OSP-DB-OTHER-INCORROUT GARBAGE TEXT RETURNED FROM SYSPROGRAM
SI62295 OSP-DB INTERNAL MAINTENANCE
SI62262 OSP-DB INTERNAL MAINTENANCE
SI62190 OSP-DB Change QSYS2/DISPLAY_JOURNAL() to apply RCAC
SI62136 OSP-DB INTERNAL MAINTENANCE
SI61893 OSP-DB INTERNAL MAINTENANCE
SI61883 OSP-DB MAINTAINED_TEMPORARY_INDEX_SIZE not set in DB2 catalo
SI61555 OSP-DB-PERMF Improve the performance of QSYS2/OBJECT_LOCK_IN
SI61228 OSP-DB INTERNAL MAINTENANCE
SI61212 OSP-DB Object_Lock_Info Thread_ID Output Not Set
SI60886 OSP-DB INTERNAL MAINTENANCE
SI60581 OSP-DB-INCORROUT Guardium audit journal capture and FTRFILE
SI60275 OSP-DB SP/QDBSSUDF2-MSGSQL0802-MOD/QSQJOBLOG
SI60265 OSP-DB subsystem routing problem
SI60125 OSP-DB INTERNAL MAINTENANCE
SI60028 OSP-DB INTERNAL MAINTENANCE
SI59920 OSP-DB INTERNAL MAINTENANCE
SI59665 OSP-DB INTERNAL MAINTENANCE
SI59658 OSP-DB INTERNAL MAINTENANCE
SI59490 OSP-DB-MSGSQL0443 Journal Entry Not Compatible With Table
SI59120 OSP-DB OBJECT_STATISTICS returns *INTLIB for object type of
SI59034 OSP-DB INTERNAL MAINTENANCE
SI58774 OSP-DB QSYS2/PTF_INFO detail incorrect
SI58659 OSP-DB Guardium install failure
SI58605 OSP-DB NETSTAT SERVICES ERROR
SI58436 OSP-MSGMCH3203-D/TQDBGETMQO-PAR QUERY OF SCHEDULED_JOB_INFO
SI58432 OSP-DB-INCORROUT SYSPARTITIONSTAT catalog lacks range detail
SI58211 OSP-DB-OTHER-MSGMCH3601-T/QSQRUN3 PROCEDURE GETUFCB
SI58170 OSP-DB-PERFM Fix memory leak in QSYS2/JVM_INFO
SI58086 OSP-DB INTERNAL MAINTENANCE
SI58066 OSP-DB INTERNAL MAINTENANCE
SI58028 OSP-DB INTERNAL MAINTENANCE
SI58025 OSP-DB Internal maintenance
SI58025 OSP-DB Internal maintenance
SI57967 OSP-DB Incremental Enhancement
SI57967 OSP-DB Incremental Enhancement
SI57882 OSP-DB JVM_INFO error
SI57851 OSP-DB INTERNAL MAINTENANCE
SI57849 OSP-DB F/QGYOLJBL-MSGMCH3601 QSYS2.JOBLOG_INFO
SI57847 OSP-DB INTERNAL MAINTENANCE
SI57846 OSP-DB RGZPFM performance improvement
SI57755 OSP-DB INTERNAL MAINTENANCE
SI57751 OSP-DB INTERNAL MAINTENANCE
SI57523 OSP-DB-OTHER-UNPRED RGZPFM - BLOB - EMPTY POINTER - ZERO LEN
SI57475 OSP-DB OBJECT_STATISTICS IMPROVEMENTS
SI57426 OSP-DB INTERNAL MAINTENANCE
SI57380 OSP-DB INTERNAL MAINTENANCE
SI57275 OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
SI57230 OSP-DB INTERNAL MAINTENANCE
SI57230 OSP-DB STRDBMON Filter Operator Support
SI57195 OSP DISPLAY_JOURNAL TABLE FUNCTION HAS STOPPED POPULATING TH
SI56649 OSP-DB Table Function DATABASE_MONITOR_INFO
SI56567 OSP-DB-MSGMCH1210-T/QDBSSUDF2 QSQOBSTAT SET_NAME
SI56432 OSP-DB ADD ACTIVE_JOB_INFO, SCHEDULED_JOB_INFO, DRDA_AUTHENT
SI56403 OSP-DB INTERNAL MAINTENANCE
SI56194 OSP-DB INTERNAL MAINTENANCE
SI56084 OSP-DB-OTHER-INCORROUT USER-DEFINED TABLE FUNCTION DISPLAY_J
SI56062 OSP-DB Table Function DATABASE_MONITOR_INFORMATION.
SI55861 OSP-DB Table Function DATABASE_MONITOR_INFORMATION.
SI55794 OSP-DB INTERNAL MAINTENANCE
SI55534 OSP-DB Add HISTORY_LOG service
SI55444 CA400EXP-OPNAV-DBASE-INCORROUT FIELD TEXT INCLUDING DBCS GOT
SI55405 OSP-DB INTERNAL MAINTENANCE
SI55400 OSP-DB Internal maintenance
SI55376 OSP-DB QUERY FAILS WITH MSGMCH3601 T/QDBGETMQO
SI55366 OSP-DB-INCORROUT-MSGCPD0093 Guardium unable to start
SI55286 OSP-DB SP/QDBSSUDF2-MOD/QSQJOBLOG Job log on NLV 2989 system
SI54988 OSP-DB INTERNAL MAINTENANCE
SI54939 OSP-DB INTERNAL MAINTENANCE
SI54754 OSP-DB Improved Turkish support for IBM supplied table funct
SI54754 CA400EXP-OPNAV-DBASE-INCORROUT FIELD TEXT INCLUDING DBCS GOT
SI54754 OSP-DB-OTHER-UNPRED A RGZPFM MAY NOT HANDLE CONCURRENT INSER
SI54402 OSP-DB INTERNAL MAINTENANCE
SI54323 OSP-DB-OTHER-INCORROUT NOT ALL STATEMENTS RETURNED BY SYSPAC
SI54138 OSP-DB LIBRARY_LIST_INFO and REPLY_LIST_INFO views with asso
SI54106 OSP-DB JOURNAL_INFO view and associated table function
SI53916 OSP-OTHER-INCORROUT SQL QUERY TO DETERMINE THE SQL SPACE IN
SI53544 OSP-DB INTERNAL MAINTENANCE
SI53330 OSP-DB-MSGCPF5029 Guardium status procedure SYSPROC/SYSAUDIT
SI53251 OSP-DB INTERNAL MAINTENANCE
SI53225 OSP-DB INTERNAL MAINTENANCE
SI53085 OSP-DB-OTHER-T/QSQPKSTST-MSGMCH1210
SI53054 OSP-DB INTERNAL MAINTENANCE
SI53026 OSP-DB-MSGCPF4102 QDBSSUDF2/QSQRUN4 GENERATE_SQL procedure
SI52836 OSP-DB Internal maintenance
SI52836 OSP-DB-OTHER-UNPRED INTERNAL MAINTENAINCE
SI52760 OSP-DB-OTHER-UNPRED INTERNAL MAINTENAINCE
SI52456 OSP-DB-OTHER-INCORROUT T-AF INCORROUT LIKE SE52678 WHEN YOU
SI52195 OSP-DB-MSGMCH3601-T/QSQENVLIM GET_A_ROW
SI52195 OSP-DB INTERNAL MAINTENANCE
SI52012 OSP-DB INTERNAL MAINTENANCE
SI51907 OSP-DB INTERNAL MAINTENANCE
SI51357 OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGSQL0104 MSGSQL0104 F/Q
SI51280 OSP-DB Add CP as included by default for new Guardium users
SI57384 OSP-DB-OTHER-F/QDBRGZPF-MSGCPF2982 RGZPFM MSGSQL0900 F/QSQXC
SI52632 OSP-DB Incremental Enhancement
Summary Information
System.............................. i
Models..............................
Release............................. V7R2M0
Licensed Program.................... 5770SS1
APAR Fixed.......................... View details for APAR SE70378
Superseded by:...................... View fix details for PTF SI85770
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C9123720
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, 2021, 2022, 2023, 2024 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:
13 March 2024