SI67719 - OSP-HOSTSERVERS-OTHER NOT ALL LIBRARIES ARE RETURNED USING A

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770SS1  710  SI47120   00/00    0000
CO   5770SS1  710  SI46685   00/00    0000
CO   5770SS1  710  SI46285   00/00    0000
CO   5770SS1  710  SI43509   00/00    0000
CO   5770SS1  710  SI43568   00/00    0000
CO   5770SS1  710  SI43569   00/00    0000
CO   5770SS1  710  SI39896   00/00    0000
CO   5770SS1  710  SI39899   00/00    0000
CO   5770SS1  710  SI39903   00/00    0000
CO   5770SS1  710  SI39902   00/00    0000
CO   5770SS1  710  SI39905   00/00    0000
DIST 5770SS1  710  SI43063   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

-----------------------------------------------
When a ACS Data Transfer is set to use an iASP (Connection tab -
Database) not all libraries are returned. Only libraries from
iASP are returned not the ones from *SYSBAS. The message
received is "One or more of the IBM i libraries in the list do
not exist on the current system".

CORRECTION FOR APAR SE69257 :
-----------------------------
The Host Sever Database code will be fixed so that all libraries
from both the *SYSBAS and IASP are returned for this request.

CIRCUMVENTION FOR APAR SE69257 :
--------------------------------
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 SI47166 :
=================================================

If the DRDA "listener" server job QRWTLSTN is active in the
QSYSWRK subsystem when this PTF to be applied immediately, the server
job should be ended prior to applying the ptf:
ENDTCPSVR SERVER(*DDM)

Then after the ptf is applied, restart the QRWTLSTN server job:
STRTCPSVR SERVER(*DDM)

Restart the QRWTSRVR prestart jobs
ENDPJ SBS(QUSRWRK) PGM(QRWTSRVR) OPTION(*IMMED)
STRPJ SBS(QUSRWRK) PGM(QRWTSRVR)

Restart the QSQSRVR prestart jobs
ENDPJ SBS(QSYSWRK) PGM(QSQSRVR) OPTION(*IMMED)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)

Restart the QZDASOINIT prestart jobs
ENDPJ SBS(QUSRWRK) PGM(QZDASOINIT) OPTION(*IMMED)
STRPJ SBS(QUSRWRK) PGM(QZDASOINIT)

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI37983 :
=================================================

To properly enable this PTF for database server prestarted jobs,
you will need to stop and restart the database server prestarted
jobs that are active after the PTF has been applied.
Otherwise, the prestarted jobs may continue to use older versions
of programs and unexpected results may occur. Applying this
PTF as delayed would achieve the same results.


To stop and restart the host server jobs, the following directions
must be followed.

The database server prestart jobs (QZDAINIT, QZDASOINIT, and
QZDASSINIT) by default are shipped to run in subsystem QSERVER
(QZDAINIT) and QUSRWRK (QZDASOINIT and QZDASSINIT).  However,
systems can be customized to allow the database server prestart
jobs to run in other subsystems.

SYSTEMS WITH DEFAULT CONFIGURATION (database server prestart jobs
run ONLY in the QSERVER and QUSRWRK subsystems).

---------------------------------------------------------------------

1) To ensure that the database server prestart jobs are ended,
issue the requests:

QSYS/ENDPJ SBS(QSERVER) PGM(QSYS/QZDAINIT) OPTION(*IMMED)
and
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT) OPTION(*IMMED)
and
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QZDASSINIT) OPTION(*IMMED)
and if a non default prestart job configuration exists
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDAINIT)

If the above commands fail with CPF0922, nothing more needs
to be done (the prestarted jobs are already inactive).

2) To re-enable the function after the PTF is applied, issue the
requests:

QSYS/STRPJ SBS(QSERVER) PGM(QSYS/QZDAINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASSINIT)
and if a non default prestart job configuration exists
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASSINIT)

