IBM Support

SI56794 - OSP-DB Update SYSTRIGGERS to correct REMARKS column

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB Update SYSTRIGGERS to correct REMARKS column


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770SS1  V7R2M0    SI54773   00/00    0000
CO   5770SS1  V7R2M0    SI56758   00/00    0000
CO   5770SS1  V7R2M0    SI54682   00/00    0000
CO   5770SS1  V7R2M0    SI54082   00/00    0000
CO   5770SS1  V7R2M0    SI54400   00/00    0000
CO   5770SS1  V7R2M0    SI52819   00/00    0000
CO   5770SS1  V7R2M0    SI52820   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

-----------------------------------------------
Due to an error during view creation, the data type for the
REMARKS column in the QSYS2.SYSTRIGGERS view was set to
DBCLOB(2000) instead of VARGRAPHIC(2000). Now that the
underlying problem has been fixed, the view is being recreated
with the correct attributes.

CORRECTION FOR APAR SE61879 :
-----------------------------
The QSYS2.SYSTRIGGERS view's REMARKS column will now be
VARGRAPHIC(2000) CCSID 1200

CIRCUMVENTION FOR APAR SE61879 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI56757      OSP-DB CPYFRMIMPF CAN RUN SLOW IF OVRDBF IS USED.
   SI56720      OSP-DB Internal Maintenance
   SI56633      OSP-DB-PERFM SQL ROUTINE GRAPHIC/VARGRAPHIC PERFORMANCE
   SI56593      SQL-CMPL-INCORROUT TRIGGER EVENT PREDICATE OF A MULTIPLE EVE
   SI56348      OSP-DB Formatting for SQL routine text lost using RUNSQLSTM
   SI56323      OSP-DB INTERNAL MAINTENANCE
   SI56253      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-RC2-MSGSQL0101 SQL MERGE ST
   SI56253      OSP-DB INTERNAL MAINTENANCE
   SI56136      OSP-DB Extend QSQPRCED() to include some QAQQINI options
   SI56125      OSP-DB INTERNAL MAINTENANCE
   SI55931      SQL-CMPL-INCORROUT DEBUGGER ARRAY TYPE VARIABLES
   SI55612      OSP-DB Internal Maintenance
   SI55601      OSP-DB Internal Maintenance
   SI55601      OSP-DB-F/QSQRCHK-MSGMCH0601 when there are a large number of
   SI55601      OSP-DB CREATE TABLE with range partition starting value grea
   SI55601      OSP-DB-OTHER-T/QSQRUN4X/42011-MSGSQL0204 SQL0204 ISSUED WHEN
   SI55601      OSP-DB-OTHER-INCORROUT NO MSGSQL0206 AT COMPILE WHEN SQL_GVA
   SI55588      OSP-DB-OTHER-F/QDBCRTFI-T/QSQCRTT-MSGCPF3204
   SI55495      OSP-F/QSQDDL1-T/QSQDDL1-MSGMCH1210 RUNSQLSTM FAILS WITH MCH1
   SI55455      OSP-DB-OTHER-F/QSQPARSP-T/QSQPARSP-MSGMCH0601 DBGVIEW *SOURC
   SI55430      SQL-CMPL-CURR-INCORROUT CORRECT DATE/TIME/TIMESTAMP HOST VAR
   SI55290      OSP-DB-MSGMCH3601-T/QSQRCHK using array variables
   SI55283      OSP-DB Internal Maintenance
   SI55222      OSP-DB Internal Maintenance
   SI54999      OSP-DB INTERNAL MAINTENANCE
   SI54868      OSP-DB-OTHER-UNPRED UPDATING A TABLE WITH BOTH A NULLABLE FI
   SI54866      SQL-CMPL DEBUGGER SUPPORT FOR SQL VARIABLES WITHIN SQL ROUTI
   SI54746      OSP-DB Internal Maintenance
   SI54683      OSP-DB INTERNAL MAINTENANCE
   SI54606      OSP-DB Internal Maintenance
   SI54555      OSP-DB INTERNAL MAINTENANCE
   SI54520      QRY-QRYRUN-THREADS-MSGCPD4302 IN DEFINE RESULT FIELDS CPD430
   SI54070      OSP-DB Internal Maintenance
   SI53986      OSP-DB RUNSQL sends duplicate messages to joblog
   SI53912      OSP-DB ADD LOCK TABLE SUPPORT MULTIPLE MEMBER FILES
   SI53690      OSP-DB-MSGCPD4324 QQQVSEL Global variable and NOT IN predica
   SI53646      OSP-DB RUNSQL not writing error to joblog with *LIST option
   SI53618      OSP-DB-MSGSQL5001 when using a global variable in a DISTINCT
   SI53547      OSP-DB-MSGSQL0901 invoking function LPAD with parameter 1 va
   SI53502      OSP-DB INTERNAL MAINTENANCE
   SI53481      OSP-DB INTERNAL MAINTENANCE
   SI53428      OSP-DB-MSGSQL0901 ALTER TABLE ALTER PARTITION on a table wit
   SI53428      OSP-DB-MSGSQL0312 INCORRECT ERROR MESSAGE
   SI53428      OSP-DB-MSGSQL0901 ALTER TABLE ALTER PARTITION on a table wit
   SI53425      OSP-DB INTERNAL MAINTENANCE
   SI53405      OSP-DB Add option for listing to RUNSQL command
   SI53293      OSP-DB-MSGSQL9001 SQL PRECOMPILE FAILS WITH SQL0122 WHEN USI
   SI53214      SQL-CMPL-MSGSQL7032 SQL ROUTINE FAILS TO CREATE
   SI53146      OSP-DB Serviceability Enhancement for SQL
   SI53071      OSP-DB Internal maintenance
   SI52897      OSP-DB-OTHER-UNPRED A CREATE OF A MATERIALIZED QUERY TABLE M
   SI52831      OSP-DB CREATE TABLE with range partition starting value less
   SI52818      OSP-DB Internal Maintenance
   SI52789      SQL-CMPL-MSGSQL7032 SQL ROUTINE FAILS TO CREATE
   SI52745      OSP-DB-OTHER-INCORROUT THE COLUMN NAME OF A GLOBAL VAR WITH
   SI52745      OSP-F/QSQRCHK-T/QSQRCHK-MSGMCH0601 A CALL TO A STORED PROCED
   SI52745      OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 CRTSQLCBLI FAILS
   SI52685      OSP-DB UNABLE TO USE GENERATE SQL WITH PARTITIONED TABLE IF
   SI52604      OSP-DB-MSGSQL0338 with implied parentheses in join order
   SI52458      OSP-DB Internal maintainence
   SI52344      OSP-DB INTERNAL MAINTENANCE
   SI52271      OSP-DB INTERNAL MAINTENANCE
   SI52193      OSP-DB Column name for global variable with long AS name
   SI52016      OSP-DB-MSGSQL0156 TRUNCATE sends wrong message for an index
   SI51984      OSP-DB INTERNAL MAINTENANCE
   SI51927      OSP-DB INTERNAL MAINTENANCE
   SI51755      OSP-DB Internal Maintenance
   SI51682      OSP-DB INTERNAL MAINTENANCE
   SI51529      OSP-DB Incremental Enhancement
   SI51461      OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 CRTSQLCBLI FAILS
   SI51282      OSP-DB Internal Maintenance
   SI51241      OSP-DB Internal Maintenance

Summary Information

System..............................i
Models..............................
Release.............................V7R2M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE61879
Superseded by:......................View fix details for PTF SI74679
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C5310720


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, 2020, 2021 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.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2","Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"5770SS1","Edition":""}]

Document Information

Modified date:
25 January 2021