IBM Support

SI46876 - OSP-DB-OTHER-SAP400-THREADS-MSGCPF5257 QUERY FAILS WITH CPF5

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-SAP400-THREADS-MSGCPF5257 QUERY FAILS WITH CPF5


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF53181   00/00    0000
PRE  5770999  710  MF53178   00/00    0000
CO   5770SS1  710  SI46476   00/00    0000
CO   5770SS1  710  SI46365   00/00    0000
CO   5770SS1  710  SI46284   00/00    0000
CO   5770SS1  710  SI46245   00/00    0000
CO   5770SS1  710  SI45962   00/00    0000
CO   5770SS1  710  SI45963   00/00    0000
CO   5770SS1  710  SI45333   00/00    0000
CO   5770SS1  710  SI45028   00/00    0000
CO   5770SS1  710  SI44825   00/00    0000
CO   5770SS1  710  SI43568   00/00    0000
CO   5770SS1  710  SI43569   00/00    0000
CO   5770SS1  710  SI42836   00/00    0000
CO   5770SS1  710  SI40611   00/00    0000
CO   5770SS1  710  SI40612   00/00    0000
CO   5770SS1  710  SI40757   00/00    0000
CO   5770SS1  710  SI39897   00/00    0000
CO   5770SS1  710  SI39903   00/00    0000
CO   5770SS1  710  SI39905   00/00    0000
CO   5770SS1  710  SI39069   00/00    0000
DIST 5770SS1  710  SI44237   00/00    0000
DIST 5770SS1  710  SI44239   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

-----------------------------------------------
ROBOT job was generating this message. Was not able to retrieve
the query that caused this.

Message ID . . . . . . : CPF5257 Severity . . . . . . . : 70
Date sent . . . . . . : 04/30/12 Time sent . . : 08:41:36
Message type . . . . . : Escape
From . . . . . . . . . : RBTNETPT CCSID . . . . . . . . : 65535

From program . . . . . . . . . : QDBIOERRQO
From library . . . . . . . . : QSYS
From module . . . . . . . . : QDBIOERRQO
From procedure . . . . . . . : SEND_MESSAGE
From statement . . . . . . . : 3619

To program . . . . . . . . . . : QSQRUN2
To library . . . . . . . . . : QSYS
To module . . . . . . . . . : QSQFETCH
To procedure . . . . . . . . : SQKY_POSNM
To statement . . . . . . . . : 16959

CORRECTION FOR APAR SE52044 :
-----------------------------
The handling of a FETCH ABSOLUTE on an empty result set has
been corrected.

