Query Management Facility for z/OS V8.1

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

APAR	CLOSE DATE	PTF(s)	Fixing APAR if PE	HIPER?	Abstract
Query Management Facility for z/OS V8.1
PM51082	4_Nov 2011	UK73584			AFTER MIGRATE DB2 DSQ1BVW GENERATES SQLCODE -104
PM48846	11_Oct 2011	UK72805			DSQ22982 "RECORD LENGTH OF 85 SHOULD BE 97" MSG AFTER QMF EXPORT DATA COMMAND IN IXF FORMAT.
PM25764	8_Nov 2010	UK61990			REMOVE THE MESSAGE HIGHEST QMF LEVEL DETECTED AT SERVER
PM19236	10_Aug 2010	UK59582			UPDATE QMF TO RECOGNIZE 2 DIGIT DATABASE VERSION IDENTIFIERS
PM18660	26_Jul 2010	UK59147			DSQ1BLNM RC00 AFTER PRIOR ABEND
PM08963	7_Jun 2010	UK57715			MSG DSQ14107I ISSUED WHEN PRINTING A BLOB
PM10295	23_Mar 2010	UK55491			DSQ10497 SQLCODE= 445 ISSUED INCORRECTLY FOR SQLCODE= -803
PM04397	14_Jan 2010	UK53555			USING THE EXPORT DATA COMMAND WITH DATAFORMAT=IXF EXPORT DATA TABLE NAME INCORRECT
PM00232	24_Nov 2009	UK52255			BLOB WASN'T DISPLAYED IF A COLUMN CONTAIN BLANK BEFORE CLOB
PK95891	28_Oct 2009	UK51488			UNABLE TO CALL FULLY QUALIFIED USER DEFINED FUNCTIONS FROM QMF PROMPTED QUERY UTILITY.
PK98476	21_Oct 2009	UK51272			PROBLEM WITH REFORMATTING DATE OR TIME COLUMN DATA. 09/10/21 PTF PECHANGE
PK96402	17_Sep 2009	UK50222			CICS CATALOG ENQUEUE
PK95351	16_Sep 2009	UK50162			IMPORT OF AN IXF FORMATED DB2 TABLE GETS THE MESSAGE: WIDTH OF IMPORTED DATA COLUMN 12 IS NOT IN THE ALLOWED RANGE.
PK94049	21_Aug 2009	UK49474			DSQ40393 GDDM ERROR
PK92062	28_Jul 2009	UK48780			ABEND0C4 IN DSQISDT8 AT DISPLACEMENT X'AAC'
PK88266	6_Jul 2009	UK48114			UPDATE LAST_USED COLUMN ONLY WHEN QMF RUN, SAVE, OR IMPORT COMMAND IS ISSUED.
PK86139	13_May 2009	UK46562			SQLCODE246 IS RECIEVED FROM DB2 WHILE QMF IS DOING MULTI-ROW INSERT (MRI) STMT.
PK83145	13_May 2009	UK46559	PK98476		QMF WILL NOT REFORMAT DATE OR TIME COLUMN DATA RETURNED THROUGH A STORED PROCEDURE RESULT SET.
PK79681	27_Feb 2009	UK44459			MESSAGE DSQ10344 SHOWS WHEN DB2Z CODE PAGE IS 939(DBCS), WHICH MISMATCHES GDDM CCSID SET TO 1027 (SBCS).
PK79068	26_Jan 2009	UK43471			QMF V81 PROCEDURE NOT HALTED WHEN ERROR IS ENCOUNTERED QMF V81/V91 ERROR MESSAGE NOT DISPLAYED AFTER EXPORT ABEND
PK78674	19_Jan 2009	UK43296			MIGRATING FROM QMF 8.1 TO 9.1, SOME TABLES WITH BLOB COLUMN FAIL TO BE ACCESSED
PK75847	18_Nov 2008	UK41682			QMF810 COMMAND INTERFACE GLOBAL VARIABLES CONTAIN INCORRECT VALUES. 08/11/18 PTF PECHANGE
PK75923	18_Nov 2008	UK41689			SQLCODE -104
PK73858	11_Nov 2008	UK41511			ABENDS0C4 IN DSQCISDT IF QMF APF AUTHORIZED OR IN LINKLIST
PK72929	15_Oct 2008	UK40753			RUNNING QMF INSTALL JOB DSQ1BINX RECEIVE SQLCODE -679 DROP PENDING ON Q.OBJECT_DIRECTORYX.
PK66525	22_Sep 2008	UK40062	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	UK39636			QMF TABLE EDITOR CAUSES TRAILING BINARY ZEROES (X'00') IN CHAR DATA FIELDS TO BE CHANGED TO BLANKS (X'40').
PK68353	21_Aug 2008	UK39146	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	UK38961			ABEND0C4 WHEN ISSUING SHOW GLOBALS COMMAND IN QMF V810 AND V910
PK67718	22_Jul 2008	UK38360			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	UK37933			IMPROVEMENTS TO THE ENHANCED LIST VIEW ACTIVATION PROCESS.
PK65110	12_May 2008	UK36420			DSQ10492 AND DSQ10497 WITH MR = YES
PK62738	1_May 2008	UK36121			H, T, AND C RECORDS IN IXF EXPORTED TABLE OR DATA INCREASED TO LRECL 93 IN QMF V810 OR V910.
PK63421	25_Apr 2008	UK35894			QMF ABEND0C4 IN DSQIFSQ7 R910 AT PK32589 WHEN MVS DIAGNOSTIC PROGRAM IGVDGNPP IS ALSO RUNNING.
PK63502	9_Apr 2008	UK35422			QMF ABEND0C4 IN DSQDUPNM AT OR NEAR OFFSET X'7D6', DEPENDING ON RELEASE AND MAINTENANCE LEVELS.
PK63939	7_Apr 2008	UK35325			MSGDSQ10498 SQLCODEN514 WHEN (ROWLIMIT=N USED WITH RUN QUERY E.G. RUN <QUERYNAME> (R=N
PK61897	1_Apr 2008	UK35138			QMF810 AND QMF910 RECEIVE MESSAGE IKT00405I WHEN DSQSPILL FILE IS USED.
PK62696	19_Mar 2008	UK34774			QMF MSGDSQ10498 WITH SQLCODE -330 SQLCODE330N SQLSTATE 22021 & "SQLERRM16: FORM EXECEPTION(FOR EXAMPLE, INVALID MIXED DATA)."
PK62259	12_Mar 2008	UK34493			STORED PROC WITH DECIMAL FIELDS MAY FAIL WITH DSQ10496 SQL CODE (SQL STATE): -310 ( 22023 ) WHEN CALLED BY QMF.
PK62391	11_Mar 2008	UK34450			MSGDSQ10341 "THE DATABASE PRODUCT ( ) IS NOT SUPPORTED BY QMF." WHEN RUNNING DB2 Z/OS V7 OR HIGHER
PK61535	28_Feb 2008	UK34138			MSGDSQ10498 WITH SQLCODE310 -310 SQLSTATE 22023 WHEN RUNNING QMFWITH MULTI-ROW FETCH (DSQSMRFI=YES).
PK61313	27_Feb 2008	UK34094	PK66525		MESSAGE NUMBER: DSQ60211 MESSAGE TEXT: FM - ERROR - RECALL SPILL BUFFER NOT AVAILABLE. *** CMD=SAVE
PK60609	15_Feb 2008	UK33770			SQLCODE551 RECEIVED ON GRANT EXECUTE OF PACKAGE Q.DSQESSDS WHEN RUNNING DSQ1BPKG.
PK59113	18_Jan 2008	UK33076			QMF V81 MESSAGE DSQ20712 WHEN ISSUING QBE DRAW COMMAND WITH SYNONYMS.
PK54846	16_Nov 2007	UK31342			MR FETCH ERROR HANDLING AND SERVICEABILITY
PK55048	29_Oct 2007	UK30749			QMF TSO/CICS V8 V9 KEYWORD CC=NO ON PRINT COMMAND IGNORED WHEN KEYWORD PRINTER SET TO BLANKS.
PK54838	18_Oct 2007	UK30417			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	UK28528			QMF MSGDSQ16805 AND SQLCODE -805 WHEN QMF FOR TSO TRIES TO CONNECT TO A NON-DB2 Z/OS SERVER.
PK46854	13_Jun 2007	UK26083			QMF DOES NOT ALWAYS DELETE DSQCBST FROM MEMORY WHEN INITIALIZATION ERRORS CAUSE QMF TO TERMINATE.
PK40809	9_Mar 2007	UK22888			QMF FOR TSO/CICS 810 AND 910 ENHANCEMENT FOR REPORTS GENERATED USING USER-SPECIFIED TEXT"
PK39338	16_Feb 2007	UK22289			ABENDS0C4 ABEND0C4 OR OTHER ERRORS IN QMF AFTER APPLY OF PK34089 07/02/13 PTF PECHANGE
PK38633	14_Feb 2007	UK22150			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	UK21050		HIPER	USING MULTI ROW FETCH (MR=YES) WITH QMF GIVES WRONG OUTPUT
PK34377	4_Jan 2007	UK21037			QMF ABEND0C4 IN DSQCCI CSECT DSQCDBUG WHEN FIXED COLUMNS ARE USED IN FORMS
PK34089	14_Nov 2006	UK19729	PK39338		QMF ABEND0C4 IN DSQFMCTL WHEN MULTIPLE FORMS USED IN A QMF PROCEDURE.
PK32589	3_Nov 2006	UK19379			QMF V81: IMPLEMENTING LOB SUPPORT IN LUW SERVERS
PK29168	5_Oct 2006	UK18567			QMF V8, SUBSTITUTION VARIABLES DISAPPEAR OR CAUSE ABEND0C4 WHEN EXPORT OR IMPORT OF QUERIES FROM PROC. 06/09/25 PTF PECHANGE
PK29868	18_Aug 2006	UK17316			QMF INSTALLATION - THREE PART NAME INSTALL
PK29164	14_Aug 2006	UK17194			QMF V81 "CONNECT TO" COMMAND LOOPS ON CONNECT COMMAND PROMPT SCREEN WHEN INVALID SERVER NAME IS ENTERED.
PK29326	9_Aug 2006	UK17090			QMF INSTALLATION PROGRAM DSQ1BLNI DOESN'T WORK PROPERLY WITH DB2V9.
PK28288	27_Jul 2006	UK16653			QMF V81 ABENDS0C1 IN DSQCCI WHEN FAULT ANALYZER IS ALSO RUNNING.
PK28666	27_Jul 2006	UK16670			QMF V81 DRAW OUTPUT IS GREATER THAN 72 CHARACTERS PER LINE
PK26870	30_Jun 2006	UK15961	PK29168		QMF V81 ABENDS0C4 IN DSQDIMPI
PK24451	5_Jun 2006	UK15152			MSGDSQ84565 is issued when adding GRAPHIC data using the QMF Table Editor.
PK22659	11_Apr 2006	UK13462			ABENDS0C4 IN DSQCMSGH DURING QMF V81 INITIALIZATION OR TERMINATION.
PK21706	27_Mar 2006	UK13048			ABENDS0C4 IN DSQEMDSP WHEN PRINTING IN QMF V8.1
PK20355	7_Mar 2006	UK12018			AE PK19989 FIX COMPLETION
PK19989	22_Feb 2006	UK12018			QMF QBE SAVE QUERY DOES NOT ACCEPT NAMES CONTAINING MORE THAN 9 CHARACTERS.
PK19254	21_Feb 2006	UK12001			POOR PERFORMANCE IN QMF V8 WHEN IN TABLE EDITOR
PK16393	3_Feb 2006	UK11471			SQLCODE-518 IN QMF TABLE EDITOR AFTER SQLCODE-438.
PK17275	3_Jan 2006	UK10508			QMF COLUMN NAMES NOT RENAMED TO COL1, COL2 WHEN THEY EXCEED MAX LENGTH ALLOWED FOR CURRENT DATABASE CONNECTION.
PK15754	1_Dec 2005	UK09714			MESSAGE DSQ17438 MISSING SQLSTATE INFORMATION. FORWARD FIT OF PK14857 TO QMF V8.1.
PK13160	24_Oct 2005	UK08383			QUERY DISPLAYED BY DRAW FUNCTION IS INCONSISTENT WITH SAMPLES IN ONLINE HELP.
PK13894	24_Oct 2005	UK08384			SQLCODE -104 FOR QUERIES WHEN QMF FOR TSO AND CICS CONNECTED TO DB2 ON DISTRIBUTED PLATFORMS
PQ98948	12_Oct 2005	UK08083			USERS WILL SEE AN SQLCODE -20210 ON JOB DSQ1BLNI IF RUNNING APPENSCH=UNICODE.
PK12642	5_Oct 2005	UK07889			APPLY OF UK06848 MAY CAUSE MSGIEW2456E FOR SYMBOL DSQIVMSC. 05/10/05 PTF PECHANGE
PQ99482	1_Sep 2005	UK06848	PK12642		MULTI-ROW FETCH AND INSERT FOR SQL QUERIES. THIS IS A NEW ENHANCEMENT FOR QMF V8 FOR Z/OS.
PK09295	25_Aug 2005	UK06649		HIPER	AFTER QMF/TSO V8 UPGRADE (COMPATIBILITY), EXPERIENCING A 20% INCREASE IN CPU TIMES
PK05000	4_May 2005	UK03115			EDIT TABLE DOES NOT DISPLAY CHAR(50) COLUMNS CORRECTLY.
PK04281	21_Apr 2005	UK02672			DSQ22982 ISSUED WHEN AN OBJECT IS EXPORTED FROM QMF V8 TO A DATA SET THAT WAS CREATED IN A PREVIOUS VERSION OF QMF
PK02822	31_Mar 2005	UK01978			AUTHORIZATION ID FIELD MISSING FIRST TWO CHARACTERS AFTER SET CURRENT SQLID = 'USER-ID'
PK00604	17_Feb 2005	UK00662			WHEN, SET CURRENT SQLID = USER IS ISSUED IN QMF V8, QMF PREFIXES THE USERID WITH ADDITIONAL UNVIEWABLE CHARACTERS
PQ94893	21_Jan 2005	UQ97046			ISSUE QMF WARNING MESSAGE IF GDDM CCSID IS NOT THE SAME AS DB2'SAND ENHANCEMENTS TO OTHER QMF ERROR MESSAGES AND WARNINGS
PQ96744	21_Jan 2005	UQ97062			NEW FUNCTION TO CHANGE HOW AND WHEN THE LAST_USED DATE FOR A QMFOBJECT IS UPDATED.
PQ96755	10_Nov 2004	UQ94928			DXYE0444 IS INCORRECTLY ISSUED FOR NUMERIC COLUMN WITH EDIT CODE 'M'
PQ96208	9_Nov 2004	UQ94808			DSQ10183 WHEN WORKING WITH DSQ1BUDV
PQ90145	16_Aug 2004	UQ91861			CHANGING QMF INSTALL PROCESS TO ACCOUNT FOR SQLID DIFFERENT THENID OF PERSON RUNNING INSTALL JOBS.
PQ89041	11_Jun 2004	UQ89752			SQLCODE -104 WHEN RUNNING A QUERY AND USING SET GLOBALS 09/06/10 PTF PECHANGE
PQ87623	24_May 2004	UQ88698			QMF ALLOWS ACCESS TO A REMOTE LOCATION EVEN IF NO PROFILE EXISTS
PQ86432	12_May 2004	UQ88693			MSGDSQ50425 issued when running an IMPORT against a table containing a column defined as CHAR(255).
PQ84169	20_Apr 2004	UQ87545			QMF EXPORT AND IMPORT COMMAND WILL NOW SUPPORT PDSE DATASETS
PQ83178	10_Feb 2004	UQ84982			SUPPORT NEW FUNCTIONS IN QMF V8.1
PQ81406	9_Dec 2003	UQ82977			QMF 8.1 NFM INSTALL ADD UNICODE OPTION
PQ78230	12_Sep 2003	UQ80137			SUPPORT NEW FUNCTIONS IN QMF V8.1
PQ76597	1_Aug 2003	UQ79145			SUPPORT NEW FUNCTIONS IN QMF V8.1
PQ74337	13_Jun 2003	UQ77741	PQ89041		NEW FUNCTIONS FOR QMF V8.1

Top of page