SI43651 - OSP-DB ADD QSYS2.SQLQMProfilesAudit for improved audit suppo

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI43643   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

-----------------------------------------------
The Start DB2 UDB Query Manager (STRQM) command option 10 can be
used to the setup and SQL statement security configuration for
specific users.

Security auditors need to observe granular detail for how STRQM
(Select Allowed SQL Statements) is changed.

CORRECTION FOR APAR SE48101 :
-----------------------------
Query Manager Profile Auditing

Changes made to a Query Manager profile can now be audited if
auditing is enabled for AUDLVL(*SECURITY).
A new journal entry type of X2 will contain the old and new
Query Manager profile values.
An outfile is not provided for this journal entry. Instead view
QSYS2.SQLQMProfilesAudit can be queried.
To create a permanent table that contains the new journal
entries, an SQL statement similar to the following can be used:

CREATE TABLE mytablename AS (SELECT * FROM
QSYS2.SQLQMProfilesAudit) WITH DATA

CIRCUMVENTION FOR APAR SE48101 :
--------------------------------
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
--------------  ------------------------------------------------------------
     NONE

Summary Information

System i Support