IBM Support

SI68913 - SQL-RUN-F/QDBSSUDF2-T/QDBSSUDF2-MSGMCH3601 IN A SYSTEM WITHO

PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

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 SI70519
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C9123720


IBM i Support

IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019 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.

Document information

More support for: i family

Software version: V7R2M0

Operating system(s): OS/400

Reference #: SI68913

Modified date: 09 April 2019