SI41528 - OSP-DB mutex leaks in xda job

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
NONE



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

-----------------------------------------------
mutex leak in xda jobs.

CORRECTION FOR APAR SE38666 :
-----------------------------
mutex allocations have been optimized.

CIRCUMVENTION FOR APAR SE38666 :
--------------------------------
None.


DESCRIPTION OF PROBLEM FIXED FOR APAR SE45364 :
-----------------------------------------------
A TCP scanning program caused the *EDRSQL server to end. Joblog
shows the following: CPE3515 f/QXDALISTEN x/31 t/QXDALISTEN *N
CPC1224 f/QWTPITP2 x/0610 t/ *EXT *N

CORRECTION FOR APAR SE45364 :
-----------------------------
signal handler code was added to xda module.

CIRCUMVENTION FOR APAR SE45364 :
--------------------------------
None.


Activation Instructions


None.


Special Instructions


********************************************************************
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 SI34569 :
=================================================

If you apply or remove this PTF during an IPL (delayed), you do
not need to perform the special instructions. Otherwise you must

execute the following steps:

Before applying or removing this PTF, end all applications using
the XDA/BFC interface:

- STOPSAP (SAP R/3 customers only)

- ENDBAAN (Baan customers only)

- ENDNET (JDEdwards OneWorld customers only)


End the active *EDRSQL server job by issuing the command:


ENDTCPSVR SERVER(*EDRSQL)

(SAP customers also need to end job R3RMTDB if it is active)


If you remove the PTF, delete user space QXDADBBK from library


QSYS, using command:


DLTUSRSPC USRSPC(QSYS/QXDADBBK)


Now you can apply or remove the PTF.


To re-enable *EDRSQL server functions issue the command:


STRTCPSVR SERVER(*EDRSQL)


Then start your applications:

- STARTSAP (SAP R/3 customers only)


- STRBAAN (Baan customers only)


- STRNET (JDEdwards OneWorld customers only)

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI31210 :
=================================================

If you apply or remove this PTF during an IPL (delayed), you do

not need to perform the special instructions. Otherwise you must



execute the following steps:



Before applying or removing this PTF, end all applications using

the XDA/BFC interface:



- STOPSAP (SAP R/3 customers only)



- ENDBAAN (Baan customers only)



- ENDNET (JDEdwards OneWorld customers only)





End the active *EDRSQL server job by issuing the command:





ENDTCPSVR SERVER(*EDRSQL)



(SAP customers also need to end job R3RMTDB if it is active)





If you remove the PTF, delete user space QXDADBBK from library





QSYS, using command:





DLTUSRSPC USRSPC(QSYS/QXDADBBK)





Now you can apply or remove the PTF.





To re-enable *EDRSQL server functions issue the command:





STRTCPSVR SERVER(*EDRSQL)





Then start your applications:



- STARTSAP (SAP R/3 customers only)





- STRBAAN (Baan customers only)





- STRNET (JDEdwards OneWorld customers only)

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI29985 :
=================================================

If you apply or remove this PTF during an IPL (delayed), you do not
need to perform the special instructions. Otherwise you must
execute the following steps:

Before applying or removing this PTF, end all applications using
the XDA/BFC interface:
- STOPSAP (SAP R/3 customers only)
- ENDBAAN (Baan customers only)
- ENDNET  (JDEdwards OneWorld customers only)

End the active *EDRSQL server job by issuing the command:
- ENDTCPSVR SERVER(*EDRSQL)
(SAP customers also need to end job R3RMTDB if it is active)

If you remove the PTF, delete the user space QXDADBBK from library
QSYS, using command:
- DLTUSRSPC USRSPC(QSYS/QXDADBBK)

Now you can apply or remove the PTF.

To re-enable *EDRSQL server functions issue the command:
- STRTCPSVR SERVER(*EDRSQL)

Then start your applications:
- STARTSAP (SAP R/3 customers only)
- STRBAAN  (Baan customers only)
- STRNET   (JDEdwards OneWorld customers only)


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI35754      OSP-DB TERASPACE STORAGE LEAK IN JOBS USING XDA
   SI34569      OSP- XDA MCH3601 from QXDADBBK service program
   SI33060      OSP - XDA Serviceabiity enhancements
   SI32551      OSP - MCH3601 from XDA module QXDASQINFO with DBMON enabled
   SI32463      OSP - XDA MCH3601 from QXDAEVT in module QXDASQINFO
   SI32396      OSP - XDA CPF9872 in QXDASQL, MCH3601 in QSQROUTX with QSQSR
   SI32038      OSP - XDA serviceability enhancements
   SI30029      OSP - MCH5804, MCH2604 on XDA receiver jobs
   SI31210      OSP - XDA v6r1 server incompatible with previous release XDA
   SI30427      OSP-DB SQL Server Mode QAQQINI INHERITANCE
   SI30389      OSP - CPFB752 returned by XDA client, possible C2M1212 messa
   SI30019      OSP - XDA QxdaFindEDRSJob API returns invalid results
   SI29996      OSP-DB-OTHER-SAP400-MSGC2M1212 C2M1212 IN QXDARECVR JOBLOG A
   SI29985      OSP - STORAGE LEAK WHEN QUERY HAS MORE THAN 181 COLUMNS
   SI29424      OSP - XDA to get parser options from WM for execute immed

Summary Information

System i Support