IBM Support

SI56804 - DB2 Web Query 2.1.0 fix

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

DB2 Web Query 2.1.0 fix


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5733WQX  210  SI55973   NONE     0000
CO   5733WQX  210  SI56889   NONE     0000
CO   5733WQX  210  SI55870   NONE     0000
CO   5733WQX  210  SI55072   NONE     0000
CO   5733WQX  210  SI54955   NONE     0000
CO   5733WQX  210  SI54777   NONE     0000
CO   5733WQX  210  SI53381   NONE     0000
CO   5733WQX  210  SI52405   NONE     0000
CO   5733WQX  210  SI52327   NONE     0000
CO   5733WQX  210  SI49914   NONE     0000
CO   5733WQX  210  SI49944   NONE     0000
CO   5733WQX  210  SI49942   NONE     0000
CO   5733WQX  210  SI47313   NONE     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

-----------------------------------------------
The PTF will update the
/QIBM/userdata/qwebqry/WQLIB85/wlp/usr/servers/WQLIB85/server.xm
l file, so that Web Query supports Liberty 8.5.5.5.

CORRECTION FOR APAR SE61892 :
-----------------------------
The PTF will update the
/QIBM/userdata/qwebqry/WQLIB85/wlp/usr/servers/WQLIB85/server.xm
l file, so that Web Query supports Liberty 8.5.5.5.

CIRCUMVENTION FOR APAR SE61892 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


End Web Query server before applying the PTF.

When removing this PTF, if the /qibm/userdata/qwebqry directory resides
on an iASP that is varied off, then you must vary on the iASP and
manually restore the file
/qibm/userdata/qwebqry/WQLIB85/wlp/usr/servers/WQLIB85/server.xml via
the following steps:

1. Sign on with user profile in WebQueryAdministrator group.
2. Check whether the backup file
/qibm/userdata/qwebqry/WQLIB85/wlp/usr/servers/WQLIB85/server.xml.preHF
11plus exists. If yes, then do the following operation.
3. If the job CCSID is 5026, 930 or 290, issue the command "CHGJOB
CCSID(37)" to change job CCSID.
4. Issue the command "QSYS/RMVLNK
OBJLNK('/qibm/userdata/qwebqry/WQLIB85/wlp/usr/servers/WQLIB85/server.x
ml')"
5. Issue the command "QSYS/RNM
OBJ('/qibm/userdata/qwebqry/WQLIB85/wlp/usr/servers/WQLIB85/server.xml.
preHF11plus') NEWOBJ('server.xml')"
6. If the job CCSID is changed to 37 in step 3, issue the command,
for example "CHGJOB CCSID(5026)", to change it back.

Note: If the server.xml file is edited between the time the PTF
is applied and removed, those changes won't be preserved.

When permanently applying this PTF, if the /qibm/userdata/qwebqry
directory resides on an iASP that is varied off, then you can vary on
the iASP and manually delete the backup file
/qibm/userdata/qwebqry/WQLIB85/wlp/usr/servers/WQLIB85/server.xml.preHF
11plus by the command "QSYS/RMVLNK
OBJLNK('/qibm/userdata/qwebqry/WQLIB85/wlp/usr/servers/WQLIB85/server.x
ml.preHF11plus')". If server.xml.preHF11plus does not exist, ignore
this step.

********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI55897 :
=================================================

End Web Query server before applying the PTF.

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI54954 :
=================================================

Please end Web Query server before applying the PTF.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI55897      WQX-v210-HF11.2015 DB2 Web Query Hotfix 11
   SI55939      OSP-F/QCAFLD-T/QWQWLC-MSGCPD0085 WEBQUERY AFTER INSTALLING H
   SI55154      WQX-v210-HF10.2014 DB2 Web Query Hotfix 10
   SI55018      DB2 Web Query 2.1.0 fix for STRWEBQC
   SI54954      DB2 Web Query 2.1.0 fix for STRWEBQC
   SI54779      DB2 Web Query 2.1.0 fix for STRWEBQC
   SI54616      DB2 Web Query 2.1.0 fix for STRWEBQC
   SI53418      DB2 Web Query 2.1.0 fix for STRWEBQC
   SI53418      OSP-UNPRED PROCESSOR LIMIT IN WORKLOAD CAPPING GROUP CHANGED
   SI53426      DB2 Web Query 2.1.0 fix for STRWEBQC
   SI53012      DB2 Web Query 2.1.0 fix for STRWEBQC
   SI52391      DB2 Web Query fix for STRWEBQC
   SI52329      DB2 Web Query fix for STRWEBQC
   SI51995      DB2 Web Query fix for QWQUTILS
   SI51196      DB2 Web Query fix for STRWEBQC
   SI51041      DB2 Web Query 2.1.0 fix for STRWEBQRY
   SI50946      WQX-v210-HF6.2013 DB2 Web Query Hotfix 6
   SI50147      DB2 Web Query 2.1.0 fix for STRWEBQC
   SI49913      DB2 Web Query 2.1.0 fix for STRWEBQRY
   SI49523      WQX v210 DB2 Web Query fix --Use job CCSID 37 in Arabic Web
   SI49509      DB2 Web Query 2.1.0 fix for CVTBLOBTOCHAR UDF
   SI49262      DB2 Web Query 2.1.0 Hotfix 4
   SI48622      WQX-v210-DB2 Web Query fix-Group QWQADMIN authority to STRWE
   SI48230      Part check in of STRWEBQC.cl in WQX 2.1.0
   SI47783      OSP-F/QWQUTILS-T/QWQUTILS-MSGMCH3601 ENDWEBQRY FAILS WITH MS
   SI47172      WQX-v210-HF1-June.2012 DB2 Web Query Hotfix 1
   SI47149      WQX-v210-HF1-June.2012 DB2 Web Query Hotfix 1:Fix dump when

Summary Information

System..............................i
Models..............................
Release.............................V2R1M0
Licensed Program...............5733WQX
APAR Fixed..........................View details for APAR SE61892
Superseded by:......................View fix details for PTF SI66260
Recompile...........................N
Library.............................QWEBQRY
MRI Feature ........................NONE
Cum Level...........................


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 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":"V2R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
19 May 2015