IBM Support

SI57522 - OSP-DB-OTHER-UNPRED RGZPFM - BLOB - EMPTY POINTER - ZERO LEN

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-UNPRED RGZPFM - BLOB - EMPTY POINTER - ZERO LEN


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI55892   00/00    0000
PRE  5770999  710  MF59270   00/00    0000
PRE  5770SS1  710  SI54647   00/00    0000
PRE  5770SS1  710  SI54477   00/00    0000
PRE  5770SS1  710  SI54026   00/00    0000
PRE  5770SS1  710  SI54027   00/00    0000
PRE  5770SS1  710  SI54028   00/00    0000
PRE  5770SS1  710  SI54031   00/00    0000
PRE  5770SS1  710  SI54030   00/00    0000
PRE  5770SS1  710  SI54032   00/00    0000
PRE  5770SS1  710  SI54033   00/00    0000
PRE  5770SS1  710  SI54034   00/00    0000
PRE  5770SS1  710  SI54035   00/00    0000
PRE  5770SS1  710  SI54036   00/00    0000
PRE  5770SS1  710  SI54161   00/00    0000
PRE  5770SS1  710  SI50196   00/00    0000
PRE  5770SS1  710  SI41677   00/00    0000
CO   5770SS1  710  SI57429   00/00    0000
CO   5770SS1  710  SI54478   00/00    0000
CO   5770SS1  710  SI54029   00/00    0000
CO   5770SS1  710  SI50806   00/00    0000
CO   5770SS1  710  SI45895   00/00    0000
CO   5770SS1  710  SI44157   00/00    0000
CO   5770SS1  710  SI44158   00/00    0000
CO   5770SS1  710  SI44159   00/00    0000
CO   5770SS1  710  SI44160   00/00    0000
CO   5770SS1  710  SI43510   00/00    0000
CO   5770SS1  710  SI43509   00/00    0000
CO   5770SS1  710  SI43017   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

-----------------------------------------------
In some circumstances, the final phase of ALWCANCEL(*YES) RGZPFM
could cause non-null and non-zero LOB data to be zeroed.

CORRECTION FOR APAR SE62475 :
-----------------------------
In some circumstances, the final phase of ALWCANCEL(*YES) RGZPFM
could cause non-null and non-zero LOB data to be zeroed. The
final phase has been corrected.

CIRCUMVENTION FOR APAR SE62475 :
--------------------------------
None.


Activation Instructions


To properly enable this PTF for prestarted server jobs,
you will need to stop and restart the host server jobs.

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