CIRCUMVENTION FOR APAR SE52044 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI46720      OSP-DB-QSQPREP-MSGSQL0904 when preparing 3 part naming statm
   SI46710      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQ30020 CONNECT TO FAI
   SI46614      OSP-DB-MSGSQL7001 select using 3 part alias
   SI46475      OSP-DB internal maintenance
   SI46458      OSP-UNPRED STORED PROCEDURE RETURNS THE WRONG RESULT SET
   SI46445      OSP-INCORROUT GET DESCRIPTOR SHOWS UNDOCUMENTED VALUES FOR K
   SI46368      F/QSQXCUTE-MSGSQL0104-RIDS/CLEANUP SETTING AN SQL VARIABLE T
   SI46359      INCORROUT Variable length field not padded after FETCH when
   SI46355      OSP-DB-Other Internal Maintenance
   SI46320      OSP-DB INTERNAL MAINTENANCE
   SI46294      OSP-DB-OTHER-INCORROUT WRONG NUMBER OF COLUMNS RETURNED ON A
   SI46294      OSP-DB-OTHER-F/QSQCONN-MSGSQL0113 HOST VARIABLE PADDED WITH
   SI46285      OSP-OTHER-MSGSQL0519 AFTER CANCEL
   SI46246      OSP-DB INTERNAL MAINTENANCE
   SI46066      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0331 CPYTOIMPF GET MS
   SI45964      OSP-DB Support Insert with Remote Subselect
   SI45825      OSP-DB-QSQCMPDS-MSGMCH1210
   SI45825      OSP-DB-QRWXFDOCA-MSGMCH0601 occurs on SELECT * FROM alias ta
   SI45813      SP/QRWTBAS-MSGSQL0144-RC5-MOD/QRWTQRY-PRCS/5 NESTED SP WITH
   SI45760      OSP-DB-OTHER-MSGSQL0303 MSGSQL0303 MAY OCCUR WITH A USER DEF
   SI45625      OSP-DB-MSGSQL0501 with 3 part name to DB2 for Z
   SI45598      OSP-F/QSQROUTX-T/QSQROUTX-MSGSQ30000 MSGSQ30000 F/QSQROUTX T
   SI45490      OSP-DB-OTHER-PERFM Convert CCSID short to long form using ex
   SI45334      OSP-DB-OTHER-PERFM ENHANCEMENTS MADE TO RECOGNIZE STATEMENTS
   SI45187      OSP-DB-MSG MCH3601 QSQCALLSP calling procedure
   SI45073      OSP-DB-MSGSQL0843 ISQL DISCONNECT FAILURE USING OPTICONNECT/
   SI45029      OSP-DB-MSGSQL0084 repeated connect fails
   SI45016      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGSQL0305 CHARACTER CONV
   SI44990      OSP-DB DBCLOB to CLOB assignment fails
   SI44946      OSP-DB sql with alias using 3 part name fails
   SI44905      OSP-F/QSQROUTS-T/QSQROUTS-MSGMCH3601 MSGMCH3601 F/QSQROUTS F
   SI44863      OSP-DB-OTHER CODE UPDATES TO VERIFY USE OF EXPRESSION EVALUA
   SI44823      OSP-DB ADD Application information to SQL0901 logger
   SI44822      OSP-DB set connection statement fails from odbc
   SI44785      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0313 SQL0313 CALLING
   SI44785      OSP-DB-OTHER-F/QRWTBAS-T/QRWTBAS-MSGMCH3601 SOME STORED PROC
   SI44745      OSP-DB-OTHER-F/#CCEXCEP-T/QSQSBAS-MSGMCH5003 A MSGMCH5003 MA
   SI44743      OSP-DB table incorrectly searched on local sytem insted of r
   SI44467      OSP-DB-OTHER-T/QSQDSCPTX/6103-MSGSQL0904 FETCH NEXT FROM C1
   SI44415      OSP-DB internal maintenance
   SI44357      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGMSGSQL0204 DRDA CONNECTI
   SI44347      OSP-DB-OTHER-UNPRED SQLERRD5 NOT SET TO  100 WHEN FETCHING O
   SI44304      OSP-DB-INCORROUT SQL DETAILS FOR JOB DOES NOT REFRESH
   SI44304      OSP-DB-INCORROUT SQL DETAILS FOR JOB DOES NOT REFRESH
   SI44238      OSP-DB-OTHER-MSGCPF32A5 A MSGCPF32A5 CCSID 13488 FOR FIELD *
   SI44229      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGMCH3601 AFTER THE 2ND
   SI44124      OSP-DB-OTHER-UNPRED SQLERRD5 NOT SET TO  100 WHEN FETCHING O
   SI44086      OSP-DB-MSGMCH0601-T/QSQSBAS MODULE QSQCLSCR PROCEDURE SQCLOS
   SI44066      OSP-DB Allow GET DIAGNOSTICS MESSAGE_TEXT from external UDF/
   SI44008      OSP-DB OPEN/FETCH QUERY DATA PARTIAL ROW FIXES
   SI43801      OSP-DB-OTHER VARIOUS FIXES FOR SELECT FROM INSERT
   SI43734      OSP-F/QSQROUTX-T/QSQROUTX-MSGMCH3601 MSGMCH3601 F/QSQROUTX T
   SI43566      OSP-DB ADDITIONAL TCPIP FILTERING ENHANCEMENTS
   SI43318      OSP-DB-OTHER-INCORROUT SELECTING FIELD INTO VARCHAR WITH MIX
   SI43162      OSP-DB-MSGMCH5003 during SQL SET integer from character valu
   SI43129      OSP-DB-MSGSQL0204 when using an alias for 3 part name
   SI42999      OSP-DB-INCORROUT Array Support
   SI42981      OSP-DB Connect By support
   SI42854      OSP-DB-UNPRED Internal DRDA Maintenance
   SI42839      OSP-DB-QSQCMPDS High CPU during long running job
   SI42813      OSP-DB-OTHER-PERFM LOTS OF CPU TIME SPENT IN QSQCMPDS
   SI42724      OSP-DB-OTHER-INCORROUT SQL PACKAGE USAGE DATE NOT UPDATING.
   SI42720      OSP-DB SQL cancel improvements
   SI42679      OSP-DB-QSQROUTQ performance improvement
   SI42671      OSP-DB-MSGMCH3603 F/QSQSBAS QSQTHDTM
   SI42630      OSP-DB-MSGSQL0822 Using QSQPRCED API to run MERGE statement
   SI42508      OSP-DB-MSGMCH0601 F/QSQROUTQ PREPARE OF STATEMENT CONTAINING
   SI42280      OSP-DB-OTHER-F/QSQROUTS-MSGMCH3601 MODULE QSQSRVRC
   SI42275      OSP-DB-OTHER-F/QSQSBAS2-T/QSQSBAS2-MSGMCH3402 MCH3402 PRODUC
   SI42201      OSP-DB-OTHER-F/QSQSBAS-MSGMCH3601 WHEN RUNNING A STATEMENT W
   SI42174      OSP-DB-OTHER-F/QDBIOERRQO-T/QSQRUN2-MSGCPD5036 A MSGCPD5036
   SI42142      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0501 SQL0501 OCCURS
   SI42074      OSP-DB-OTHER-INCORROUT INVALID NULL INDICATORS RETURNED TO D
   SI41922      OSP-DB support atomicity in block merge
   SI41872      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGMCH3601 STORED PROCEDU
   SI41568      OSP-DB-MSGMCH3601-T/QSQROUTX
   SI41480      OSP-DB-UNPRED Retry of table to alias modification failing
   SI41467      OSP-DB-UNPRED Support QIBM_SQL_PASSIVE_UNQUALIFIED_RDB
   SI41441      OSP-MSGMCH3601-PAR-940XBASE SOME QUERIES ARE GENERATING MCH3
   SI41441      OSP-DB-OTHER-PERFM THE USE OF SQL UDF CALLS IS CAUSING HIGH
   SI41441      OSP-DB SQ EXIT PROGRAM FAILED AND ENDED QDBXRVXR2.
   SI41441      OSP-DB-OTHER-INCORROUT CPYTOIMPF RETURNS INCORRECT DATA ON B
   SI41441      OSP-DB SQL DELETE LOOPS WITH MSGSQL0918
   SI41295      OSP-DB-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
   SI41273      OSP-DB-MSGMCH3601-T/QSQROUTX intermittent problem
   SI41231      OSP-DB-UNPRED Reprepare of DRDA cursors when open attributes
   SI41061      OSP-DB-UNPRED Retry of three-part table to alias change fail
   SI41051      OSP-DB-F/QSQROUTQ-MSGMCH1210 CALL with expressions and XML g
   SI41043      OSP-DB-UNPRED Statistics causing three-part naming to corrup
   SI40977      OSP-DB-UNPRED Authorization failure retrieving stored proced
   SI40974      OSP-DB-OTHER-F/QDMCLOSE-MSGMCH6216
   SI40961      OSP-DB-INCORROUT Expressions in CALL Support
   SI40941      OSP-DB-MSGSQL0303 F/QSQRUN2/QSQFETCH RETURNING NULL XML IN R
   SI40941      OSP-DB-MSGSQL0901 F/QSQRUN2/QSQVALUE RC=1205 LOCK ESCALATION
   SI40930      OSP-DB-UNPRED Generated three-part naming queries failing
   SI40916      OSP-DB-UNPRED Implicit package creation failing for SQL proc
   SI40881      OSP-DB-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
   SI40791      OSP-DB simple insert fails in a long running job
   SI40737      OSP-DB-MSGCPF5153-T/QSQFETCH on complex merge
   SI40685      OSP-DB-INCORROUT Array Support Performance
   SI40675      OSP-DB-INCORROUT Expressions In CALL Support
   SI40610      OSP-DB-UNPRED Three part alias statement rewrite
   SI40602      OSP-DB Incorrect failure info for insert
   SI40531      OSP-DB-UNPRED Three part alias retry corrections
   SI40414      OSP-DB-OTHER-F/STRINGHIGHUSE-T/QSQRUN2-MSGMCH3601 SELECT STA
   SI40414      OSP-DB QM QUERY FAILS WITH MCH1210
   SI40384      OSP-DB-INCORROUT Array Support
   SI40342      OSP-DB-MSGSQ99999-T/QSQCLI procedure SQLGDF
   SI40304      OSP-DB-UNPRED SQL statements not picking up table to alias c
   SI40280      OSP-DB QSQSRVR jobs not running in QSYSWRK
   SI40260      OSP-DB-UNPRED DRDA errored connections not going to unconnec
   SI40236      OSP-DB-OTHER-INCORROUT SQL0803 ERROR RETURNS WRONG # OF ROWS
   SI40192      OSP-DB-OTHER-INCORROUT DRDA QUERY OUTPUT INCORRECT
   SI40173      OSP-DB-MSGSQL0501 on result set cursor
   SI40152      OSP-DB-OTHER Expressions in CALL Support
   SI40086      OSP-THREADS-F/QSQROUTS-T/QSQROUTS-RC423-MSGSQL0904 SQL0904 F
   SI40041      OSP-DB-OTHER-UNPRED  WRONG CURSOR SELECTED ON EXECUTE IMMEDI
   SI40000      OSP-DB various errros when using hetero client
   SI39993      OSP-DB MCH1210 F/QQQSRVE1 MODULE QQQOOOSETS PROCEDURE SETUP_
   SI39991      OSP-DB-OTHER-UNPRED 1000 3000 Storage Managment VLOGs
   SI39969      OSP-DB-QSQSTATS-MSGMCH3601
   SI39898      OSP-DB-QSQASLOC-MSGSQL0204 when using specific name on ASSOC
   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 SE52044
Superseded by:......................View fix details for PTF SI68439
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C2279710


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.

[{"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:
21 May 2012