This page is being sunset with the final update being made on May 21, 2019. I do apologize for any inconvenience this might cause you but due to end of support of some of the underlying software it has become problematic to maintain this site. As an alternative, please pull down all available PTFs for this product from IBMSERV/ShopzSeries and review the PTF descriptions.
|
Security Guardium S-TAP for DB2 for z/OS Version 9.0.0
|
|||||
| APAR | CLOSE DATE |
PTF(s) | Fixing APAR if PE |
HIPER? | Abstract |
|---|---|---|---|---|---|
2017 |
DUMP TITLE=DB2 TOOLS SQL COLLECTOR ABEND=0C4-00000004,MODULE=UN | ||||
2017 |
COMPATIBILITY WITH CQM | ||||
2017 |
COMPATIBILITY WITH CQM | ||||
2017 |
INTERNAL CODE CLEAN UP. CODE HAS BEEN ALTERED TO ADDRESS INTERNAL ABENDS FOUND IN THE INTERNAL DIAG TABLE. | ||||
2017 |
Support for future enhancements | ||||
2017 |
CLEANUP INTERNAL DIAGNOSTIC ENTRY DURING HOST VARIABLE COLLECTION | ||||
2017 |
CQM COMPATIBILITY FOR STORE PROCEDURES. (PI72645) | ||||
2017 |
WORK SPACE BUILD-UP | ||||
2016 |
INCORROUT: RECORDS AFFECTED FOR FETCH FIRST N ROWS ONLY INCORRECTLY | ||||
2016 |
DC2-40, A03 ABEND, CQM1026E SHARED MEMORY FAILURE in CQM on start up | ||||
2016 |
ABEND 0C4 IN MODULE ADHGSTRI STREAMING IFCID 140 | ||||
2016 |
COMPATIBILITY WITH CQM - CQM GA 3.3 COMPATIBLITY | ||||
2016 |
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 | ||||
2016 |
NEW QUERY MONITOR RELEASE TOLERANCE | ||||
2016 |
IEA705I ERROR DURING GETMAIN SYS CODE = 878-10 AFTER MULTIPLE RECYCLES OF DB2 SUBSYSTEM | ||||
2016 |
S-TAP FOR DB2 #DRVR SUBTASK ABEND | ||||
2016 |
COMPATIBILITY SUPPORT FOR CQC | ||||
2016 |
ABEND S0C4 IN S-TAP FOR DB2 MAY OCCUR DURING STARTUP | ||||
2016 |
SUPPORT FOR FUTURE ENHANCEMENTS. | ||||
2016 |
SUPPORT FOR ENHANCEMENTS IN FUTURE VERSIONS. | ||||
2016 |
INCORROUT: ERROR IN RESULT OF CONVERSION OF SQL STATEMENT TEXT TO UTF8 CCSID. | ||||
2016 |
ADHTCPWS/ADHTCPWZ ABEND S0C4 IN CURRENT SCHEMA COLLECTION PROCESSING | ||||
2016 |
ABEND0C4 DB2 V10 DSNXGRDS.DSNXECL +0030 WHEN ADH5010I MONITORINGAGENT DEINSTALLATION IN PROGRESS FOR SUBSYSTEM NNNN OCCURS | ||||
2016 |
COMPATIBILITY SUPPORT WITH CQC | ||||
2016 |
RESOLVE PROGRAM EXCEPTIONS RESULTING FROM DIAG TRAP TESTING. | ||||
2016 |
S-TAP STC ABNORMAL TERMINATION WITH ADHQ2002E MONITORING AGENT INSTALLATION FAILED MESSAGE | ||||
2016 |
COMPATIBILITY SUPPORT WITH CQC | ||||
2016 |
ADHQ1212E DUE TO MEMORY LEAK FOR SPECIFIC SQL WORKLOADS | ||||
2016 |
COMPATIBILITY SUPPORT WITH CQM/CQR. | ||||
2016 |
HOST VARS MISSING AFTER FALLBACK TO PREVIOUS VERSION WHEN HOSTVARS SPECIFIED FOR STAP V10.0 POLICY.(PI57591) | ||||
2016 |
SDC2-003F ABEND, SA03 ABEND ON START UP OF STP. ERROR OCCURS WHEN RSM DETACH REQUEST IS ISSUED FOR AN OBJECT THAT IS NOT | ||||
2016 |
INCORROUT, INTERMITTENT ABEND, MISSING AUDIT EVENT RECORDS, AND VARIOUS ADHQ12NN (1217, 1205) MESSAGES | ||||
2016 |
ABENDS0C4 IN COMMON COLLECTOR INTERNAL ABEND TABLE. COMPATIBILITY BETWEEN STAP AND CQC | ||||
2016 |
ADD TARGETS TO UTILITY EVENTS WHEN OMITTED. | ||||
2016 |
NEGATIVE SQL CODE EVENT COLLECTED WITHOUT NEGATIVE SQL CODES INTHE POLICY WHEN CQR IS COLLECTING EVERYTHING | ||||
2016 |
S0C4 AT ADHZGIF+14DA OR FURTHER OFFSET - CROSSING A PAGE BOUNDARY | ||||
2015 |
HIGH CPU USAGE IN STAP AGENT | ||||
2015 |
IMPROVE VSAM BUFFER SIZING FOR FUTURE RELEASE COMPATIBILITY | ||||
2015 |
SUPPORT FOR FUTURE ENHANCEMENTS. | ||||
2015 |
CURRENT ACTIVITY MAY NOT BE DISPLAYED | ||||
2015 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2015 |
SUPPORT FILTERING OF CONNECTION_TYPE ('NETPROTOCOL') VALUE OF 0 | ||||
2015 |
DB2 AUDIT SQL COLLECTOR #AUDT SUBTASK ABEND ON STARTUP | ||||
2015 |
SYSTEM COMPLETION CODE=A03 IN THE COLLECTOR STARTED TASK | ||||
2015 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2015 |
SUPPORT FOR FUTURE ENHANCEMENTS (PI40203) | ||||
2015 |
INCORROUT: RECORDS AFFECTED' VALUE INCORRECT FOR FETCH FIRST 1 ROWS ONLY | ||||
2015 |
EXTERNALIZE ERROR REASON CODES DURING INITIALIZATION OF IFI TRACE. | ||||
2015 |
ADDITION OF SAMPLIB ADHGRANT MEMBER FOR GRANT ON EXECUTE TO PLANAND GRANTS FOR USERIDS | ||||
2015 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2015 |
DETECT CORRUPT DATA ON TCP/IP READ | ||||
2015 |
IMPROVE PERFORMANCE OF OBJECT NAME RESOLUTION FOR UTILITY EVENTS | ||||
2015 |
ADHQ2002E MONITORING AGENT INSTALLATION FAILED | ||||
2015 |
POTENTIAL 0C4 CAUSED BY A MEMORY OVERLAY DURING PROCESSING PUSHED DOWN POLICY. | ||||
2015 |
REPORT TABLE UPDATE FOR NESTED INSERT ON SELECT INTO STATEMENT. | ||||
2015 |
KEEP CONNECTION LIVE TO FAILOVER APPLIANCES | ||||
2015 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2015 |
OQWT: CURRENT_SCHEMA IS INCORRECT FOR DIFFERENT SCHEMAS WITH SAME AUTHID | ||||
2015 |
SUPPORT FOR FUTURE ENHANCEMENTS | ||||
2015 |
SUPPORT PROCESSING OF IFI TRACE IFCIDS WITH DB2 PARM UIFCIDS = N. | ||||
2015 |
STORAGE IN THE COLLECTOR MAY NOT BE FREED WHEN MONITORING LONG RUNNING THREADS THAT EXECUTE MANY PROGRAMS AND/OR STATEMENTS | ||||
2015 |
PREVENT LOOP WHEN EXCLUDE OF DBNAME AND OCCURRENCE OF INSERT RESULTING FROM TRIGGER | ||||
2015 |
DB2 ABEND0C4 IN CQMMPRA1 CAN OCCUR WHEN MONITORING DB2 SUBSYSTEM WITH S-TAP FOR DB2 AND QUERY MONITOR | ||||
2015 |
CORRUPTED SQL STATEMENT TEXT REPORTED FOR CERTAIN WORKLOADS | ||||
2015 |
RELEASE SHARED MEMORY OBJECTS AFTER RESTART OF DB2 SUBSYSTEM | ||||
2015 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2015 |
COMPATIBILITY WITH WORKLOAD REPLAY | ||||
2015 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2015 |
SAMPLIB MEMBER ADHCFGPE DOES NOT CONTAIN FULL SET OF PARAMETERS | ||||
2015 |
ABEND S0C9 WHEN FAILOVER ENABLED WITH PRIMARY SERVER NOT AVAILABLE | ||||
2015 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2015 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2014 |
ADDITIONAL FIXES FOR INCORRECT REPORTING OF NULL INDICATOR FOR HOST VARIABLES | ||||
2014 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2014 |
INCORROUT: PREVIOUS POLICY ACTIVATED AFTER DB2 SUBSYSTEM RESTART | ||||
2014 |
INCREASE AGENT-CONFIG MESSAGE LENGTH LIMIT FOR S-TAP V9.X PROTOCOLS | ||||
2014 |
COMMON COLLECTOR PACKAGING ENHANCEMENTS | ||||
2014 |
POSSIBLE MSG ADHQ120E RC8,RSN38 WITH HIGH VOLUME, SHORT DURATION THREAD ACTIVITY DOING COMMITS | ||||
2014 |
UNEXPECTED SQL EVENTS REPORTED IF OBJECT FILTER NOT SPECIFIED | ||||
2014 |
ADHQ1071E ISSUED AT STARTUP WHEN PRIMARY APPLIANCE DOWN AND FAILING OVER TO SECONDARY APPLIANCE | ||||
2014 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2014 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2014 |
INCORRECT TIMEOUT VALUE WHEN IN ZIIP MODE | ||||
2014 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2014 |
INCORROUT: INVALID CCSID FOR WLM SP WHEN CALLED FROM DISTRIBUTEDAPPLICATION | ||||
2014 |
DSNL028I,ABEND0C1, ABND=0C1-00000001 | ||||
2014 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2014 |
MESSAGE ADHQ2618I AT SHUTDOWN | ||||
2014 |
SUPPORT FOR FUTURE ENHANCEMENTS | ||||
2014 |
IMPROVED PERFORMANCE AND AUDIT EVENT THROUGHPUT FOR S-TAP | ||||
2014 |
COMPATIBILITY WITH CAPTURE REPLAY | ||||
2014 |
ZIIP_TCP(Y) COULD CAUSE S0C1 IN ADHTCPWS | ||||
2014 |
CHANGES REQUIRED FOR COMPATIBILITY WITH QUERY MONITOR | ||||
2014 |
PREVENT ABEND 0C1 AT STARTUP | ||||
2014 |
DB2 | ||||
2014 |
INVALID TEXT COLLECTED WHEN DB2 OPTION CONCENTRATE STATEMENTS W/LITERALS(YES) | ||||
2014 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2014 |
INCORRECT CAPTURING/REPORTING OF NULL INDICATOR FOR HOST VARIABLES | ||||
2014 |
DYNAMIC SQL TEXT OF LENGTH GREATER THAN 64K NOT REPORTED | ||||
2014 |
IMPROVED INSTRUCTIONS FOR SAMPLIB JOB ADHSJ001 | ||||
2014 |
COMPATIBLITY WITH QUERY MONITOR 3.X | ||||
2014 |
ABEND C78-60 AND MALLOC ERRORS WHEN USING SPILLFILE WITH MEGABUFFER DISABLED | ||||
2014 |
OVERLAY IN ADDRESS POINTER IN ADHMSTR ADDRESS SPACE MAY CAUSE ABND=04E-00E50076 , ABND=04E-00E501A1 IN DB2 | ||||
2014 |
ADHP101W MESSAGING IMPROVEMENTS | ||||
2014 |
COMPATIBILITY WITH WORKLOAD REPLAY V2.1 | ||||
2014 |
ABEND S60D IN DSNTFRCV | ||||
2014 |
COMPATIBILITY WITH QUERY MONITOR | ||||
2014 |
INCORROUT: STRANGE CHARACTERS IN BIND (HOST) VARIABLE VALUES FOR SOME SQL STATEMENTS | ||||
2014 |
ADDITION OF STAP_IFI_SCOPE PARAMETER | ||||
2014 |
AVOID COLLECTION OF EXTRANEOUS CREATE PROCEDURE FOR SOME SQL WORKLOADS. | ||||
2014 |
EXTRANEOUS EVENTS COLLECTED BY WORKLOAD REPLAY WHEN RUNNING CONCURRENTLY WITH STAP AND STAGE1 PARM = Y. | ||||
2014 |
DB2 ABND=04E-00C90101 | ||||
2014 |
INCORRECT AUDIT DATA RESULTS WHEN RUNNING CONCURRENTLY WITH WORKLOAD REPLAY | ||||
2014 |
REDUCE CSA FOOTPRINT FOR GUARDIUM STAP | ||||
2014 |
ABND=0C4-00000011 IN DB2 DBM1 ADDRESS SPACE | ||||
2014 |
LOOP IN ADHZT1 AFTER DB2 TERMINATION | ||||
2014 |
SQLCODE -204 ATTEMPTING TO ACCESS [QUALIFIER].ADHVTBLS FROM ADHZ021 | ||||
2014 |
INCORRECT DELAY AND ELAPSED TIMES STATISTICS REPORTED IN QUERY MONITOR AFTER APPLYING DB2 APAR PM96478 | ||||
2014 |
SUPPORT FOR FUTURE ENHANCEMENTS | ||||
2014 |
INVALID SQL FROM PLAN DSNUTIL DISPLAYED IN CURRENT ACTIVITY | ||||
2014 |
HIGH CPU USAGE IN ALLIED ADDRESS SPACE WHEN MONITORING WITH QUERY MONITOR AND WORKLOAD REPLAY (PI08663) | ||||
2014 |
CQM3311E UNABLE TO LINK DB2 SYSTEM WHEN TRYING TO INSTALL TO A DB2 | ||||
2014 |
INCORRECT DELAY AND ELAPSED TIMES STATISTICS REPORTED IN QUERY MONITOR AFTER APPLYING DB2 APAR PM90886 / UK97693 | ||||
2014 |
POTENTIAL EXCLUSION OF EVENT FOR SPECIFIC FILTER SPECIFICATION | ||||
2014 |
DUPLICATED PROGRAM LOADS RESULTING IN UNNECESSARY CSA ALLOCATIONS | ||||
2014 |
POLICY-PUSHDOWN ERRORS DUE TO NON-DB2 POLICY | ||||
2014 |
COMPATIBILITY WITH CQR | ||||
2014 |
ALERT CAPTURED ONLY ON QUERY MONITOR WEB CLIENT AND NOT SHOWN ON ISPF CLIENT INTERFACE | ||||
2014 |
COM | ||||
2013 |
INCORRECT AUDIT DATA RESULTS WHEN RUNNING CONCURRENTLY WITH WORKLOAD REPLAY | ||||
2013 |
-904, ERROR: REASON 00E30100, HIGH CPU WHILE MONITORED BY CQM | ||||
2013 |
POLICY PUSHDOWN: CORRECT ISSUES WITH VALUE-GROUPS IN SVC. NAME | ||||
2013 |
DB2 QUERY MONITOR MMETR SUBTASK ABEND ABEND0C4, ABEND U1205, INCORROUT and High CPU in monitored thread | ||||
2013 |
POSSIBLE LOOP IN MODULE ADHGUARZ EXPOSURE | ||||
2013 |
MISSING DATA FOR WILD CARD IF SINGLE CHARACTER IN THE WILDCARD POSITION MATCHES THE CHARACTER FOLLOWING THE WILDCARD | ||||
2013 |
ADHQ2002E WHEN MONITORING DB2 SUBSYSTEM | ||||
2013 |
QUERY MONITOR STOPS MONITORING WHILE GUARDIUM STAP IS ACTIVE | ||||
2013 |
COMPATIBILITY WITH FUTURE ENHANCEMENTS. | ||||
2013 |
ADHKAFLT ABEND0C4 DURING POLICY INSTALLATION | ||||
2013 |
ENHANCEMENTS TO SUPPORT FUTURE VERSIONS OF DB2. | ||||
2013 |
AGENT ABEND0C4 DURING IFI DATA COLLECTION IN UCS CALL | ||||
2013 |
COMPATIBILITY WITH CQR | ||||
2013 |
INCORRECT VALUE SENT FOR CORRELATION NAME FIELD FOR IFI DATA | ||||
2013 |
MEMORY OBJECT LEFT ATTACHED AND NOT FREED TO DB2 NNNNDIST AFTER STAP CYCLE. | ||||
2013 |
ENABLE SUPPORT FOR "CONNECT RESET" | ||||
2013 |
POTENTIAL WAIT STATE IN STREAMER TASK CAUSING MAX ALLOCATIONS AND EVENTS NOT SENT TO APPLIANCE | ||||
2013 |
INCORRECT ROW COUNT REPORTED FOR MULTI-FETCH WORKLOADS | ||||
2013 |
COMPATIBILITY WITH CQR | ||||
2013 |
ABEND0C4-4 CQR#SDIR +25F2 | ||||
2013 |
COMPATIBILITY WITH CQR | ||||
2013 |
REMOVAL OF FAILOVER_PORT PARMS | ||||
2013 |
IMPROVE VALIDATION OF ADHPARMS PARAMETERS | ||||
2013 |
LOOP BETWEEN X'858' THRU X'892' IN ADHGUARZ | ||||
2013 |
MISSING HOST VARIABLE FOR SELECT STATIC STATEMENT | ||||
2013 |
INCOMPLETE AUDIT DATA REPORTED FOR ALTER PROCEDURE EVENTS | ||||
2013 |
ERRORS IN ESTAE SETUP PROCESSING FOR SDUMP CAN PREVENT ABEND DUMPS FROM BEING GENERATED | ||||
2013 |
REDUCED THROUGHPUT OF IFI-COLLECTED DATA | ||||
2013 |
PREVENT TERMINATION OF COLLECTOR AGENT IF POLICY ERROR EXPERIENCED DURING INITIALIZATION. | ||||
2013 |
POTENTIAL UNREPORTED LOSS OF AUDIT DATA WHEN SPILLFILE IS USED | ||||
2013 |
CPU CONSUMPTION IS HIGHER FOR AN APPLICATION WHEN QM IS RUNNING,ALTHOUGH THE APPLICATION IS NOT BEING MONITORED BY QM. | ||||
2013 |
COMPATIBILITY WITH DATA CAPTURE | ||||
2013 |
INCORRECT CCSID REPORTED FOR HOST VARIABLES WITH DISTRIBUTED WORKLOADS ON DB2 V8 | ||||
2013 |
S-TAP 9.0 FAILS TO COLLECT IFI TRACE DATA FOLLOWING DB2 SHUTDOWN/ STARTUP | ||||
2013 |
ENHANCEMENTS FOR FUTURE DB2 VERSIONS | ||||
2013 |
STORED PROCEDURE NAME NOT REPORTED FOR NESTED STORED PROCEDURE CALL. | ||||
2013 |
MESSAGE "ADHP101W INVALID VALUE FOR FILTER:" IN ADHLOG DD | ||||
2013 |
MODIFICATIONS TO INTERNAL STORAGE MANAGEMENT SYSTEM TO IMPROVE PERFORMANCE | ||||
2013 |
DATA COLLECTION IS NOT OCCURRING ON MACHINES THAT DO NOT HAVE THE EXTRACT CPU TIME FACILITY. | ||||
2013 |
COLLECTOR AGENT FAILS TO TERMINATE WHEN STOP COMMAND IS ISSUED | ||||
2013 |
ISOLATED ABEND60D-18, POSSIBLE ABEN0CX, OR NO STATS COLLECTED FOR AN ISOLATED THREAD AND MISSING MONITORING DATA FOR A THREAD | ||||
2013 |
CCSID NOT REPORTED FOR NULL TERMINATED CHAR STRING (SQLTYPE = 460) HOST VARIABLE | ||||
2013 |
FAILED SEND AS A RESULT OF A BUFFER OVERFLOW | ||||
2013 |
ADHG099E UNEXPECTED ERROR: RETRY LIST END IS NULL | ||||
2013 |
INCORRECT CURSOR NAME DISPLAYED UNDER SQLCA SCREEN | ||||
2013 |
S0C4-04 IN LMOD ADHTTXTX | ||||
2013 |
OQWT INTEGRATION | ||||
2013 |
ABEND C78-60 IN ADHGSTRI | ||||
2013 |
MESSAGE "OUT BUFFER OVERFLOW!" MAY APPEAR IN ADHLOG | ||||
2013 |
MISSING OBJECTS (TABLES) FOR DELETE STATEMENT | ||||
2013 |
S-TAP COLLECTOR TERMINATION DUE TO ADHZ217A | ||||
2013 |
ABEND 0C4 - ADHZGIF + OFFSET X'00000252' | ||||
2013 |
DETECT NEW DRDA CONNECTION ON EXISTING THREAD | ||||
2013 |
PRODUCT SUITE COMPATIBILITY SUPPORT. | ||||
2013 |
PARSING ERRORS AND ABEND WHEN MANY POLICIES INSTALLED. | ||||
2013 |
MULTIPLE OCCURRENCES OF MESSAGE ADHQ1217W | ||||
2012 |
ABEND0C4 IN ADHMINSZ + 955C, ASC COLLECTS MINIMUM AUDIT DATA. | ||||
2012 |
GUARDIUM APPLIANCE DOES NOT SHOW SQL EXECUTION IF -904 SQLCODE | ||||
2012 |
ADHQ1217W, ADHQ1205E ISM ERROR OCCURRED, ADHQ1203I RC=0008, RSN=004C, RSN=0038 | ||||
2012 |
PROTOBUF ENCODING ERROR FOR LARGE UNSIGNED INTEGERS | ||||
2012 |
ADD A PARAMETER TO ALTER THE LIMIT OF HOST VARIABLES ALLOWED | ||||
2012 |
SUPPRESS DUPLICATE ADHQ12XX MESSAGES FOR UNKNOWN CPID | ||||