IBM Support

SI39898 - OSP-DB-QSQASLOC-MSGSQL0204 when using specific name on ASSOC

PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-QSQASLOC-MSGSQL0204 when using specific name on ASSOC


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770SS1  710  SI39897   00/00    0000
CO   5770SS1  710  SI39896   00/00    0000
CO   5770SS1  710  SI39899   00/00    0000
CO   5770SS1  710  SI39900   00/00    0000
CO   5770SS1  710  SI39903   00/00    0000
CO   5770SS1  710  SI39902   00/00    0000
CO   5770SS1  710  SI39904   00/00    0000
CO   5770SS1  710  SI39905   00/00    0000
CO   5770SS1  710  SI39711   00/00    0000
CO   5770SS1  710  SI39709   00/00    0000
CO   5770SS1  710  SI39069   00/00    0000
CO   5770SS1  710  SI39064   00/00    0000
CO   5770SS1  710  SI39061   00/00    0000
CO   5770SS1  710  SI38591   00/00    0000
CO   5770SS1  710  SI37396   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

-----------------------------------------------
MSGSQL0204 occurs on ASSOCIATE LOCATOR and DESCRIBE PROCEDURE
when using specific name in a host variable.

CORRECTION FOR APAR SE43430 :
-----------------------------
When a host variable is used on ASSOCIATE LOCATOR or DESCRIBE
PROCEDURE and the procedure is not found using the name as the
routine name, it will be retried using the name as a specific
name.

CIRCUMVENTION FOR APAR SE43430 :
--------------------------------
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 SI39342 :
=================================================

To properly enable this PTF for prestarted server jobs,
you will need to stop and restart the SQL server jobs,
the Directory Services server jobs, the DRDA TCPIP server
jobs, and the host server jobs.  Otherwise,
the prestarted server 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 SQL server jobs, run the following:

ENDPJ SBS(QSYSWRK) PGM(QSQSRVR) OPTION(*IMMED)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)

To stop and restart the QRWTSRVR prestart jobs, run the following:

ENDPJ SBS(QUSRWRK) PGM(QRWTSRVR) OPTION(*IMMED)
STRPJ SBS(QUSRWRK) PGM(QRWTSRVR)

To stop and restart the DRDA TCPIP server jobs, run the following:

ENDTCPSVR SERVER(*DDM) OPTION(*IMMED)
STRTCPSVR SERVER(*DDM)

To stop and restart the Directory Services server job,
run the following:

ENDTCPSVR SERVER(*DIRSRV) OPTION(*IMMED)
STRTCPSVR SERVER(*DIRSRV)

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
--------------  ------------------------------------------------------------
   SI39828      OSP A SQL COMING IN FROM DRDA IS USING THE WRONG CURSOR.
   SI39826      OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QSQXCUTE-MSGMCH0601
   SI39807      OSP-DB erroneous check constraint error msg
   SI39759      OSP-DB-MSGSQL0900 connect with global variable
   SI39734      OSP-DB-MSGMSQL0901-F/QSQFETCH Procedure BF_SET
   SI39710      OSP-DB-UNPRED Java stored procedure result sets failing over
   SI39691      OSP-DB-INCORROUT PERFORMANCE CLI FETCH RELEASE-TO-RELEASE
   SI39666      OSP-DB-MSGMCH3601-T/QSQPREP with inflate table
   SI39656      OSP-DB-UNPRED INTERNAL GLOBAL VARIABLE MAINTENANCE.
   SI39643      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0551 SQL PACKAGE STAT
   SI39635      OSP-DB-OTHER-INCORROUT RPGLE PROGRAM USING DESCRIPTORS RETUR
   SI39519      OSP-DB-OTHER-F/QSQFETCH-T/QSQFETCH-MSGMCH3601 F_MAPLOBLOC
   SI39516      OSP-DB-INCORROUT Array Support
   SI39507      OSP-DB multi value merge fixes
   SI39498      OSP-DB Internal Maintenance
   SI39491      OSP-DB-INCORROUT Expressions In CALL Support
   SI39446      OSP-DB-UNPRED Java stored procedure result sets failing over
   SI39357      OSP-DB extra diag item returned in drda job
   SI39351      OSP-DB-OTHER-UNPRED XML PROCESSING
   SI39342      OSP-DB-MSGMCH3601-F/QSQFETCH Array Support
   SI39329      OSP-DB-MSGSQL0508 in drda job
   SI39272      OSP-F/QSQRUN2-T/QSQRUN2-MSGSQL0303 MSGSQL0303 F/T/QSQRUN2
   SI39253      OSP-DB decfloat error not signalled
   SI39188      OSP-DB-QSQPREP-MSGMCH1210 when using result sets
   SI39176      OSP-DB Internal Maintenance
   SI39151      OSP-DB-MSGMCH0601-T/QSQDITEM in drda job updates
   SI39133      OSP-DB-MSGMCH3601-T/QSQVATTR with batch updates
   SI39116      OSP-DB-MSGMCH3601 f/t stringHighUse4K/QSQROUTE issued in enc
   SI39073      OSP-DB Internal Maintenance
   SI39062      OSP-DB Internal Maintenance
   SI39056      OSP-DB-OTHER-UNPRED MISSING SQL0364 DECLFOAT WARNING
   SI38966      OSP-DB fetch over drda return incorrect rows
   SI38910      OSP-DB Internal Maintenance
   SI38864      OSP-DB-OTHER-T/QSQCONN-MSGMCH6903
   SI38795      OSP-DB-OTHER-INCORROUT DRDA RETURNS LAST ROW TWICE
   SI38789      OSP-DB Internal Maintenance
   SI38787      OSP-DB-MSGMCH0601 F/STRINGHIGHUSE4K T/QSQCALLSP OPM PROGRAMS
   SI38785      OSP-DB-INCORROUT Array Support
   SI38750      OSP-DB-MSGSQ30000 Errors Running from V7R1 to V7R1/V6R1 Usin
   SI38675      osp-db-incorrout Stored Procedure Output Parameter is not up
   SI38672      OSP-DB Internal Maintenance
   SI38658      OSP-DB Internal Maintenance
   SI38589      OSP-DB-MSGMCH3601 F/QSQRUN2 MODULE/QSQVALUE F_MAP QUERY USIN
   SI38565      OSP-DB-OTHER-F/QSQFETCH-MSGMCH3601 PROCEDURE DTTERR
   SI38558      OSP-DB-QQQQEXIT-MSGMCH4417 in server mode
   SI38533      OSP-DB Internal Maintenance
   SI38504      OSP-DB Internal Maintenance
   SI38491      OSP-DB-OTHER LOB PROCESSING
   SI38427      OSP-DB-MSGMCH3601 T/QSQCLSCR NESTED STATEMENTS CONTAINING GL
   SI38403      OSP-DB multi row merge fails
   SI38345      OSP-DB-MSGMCH3601 F/QSQRUN2 MODULE/QSQVALUE PROCEDURE F_MAP_
   SI38308      OSP-DB Internal Maintenance
   SI38293      OSP-DB-MSGMCH3601 F/QSQROUTA SET GLOBAL VARIABLE = DEFAULT I
   SI38284      OSP-DB-INCORROUT Array Support
   SI38277      OSP-DB-OTHER-MSGSQL7953 MISSING LIBRARY NAME ON SQL DROP
   SI38189      OSP-DB-INCORROUT Array Support
   SI38137      OSP-DB-OTHER RESULT SET PROCESSING
   SI38122      OSP-DB-INCORROUT DRDA Array Support
   SI38118      OSP-DB failure in qsqrund
   SI38098      OSP-DB Internal Maintenance
   SI38027      OSP-DB-INCORROUT DRDA UPDATE WITH MIXTURE OF GLOBAL VARIABLE
   SI38018      OSP-DB Internal Maintenance
   SI38010      OSP-DB-MSGSQL0204 SET DESCRIPTOR references UDF in remote co
   SI38006      OSP-DB-INCORROUT SQL UPDATE WITH GLOBAL VARIABLES AND MIXTUR
   SI37981      OSP-DB-OTHER-F/QSQCONN-T/QSQCONN-MSGMCH3402 DISCONNECT IASP
   SI37979      OSP-DB-QSQVALUE-MSGMCH3601 when using descriptors
   SI37977      OSP-DB-OTHER-WAIT DLTLIB DOES NOT COMPLETE
   SI37968      OSP-DB No error message from program QSQ901
   SI37924      OSP-DB multi value updates
   SI37910      OSP-DB-INCORROUT VALUES INTO WITH GLOBAL VARIABLE
   SI37908      OSP-DB-MSGSQ20398-F/QSQCALLSP Array Support
   SI37857      OSP-DB-INCORROUT Array Support
   SI37856      OSP-DB-OTHER DRDA PROCESSING
   SI37820      OSP-DB Internal Maintenance
   SI37808      OSP-DB-OTHER-MSGSQL7953 MISSING LIBRARY NAME ON SQL DROP
   SI37796      OSP-DB multi value support
   SI37719      OSP-DB-OTHER-F/QSQRUN3-MSGSQL0404 WHEN INSERTING AN EMPTY ST
   SI37719      OSP-INCORROUT INCORRECT NUMBER OF RECORDS RETURNED WHEN RUNN
   SI37713      OSP-DB Internal Maintenance
   SI37631      OSP-DB-QSQVALUE MSGMCH3601
   SI37609      OSP-DB-INCORROUT VALUES INTO WITH MIXED GLOBAL VARIABLES AND
   SI37609      OSP-DB-INCORROUT SET GLOBAL VARIABLE=DEFAULT
   SI37609      OSP-DB-INCORROUT SET ENCRYPTION PASSWORD WITH GLOBAL VARIABL
   SI37576      OSP-DB-INCORROUT Array Support
   SI37575      OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QRWSQRY-RC00-MSGMCH0601 DDM
   SI37575      OSP-DB-OTHER-F/QRWSEXEC-T/QRWSEXEC-RC01-MSGCPF3E33 DRDA CONN
   SI37563      OSP-DB Internal Maintenance
   SI37558      OSP-DB-MSGSQL0313-F/QSQROUTA Array Support
   SI37537      OSP-DB-MSGMCH3601-F/QSQFETCH Toolbox JDBC
   SI37488      OSP-DB-OTHER XML PROCESSING
   SI37478      OSP-DB Internal Maintenance
   SI37476      OSP-DB Internal Maintenance
   SI37459      OSP-DB-INCORROUT REUSE OF STATEMENT CONTAINING GLOBAL VARIAB
   SI37395      OSP-DB-MSGSQL0501-F/QSQFETCH JDBC Toolbox
   SI37380      OSP-DB-INCORROUT EXECUTE USING MORE HOST VARIABLES THAN PARA
   SI37335      OSP-DB-MSGSQL0303-F/QSQVALUE Array Support
   SI37330      OSP-DB Internal Maintenance
   SI37325      OSP-DB-MSGMCH5003 F/QQQOOOSETS WHEN REUSING STATEMENTS REFER
   SI37306      OSP-DB-MSGSQL0420-F/QSQFETCH Array Support
   SI37251      OSP-DB-INCORROUT HOST VARIABLE NOT SET WHEN GLOBAL VARIABLE
   SI37251      OSP-DB-MSGMCH3601 F/QSQFETCH FOR GLOBAL VARIABLE PROCESSING
   SI37198      OSP-DB-MSGSQL0901-F/QSQVALUE Array Support
   SI37196      OSP-DB-MSGSQL0303 F/QSQROUTS WHEN SET TIMESTAMP GLOBAL VARIA
   SI37190      OSP-DB Internal Maintenance
   SI37188      OSP-DB-MSGSQL0302 F/QSQVALUE SELECT INTO GLOBAL VARIABLE
   SI37188      OSP-DB-MSGMCH3601 F/QSQCALLSP AFTER INSERTING GLOBAL VARIABL
   SI37168      OSP-DB-UNPRED Implicit package creation
   SI37156      OSP-DB CPD4374 MERGE with C-null terminated value for parame
   SI37090      OSP-DB-
   SI37090      OSP-DB-OTHER-PERFM A LOT OF TIME SPENT IN QSQCMPDS
   SI37090      OSP-DB-OTHER-INCORROUT 3RD OR SUBSEQUENT EXECUTION OF A SELE
   SI37018      OSP-DB Array Support
   SI36980      OSP-DB-UNPRED Failure to detect RDB not defined.
   SI36877      OSP-DB XML PROCESSING
   SI36866      OSP DB GLOBAL VARIABLE PROCESSING
   SI36862      OSP-DB-INCORROUT SQL0901 RETURNED TO JDBC RUNNING QUERY
   SI36804      OSP-DB INTERNAL MAINTENANCE
   SI36790      OSP-DB-UNPRED DRDA errors
   SI36784      OSP-DB INTERNAL MAINTENANCE
   SI36737      OSP-DB-MSGSQL0904 type 7 reason code 167
   SI36737      OSP-DB-OTHER-F/QSQCONN-T/QSQCONN-MSGSQL0751 TRIGGER RUNNING
   SI36737      OSP-DB-OTHER-UNPRED QQSPC* TEMPORARY SPACES KEEP INCREASING
   SI36735      OSP-DB XML PROCESSING
   SI36659      OSP-DB-UNPRED DRDA errors
   SI36627      OSP-DB XML processing of SQLXSR objects
   SI36615      OSP-DB-OTHER-F/SQLBC-T/SQLBC-MSGMCH3601 MCH3601 F/QSQCLI T/Q
   SI36615      OSP-OTHER-PERFM CLOSE OF SQL CURSOR TAKING LONGER AFTER UPGR
   SI36584      OSP-DB-UNPRED Server mode error handling
   SI36581      OSP-DB Array Support
   SI36552      OSP DB GLOBAL VARIABLE PROCESSING
   SI36547      OSP-DB-UNPRED Correct LOB override over DRDA
   SI36536      OSP-DB INTERNAL MAINTENANCE
   SI36526      OSP-DB XML PROCESSING
   SI36517      OSP-DB-UNPRED Correct LOB override over DRDA
   SI36446      OSP-DB-UNPRED Correct indicator check for LOBs over DRDA

Summary Information

System.............................. i
Models..............................
Release............................. V7R1M0
Licensed Program............... 5770SS1
APAR Fixed.......................... View details for APAR SE43430
Superseded by:...................... View fix details for PTF SI68439
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C0229710


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, 2018, 2019 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.

Document information

More support for: i family

Software version: V7R1M0

Operating system(s): OS/400

Reference #: SI39898

Modified date: 09 June 2010