None.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI57474      OSP-DB OBJECT_STATISTICS IMPROVEMENTS
   SI57428      OSP-DB INTERNAL MAINTENANCE
   SI57383      OSP-DB-OTHER-F/QDBRGZPF-MSGCPF2982 RGZPFM MSGSQL0900 F/QSQXC
   SI57377      OSP-DB INTERNAL MAINTENANCE
   SI57301      OSP-DB INTERNAL MAINTENANCE
   SI57273      OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
   SI57194      OSP DISPLAY_JOURNAL TABLE FUNCTION HAS STOPPED POPULATING TH
   SI56741      OSP-DB Remove TEMPORARY_STORAGE from QSYS2.ACTIVE_JOB_INFO
   SI56658      OSP-DB Table Function DATABASE_MONITOR_INFO
   SI56431      OSP-DB ADD ACTIVE_JOB_INFO, SCHEDULED_JOB_INFO, DRDA_AUTHENT
   SI56195      OSP-DB INTERNAL MAINTENANCE
   SI56192      OSP-DB INTERNAL MAINTENANCE
   SI56157      OSP-DB Table Function DATABASE_MONITOR_INFORMATION.
   SI56083      OSP-DB-OTHER-INCORROUT USER-DEFINED TABLE FUNCTION DISPLAY_J
   SI55940      OSP-DB Table Function DATABASE_MONITOR_INFORMATION.
   SI55620      OSP-DB INTERNAL MAINTENANCE
   SI55443      CA400EXP-OPNAV-DBASE-INCORROUT FIELD TEXT INCLUDING DBCS GOT
   SI55439      OSP-DB INTERNAL MAINTENANCE
   SI55383      OSP-DB QUERY FAILS WITH MSGMCH3601 T/QDBGETMQO
   SI55367      OSP-DB-INCORROUT-MSGCPD0093 Guardium unable to start
   SI55285      OSP-DB SP/QDBSSUDF2-MOD/QSQJOBLOG Job log on NLV 2989 system
   SI54987      OSP-DB INTERNAL MAINTENANCE
   SI54937      OSP-DB INTERNAL MAINTENANCE
   SI54753      CA400EXP-OPNAV-DBASE-INCORROUT FIELD TEXT INCLUDING DBCS GOT
   SI54753      OSP-DB Improved Turkish support for IBM supplied table funct
   SI54753      OSP-DB-OTHER-UNPRED A RGZPFM MAY NOT HANDLE CONCURRENT INSER
   SI54479      OSP-DB INTERNAL MAINTENANCE
   SI54322      OSP-DB-OTHER-INCORROUT NOT ALL STATEMENTS RETURNED BY SYSPAC
   SI54143      OSP-DB LIBRARY_LIST_INFO and REPLY_LIST_INFO views with asso
   SI54100      OSP-DB JOURNAL_INFO view and associated table function
   SI53914      OSP-OTHER-INCORROUT SQL QUERY TO DETERMINE THE SQL SPACE IN
   SI53543      OSP-DB INTERNAL MAINTENANCE
   SI53328      OSP-DB-MSGCPF5029 Guardium status procedure SYSPROC/SYSAUDIT
   SI53155      OSP-DB INTERNAL MAINTENANCE
   SI53083      OSP-DB-OTHER-T/QSQPKSTST-MSGMCH1210
   SI53076      OSP-OTHER QDBEXDFI CHECK PENDING NOT CORRECT
   SI53074      OSP-DB-MSGCPF4102 QDBSSUDF2/QSQRUN4 GENERATE_SQL procedure
   SI53053      OSP-DB INTERNAL MAINTENANCE
   SI52838      OSP-DB-OTHER-UNPRED INTERNAL MAINTENAINCE
   SI52715      OSP-DB-OTHER-UNPRED INTERNAL MAINTENAINCE
   SI52631      OSP-DB Incremental Enhancement
   SI52372      OSP-DB-OTHER-INCORROUT T-AF INCORROUT LIKE SE52678 WHEN YOU
   SI52036      OSP-DB-MSGMCH3601-T/QSQENVLIM GET_A_ROW
   SI52008      OSP-DB INTERNAL MAINTENANCE
   SI51804      OSP-DB INTERNAL MAINTENANCE
   SI51356      OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGSQL0104 MSGSQL0104 F/Q
   SI51270      OSP-DB Add CP as included by default for new Guardium users
   SI50914      OSP - Incremental Enhancement
   SI50890      OSP-DB INTERNAL MAINTENANCE
   SI50809      OSP-DB Enhance Database Maintenance Index Build Status
   SI50758      OSP-DB INTERNAL MAINTENANCE
   SI50581      OSP-DB-PERFM Improved Guardium monitoring configuration and
   SI50541      OSP-DB SET CORRECT TEXT OF FIELD LENGTH FOR QDBPMSTAT
   SI50237      OSP-DB ADD NEW DB2 for i supplied views
   SI50197      OSP-DB Internal Maintenance
   SI50174      OSP-DB Improved QSYS2/DISPLAY_JOURNAL UDTF
   SI50169      OSP-DB-MSGCPF35BE Querying QSYS2/PTF_INFO catalog
   SI50143      OSP-DB-INCORROUT qsys2.sysprogramstat column NAMING
   SI49961      OSP-DB Improved QSYS2/DISPLAY_JOURNAL UDTF
   SI49853      OSP-DB ADD NEW DB2 for i privilege catalogs
   SI49773      OSP-DB-MSGMCH1210 RGZPFM ALWCANCEL(*YES) fails with MCH1210
   SI49662      OSP-DB-INCORROUT-MSGCPF503E-T/QSQSYSCOL2
   SI49554      OSP-DB-INCORROUT-MSGMCH1210-T/QSQOBSTAT OBJECT_STATISTICS
   SI49534      OSP-DB RGZPFM enhancment
   SI49481      OSP-DB-OTHER Changes to Parallel_Degree *OPTIMIZE percentage
   SI49384      OSP-DB ADD DB2 FOR i SUPPLIED OBJECTS
   SI49384      OSP-DB ADD DB2 FOR i SUPPLIED OBJECTS
   SI49367      OSP-DB RGZPFM Incremental Enhancement
   SI49367      OSP-DB RGZPFM enhancment
   SI41060      OSP-DB-OTHER-QDBRGZPF Omit Default Record For EXTDBM
   SI49335      OSP-DB ADD DB2 FOR i SUPPLIED OBJECTS
   SI49066      OSP-DB INTERNAL MAINTENANCE
   SI49053      OSP-DB QSYS2/SYSCOLUMNS2 HAS_DEFAULT column contains the wro
   SI48995      OSP-DB-OTHER-F/QDBSSUDF2-T/QDBSSUDF2-MSGMCH1210 MCH1210 IN Q
   SI48453      OSP-DB INTERNAL MAINTENANCE
   SI48383      OSP-DB INTERNAL MAINTENANCE
   SI47333      OSP-DB-OTHER-F/QDBIOERRQO-T/QDBIOERRQO-RC1-MSGCPF503E FOR GE
   SI47428      OSP-DB Enhance QSYS2/SYSSCHEMAS to avoid AF journal entries
   SI47312      OSP-DB INTERNAL MAINTENANCE
   SI47205      OSP-DB INTERNAL MAINTENANCE
   SI47154      OSP-DB Improve performance of SYSIBM/SQLColPrivileges and SQ
   SI46906      OSP-DB INTERNAL MAINTENANCE
   SI46769      OSP-DB-OTHER-T/QDBFFCPY-MSGCPF9999 A RGZPFM MAY ENCOUNTER A
   SI46750      OSP-DB INTERNAL MAINTENANCE
   SI46750      OSP-DB Improve performance of SYSIBM/SQLColPrivileges and SQ
   SI46551      OSP-DB-OTHER-UNPRED SHOW INDEXES IN INAVIGATOR RESULTS IN AN
   SI46327      OSP-DB-MSGCPF4328 RGZPFM ALWCANCEL(*YES) with file name over
   SI46123      OSP-DB-OTHER-QDBEXDFI QDBRNMLB infinite loop during IPL
   SI45989      F/QDBSSUDF-MSGMCH1210 MCH1210 QDBRGZMV VALUE TOO SMALL
   SI45936      OSP-DB-MSGMCH3601 T/QDBSSUDF2 querying view SYSPARTITIONSTAT
   SI45897      OSP-DB Incremental enhancement for field procs
   SI45896      OSP-DB Incremental enhancement for field procs
   SI45381      OSP-DB ADD procedure QSYS2.Reset_Table_Index_Statistics()
   SI45380      OSP-DB ADD procedure QSYS2.Reset_Table_Index_Statistics()
   SI45131      OSP-DB-OTHER-PERFM AT 7.1 STRDBG PERFORMANCE IS SLOWER WHEN
   SI44790      OSP-DB INTERNAL MAINTENANCE
   SI44691      OSP-DB-INCORROUT USING QSYS2/SYSCOLUMNSTAT
   SI44691      OSP-DB-MSGMCH3601-T/QDBSSUDF2 QSQPKSTAT Procedure SET_EARLIE
   SI44495      OSP-DB Use MTIs as a source of statistics
   SI44320      OSP-DB-OTHER-INCORROUT AN INDEX OVER A PARTITIONED TABLE MAY
   SI44156      OSP-DB-OTHER-UNPRED DEADLOCK BETWEEN CONCURRENT JOBS EXTRACT
   SI41021      OSP-DB Directory locking improvements
   SI44068      OSP-DB ADD QSYS2/Display_journal_entry_info() procedure
   SI43975      OSP - DB CPF5035 data mapping error canceling RGZPFM shortly
   SI43974      OSP - DB MCH3601 f/QDBEXDME t/ QDBEXDME
   SI43842      OSP-DB-OTHER-F/#dbcpyfl-T/QDBEXDME-MSGMCH5601 when applying
   SI43695      OSP - DB RGZPFM Internal maintenance
   SI43695      OSP-DB-OTHER-INCORROUT RGZPFM ALWCANCEL(*YES) INCORRECT HAND
   SI43569      OSP-DB ADDITIONAL TCPIP FILTERING ENHANCEMENTS
   SI43539      OSP-DB INTERNAL MAINTENANCE
   SI43270      OSP-DB-INCORROUT QSYS2/OBJECT_STATISTICS OBJCREATED column
   SI43018      OSP-DB INTERNAL MAINTENANCE
   SI42847      OSP-DB-OTHER-T/QSQOBSTAT-MSGMCH1001 MCH1001 FOR QSQOBSTAT
   SI42722      OSP-DB ADD CONSISTENCY_TOKEN COLUMN to QSYS2/SYSPROGRAMSTAT
   SI42581      OSP-DB-MSGMCH3601-T/QDBPIDISK QSYS2/SYSPARTITIONDISK
   SI42581      OSP-INCORROUT Base Function to Enable Future Extensions
   SI41994      OSP-DB INTERNAL MAINTENANCE
   SI41860      OSP-DB-OTHER-QDBEXDME and EXTDBMI changes
   SI41902      OSP-DB Internal Maintenance
   SI41574      OSP-DB-OTHER-PERFM QUSRMBRD API CONSUMES EXCESSIVE RESOURCE
   SI40841      OSP-DB Internal maintenance
   SI40606      OSP-DB QSYS2/SYSPACKAGESTAT and SYSPROGRAMSTAT fail to compl
   SI40419      OSP-DB Internal Maintenance
   SI40102      OSP-DB Internal Maintenance
   SI39830      OSP-DB Internal Maintenance
   SI39821      OSP-DB Object statistics improvement
   SI39821      OSP-DB Internal Maintenance
   SI39821      OSP-DB Internal Maintenance
   SI38576      OSP-DB Internal Maintenance
   SI38512      OSP-DB Internal Maintenance
   SI37903      OSP-DB-OTHER-LOOP WHEN TRYING TO ACCESS A TABLE THAT THE USE
   SI37828      OSP-DB Internal Maintenance
   SI37776      OSP-DB Internal Maintenance
   SI37226      OSP-DB Internal Maintenance
   SI36952      OSP-DB Fix message text for GET FILE UDFs
   SI36636      OSP-DB MSGSQL0901 from GET FILE UDFs
   SI36589      OSP-DB-OTHER-T/QSQHEALTH-MSGSQL0443 Health Activity
   SI40849      OSP-DB Directory locking improvements
   SI40160      OSP-DB Internal Maintenance
   SI40032      OSP-DB Internal Maintenance
   SI39410      OSP-DB-OTHER-F/CBLABRANCH-T/QDBEXDME-MSGMCH1210 DSPFD GETS M
   SI38996      OSP-DB-OTHER-F/QQQSVRTNFMOD-T/QQQSVRTNFMOD-MSGCPF504D MSGCPF
   SI38494      OSP-DB Internal Maintenance
   SI38069      OSP-INCORROUT QUSRMBRD API IS RETURNING INCORRECT DATA FOR T
   SI37849      OSP-DB Internal Maintenance
   SI36491      OSP-DB-OTHER-QDBEXDME
   SI36452      OSP-DB-OTHER-QDBEXDME
   SI40287      OSP-DB Incremental Enhancement
   SI39852      OSP-DB-OTHER-T/QDBEXDFIX/0CE0-MSGMCH6801 RUNNING CPFY COMMAN
   SI39617      OSP-DB-OTHER-QDBEXDFI Internal Changes
   SI39485      OSP-DB DSPFD improvements to report constraint logical damag
   SI39174      OSP-DB Internal Maintenance
   SI39030      OSP-DB-OTHER-QDBEXDFI Changes
   SI38537      OSP-DB-OTHER Check Pending Status Incorrect on Partitioned T
   SI38482      OSP-DB Internal Maintenance
   SI42716      OSP-DB SQL cancel improvements
   SI41914      OSP-DB-OTHER-F/QDBGETDR-T/QDBGETDR-MSGMCH3601 RGZPFM
   SI41876      OSP-DB Internal Maintenance
   SI41566      OSP-DB RGZPFM ALWCANCEL(*YES) TAKES HOURS TO END OVER HUGE F
   SI41538      OSP-DB-F/QDBRGZPF-MSGCPF2982 ON RGZPFM WHEN JAVA IS BEING US
   SI41453      OSP-DB-OTHER-PERFM RGZPFM DOESN'T CANCEL IN A QUICK TIMEFRAM
   SI41182      OSP-DB-OTHER-F/CFSCVOV-T/QDBRGZMV-MSGMCH3402 ON RGZPFM ON A
   SI38596      OSP-DB-OTHER-THREADS-F/QDBFFCPY-T/QDBFFCPY-MSGMCH RGZPFM FAI
   SI37594      OSP-DB-OTHER-F/QDBFFCPY-T/QDBFFCPY-MSGMCH3402 RGZPFM ALWCANC

Summary Information

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


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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1 environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
26 August 2015