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: 8 May 2018
IBM DB2 Data Access Common Collector Version 1.1
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PI95320
27_Apr
2018
UI55553


SUPPORT FILTERING ON CLIENT IP ADDRESS AS PART OF SQL BLOCKING SUPPORT
PI93815
12_Apr
2018
UI55186


INTERNAL MODIFICATIONS TO SUPPORT STAP FILTERING.
PI95319
12_Apr
2018
UI55203


CORRECT EXCESSIVE CPU, INTERNAL ABENDS, AND OTHER UNPREDICTABLE BEHAVIOR
PI93812
5_Apr
2018
UI55012


COLLECTION OF DB2 UTILITY EVENT MAY RESULT IN HIGH CPU USAGE OR OTHER UNEXPECTED RESULTS.
PI92012
2_Apr
2018
UI54923


ABEND S04E-00E20017 CAN OCCUR IN DB2 AND UTILITY JOBS
PI93133
28_Mar
2018
UI54812


DB2 QUERY MONITOR ABEND0C4-04 IN CQC#REST
PI90857
6_Feb
2018
UI53689


INCORRECT RECORDS_AFFECTED VALUE COLLECTED FOR MULTI ROW DISTRIBUTED SELECT
PI88237
2_Feb
2018
UI53632


ADDITIONAL ZIIP UTILIZATION FOR DB2 STAP
PI88118
1_Feb
2018
UI53614


DB2 STAP PERFORMANCE IMPROVEMENTS FOR POLICIES WITH NEGATIVE SQLCODE COLLECTION
PI88119
29_Dec
2017
UI52953


SUPPORT FOR STAP FEATURES
PI90376
15_Dec
2017
UI52739

HIPER

FIX FOR POSSIBLE HIGH ZIIP CPU USAGE AND OTHER UNPREDICTABLE RESULTS
PI86201
12_Dec
2017
UI52616


QUERY MONITOR V3.3 NOT DISPLAYING SOME COMMANDS
PI89004
11_Dec
2017
UI52600


TRUNCATED UTILITY CONTROL STATEMENT TEXT FOR UTILITY EVENTS
PI90365
11_Dec
2017
UI52602


INSTALL DUMP DUE TO INCORRECT DE-INSTALL WHEN MONITORING A DB2 BY CQM/STP IN A SPECIFIC ORDER
PI87232
7_Nov
2017
UI51731


OBJECT ANALYSIS IN CQC
PI87225
6_Nov
2017
UI51702


IGNORE COLLECTION OF INTERNAL -805 CAUSED BY REMOTE DB2 RESOLVING PACKAGES.
PI87153
9_Oct
2017
UI50952


HCQC110 DB2 COMMON ACCESS COLLECTOR MONITORING AGENT DE-INSTALL FAILURE
PI87238
2_Oct
2017
UI50804


UNEXPECTED COLLECTION OF UPDATE FROM TRIGGER AND/OR DELETE FROM CURRENT OF CURSOR EVENTS
PI86763
21_Sep
2017
UI50504


INCORRECT RECORDS_AFFECTED VALUE COLLECTED FOR MULTI ROW DISTRIBUTED SELECT
PI84869
16_Aug
2017
UI49597


SUPPORT ADDITIONAL FILTERING ON USER FIELD FOR CICS CONNECTIONS
PI79482
24_Jul
2017
UI49039

HIPER

HCQC110 DB2 COMMON ACCESS COLLECTOR MONITORING AGENT DE-INSTALL FAILURE
PI81324
5_Jul
2017
UI48554


COMPATIBILITY WITH STAP
PI81257
15_Jun
2017
UI48073


DUMP TITLE=DB2 TOOLS SQL COLLECTOR ABEND=0C4-00000004,MODULE=UN
PI81726
15_Jun
2017
UI48074


INTERMITTENT MISSING UTILITY EVENTS
PI81730
12_Jun
2017
UI47958


SUPPORT FILTERING ON USER FIELD FOR CICS CONNECTIONS
PI80782
30_May
2017
UI47646


INTERNAL CODE CLEAN UP. CODE HAS BEEN ALTERED TO ADDRESS INTERNAL ABENDS FOUND IN THE INTERNAL DIAG TABLE.
PI75740
12_May
2017
UI47220


HCQC110 DB2 COMMON ACCESS COLLECTOR MONITORING AGENT DE-INSTALL FAILURE
PI78743
10_Apr
2017
UI46322


SUPPORT FOR FUTURE ENHANCEMENTS
PI74111
1_Mar
2017
UI45144


CLEANUP INTERNAL DIAGNOSTIC ENTRY DURING HOST VARIABLE COLLECTION.
PI72164
14_Feb
2017
UI44670


WORK SPACE BUILD-UP
PI72641
14_Feb
2017
UI44668


SOME STORED PROCEDURES ARE INCORRECTLY REPORTING -905 SQL CODES IN CQM
PI70148
7_Nov
2016
UI42343


COMPATIBILITY WITH CQM - CQM GA 3.3 COMPATIBILITY.
PI68136
18_Oct
2016
UI41771


IF DB2 STAP STAYS UP AND CQM IS RECYCLED A MEMORY OBJECT NEEDS TO BE DETACHED FROM THE DBM1 AND THE CQM MASTER ADDRESS SPACE
PI67772
4_Oct
2016
UI40725


NEW QUERY MONITOR RELEASE TOLERANCE
PI67232
9_Sep
2016
UI40744


Potential S0C4 at STAP start up when reading policy from appliance
PI66875
22_Aug
2016
UI40282