If the above commands fail with CPF0921, nothing more needs
to be done (the prestarted jobs are already active).


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI67005      OSP-OTHER-F/QZDASRV-T/QZDASRV-MSGMCH3601 processing metadata
   SI66379      OSP-DB-OTHER-UNPRED QZDASOINIT MEMORY LEAK
   SI65648      OSP WORKING WITH JT400. WHEN DOING AN UPDATE OR INSERT OF A
   SI63216      OSP QZDASOINIT JOBS STUCK IN JOBLOG PENDING STATE,
   SI62478      OSP-DB INCORRECT FAIL FOR HOST SERVER EXIT PROGRAM ALTERNATI
   SI60335      OSP-DBMSGMCH1210-F/QZDACMDP QZDASOINIT JOB FAIL TO SET REGIS
   SI60243      OSP-DB DRDA query fails with incorrect cursor name error
   SI59571      OSP-DB STRDBMON FTRUSER including Close entries for other us
   SI58271      OSP-DB-OTHER-INCORROUT IBM I NAVIGATOR MAY NOT RETURN CORREC
   SI57485      OSP-HOSTSERVERS-OTHER-F/QZDASQL-MSGSQL7967 INCORRECT MESSAGE
   SI57156      OSP-HOSTSERVERS-OTHER-INCORROUT MSGCWBCO1047 FUNCTION USAGE
   SI56762      OSP-HOSTSERVERS Missing Parameter Names
   SI56427      OSP-DB-OTHER-F/DBBUILTINS-T/QDBGETMQO-MSGMSG0601 A MISMATCH
   SI55066      OSP-DB-OTHER-RCVENDORCODE703-MSGPWS0042 RUNNING CONNECT TO W
   SI54551      OSP-DB-OTHER-INCORROUT ARRAY AS A PARM IN STORED PROCEDURE D
   SI53971      OSP-HOSTSERVERS-PERFM QZDASRV PAGING
   SI53793      OSP-DB-OTHER-INCORROUT WRONG ROW SIZE WITH UPDATABLE QUERIES
   SI53084      OSP-HOSTSERVERS Input Compression Support
   SI52992      OSP-MSGMCH3601 WORKING WITH POWERBUILDER AND ODBC MCH3601 AN
   SI51045      OSP-DB Internal Maintenance
   SI50556      OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGSQL0446 AFTER UPGRADING
   SI50156      OSP-HOSTSERVERS MCH3601 FROM QZDASQL TO QZDASQL AT STATEMENT
   SI49739      OSP-DB-OTHER-INCORROUT ODBC APPLICATION WILL FAIL WITH DIAG[
   SI49374      OSP-HOSTSERVERS LIBRARY WITH LONG SCHEMA NAME NOT RETURNED U
   SI49368      OSP-DB-OTHER-MSGSQL0189 MSGSQL0189 ISSUED WHEN CLICKED 'APPL
   SI48412      OSP-DB-MSGSQL0514-F/QSQPEN HOST SERVER PREPARED STATEMENT NO
   SI48107      OSP-F/QZDASRV-MSGPWS0001-RC816 ON STORED PROCEDURE CALL WITH
   SI47786      OSP-HOSTSERVERS-INCORROUT ZDA Datastream error
   SI47166      OSP-DB-MSGSQL0104 ZDA CREATE TABLE XXX PACKAGE EXISTENCE CHE
   SI47117      OSP-DB Internal Maintainence
   SI46686      OSP-DB-OTHER-INCORROUT PROCEDURES WITH OUTPUT LOB LOCATORS T
   SI46423      OSP-OTHER-F/QZDASQL-T/QZDASQL-MSGMCH1210 MSGPWS0005 PREPARIN
   SI46284      OSP-OTHER-MSGSQL0519 AFTER CANCEL
   SI46035      OSP-DB HOST SERVER EXIT PROGRAM ALTERNATIVE
   SI45991      OSP-DB-MSGMCH3601-T/QZDASQL with null array
   SI45486      OSP-DB-OTHER-F/QZDASRV-T/QZDASRV-MSGMCH1210 ON FETCH REQUEST
   SI45182      SP/QZDASRV-MSGSQL5016-MOD/QSQPREP QUALIFIED OBJECT NAME NOT
   SI45040      OSP-DB-OTHER-T/QSQROUTS-RCTYPE13,RC423-MSGSQL0904 SELECT STM
   SI44968      OSP-HOSTSERVERS-OTHER-INCORROUT JDBC METADATA SOURCE=0 RETUR
   SI44593      OSP-HOSTSERVERS-OTHER-INCORROUT MSGMCH0601 AND MSGSQL0904 FR
   SI44450      OSP-DB-OTHER-F/QSQRUN2-MSGSQL0501 MSGSQL0501 F/QSQRUN2 X/221
   SI43992      OSP-DB warnings not returned for scrollable cursors
   SI43510      OSP-DB ADDITIONAL TCPIP FILTERING ENHANCEMENTS
   SI43062      OSP-DB-OTHER-INCORROUT STATEMENTS NOT ADDED TO AN SQL PACKAG
   SI43004      OSP-DB rtvfld does not work for delimited schema name
   SI43004      OSP-DB-MSGMCH0601 T/F QZDASQL/WZDA_CARVE_LITTLE_SPACE
   SI42874      OSP-DB-UNPRED Internal DRDA Maintenance
   SI42602      OSP-HOSTSERVERS-OTHER-PCSRQ-F/QSQRUN1-T/QSQRUN1-MSGSQL0501 S
   SI42602      OSP-HOSTSERVERS-INCORROUT INCORRECT VALUE RETURNED FROM SYST
   SI42118      OSP-HOSTSERVERS parm marker name not returned
   SI42102      OSP-HOSTSERVERS HOST SERVER DISCONNECTS WHEN EXIT PROGRAM RE
   SI41332      OSP-OTHER SQLCOLUMNS FUNCTION REQUEST IS RETURNING INCOMPLET
   SI41024      OSP-OTHER-F/QZDASRV-T/QZDASRV-MSGMCH1210
   SI40352      OSP-DB SQLColumns returns invalid data
   SI39980      OSP-F/QZDASRV-T/QZDASRV-MSGMCH1202 MCH1202 AND PWS0005 MESSA
   SI39900      OSP-DB-QSQASLOC-MSGSQL0204 when using specific name on ASSOC
   SI39808      OSP-DB no error on connect invalid rdb name
   SI39497      OSP-DB pass naming mode to zda sql2 exit point
   SI39409      OSP-DB-MSGMCH1210 passing array parms
   SI39254      OSP-DB-OTHER PUT BACK CODE TO CLOSE *NONE CURSORS DURING COM
   SI39057      OSP-HOSTSERVERS-INCORROUT AF AUDIT JOUNAL ENTRIES IF USER DO
   SI39057      OSP-HOSTSERVERS-T/QZDASRV-MSGMCH1210
   SI38805      OSP-DB Internal maintenance
   SI38614      OSP-DB Incorrect output from ROI server
   SI38613      OSP-DB system user incorrect in zda job
   SI38467      OSP-DB Internal Maintenance
   SI38121      OSP-OTHER-MSGPWS0043 DATABASE HOST SERVER
   SI37983      OSP-DB-MSGMCH1210-T/qzdasql
   SI37773      OSP-DB Internal Maintenance
   SI37768      OSP-HOSTSERVERS-PERFM HIGH PAGE FAULTING IN DATABASE HOST SE
   SI37396      OSP-DB-MSGSQL0501-F/QSQFETCH JDBC Toolbox
   SI37385      OSP-DB Long schema fixes
   SI37263      OSP-DB long schema fixes
   SI37201      OSP-HOSTSERVERS-INCORROUT CWBDB0052 ENCOUNTERED IN DATA TRAN
   SI36757      OSP-DB Update where current of cursor fails for xml data
   SI36502      DB issue 42119: Toolbox returning CLOB instead of XML from a

Summary Information

System i Support