IBM Support

SI34550 - OSP-DB-MSGCPF4101 Escape messages occuring during Disaster R

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-MSGCPF4101 Escape messages occuring during Disaster R


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5761999  610  MF44011   00/00    0000
PRE  5761999  610  MF43882   00/00    0000
PRE  5761999  610  MF43467   00/00    0000
CO   5761SS1  610  SI34358   00/00    0000
CO   5761SS1  610  SI34375   00/00    0000
CO   5761SS1  610  SI34360   00/00    0000
CO   5761SS1  610  SI34361   00/00    0000
CO   5761SS1  610  SI33235   00/00    0000
CO   5761SS1  610  SI33232   00/00    0000
CO   5761SS1  610  SI33237   00/00    0000
CO   5761SS1  610  SI33238   00/00    0000
CO   5761SS1  610  SI30193   00/00    0000
CO   5761SS1  610  SI29992   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

-----------------------------------------------
System UDF functions not being found on restore of QSYS2 causes
some views to not be restored.

CORRECTION FOR APAR SE36916 :
-----------------------------
Problem restoring QSYS2 views has been fixed.

CIRCUMVENTION FOR APAR SE36916 :
--------------------------------
Re-restore QSYS2.


Activation Instructions


None.




Special Instructions


None.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI34498      OSP-DB-MSGCPF503E CONTAINS and SCORE functions can not run p
   SI34498      OSP-DB-INCORROUT CONTAINS and SCORE functions
   SI34418      OSP-DB-OTHER-F/EXSNDPM-T/QQQQUERY-RC018436-MSGMCH1819 SQL ST
   SI34359      OSP-DB-OTHER-MSGSQL0913 MSGSQL0913 USING XA TRANSACTION MANA
   SI34250      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0332 MSGSQL0332 MAY B
   SI34217      OSP-DB-MSGCPD430D INSERT with VALUES with multiple values
   SI34163      OSP-DB Internal Maintenance for Database Monitor
   SI34163      OSP-DB-INCORROUT when using LOB locator and CONCAT wrong len
   SI34163      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 SQL QUERY FA
   SI34120      OSP-DB-OTHER-F/EXSNDPM-T/MCH1819-RC15664-MSGMCH1819 RUNNING
   SI33988      OSP-DB-OTHER-F/QQQVALID-T/QQQVALID-MSGMCH0601 MSGMCH0601 T/Q
   SI33988      OSP-DB-SQL-MSGSQL0302 LOB Locater uage results in SQLCODE -3
   SI33988      OSP-DB-INCORROUT for laterally correlated query
   SI33866      OSP-DB-MSGCPF3205 RCHTWINS RSTLIB QSYS2 FAILURE during Disas
   SI33814      OSP-DB the char function on a binary string field doesn't wo
   SI33814      OSP-DB-MSGMCH3401 T/QQQVFMT PROCESS_UDTF - File QSQPTABL
   SI33814      OSP-DB-INCORROUT DECIMAL or ZONED function with DECFLOAT
   SI33814      OSP-DB-OTHER-F/QQQSRVV1-T/QSQRUN3-MSGCPF4269 CUST RECEIVES M
   SI33521      OSP-CL-RUN OVRDBF support
   SI33377      OSP-DB-OTHER-F/EXSNDPM-T/QQQQUERY-MSGMCH1819 RUNNING PT1 REP
   SI33233      OSP-DB Internal Maintenance for Database Monitor
   SI33088      OSP-DB-OTHER-F/QQQVALID-T/QSQRUN1-MSGCPD4347 SQL STMT CONTAI
   SI33044      OSP-DB-MSGCPF9898 from QQQOOODBOP when querying a view
   SI33039      OSP-DB-MSGMCH3402  From DpbmTranslateOperation
   SI33039      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD433F CPD433F / SQL033
   SI33032      OSP-DB-INCORROUT When *LIBL is specified and library list ch
   SI32957      OSP-DB-OTHER-INCORROUT SELECT STMT WITH CASTING TO A CCSID W
   SI32821      OSP-DD-MSGMCH1222 from QQQIOPMP
   SI32632      OSP-F/EXSNDPM-T/QQQQUERY-MSGMCH1819 QUERY FAILS WITH MSGMCH1
   SI32632      OSP-DB-OTHER-F/QQURJ-T/QQUDA-RC20-MSGCPF5035 STRSQL OUTPUT T
   SI32632      OSP-DB-OTHER-INCORROUT RECORD FORMAT ID DIFFERENT - NULL RES
   SI32618      OSP-DB QDBCXRC and vary on of IASP CPI431B information messa
   SI32617      OSP-DB SQL Record the NLSS table even if it is not used.
   SI32603      OSP-DB SQL Implicit numeric mapping is not setting null attr
   SI32547      OSP-DB Client special registers are not reflecting changes w
   SI32503      OSP-DB-OTHER-F/QQQISVSU-T/QQQISVSU-MSGMCH3601 AFTER UPGRADIN
   SI32454      OSP-DB Infrastructure for OmniFind Text Search Server for DB
   SI32425      OSP-DB-OTHER-INCORROUT CHAR() CONVERTING UNICODE DATA TO A H
   SI32371      OSP-DB Infrastructure for OmniFind Text Search Server for DB
   SI32371      OSP-DB ASCII AND CHR FUNCTIONS FAIL CPD4318 RC12 / SQL0332 I
   SI32371      OSP-F/QQQVFM-T/QSQRUN3-RC6-MSGCPD4318 QUERY USING LEFT FUNCT
   SI32047      OSP-DB-MSGMCH1210-F/QQQVFMT when using REPLACE with a CLOB
   SI31995      OSP-DB Database monitor 3010 record does not hide host varia
   SI31976      OSP-DB-MSGCPD4307-MSGSQL0461 Like on UTF8 columns
   SI31944      OSP-DB-MSGMCH3203-f/QQQOOODBOP Using Replace with a binary s
   SI31942      LIC-DB New INI option for *UR commit level for updateable SQ
   SI31904      OSP-MSGCPD4353-PAR RGZPFM ALWCANCEL(*YES)KEYFILE(FILE WITH D
   SI31890      OSP-DB Infrastructure for OmniFind Text Search Server for DB
   SI31648      OSP-DB-SQL-MSGMCH3402  Physical Files not Lock for Update
   SI31591      OSP-DB Incorrect output using Client_applname on Japanese In
   SI31567      OSP-DB Timestampdiff(16,cast('100000000.000' as char(22))) r
   SI31505      OSP-F/QDBSIGEX-T/QQQITEMP-RC20-MSGCPF5035 QUERY MANAGER QUER
   SI31474      OSP-DB Translation not applied in the scalar full select wit
   SI31372      OSP-DB incorrect results when casting to binary string or da
   SI31295      OSP-DB-MSG-F/QQQSVOPT-T/QQQSVOPT-MSGMCH3601 ACCESS PLAN WITH
   SI31247      OSP-DB-OTHER-UNPRED A TRIGGER AFTER UPDATE DOESN'T FIRE WHEN
   SI31222      OSP-DB-MSGCPF503E using CONTAINS or SCORE function
   SI31197      OSP-DB-SQL-MSGMCH3402  Physical Files not Lock
   SI31100      OSP-DB-MSGCPF4269 from QQQVAP
   SI31055      OSP-DB-MSGSQL0901 Expected message SQL0255
   SI31032      OSP-DB-INCORROUT Null attributes not correct on numeric conv
   SI31032      OSP-DB Binary strings and char for bit data compatibility
   SI30938      OSP-DB Infrastructure for OmniFind Text Search Server for DB
   SI30906      OSP-DB RWCHKRDB macro changes
   SI30874      OSP-DB incorrect base column name and base table name
   SI30865      OSP-DB-INCORROUT  Query of view with NLSS
   SI30843      OSP-DB Infrastructure for OmniFind Text Search Server for DB
   SI30843      OSP-DB-SQL-INCORROUT  UCS-2  constants being normalized
   SI30822      OSP-DB Internal Maintenance for SQL
   SI30822      OSP-DB-MSGMCH1210 T/QQQVFMT TPROC/DECRYPT
   SI30757      OSP-DB-INCORROUT ORDER BY and FETCH FIRST on subselect
   SI30708      OSP-DB-PERFM INTERNAL MAINTENANCE
   SI30603      OSP-DB Infrastructure for OmniFind Text Search Server for DB
   SI30512      OSP-DB-SQL-PERFM  Temp Space and Active Memory usage
   SI30492      OSP-DB incorrect results with current path
   SI30437      OSP-DB Client special registers return inccorrect results wh
   SI30414      OSP-DB-OTHER-F/EXSNDPM-T/QQQQUERY-MSGMCH1819 MSGMCH1819 WHEN
   SI30414      OSP-F/QQQISVSU-MSGMCH3601 SQL STMT WITH LIKE PREDICATE WITH
   SI30400      OSP-DB-INCORROUT query including CCSID 12708
   SI30379      OSP-DB Infrastructure for OmniFind Text Search Server for DB
   SI30279      OSP-DB-MSGMCH5003 from QQQVSEL proc VLNFLOAT
   SI30230      OSP-DB-OTHER-F/QQQVSEL-T/QSQRUN3-MSGCPD4324 QUERY FAILS WITH
   SI30229      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-RC26-MSGCPD4318 SUBSTRING O
   SI30191      OSP-DB Infrastructure for OmniFind Text Search Server for DB
   SI30155      OSP-DB-MSGMCH3601 from DBPMSUBPATTERN to QQQOOOINV
   SI30133      OSP-DB-MSGCPF5035 select from insert query with date, time
   SI30085      OSP-DB-MSGCPF3203 from QQQVWCMP on query
   SI30023      OSP-DB-INCORROUT LEFT and RIGHT scalar functions
   SI29986      OSP-DB-MSGCPD4307 Alter of SQL view with ROW CHANGE TOKEN
   SI29947      OSP-DB Unnecessary query access plan rebuilds
   SI29763      OSP-DB-INCORROUT DECFLOAT scalar function with string
   SI29746      OSP-DB-INCORROUT SIGN(DECFLOAT(-0))
   SI29746      OSP-DB-PERFM SQL Queries with Host Variable use more memory
   SI29707      OSP-DB-MSGMCH3601 from/to QQQQUERY
   SI29672      OSP-DB Allow separator to be specified on DECFLOAT scalar fu
   SI29558      OSP-DB-MSGCPD4363 reason 26 for query with qaqqini normalize
   SI29529      OSP-DB-MSGCPD4318  ccsid 37 should be compatible with ccsid
   SI29354      OSP-DB-INCORROUT CASE with field that allows nulls
   SI29205      OSP-DB-INCORROUT CASE with field that allows nulls
   SI29108      OSP-DB-MSGMCH1210 from/to QQQVSEL
   SI29022      OSP-DB-MSGMCH3601-f/QQQSRVE1 when using current path and
   SI28961      OSP-DB-INCORROUT Incorrect null attribute for COALESCE
   SI28959      OSP-DB-MSGMCH3601 From QQQVJOIN
   SI28897      OSP-DB-view is undeletable with instead of trigger
   SI28897      OSP-DB-MSGMCH1210-f/QQQVFMT using NULLIF
   SI28848      OSP-DB-MSGMCH3601 F/QQQOOODBOP QUERY CONTAINING TO_CHAR

Summary Information

System..............................System i
Models..............................
Release.............................V6R1M0
Licensed Program...............5761SS1
APAR Fixed..........................SE36916
Superseded by:......................View fix details for PTF SI57412
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C9111610


System 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":"V6R1M0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG16A","label":"PTF Cover Letters - i5\/OS V6R1 environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V6R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
13 March 2009