IN SOME CASES DB2 QUERY MONITOR MESSAGE CQM2002E OR DB2 GUARDIAMSTAP MESSAGE ADHQ2002E MAY NOT BE ISSUED
PI58778
21_Jul
2016
UI39552


ABEND S0C4 IN DB2 QUERY MONITOR MAY OCCUR DURING STARTUP
PI62322
21_Jul
2016
UI39554


CQC110 DB2 COMMON ACCESS COLLECTOR MONITORING AGENT DE-INSTALL FAILURE DURING CQM SHUTDOWN
PI59517
13_Jul
2016
UI39379


SUPPORT FOR FUTURE ENHANCEMENTS.
PI56899
28_Jun
2016
UI38997


USE COLLECTOR TECHNOLOGY FOR COLLECTION OF UTILITY AND AUTH CHANGED FAILED ACTIVITY IN STAP.
PI60756
2_Jun
2016
UI38396

HIPER

0C4 DB2 V10 DSNXGRDS.DSNXECL +0030 WITH MSG CQM5010I MONITORING AGENT DEINSTALLATION IN PROGRESS FOR SUBSYSTEM NNNN
PI61429
2_Jun
2016
UI38392

HIPER

MEMORY LEAK IN PARALLEL PROCESSING WHEN RUNNING OPTKEYS PTEXT ISM SPACE RC14 RSN191 U1205 ABENDS0C4 DSNXEET CQCMPRA1
DSNB1LTS
PI55044
10_May
2016
UI37722


RESOLVE PROGRAM EXCEPTIONS RESULTING FROM DIAG TRAP TESTING.
PI60257
10_May
2016
UI37714

HIPER

CQM STC ABNORMAL TERMINATION WITH CQM2002E MONITORING AGENT INSTALLATION FAILED DB2 QUERY MONITOR #SSMN SUBTASK ABEND
PI58668
25_Apr
2016
UI37290


PREVENT LONG STORAGE STRUCTURE CHAINS IF THERE IS AN ABEND COLLECTING CERTAIN KINDS OF HOST VARIABLES
PI58175
5_Apr
2016
UI36781


PREPARATORY SUPPORT FOR FUTURE DB2 FEATURES.
PI57591
18_Mar
2016
UI36350


HOST VARS MISSING AFTER FALLBACK TO PREVIOUS VERSION WHEN HOSTVARS SPECIFIED FOR STAP V10.0 POLICY.
PI55117
11_Feb
2016
UI35293


ABENDS0C4 IN CQCMHSTV FOR THE COMMON COLLECTOR INTERNAL ABEND TABLE
PI56003
11_Feb
2016
UI35294

HIPER

MISSING AUDIT EVENT RECORDS OR MISSING DATA MESSAGES ADHQ1205 ADHQ1217 IN STAP OR CQM1205 CQM1217 IN QUERY MONITOR
PI47671
30_Nov
2015
UI33429


COMPATIBILITY WITH STAP
PI47485
6_Nov
2015
UI32753


CURRENT ACTIVITY MAY NOT BE DISPLAYED
PI47628
6_Nov
2015
UI32750


SUPPORT FOR FUTURE ENHANCEMENTS
PI45770
1_Sep
2015
UI30743


COMPATIBILITY WITH STAP
PI42872
23_Jul
2015
UI29695


INCORROUT: 'RECORDS AFFECTED' VALUE INCORRECT FOR FETCH FIRST 1 ROWS ONLY
PI40214
9_Jul
2015
UI29250


ONE TIME DB2 ABEND 0CX ON DSNIDM.DSNB1GET+0014 DURING STARTUP ORONE TIME DB2 ABEND 0CX NEAR DSNXGRDS.DSNXEDSC+0030 AFTER
SHUTDOW
PI33070
27_May
2015
UI27970


OQWT: CURRENT_SCHEMA IS INCORRECT FOR DIFFERENT SCHEMAS WITH SAME AUTHID
PI36551
7_May
2015
UI27450


COMPATIBILITY WITH STAP
PI37859
28_Apr
2015
UI27162


STORAGE IN THE COLLECTOR MAY NOT BE FREED WHEN MONITORING LONG RUNNING THREADS THAT EXECUTE MANY PROGRAMS AND/OR STATEMENTS
PI35375
20_Mar
2015
UI26166

HIPER

ABEND0C4 IN CQCMPRA1 WHEN RUNNING QUERY MONITOR
PI31875
20_Feb
2015
UI25339


COMPATIBILITY WITH QUERY MONITOR
PI30843
13_Jan
2015
UI24362


AFTER APPLYING PI27125, ABENDS MAY OCCUR IN WLM, CQM, AND/OR DB2
PI29781
13_Jan
2015
UI24358


OMITTED COLLECTION DATA AND MEMORY CLEANUP AFTER RECYCLE OF CQM
PI29780
31_Dec
2014
UI24185


ADDITIONAL FIXES FOR INCORRECT REPORTING OF NULL INDICATOR FOR HOST VARIABLES. FOR CQM R310 THIS IS ADDRESSED BY PI26769
PI29422
17_Dec
2014
UI24008


ABENDS0C4 -38 may occur in CQM#REST, ADH#REST, CQR#REST, CQC#REST
PI28896
16_Dec
2014
UI23941


COMPATIBILITY WITH QUERY MONITOR
PI28147
24_Nov
2014
UI23377


COMMON COLLECTOR PACKAGING ENHANCEMENTS

Top of page