IBM Support

SI67442 - OSP ACTIVATION SCOPE ISSUES WHEN SETTING CLIENT SPECIAL REGI

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP ACTIVATION SCOPE ISSUES WHEN SETTING CLIENT SPECIAL REGI


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI57767   00/00    0000
PRE  5770SS1  710  SI49684   00/00    0000
PRE  5770999  710  MF49948   00/00    0000
PRE  5770SS1  710  SI38332   00/00    0000
CO   5770SS1  710  SI62811   00/00    0000
CO   5770SS1  710  SI56982   00/00    0000
CO   5770SS1  710  SI56984   00/00    0000
CO   5770SS1  710  SI56682   00/00    0000
CO   5770SS1  710  SI53276   00/00    0000
CO   5770SS1  710  SI50046   00/00    0000
CO   5770SS1  710  SI49105   00/00    0000
CO   5770SS1  710  SI49106   00/00    0000
CO   5770SS1  710  SI48080   00/00    0000
CO   5770SS1  710  SI48143   00/00    0000
CO   5770SS1  710  SI48144   00/00    0000
CO   5770SS1  710  SI48018   00/00    0000
CO   5770SS1  710  SI48195   00/00    0000
CO   5770SS1  710  SI48198   00/00    0000
CO   5770SS1  710  SI48197   00/00    0000
CO   5770SS1  710  SI47868   00/00    0000
CO   5770SS1  710  SI47550   00/00    0000
CO   5770SS1  710  SI47141   00/00    0000
CO   5770SS1  710  SI47117   00/00    0000
CO   5770SS1  710  SI46685   00/00    0000
CO   5770SS1  710  SI46365   00/00    0000
CO   5770SS1  710  SI41416   00/00    0000
CO   5770SS1  710  SI39903   00/00    0000
CO   5770SS1  710  SI39069   00/00    0000
DIST 5770SS1  710  SI66541   00/00    0000
DIST 5770SS1  710  SI57813   00/00    0000
DIST 5770SS1  710  SI54179   00/00    0000
DIST 5770SS1  710  SI51159   00/00    0000
DIST 5770SS1  710  SI50683   NONE     0012
DIST 5770SS1  710  SI47687   NONE     0013
DIST 5770SS1  710  SI40707   00/00    0000
DIST 5770SS1  710  SI40754   00/00    0000
DIST 5770SS1  710  SI43720   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

-----------------------------------------------
OPNDBF FILE(HYDB.12345/EMP1) OPTION(*ALL)
Token .12345 was not valid. Valid tokens: NO BEFORE
<IDENTIFIER>.
Request CREATE TRIGGER to module QSQTRG not valid.
SQL procedure, function, trigger, or variable SAL_ADJ1 in
HYDB.12345 not
created.

CORRECTION FOR APAR SE69202 :
-----------------------------
The problem occurs when the library in a trigger statement has a
. in the name and is 9 or 10 characters. The problem is fixed
with this PTF.

CIRCUMVENTION FOR APAR SE69202 :
--------------------------------
None.


DESCRIPTION OF PROBLEM FIXED FOR APAR SE68620 :
-----------------------------------------------
There is an issue in some cases where the correct activation
group isn't being used when setting client special register
causing the wrong or no value to be returned when running in a
stored procedure.

CORRECTION FOR APAR SE68620 :
-----------------------------
The problem occurs when running in a named activation group and
using WLM_SET_CLIENT_INFO to set client special registers. In
that case, WLM_SET_CLIENT_INFO was setting the special registers
in the default activation group. With this PTF, the correct
activation group will be used.

CIRCUMVENTION FOR APAR SE68620 :
--------------------------------
None.


DESCRIPTION OF PROBLEM FIXED FOR APAR SE69082 :
-----------------------------------------------
This failed for customer
STRSQL
>create variable tablename char(7) default ('myTable')
Variable TABLENAME was created in QGPL.
>CALL PROCESS_DETAILED_MONITOR('GS',1,null,null,null,
'QUSRSYS','QAUGDBPMD2','DBSYSLIB',(values tablename))

CORRECTION FOR APAR SE69082 :
-----------------------------
The problem occurs when an expression used on a CALL statement
and the total length of the parameters exceeds 32K. The problem
is fixed with this PTF.

CIRCUMVENTION FOR APAR SE69082 :
--------------------------------
None.


Activation Instructions


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)
STRTCPSVR SERVER(*DDM)

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

ENDTCPSVR SERVER(*DIRSRV)
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).





Special Instructions


