Click on an APAR number to display the full information for that APAR. There may be a few days delay after the APAR closes before it is available on this website.
Click on a PTF number to download that PTF. You will need an IBMID. Latest update: 6 July 2023
Query Management Facility for z/OS V9.1
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PM94433
31_Oct
2013
UI12054


EXPECTED EXCLAMATION POINT ! INCORRECT IN QMF GENERATED EXPORT DATA TO DATASET WITH DATAFORMAT=XML
PM86862
7_May
2013
UK94111


CALLING A NATIVE SQL PROCEDURE GETS SQLCODE518
PM66233
26_Jun
2012
UK79828


QUERYING A SAP UNICODE TABLE WITH DBCLOB DATA TYPE USING DB2 QMFV9.1 FOR TSO GETS SQLCODE189
PM52085
6_Feb
2012
UK75967


SQL QUERY RUN FROM QMF GENERATES INCORRECT OUTPUT IF AN OUTER JOIN IS SPECIFIED
PM51082
4_Nov
2011
UK73585


AFTER MIGRATE DB2 DSQ1BVW GENERATES SQLCODE -104
PM51070
3_Nov
2011
UK73527


DSQ23700 TRYING TO CALL ANY STORED PROCEDURE FROM QMF AFTER MIGRATING TO DB2 V10 NFM 11/10/28 PTF
PECHANGE
PM48846
11_Oct
2011
UK72806


DSQ22982 "RECORD LENGTH OF 85 SHOULD BE 97" MSG AFTER QMF EXPORT DATA COMMAND IN IXF FORMAT.
PM49113
7_Oct
2011
UK72729


QMF FOR TSO USING DEFAULT FORM CAN REPORT SOME BIGINT NUMBERS AS ASTERISKS.
PM38018
27_Jun
2011
UK69196
PM51070

CALLING STORED PROCEDURES GENERATES MSG DSQ17811 SQLCODE -811
PM33134
2_Mar
2011
UK65398


QMF FOR TSO/CICS MISSING OBJECT NAME ON OBJECT PANEL 11/02/28 PTF
PECHANGE
PM32101
17_Feb
2011
UK64933


DSQ1BPKG QMF V10 MIGRATION JOB RECEIVING -4700 SQL CODE ATTEMPTING TO BIND USING V10 NFM FEATURES WHEN DB2 IS V10 CM
PM30206
25_Jan
2011
UK64210


PROC GENERATES SQLCODE -518 ISSUING A QUERY
PM30419
13_Jan
2011
UK63925


QMF QUERY MESSAGE TRUNCATED
PM23538
10_Nov
2010
UK62062


MSGDSQ90580 RUNNING UNDER CICS/TS 3.1 WITH QMFE
PM25764
8_Nov
2010
UK61991


REMOVE THE MESSAGE HIGHEST QMF LEVEL DETECTED AT SERVER
PM22855
23_Sep
2010
UK60711


QMF DOES NOT CONFIRM MERGE STATEMENT
PM21943
15_Sep
2010
UK60503


QMF V910 ABEND0C4 RC11 IN DSQISDT8 AT X'CCC'
PM18660
26_Jul
2010
UK59148


DSQ1BLNM RC00 AFTER PRIOR ABEND
PM16123
7_Jul
2010
UK58632


DSQ17798 EDIT TABLE FOR TABLE WITH GENERATED ALWAYS COLUMN
PM08963
7_Jun
2010
UK57716


MSG DSQ14107I ISSUED WHEN PRINTING A BLOB
PK95891
28_Oct
2009
UK51489


UNABLE TO CALL FULLY QUALIFIED USER DEFINED FUNCTIONS FROM QMF PROMPTED QUERY UTILITY.
PK98476
21_Oct
2009
UK51273


PROBLEM WITH REFORMATTING DATE OR TIME COLUMN DATA. 09/10/21 PTF
PECHANGE
PK96402
17_Sep
2009
UK50223


CICS CATALOG ENQUEUE
PK95351
16_Sep
2009
UK50163


IMPORT OF AN IXF FORMATED DB2 TABLE GETS THE MESSAGE: WIDTH OF IMPORTED DATA COLUMN 12 IS NOT IN THE ALLOWED RANGE.
PK94771
26_Aug
2009
UK49606


DYNALLOC ERROR ON IMPORT
PK93516
25_Aug
2009
UK49575


UPDATE QMF TO HANDLE 2 DIGIT DATABASE VERSION IDENTIFIERS
PK94263
25_Aug
2009
UK49579


BLANK LINE APPEARS ABOVE COMMAND LINE
PK94049
21_Aug
2009
UK49475


