PTF

PTF#:SI49440 - i5/OS
Licensed Program:5761SS1
APAR Fixed:View details for APAR SE54906
View details for APAR SE54907
Release:6.1
Cumulative Level:C3312610
Superseded by:View fix details for PTF SI57521


Abstract

OSP-DB ADD DB2 FOR i SUPPLIED OBJECTS


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

-----------------------------------------------
To enhance DB2 for i family compatibility, the following objects
are being added:

New Catalogs:
SYSIBMADM/ENV_SYS_INFO
QSYS2/GROUP_PROFILE_ENTRIES

New User Defined functions:
SYSIBMADM/ENV_SYS_INFO
QSYS2/GROUP_USERS
SYSPROC/BASE_TABLE

CORRECTION FOR APAR SE54906 :
-----------------------------
The new DB2 for i supplied objects will be described in the SQL
Reference and within the IBM i Technology Updates wiki:

www.ibm.com/developerworks/ibmi/techupdates/db2

CIRCUMVENTION FOR APAR SE54906 :
--------------------------------
None.


DESCRIPTION OF PROBLEM FIXED FOR APAR SE54907 :
-----------------------------------------------
To enhance DB2 for i family compatibility, the following objects
are being added:

New Catalogs:
SYSIBMADM/ENV_SYS_INFO
QSYS2/GROUP_PROFILE_ENTRIES

New User Defined functions:
SYSIBMADM/ENV_SYS_INFO
QSYS2/GROUP_USERS
SYSPROC/BASE_TABLE

CORRECTION FOR APAR SE54907 :
-----------------------------
The new DB2 for i supplied objects will be described in the SQL
Reference and within the IBM i Technology Updates wiki:

www.ibm.com/developerworks/ibmi/techupdates/db2

CIRCUMVENTION FOR APAR SE54907 :
--------------------------------
None.


Activation Instructions


None.


Special Instructions


None.

    Default Instructions

    THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



    Supersedes

    PTF/FIX NO(S).  APAR TITLE LINE
    --------------  ------------------------------------------------------------
       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, 2015, 2016 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.