PTF

PTF#:SI49556 - i5/OS
Licensed Program:5761SS1
APAR Fixed:View details for APAR SE55021
Release:6.1
Cumulative Level:C3312610
Superseded by:View fix details for PTF SI55289


Abstract

OSP-DB-INCORROUT-MSGMCH1210-T/QSQOBSTAT OBJECT_STATISTICS


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL
TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5761SS1  610  SI49373   00/00    0000
PRE  5761999  611  MF56663   00/00    0000
PRE  5761999  610  MF56664   00/00    0000
PRE  5761SS1  610  SI42069   00/00    0000
PRE  5761SS1  610  SI40839   00/00    0000
PRE  5761SS1  610  SI44044   00/00    0000
PRE  5761999  610  MF51567   00/00    0000
PRE  5761999  610  MF51003   00/00    0000
PRE  5761999  611  MF51000   00/00    0000
PRE  5761999  611  MF50996   00/00    0000
CO   5761SS1  610  SI49441   00/00    0000
CO   5761SS1  610  SI43638   00/00    0000
CO   5761SS1  610  SI44143   00/00    0000
CO   5761SS1  610  SI44144   00/00    0000
CO   5761SS1  610  SI44145   00/00    0000
CO   5761SS1  610  SI44146   00/00    0000
CO   5761SS1  610  SI41284   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 a library contains a large number of objects, the DB2 for i
supplied Object Statistics UDTF encounters a failure:

SELECT *   FROM TABLE (QSYS2.OBJECT_STATISTICS('QSYS      ','LIB
')) AS P

Results in this failure:
Message ID . . . . . . :   MCH1210       Severity . . . . . . .
:   40
Date sent  . . . . . . :   02/21/13      Time sent  . . . . . .
:   16:12:10
Message type . . . . . :   Escape

From . . . . . . . . . :   IBM           CCSID  . . . . . . . .
:   65535


From program . . . . . . . . . :   QDBSSUDF2

From library . . . . . . . . :     QSYS

From module  . . . . . . . . :     QSQOBSTAT

From procedure . . . . . . . :     OPEN_CALL

From statement . . . . . . . :     1780



To program . . . . . . . . . . :   QDBSSUDF2

To library . . . . . . . . . :     QSYS

To module  . . . . . . . . . :     QSQOBSTAT

To procedure . . . . . . . . :     OPEN_CALL

To statement . . . . . . . . :     1780

CORRECTION FOR APAR SE55021 :
-----------------------------
The MSGMCH1210 T/QDBSSUDF2 Module/QSQOBSTAT Procedure/OPEN_CALL
has been fixed.

CIRCUMVENTION FOR APAR SE55021 :
--------------------------------
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
    --------------  ------------------------------------------------------------
       SI49533      OSP-DB RGZPFM enhancment
       SI49440      OSP-DB ADD DB2 FOR i SUPPLIED OBJECTS
       SI49440      OSP-DB ADD DB2 FOR i SUPPLIED OBJECTS
       SI49365      OSP-DB RGZPFM Incremental Enhancement
       SI49365      OSP-DB RGZPFM enhancment
       SI49286      OSP-DB ADD DB2 FOR i SUPPLIED OBJECTS
       SI49052      OSP-DB QSYS2/SYSCOLUMNS2 HAS_DEFAULT column contains the wro
       SI48994      OSP-DB-OTHER-F/QDBSSUDF2-T/QDBSSUDF2-MSGMCH1210 MCH1210 IN Q
       SI47429      OSP-DB Enhance QSYS2/SYSSCHEMAS to avoid AF journal entries
       SI47315      OSP-DB INTERNAL MAINTENANCE
       SI46550      OSP-DB-OTHER-UNPRED SHOW INDEXES IN INAVIGATOR RESULTS IN AN
       SI46124      OSP-DB-OTHER-QDBEXDFI QDBRNMLB infinite loop during IPL
       SI45391      OSP-DB ADD procedure QSYS2.Reset_Table_Index_Statistics()
       SI45390      OSP-DB ADD procedure QSYS2.Reset_Table_Index_Statistics()
       SI44792      OSP-DB INTERNAL MAINTENANCE
       SI44693      OSP-DB-INCORROUT USING QSYS2/SYSCOLUMNSTAT
       SI44693      OSP-DB-MSGMCH3601-T/QDBSSUDF2 QSQPKSTAT Procedure SET_EARLIE
       SI44200      OSP-DB-OTHER-INCORROUT AN INDEX OVER A PARTITIONED TABLE MAY
       SI44142      OSP-DB-OTHER-UNPRED DEADLOCK BETWEEN CONCURRENT JOBS EXTRACT
       SI41020      OSP-DB Directory locking improvements
       SI34134      OSP-DB-F/QDBEXTWU-T/QWHDSDBR-MSGCPF32BE MSGCPF32BE F/QDBEXTW
       SI44045      OSP-DB ADD QSYS2/Display_journal_entry_info() procedure
       SI43973      OSP - DB MCH3601 f/QDBEXDME t/ QDBEXDME
       SI43538      OSP-DB INTERNAL MAINTENANCE
       SI43269      OSP-DB-INCORROUT QSYS2/OBJECT_STATISTICS OBJCREATED column
       SI42846      OSP-DB-OTHER-T/QSQOBSTAT-MSGMCH1001 MCH1001 FOR QSQOBSTAT
       SI42729      OSP-DB ADD CONSISTENCY_TOKEN COLUMN to QSYS2/SYSPROGRAMSTAT
       SI42576      OSP-DB-MSGMCH3601-T/QDBPIDISK QSYS2/SYSPARTITIONDISK
       SI41864      OSP-DB-OTHER-QDBEXDME and EXTDBMI changes
       SI41816      OSP-DB Internal Maintenance
       SI41579      OSP-DB-OTHER-PERFM QUSRMBRD API CONSUMES EXCESSIVE RESOURCE
       SI41282      OSP-DB INTERNAL MAINTENANCE
       SI40840      OSP-DB Internal maintenance
       SI40605      OSP-DB QSYS2/SYSPACKAGESTAT and SYSPROGRAMSTAT fail to compl
       SI40421      OSP-DB Internal Maintenance
       SI40099      OSP-DB Internal Maintenance
       SI39823      OSP-DB Object statistics improvement
       SI39823      OSP-DB Internal Maintenance
       SI39823      OSP-DB Internal Maintenance
       SI38511      OSP-DB Internal Maintenance
       SI37899      OSP-DB-OTHER-LOOP WHEN TRYING TO ACCESS A TABLE THAT THE USE
       SI36588      OSP-DB-OTHER-T/QSQHEALTH-MSGSQL0443 Health Activity
       SI36317      OSP-DB-INCORROUT QUERYEST column in QSYS2/CONDIDXA view
       SI35805      OSP-DB-OTHER-INCORROUT INDEX ADVISER
       SI35750      OSP-DB Extend SYSPARTITIONSTAT and SYSTABLESTAT
       SI35383      OSP-DB-OTHER-PERFM SYSTEM I NAVIGATOR, INDEX ADVISOR->CONDEN
       SI34105      OSP-DB-PERFM ALTERNATIVE TO SYSIBM.SCHEMATA
       SI32926      OSP-DB INTERNAL MAINTENANCE
       SI31117      OSP-DB MCH1210 f/QDBSSUDF2 t/QDBSSUDF2 querying SYSTABLESTAT
       SI30764      OSP-DB-MSGSQL0443-T/QDBSSUDF2 Using QSYS2/SYSPARTITIONSTAT
       SI30273      OSP-DB Add NEXT_IDENTITY_VALUE to QSYS2/SYSPARTITIONSTAT
       SI29934      OSP-DB-MSGMCH1210-F/QSQENVLIM ENVIRONMENTAL LIMITS
       SI29332      OSP-DB-MSGSQL0443-F/QDBSSUDF2 SYSIBM/SQLSCHEMAS
       SI40848      OSP-DB Directory locking improvements
       SI38497      OSP-DB Internal Maintenance
       SI38068      OSP-INCORROUT QUSRMBRD API IS RETURNING INCORRECT DATA FOR T
       SI31615      OSP-DB-OTHER-INCORROUT PRIMARY KEYS SHOW AS UNIQUE
       SI30275      OSP-DB Navigator Show Indexes displays partitioned indexes a
       SI29695      OSP-DB-MSGMCH3601 QDBEXDME
       SI39851      OSP-DB-OTHER-T/QDBEXDFIX/0CE0-MSGMCH6801 RUNNING CPFY COMMAN
       SI39476      OSP-DB DSPFD improvements to report constraint logical damag
       SI34875      OSP-PERFM DSPFD TYPE(*MBR) LOCKS LIBRARY QDBEXDFI code
       SI33465      OSP-THREADS-PERFM NEED A WAY TO TURN OFF CHECK PENDING BIT O
       SI32570      OSP-DB-OTHER-RC1-MSGCPF32BE SAVING A FILE MAY ISSUE MSGCPF32
       SI31444      OSP-DB-OTHER-F/QSYDLUP-T/QMNWRKXX-MSGCPF2215
       SI31091      OSP-DB QDBEXDFI  change
       SI49065      OSP-DB INTERNAL MAINTENANCE
       SI48450      OSP-DB INTERNAL MAINTENANCE
       SI48386      OSP-DB INTERNAL MAINTENANCE
       SI47204      OSP-DB INTERNAL MAINTENANCE
       SI47155      OSP-DB Improve performance of SYSIBM/SQLColPrivileges and SQ
       SI46905      OSP-DB INTERNAL MAINTENANCE
       SI46767      OSP-DB-OTHER-T/QDBFFCPY-MSGCPF9999 A RGZPFM MAY ENCOUNTER A
       SI46751      OSP-DB Improve performance of SYSIBM/SQLColPrivileges and SQ
       SI46325      OSP-DB-MSGCPF4328 RGZPFM ALWCANCEL(*YES) with file name over
       SI44707      OSP-DB INTERNAL MAINTENANCE
       SI43694      OSP - DB RGZPFM Internal maintenance
       SI43694      OSP-DB-OTHER-INCORROUT RGZPFM ALWCANCEL(*YES) INCORRECT HAND
       SI43639      OSP-DB ADDITIONAL TCPIP FILTERING IMPROVEMENTS
       SI42071      OSP-DB Internal Maintenance
       SI41909      OSP-DB-OTHER-F/QDBGETDR-T/QDBGETDR-MSGMCH3601 RGZPFM
       SI41564      OSP-DB RGZPFM ALWCANCEL(*YES) TAKES HOURS TO END OVER HUGE F
       SI41452      OSP-DB-OTHER-PERFM RGZPFM DOESN'T CANCEL IN A QUICK TIMEFRAM
       SI41175      OSP-DB-OTHER-F/CFSCVOV-T/QDBRGZMV-MSGMCH3402 ON RGZPFM ON A
       SI40858      OSP-DB Internal Maintenance
       SI38809      OSP-DB-OTHER-THREADS-F/QDBFFCPY-T/QDBFFCPY-MSGMCH RGZPFM FAI
       SI38042      OSP-DB-OTHER-UNPRED RGZPFM ALWCANCEL(*YES) DOES NOT RESUME A
       SI37593      OSP-DB-OTHER-F/QDBFFCPY-T/QDBFFCPY-MSGMCH3402 RGZPFM ALWCANC
       SI33223      OSP-DB Internal Maintenance
       SI33223      OSP-DB-OTHER-T/QDBFFCPY-MSGMCH1210 RUNNING RGZPFM OVER PF WI
       SI33223      OSP-THREADS-F/QJOREAPY-MSGCPF7048 APYJRNCHG FAILS WITH MSGCP
       SI31113      OSP-DB-OTHER-F/QDBFFCPY-T/QDBRGZPF-RC1-MSGCPD3199 RGZPFM USI
       SI30885      OSP-DB-OTHER-F/QDBFFCPY-T/QUIMNDRV-MSGCPF3130 RGZPFM ON V4R2
       SI30154      OSP-DB RGZPFM Performance

    Summary Information

    System..............................................i
    Models..............................................
    Release............................................V6R1M0
    Recompile........................................N
    Library................................................QSYS
    MRI Feature......................................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 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.