DSQ40393 GDDM ERROR
PK92201
4_Aug
2009
UK49013


ABENDASRA DOING AN EXPORT FUNCTION FROM QMF UNDER CICS.
PK92062
28_Jul
2009
UK48781


ABEND0C4 IN DSQISDT8 AT DISPLACEMENT X'AAC'
PK88266
6_Jul
2009
UK48115


UPDATE LAST_USED COLUMN ONLY WHEN QMF RUN, SAVE, OR IMPORT COMMAND IS ISSUED.
PK86139
13_May
2009
UK46563


SQLCODE246 IS RECIEVED FROM DB2 WHILE QMF IS DOING MULTI-ROW INSERT (MRI) STMT.
PK83145
13_May
2009
UK46560
PK98476

QMF WILL NOT REFORMAT DATE OR TIME COLUMN DATA RETURNED THROUGH A STORED PROCEDURE RESULT SET.
PK79681
27_Feb
2009
UK44460


MESSAGE DSQ10344 SHOWS WHEN DB2Z CODE PAGE IS 939(DBCS), WHICH MISMATCHES GDDM CCSID SET TO 1027 (SBCS).
PK79068
26_Jan
2009
UK43472


QMF V81 PROCEDURE NOT HALTED WHEN ERROR IS ENCOUNTERED QMF V81/V91 ERROR MESSAGE NOT DISPLAYED AFTER EXPORT ABEND
PK78674
19_Jan
2009
UK43314


MIGRATING FROM QMF 8.1 TO 9.1, SOME TABLES WITH BLOB COLUMN FAIL TO BE ACCESSED
PK73858
11_Nov
2008
UK41512


ABENDS0C4 IN DSQCISDT IF QMF APF AUTHORIZED OR IN LINKLIST
PK72929
15_Oct
2008
UK40754


RUNNING QMF INSTALL JOB DSQ1BINX RECEIVE SQLCODE -679 DROP PENDING ON Q.OBJECT_DIRECTORYX.
PK72928
29_Sep
2008
UK40303
PK73858

QMF R910 PTF UK40063 IN ERROR BECAUSE IT DOES NOT PRE-REQ UK38359. BOTH PTFS HIT DSQPNLE.
PK66525
22_Sep
2008
UK40063
PK72928

QMF WRITE ERROR TO DSQSPILL FILE:MESSAGE DSQ20855 OR MESSAGE DSQ60211 IF MULTIVOLUME SPILL DATA SET USED08/09/05 PTF
PECHANGE
PK70634
8_Sep
2008
UK39637


QMF TABLE EDITOR CAUSES TRAILING BINARY ZEROES (X'00') IN CHAR DATA FIELDS TO BE CHANGED TO BLANKS (X'40').
PK68353
21_Aug
2008
UK39147
PK75847

QMF EXPORT USES 30 BYTE COLUMN NAME FIELDS EVEN IF THE TABLE OR DATA BEING EXPORTED HAS NO NAMES GREATER THAN 18 BYTES LONG.
PK70030
14_Aug
2008
UK38962


ABEND0C4 WHEN ISSUING SHOW GLOBALS COMMAND IN QMF V810 AND V910
PK67718
22_Jul
2008
UK38359


QMF NEEDS A NEW MESSAGE TO ISSUE TO REPORT DB2 SQLCODE -423 WHEN SELECTING LOBS FROM A 3 PART NAME TABLE.
PK68217
8_Jul
2008
UK37934


IMPROVEMENTS TO THE ENHANCED LIST VIEW ACTIVATION PROCESS.
PK65110
12_May
2008
UK36421


DSQ10492 AND DSQ10497 WITH MR = YES
PK62738
1_May
2008
UK36122


H, T, AND C RECORDS IN IXF EXPORTED TABLE OR DATA INCREASED TO LRECL 93 IN QMF V810 OR V910.
PK63421
25_Apr
2008
UK35895


QMF ABEND0C4 IN DSQIFSQ7 R910 AT PK32589 WHEN MVS DIAGNOSTIC PROGRAM IGVDGNPP IS ALSO RUNNING.
PK63502
9_Apr
2008
UK35423


QMF ABEND0C4 IN DSQDUPNM AT OR NEAR OFFSET X'7D6', DEPENDING ON RELEASE AND MAINTENANCE LEVELS.
PK63939
7_Apr
2008
UK35326