None.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI60868      OSP-DB-INCORROUT CURRENT CLIENT_APPLNAME may not be correct
   SI49183      OSP-DB-MSGSQL7034 intermittent failure with java udf
   SI45856      OSP-DB sqludf_ccsid API
   SI42504      OSP-DB-INCORROUT ENABLE AUTOCOMMIT WITH COMMIT LEVEL *NONE I
   SI39415      OSP-DB-MSGMCH3601 calling java procedure
   SI67373      OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGSQL0204 A MSGSQL0204 MAY
   SI66713      F/QSQTRG-MSGSQL0104 CRTDUPOBJ FOR TRIGGER SQL0104 T/QSQTRG F
   SI66540      OSP-DB-OTHER-UNPRED MERGER STATEMENT WITH AN UPDATE OPERATIO
   SI65849      OSP-DB-OTHER-F/QZDGDBGS-T/QSQRUN4-MSGMCH0601 GENERATE SQL FA
   SI65849      OSP-DB-OTHER-F/QZDGDBGS-T/QSQRUN4-MSGSQL0204 INAV GENERATE S
   SI65422      OSP-DB-OTHER-MSGMCH1210 QSQGNDDL PROBLEM WITH WRAPPED COMMEN
   SI65166      OSP-DB-OTHER-INCORROUT MERGE SHOULD INSERT 2 RECORDS, ONLY 1
   SI65143      OSP-DB-OTHER-F/QSYRVAUT-T/QSQPROC-MSGCPF2236 WHEN JAVA UDF S
   SI64282      OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGMCH1210 MSGMCH1210 F/QSQ
   SI63646      OSP-DB INTERNAL MAINTENANCE
   SI63009      OSP-DB-QSQCALLSP-MSGMCH3601 Calling stored procedure using d
   SI62812      OSP-DB INTERNAL MAINTENANCE
   SI62708      OSP-DB-MSGSQL0206 Setting Global Variable to Default Value A
   SI61269      OSP-DB-OTHER-F/QSQRUN4MOD/QSQCALLEXPPROC/SQL_EXPINCALL- MSGM
   SI60587      OSP-DB-OTHER-UNPRED EXTERNAL PROCEDURE CANNOT BE RESTORED
   SI60476      OSP-DB-MSGMCH3601 External Procedure Call with Basic Default
   SI60356      OSP-DB-F/QSQROUTS-MSGSQ20226 Looping on SQ20226 when running
   SI60298      OSP-DB-OTHER-UNPRED EXTERNAL PROCEDURE CANNOT BE RESTORED
   SI60298      OSP-DB Describe Parameter Marker incorrect for CALL with nam
   SI59836      OSP-DB Embedded Create trigger uses program target release
   SI58275      OSP-DB Internal Maintenance
   SI58275      OSP-DB Embedded Create trigger uses program target release
   SI58203      OSP-DB Embedded Create trigger uses program target release
   SI58151      OSP-DB-MSGSQL0482 not returned on remote procedure
   SI58037      OSP-DB Internal Maintenance
   SI57968      OSP-DB-MSGMCH3601-T/QSQRUND2 sql stored procedure call
   SI57902      OSP-DB-OTHER-T/QSQRUN4-MSGMCH0601 MODULE QSQCALLSP PROCEDURE
   SI57832      OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGMCH1210 ON A CREATE PROC
   SI57814      OSP-DB Internal Maintenance
   SI57525      OSP-DB-JRN-INCORROUT NO AUDIT JOURNAL ENTRY FOR CREATE OR RE
   SI57400      OSP-DB-OTHER-THREADS-UNPRED RDB() SHOWS BLANK FOR AN RPG PGM
   SI57085      OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON
   SI56983      OSP-DB Internal Maintenance
   SI56972      F/QSQCALLSP-MSGSQL0443 AFTER CREATE TRIGGER IN GENERATE SQL
   SI56755      OSP-DB CPYFRMIMPF CAN RUN SLOW IF OVRDBF IS USED.
   SI56721      OSP-DB Internal Maintenance
   SI56681      OSP-DB Update SYSTRIGGERS to correct REMARKS column
   SI56369      OSP-DB-OTHER-INCORROUT SYSROUTINEDEP DELIMITED NAMES QUOTES
   SI56362      OSP-DB-OTHER-LOOP-T/QSQCMTSP-MSGMCH0601
   SI56015      OSP-DB-OTHER-F/QDBCRTFI-T/QSQCRTT-MSGCPF3204 DECLARE GLOBAL
   SI55908      OSP-DB-OTHER-F/QSQRUN4-MSGMCH0601 WHEN USING A QUERY DEFINED
   SI55634      OSP-DB-OTHER-F/QSQRCHK-T/QSQRCHK-MSGMCH1210 RUNSQLSTM FAILS
   SI55299      OSP-DB-INCORROUT-MSGMCH3601 QSQGNDDL GENERATE_SQL procedure
   SI55278      OSP-DB Internal Maintenance
   SI55165      OSP-DB-OTHER-RC2-MSGSQL7049
   SI55160      OSP-DB Internal Maintenance
   SI55108      OSP-DB-OTHER-UNPRED QSQSVCDMP SPOOLED FILE CREATED
   SI55051      OSP-DB-MSGMCH3402-F/QSQFETCH ARRAY RESULT SET CURSOR FETCH F
   SI54966      OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
   SI54716      OSP-DB INTERNAL MAINTENANCE
   SI54625      OSP-DB INTERNAL MAINTENANCE
   SI54623      OSP-DB-OTHER-T/QSQRUN4-MSGMCH1210 MODULE QSQMERGE
   SI54396      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
   SI54328      OSP-DB-MSGSQL1506 Generate SQL of a DDS file
   SI54178      OSP-DB-MSGMCH3402-F/QSQSETUP SQL PGM/SRVPGM IN QTEMP QRWTSRV
   SI54101      OSP-DB CREATE OR REPLACE sourced function not replacing corr
   SI54031      OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
   SI53919      OSP-DB-OTHER-UNPRED AUDIT JOURNAL ENTRY FROM COMMENT ON FOR
   SI53909      OSP-DB ADD LOCK TABLE SUPPORT MULTIPLE MEMBER FILES
   SI53863      OSP-DB INTERNAL MAINTENANCE
   SI53779      OSP-DB-OTHER-F/QDBSIGEX-T/QSQPROCR-MSGCPF5009 MSGCPF5009 MSG
   SI53703      OSP-DB-MSGSQL0435 sent for a SIGNAL statement with a warning
   SI53695      OSP-DB DBMON 1000 QVC1C EXPLAINABLE INCORRECT SET FOR SP PRE
   SI53606      OSP-DB SQL procedure parameter DEFAULT value in SYSPARMS mis
   SI53278      OSP-DB SYSROUTINEDEP column PARM_SIGNATURE has the wrong dat
   SI53154      OSP-DB Generate SQL for obfuscated procedure fixes
   SI53159      OSP-DB-OTHER-F/QQQSRVE1-T/QSQRUN3-MSGCPD4373 A MSGCPD4373 MA
   SI53044      OSP COMMENT ON FOR STORED PROCEDURE CAUSES A SYSROUTINE SYNC
   SI52840      OSP-F/QSQRUN4-T/QSQRUN4-MSGMCH1210 SIGNAL STATEMENT TRIGGER
   SI52814      OSP-DB-OTHER-INCORROUT GENERATE SQL TRANSLATING '/' TO '.'
   SI52720      OSP-DB-MSGMCH0602-T/QSQROUTE long running job
   SI52467      OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGMCH3601 A MSGMCH3601 F/Q
   SI52464      OSP-DB-OTHER-T/QSQPROC-MSGSQL0913 DROPPING A SQL PROCEDURE
   SI52300      OSP-DB QIBM_SQL_NO_CATALOG_UPDATE should include Rename Libr
   SI52284      OSP-DB-OTHER-T/QSQRUN4X/19306-MSGSQL0204 WITH OVRDBF, MERGE
   SI52276      OSP-DB-OTHER-MSGSQL0443 SERVICEABILITY ENHANCEMENT
   SI52255      OSP-DB-SQL Support optionally clearing SQLSTATE on truncatio
   SI52140      OSP-DB INTERNAL MAINTENANCE
   SI52009      OSP-DB INTERNAL MAINTENANCE
   SI51988      OSP-DB-OTHER-LOOP QSQRUN4/QSQCALLSP/MAP_WITH_CCSIDS
   SI51910      OSP-DB INTERNAL MAINTENANCE
   SI51802      OSP-DB-OTHER-MSGCPF5129-T/QSQRUN4 MODULE QSQMERGE
   SI51679      OSP-DB-OTHER-F/QDMROUTE-T/QSQTRGIO-MSGCPF2207
   SI51675      OSP-DB Generate SQL for EVI index with include columns not c
   SI51446      OSP-DB-SQL Support optionally setting indicator on truncatio
   SI51395      OSP-DB Internal Maintenance
   SI51324      OSP-DB-OTHER-UNPRED SYSTEM SQL APPEARS IN STRDBMON WHEN INCS
   SI51212      OSP-UNPRED CRTDUPOBJ AND MOVOBJ OF PROGRAM REMOVES CATALOG R
   SI51158      OSP-DB-OTHER-INCORROUT AFTER MOVING FROM R540 TO R710, PROCE
   SI51147      OSP-DB-OTHER-INCORROUT SQL7985 AND SQ99999 WITH NO RESULT SE
   SI51080      OSP-DB Support compatible date/time strings in input arrays
   SI51076      OSP-DB-OTHER-INCORROUT Deleting *SRVPGM of external function
   SI51068      OSP-DB-OTHER-LOOP QSQAPIS/sqludf_create_locator
   SI50993      OSP-DB-OTHER-T/QSQRUN4-MSGMCH3601 MODULE QSQCALLSP PROCEDURE
   SI50934      OSP-DB-MSGCPD5D02 ON CREATE FUNCTION EMBEDDED IN A HLL PROGR
   SI50924      OSP-DB-SQL Dynamic Compound Statement Support
   SI50911      OSP-DB Global variable initialized to NULL when default is I
   SI50733      OSP-DB QSQGNDDL() enhancement to generate SQLindexes for key
   SI50618      OSP-THREADS-F/QSQRUN4-T/QSQRUN4-MSGSQL0913 WITH A REFRESH TA
   SI50553      OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGSQL0446 AFTER UPGRADING
   SI50454      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0313 SQL0313 WHEN E
   SI50432      OSP-DB-QSQPROCR-MSGSQL9015 when CRTDUPOBJ of a program acros
   SI50418      OSP-DB-OTHER-F/EX2401PTRDOESNOTEXIST-T/QSQPROC-MSGMCH3601 QZ
   SI50326      OSP-DB-MSGSQL0429 Using LOB variable within a SQL procedure
   SI50306      OSP-DB-OTHER-INCORROUT TRIGGERS FIRE IN WRONG ORDER FOR MERG
   SI50091      OSP-DB-OTHER-INCORROUT AFTER DROP PROCEDURE, INCORRECT INFOR
   SI50084      OSP-DB-OTHER-F/QZDGDBGS-T/QSQRUN4-MSGMCH1210 MSGMCH1210 F/QZ
   SI50048      OSP-DB Support for Debug of Scalar UDFs with Data Studio
   SI50028      OSP-DB-QSQPROCR-MSGSQL9015 Restore of program for procedure
   SI49946      OSP-DB-OTHER-MSGCPF3BCC-F/QSQPROC/BUILDNLSSSTRUCTURE When do
   SI49916      OSP-DB-QSQTRGPM-MSGMCH1210 creating a duplicate trigger with
   SI49916      OSP-DB-QSQPROCR-MSGSQL9015 on MOVOBJ or RNMOBJ of a library
   SI49888      OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGSQL0901 A MSGSQL0901 MAY
   SI49875      OSP-DB-OTHER-F/QSQPROCR-T/QSQPROCR-MSGMCH1210 MSGMCH1210 F/Q
   SI49833      OSP-DB-QSQPROCR-MSGSQL9015 on MOVOBJ or RNMOBJ of a library
   SI49818      OSP-DB-OTHER-MSGSQ20073 ON A CREATE FUNCTION USED BY AN MQT
   SI49814      OSP-DB-MSGMCH3601-F/QSQRUN4 QSQCALLEXP EXPRESSIONS IN CALL F
   SI49814      OSP-DB-OTHER-MSGSQL0302 CALLING JAVA STP WITH LOBS
   SI49738      OSP-DB-OTHER-F/QZDGDBGS-T/QSQRUN4-MSGMCH0601 FOR GENERATE SQ
   SI49725      OSP-DB-OTHER-F/QSQPROCR-T/QSRRSTPS-MSGSQL9015 RESTORING SQL
   SI49704      OSP-DB-OTHER Disallow triggers with BEFORE action over QSYS2
   SI49688      OSP-DB Unexpected SQL7909 for DROP external SQL function
   SI49668      OSP-DB-OTHER Incorrect trigger name in catalog when trigger
   SI49658      OSP-DB-OTHER-INCORROUT RSTOBJ AND RNMOB AT TIMES RESULT IN M
   SI49640      OSP-F/QSQRUN3-T/QSQRUN3-RC3-MSGSQL7008 MQT FAILS TO REFRESH
   SI49629      OSP-DB-OTHER-MSGMCH3601 F/QSQPROC/45634 on SQL CREATE PROCED
   SI49538      OSP-DB-OTHER-MSGSQL0392 PROCESSING A DRDA RESULT SET
   SI49511      OSP-DB Problems after a CREATE PROCEDURE with default parame
   SI49511      OSP-DB-OTHER-Sort sequence on SQL SET OPTION not used for SQ
   SI49466      OSP-DB SYSROUTINE locked by QDBSRVXR2 after PTFs are applied
   SI49389      OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGMCH1210 OSP-DB-OTHER-F/Q
   SI49381      OSP-DB-OTHER-MSGSQL0204 QSQGNDDL API FAILING WITH MSGSQL0204
   SI49356      OSP-DB Internal Maintenance
   SI49319      OSP-DB Internal Maintenance
   SI49289      OSP-F/QSQRUN3-T/QSQRUN3-RC3-MSGSQL7008 MQT FAILS TO REFRESH
   SI49289      OSP-F/EXSNDPM-T/QSQRUN4-MSGMCH1401 MQT REFRESH FAILS WITH MS
   SI49098      OSP-DB-OTHER-UNPRED STORED PROCEDURE REGISTERED INCORRECTLY
   SI49111      OSP-DB Add option to specify system name for create table, v
   SI49104      OSP-DB-OTHER-MSGSQL0104 WHEN TRYING TO CREATE A TRIGGER USIN
   SI49055      OSP-DB Internal Maintenance
   SI49035      OSP-DB QSQGNDDL API GENERATING A 'N' INSTEAD OF UNDERSCORE.
   SI49007      OSP-DB-OTHER-UNPRED MERGE SQL STATEMENTS SHOWING UP AS USER
   SI49005      OSP-DB-OTHER-F/QSQPROCR-T/QSRRSTPS-MSGSQL9015 RESTORING SQL
   SI48961      OSP-DB-QSQQDTNV-MSGMCH0601 when dropping schema
   SI48960      MSGMCH2601 Lock enforcement rules broken when trying to acce
   SI48909      OSP-DB Internal Maintenance
   SI48896      OSP-DB Internal maintenance
   SI48847      OSP-DB INTERNAL MAINTENANCE
   SI48115      OSP-DB-OTHER-INCORROUT CREATE_WRAPPED fails in RUNSQLSTM
   SI47694      OSP-DB-OTHER-MSGSQL0206 WRAPPING GLOBAL VARIABLE
   SI46169      OSP-DB Internal Maintenance
   SI45872      OSP-DB Internal Maintenance
   SI45672      OSP-DB-MSGSQL0601 CREATE REPLACE TRIGGER WITH UNQUALIFIED TR
   SI44424      OSP-DB-INCORROUT SQL DETAILS FOR JOB DOES NOT REFRESH
   SI42928      OSP-DB SPECIFY PROGRAM NAME ON CREATE TRIGGER
   SI38924      OSP-DB-MSGMCH1210 Creating SQL trigger
   SI39240      OSP-DB CREATE OR REPLACE TRIGGER RESULTS IN WRONG STATEMENT
   SI38573      OSP-DB Incorrect Owner of Triggers Created for OmniFind Text
   SI37646      OSP-DB Internal Maintenance
   SI37169      OSP-DB INTERNAL MAINTENANCE
   SI48597      OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGCPF9898 AFTER APPLY OF S
   SI48570      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
   SI48503      OSP-DB INTERNAL MAINTENANCE
   SI48419      OSP-DB EXTERNAL_NAME in SYSROUTINE not correct
   SI48273      OSP-DB Improved database catalog management for SQL routines
   SI48273      OSP-DB INTERNAL MAINTENANCE
   SI48273      OSP-DB-QSQPROC MSGSQL0913 when dropping routine
   SI48194      OSP-DB-OTHER-RC480-MSGSQL0904
   SI48127      OSP-DB INTERNAL MAINTENANCE
   SI48104      OSP-DB Improved database catalog management for SQL routines
   SI48020      OSP-DB INTERNAL MAINTENANCE
   SI47865      OSP-DB incorrect data with new save point level
   SI47841      OSP-DB EXTERNAL_NAME in SYSROUTINE has extra trailing blank
   SI47551      OSP-DB-MSGCPF9898 SQL CREATE PROCEDURE statement in RUNSQL
   SI47324      OSP-DB Add a listing option to the RUNSQLSTM command
   SI47268      OSP-DB-OTHER-UNPRED A QUERY OF SYSFUNCS MAY HAVE AN EXTRA SP
   SI47143      OSP-DB INTERNAL MAINTENANCE
   SI47120      OSP-DB Internal Maintainence
   SI46783      OSP-DB-OTHER-UNPRED A COMPLETE SYSTEM RESTORE WITH RESTORE O
   SI46746      OSP-DB-OTHER-T/QSQRUN4-MSGMCH1001 MODULE QSQMERGE
   SI46736      OSP-DB ALLOW GLOBAL VARIABLES TO BE CHANGED WITHIN TRIGGERS
   SI46684      OSP-DB-OTHER-INCORROUT PROCEDURES WITH OUTPUT LOB LOCATORS T
   SI46607      OSP-DB INTERNAL MAINTENANCE
   SI46486      OSP-DB-OTHER-F/QSQBAS\SQGETSPACE-MSGMCH3601 OPEN OF VIEW OVE
   SI46435      OSP-DB-OTHER-MSGSQL0204 RUNNING MERGE STATEMENT SIMULTANEOUS
   SI46367      F/QSQXCUTE-MSGSQL0104-RIDS/CLEANUP SETTING AN SQL VARIABLE T
   SI46329      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0804 SQL0804 MESSAG
   SI46196      OSP-DB-OTHER-MSGMCH5401-T/QSQRUN1 IN LONG RUNNING JOB
   SI46120      OSP-DB Internal Maintenance
   SI46120      OSP-DB INTERNAL MAINTENANCE
   SI46120      OSP-DB-MSGSQL7909 REASON CODE 1 SCHEMA NAME TRUNCATED IN MES
   SI45899      SQL-RUN-INCORROUT GENERATE SQL ON A PROCEDURES THAT CONTAINS
   SI45837      OSP-DB SQL CALL CACHE AND UNQUALIFIED PROCEDURE CALLS
   SI45805      OSP-F/QDBSIGEX-T/QSQPROCR-MSGCPF5035 MSGCPF5035 F/QDBSIGEX T
   SI45264      OSP-DB Storage Leak using procedure with expressions
   SI45190      OSP-DB-OTHER DRDA HETEROGENEOUS CALL WITH ARRAY NOT WORKING
   SI45186      OSP-DB-MSG MCH6801 QSQCALLSP calling procedure
   SI45058      OSP-DB-OTHER-UNPRED Incorrect result set returned with neste
   SI44883      OSP-DB-OTHER-F/QSQRUN4-MSGMCH0601 A MSGMCH0601 F/QSQRUN4 FMO
   SI44786      OSP-DB-OTHER-F/QRWTBAS-T/QRWTBAS-MSGMCH3601 SOME STORED PROC
   SI44544      OSP-DB-OTHER XML Support
   SI44423      OSP-DB-INCORROUT SQL DETAILS FOR JOB DOES NOT REFRESH
   SI44393      OSP-DB-MSGSQL0788 MERGE into logical file based on multiple
   SI44210      OSP-DB SLOW RENAME LIBRARY PERFORMANCE
   SI44193      OSP-DB-OTHER-MSGSQL0312 MERGE SQL statement
   SI44125      OSP-DB-OTHER-T/QRWSQRY-MSGMCH3601
   SI43805      OSP-DB Sourced UDFs based on NOT FENCED UDFs are FENCED
   SI43719      OSP-MSGSQL0913 MERGE INTO STATEMENT FAILS WITH SQL0913
   SI43465      OSP-DB-MSGSQL7909 RETURN REASON CODE 1 instead of 9
   SI43131      OSP-DB-MSGSQL0204 when using an alias for 3 part name
   SI43072      OSP-DB-OTHER-MSGSQL0751
   SI42990      OSP-DB-INCORROUT Array Support
   SI42989      OSP-DB SELECT WITH MULTIPLE JOIN FAILS MSGSQL0913 F/QSQRUN3
   SI42983      OSP-DB Connect By support
   SI42931      OSP-DB SPECIFY PROGRAM NAME ON CREATE TRIGGER
   SI42856      OSP-DB-OTHER-PERFM WHEN TRYING TO SEND A LARGE BLOB AS PARAM
   SI42785      OSP-DB-INCORROUT Expressions in CALL Support
   SI42617      OSP-DB-QSQCALLSP-MSGMCH0601 with a long running job that cal
   SI42100      OSP-DB-MSGSQL0491 when specifying EXTERNAL ACTION on SQL pro
   SI41955      OSP-DB-INCORROUT Expressions in CALL Support
   SI41916      OSP-DB-MSGMCH1224 F/#CFDATEI T/QSQRUN4-QSQCALLSP CALL PROGRA
   SI41870      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGMCH3601 STORED PROCEDU
   SI41781      OSP-DB-OTHER-MSGSQL0519 USING BRMS CONTROL GROUP
   SI41637      OSP-DB-OTHER-UNPRED UPDGRADE PROCESS FOR V5R4 TO V6R1, RESTO
   SI41637      OSP-DB-OTHER-F/QSQPROCR-T/QSQPROCR-MSGMCH3601 MSGMCH3601 F/Q
   SI41606      OSP-DB-MSGSQL0478 f/QSQPROC Unexpected failure on CREATE OR
   SI41599      OSP-DB-MSGSQL0501 with SQL MERGE statement via QSQPRCED API
   SI41523      OSP-DB-INCORROUT Expressions in CALL Support
   SI41430      OSP-DB-QSQASLOC-MSGSQL0480 when should have received SQL0482
   SI41418      OSP-DB-INCORROUT VISUAL EXPLAIN OF MERGE FAILS
   SI41402      OSP-DB-MSGMCH5401-T/QSQLOCK on lock table statement
   SI41351      OSP-DB-INCORROUT Using file reference variable as argument t
   SI41293      OSP-DB-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
   SI41264      OSP-DB-INCORROUT Expressions in CALL Support
   SI41247      OSP-DB-MSGMCH3601-T/QSQRFRSH with a deflated table
   SI41227      OSP-DB-OTHER-F/QSQCALL-T/QSQCALL-MSGSQL0204 CALL TO PROCEDUR
   SI40949      OSP-DB-INCORROUT Expressions in CALL Support
   SI40879      OSP-DB-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
   SI40819      OSP-DB-MSGSQL0301 calling procedure with XML AS BINARY param
   SI40700      OSP-DB-UNPRED Three part alias statement rewrite
   SI40608      OSP-DB-INCORROUT Expressions in CALL Support
   SI40588      OSP-DB-INCORROUT Expressions In CALL Support
   SI40578      OSP-DB-INCORROUT Array Support
   SI40521      OSP-DB-MSGMCH3601 F/QSQVARSERV/CopyValue when using three-pa
   SI40454      OSP-DB-UNPRED IBM Internal Post GA Test - MSGSQ30000 Errors
   SI40369      OSP-DB-QSQASLOC-MSGSQL0206 on ASSOCIATE LOCATOR to LUW
   SI40361      OSP-DB-UNPRED Failing to propagate LOBs over three-part nami
   SI40249      QSP-DB-MSGMCH3402 f/QSQRUN4/QSQVARSERV/15121 during end job
   SI40181      OSP-DB-INCORROUT Passing XML to CHAR parameter does not pad
   SI40174      OSP-DB-MSGSQL0501 on result set cursor
   SI40161      OSP-DB-MSGMCH5003 f/QQQVALID/33170 when using XML data in OP
   SI40151      OSP-DB-OTHER Expressions in CALL Support
   SI40149      OSP-DB-INCORROUT RAISE_ERROR SQL builtin function produces t
   SI39997      OSP-DB-QSQPROC-MSGSQL0204 when dropping  routine using speci
   SI39985      OSP-DB-INCORROUT Expressions in CALL Support
   SI39897      OSP-DB-QSQASLOC-MSGSQL0204 when using specific name on ASSOC
   SI39861      OSP-DB Internal Maintenance
   SI39846      OSP-DB-MSGSQL0518 EXECUTE IMMEDIATE MERGE repeatedly
   SI39709      OSP-DB-UNPRED Java stored procedure result sets failing over
   SI39703      OSP-DB-MSGSQL0518 when MERGE statement run repeatedly
   SI39630      OSP-F/QLIMROIR-T/QSQPROCR-MSGSQL9015 EXTERNAL STORED PROCEDU
   SI39597      OSP-DB-INCORROUT Array Support
   SI39567      OSP-DB Internal Maintenance
   SI39545      OSP-DB Row locks not released after SQL MERGE
   SI39535      OSP-DB-INCORROUT Array Support
   SI39505      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGSQL0180 DRDA CALL
   SI39486      OSP-DB-INCORROUT Expressions In CALL Support
   SI39447      OSP-DB-UNPRED Java stored procedure result sets failing over
   SI39416      OSP-DB-INCORROUT MSGSQL0440 f/QSQPROC generated when specify
   SI39416      OSP-DB-INCORROUT MSGMCH2601 f/QSQVARSERV/SQVARF_RESOLVE/5480
   SI39371      OSP-DB-MSGSQL0805 in drda job
   SI39343      OSP-DB-INCORROUT Array Support
   SI39327      OSP-DB-QSQDSCPR-MSGSQL0476 when using specific name for DESC
   SI39318      OSP-DB Performance enhancement for SQL MERGE statement
   SI39230      OSP-DB-INCORROUT CLOB GLOBAL VARIABLE MAY CONTAIN INCORRECT
   SI39187      OSP-DB-QSQPREP-MSGMCH1210 when using result sets.
   SI39177      OSP-DB-OTHER Expressions in CALL Support
   SI39164      OSP-DB Internal Maintenance
   SI39060      OSP-DB Internal Maintenance
   SI38915      OSP-DB-QSQDSCPR-MSGMCH1210 on DESCRIBE PROCEDURE or ASSOCIAT
   SI38913      OSP-DB Internal Maintenance
   SI38791      OSP-DB Internal Maintenance
   SI38783      OSP-DB-MSGSQL0180-F/QSQCALLSP Array Support
   SI38774      OSP-DB-MSGSQL0516 with merge stmt
   SI38774      OSP-DB index advisor errors
   SI38701      OSP-DB-INCORROUT Capturing DBMONITOR of Global Variables
   SI38687      OSP-DB Internal Maintenance
   SI38659      OSP-DB Internal Maintenance
   SI38606      OSP-DB-MSGMCH3601-T/QSQPROC
   SI38505      OSP-DB Internal Maintenance
   SI38457      OSP-DB Internal Maintenance
   SI38311      OSP-DB update sq objects with last change date
   SI38287      OSP-DB Internal Maintenance
   SI38119      OSP-DB incorrect describe logic
   SI38072      OSP-DB-OTHER-UNPRED DB2_NUMBER_RESULT_SETS SQLERRD2 NOT SET
   SI38030      OSP-DB Internal Maintenance
   SI37985      OSP-DB-MSGMCH3601 T/QSQPDI MERGE with constraint on target t
   SI37963      OSP-DB-OTHER XML PROCESSING
   SI37915      OSP-DB-INCORROUT XML Array Support
   SI37817      OSP-DB-MSGMCH1880 REFRESH TABLE fails with SQL0901 with cons
   SI37786      OSP-DB Internal Maintenance
   SI37749      OSP-DB-OTHER CREATE OR REPLACE PROCESSING
   SI37731      OSP-DB Internal Maintenance
   SI37675      OSP-DB Internal Maintenance
   SI37666      OSP-DB Internal Maintenance
   SI37667      OSP-DB Internal Maintenance
   SI37650      OSP-DB Internal Maintenance
   SI37628      OSP-DB-QSQALTER-MSGMCH0605, MSGSQL0901 with ALTER REPLACE
   SI37607      OSP-DB-MSGMCH3601 F/QSQCALLSP PROGRAM PARAMETERS GLOBAL VARI
   SI37603      OSP-DB-OTHER XML PROCESSING
   SI37596      OSP-DB Internal Maintenance
   SI37471      OSP-DB-OTHER-F/QSQCALL-T/QSQCALL-MSGMCH3601 PROCEDURE SET_TA
   SI37408      OSP-DB-INCORROUT Toolbox JDBC Array Support
   SI37405      OSP-DB-MSGSQL7049 when running with result sets
   SI37377      OSP-DB SYSPARMS does not contain CCSID for XML table functio
   SI37352      OSP-DB Duplicate key SQL0803 from MERGE statement
   SI37324      OSP-DB-MSGSQL0446 F/QSQCALLSP WHEN CALL PARAMETER HAS XML AS
   SI37281      OSP-DB XML PROCESSING
   SI37271      OSP-DB-INCORROUT DRDA Array Support
   SI37173      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGSQL0311 STORED PROCEDU
   SI37155      OSP-DB SYSPARMS DATA_TYPE COLUMN DOES NOT CONTAIN ARRAY
   SI37126      OSP-DB INTERNAL MAINTENANCE
   SI37014      OSP-DB-MSGSQL0901-F/QSQCALLSP Array Support
   SI37010      OSP ROUTINE_DEFINER IN SYSPROCS IS GETTING SET HAS PROGRAM O
   SI36894      OSP-DB-INCORROUT - MSGSQL0104 ON ALTER FUNCTION IF FUNCTION
   SI36875      OSP-DB XML PROCESSING
   SI36861      OSP-DB Array Support
   SI36833      OSP-DB MCH1210 T/QQQOOOOPEN running MERGE statement
   SI36831      OSP-DB INTERNAL MAINTENANCE
   SI36742      OSP-DB XML PROCESSING
   SI36669      OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGMCH1210 USER-DEFINED FUN
   SI36580      OSP-DB Array Support
   SI36579      OSP-DB-OTHER-INCORROUT MSGSQ20073 ON CREATE FUNCTION IF PREV
   SI36578      OSP-DB Row count not set for NOT ATOMIC MERGE
   SI36527      OSP-DB XML PROCESSING
   SI36520      OSP-DB-UNPRED Force FDOCA mode for DATE/TIME in SPRS
   SI48295      QSQGNDDL - Privilege are not generated for *LIBL qualifed ob
   SI48126      OSP-DB INTERNAL MAINTENANCE
   SI48022      OSP-DB INTERNAL MAINTENANCE
   SI47661      OSP-DB Qualified name option for QSQGNDDL API
   SI46015      OSP-DB Internal Maintenance
   SI45924      SQL-RUN-INCORROUT GENERATE SQL ON A PROCEDURES THAT CONTAINS
   SI44421      OSP-DB-INCORROUT QSQGNDDL() of an EVI index with INCLUDE
   SI43553      OSP-DB-OTHER-INCORROUT GENERATE SQL MISSING THE WHEN WHEN CR
   SI43532      OSP-DB-OTHER-INCORROUT QSQGNDDL API MAY RETURN THE WRONG NAM
   SI43354      OSP-DB-OTHER-F/QSQGNDDL-T/QSQGNDDL-MSGMCH3601 QSQGNDDL API T
   SI42930      OSP-DB SPECIFY PROGRAM NAME ON CREATE TRIGGER
   SI41684      OSP-OSP-DB-OTHER-T/QSQRUN4X/37681-MSGSQL0204 GENERATE SQL->G
   SI41449      OSP STORED PROCEDURE CREATED WITH EXTERNAL NAME "LIB.NAME"/S
   SI41320      OSP-DB-OTHER-INCORROUT QSQGNDDL API BUILDS CREATE INDEX WITH
   SI40706      OSP-DB-INCORROUT Query text generated for a CREATE VIEW SQL
   SI39618      OSP-DB Generate DDL does not generate CLOSQLCSR for routines
   SI39235      OSP-DB-INCORROUT GENERATE SQL SCRIPT TO CREATE VARIABLE GIVE
   SI38405      OSP-THREADS-MSGSQL0199 GENERATE SQL SCRIPT TO CREATE VIEW FA
   SI38380      OSP-OSP-DB-OTHER-INCORROUT TABLE GETS CREATED WITH INCORRECT
   SI38077      OSP-DB Internal Maintenance
   SI38000      OSP-DB Internal Maintenance
   SI37810      OSP-DB Internal Maintenance
   SI37744      OSP-DB Incremental Enhancement
   SI37638      OSP-DB Internal Maintenance
   SI37197      OSP-DB-OTHER-UNPRED NORMALIZED MISSING ON QSQGNDDL API OUTPU
   SI36959      OSP-DB XML PROCESSING
   SI36944      OSP-DB 5733-OMF Support for QSQGNDDL api
   SI36686      OSP-DB XML PROCESSING
   SI36590      OSP-DB XML processing of SQLXSR objects

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE69202
View details for APAR SE68620
View details for APAR SE69082
Superseded by:......................
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................NONE


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 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.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"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":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
25 July 2018