MSGDSQ10498 SQLCODEN514 WHEN (ROWLIMIT=N USED WITH RUN QUERY E.G. RUN <QUERYNAME> (R=N
PK61897
1_Apr
2008
UK35139


QMF810 AND QMF910 RECEIVE MESSAGE IKT00405I WHEN DSQSPILL FILE IS USED.
PK62696
19_Mar
2008
UK34775


QMF MSGDSQ10498 WITH SQLCODE -330 SQLCODE330N SQLSTATE 22021 & "SQLERRM16: FORM EXECEPTION(FOR EXAMPLE, INVALID MIXED
DATA)."
PK62391
11_Mar
2008
UK34496


MSGDSQ10341 "THE DATABASE PRODUCT ( ) IS NOT SUPPORTED BY QMF." WHEN RUNNING DB2 Z/OS V7 OR HIGHER
PK61535
28_Feb
2008
UK34139


MSGDSQ10498 WITH SQLCODE310 -310 SQLSTATE 22023 WHEN RUNNING QMFWITH MULTI-ROW FETCH (DSQSMRFI=YES).
PK61313
27_Feb
2008
UK34095
PK66525

MESSAGE NUMBER: DSQ60211 MESSAGE TEXT: FM - ERROR - RECALL SPILL BUFFER NOT AVAILABLE. *** CMD=SAVE
PK60609
15_Feb
2008
UK33771


SQLCODE551 RECEIVED ON GRANT EXECUTE OF PACKAGE Q.DSQESSDS WHEN RUNNING DSQ1BPKG.
PK59113
18_Jan
2008
UK33077


QMF V81 MESSAGE DSQ20712 WHEN ISSUING QBE DRAW COMMAND WITH SYNONYMS.
PK58185
18_Jan
2008
UK33072


STORED PROC WITH DECIMAL FIELDS MAY FAIL WITH DSQ10496 SQL CODE (SQL STATE): -310 ( 22023 ) WHEN CALLED BY QMF.
PK54846
16_Nov
2007
UK31343


MR FETCH ERROR HANDLING AND SERVICEABILITY
PK55048
29_Oct
2007
UK30750


QMF TSO/CICS V8 V9 KEYWORD CC=NO ON PRINT COMMAND IGNORED WHEN KEYWORD PRINTER SET TO BLANKS.
PK54838
18_Oct
2007
UK30414


QMF TSO/CICS V8 V9 DOES NOT DISPLAY INCORRECT COLUMN NAME AFTER RECEIVING SQLCODE-206 WHEN CONNECTED TO DB2 FOR LUW
PK51461
23_Aug
2007
UK28530


QMF MSGDSQ16805 AND SQLCODE -805 WHEN QMF FOR TSO TRIES TO CONNECT TO A NON-DB2 Z/OS SERVER.
PK46854
13_Jun
2007
UK26084


QMF DOES NOT ALWAYS DELETE DSQCBST FROM MEMORY WHEN INITIALIZATION ERRORS CAUSE QMF TO TERMINATE.
PK41161
23_Mar
2007
UK23321
PM33134

THIS APAR WAS CREATED TO INTRODUCE NEW FUNCTIONS TO QMF V9.1.
PK40809
9_Mar
2007
UK22889


QMF FOR TSO/CICS 810 AND 910 ENHANCEMENT FOR REPORTS GENERATED USING USER-SPECIFIED TEXT"
PK28905
9_Mar
2007
UK22891


THIS APAR WAS CREATED TO INTRODUCE NEW FUNCTIONS TO QMF V9.1.
PK39338
16_Feb
2007
UK22290


ABENDS0C4 ABEND0C4 OR OTHER ERRORS IN QMF AFTER APPLY OF PK34089 07/02/13 PTF
PECHANGE
PK38633
14_Feb
2007
UK22151


ABEND S0C7 AT X'3A1C' IN DSQIDOPT DUE TO -904 ON TABLESPACE XXXXX.DSNDBC.DSQDBCTL.DSQTSRDO.I0001.A001, TABLE
Q.DSQ_RESERVED
PK36226
5_Jan
2007
UK21051

HIPER

USING MULTI ROW FETCH (MR=YES) WITH QMF GIVES WRONG OUTPUT
PK34377
4_Jan
2007
UK21038


QMF ABEND0C4 IN DSQCCI CSECT DSQCDBUG WHEN FIXED COLUMNS ARE USED IN FORMS
PK34089
14_Nov
2006
UK19730
PK39338

QMF ABEND0C4 IN DSQFMCTL WHEN MULTIPLE FORMS USED IN A QMF PROCEDURE.
PK32589
3_Nov
2006
UK19380


QMF V81: IMPLEMENTING LOB SUPPORT IN LUW SERVERS
PK29868
18_Aug
2006
UK17317


QMF INSTALLATION - THREE PART NAME INSTALL

Top of page