Question & Answer
Question
This document contains keywords that you can use to optimize your search results when you are searching APAR text.
Answer
IBM® uses the keywords documented in the following tables in APAR text. Using these keywords when you search APARs helps you better find the APARs that you need.
Db2 FIXCAT Keywords
Explanation | Keyword |
Fixes that enable the SYSPLEX data sharing function or fixes required for SYSPLEX data sharing | SYSPLEXDS |
Fixes that enable Db2 releases to coexist when in data sharing mode | DB2COEXIST/K |
Fixes for problems with the Db2 parallelism function | DB2PARALL/K |
Fixes for Db2 storage leak problems | DB2STGLK/K |
Fixes for Db2 storage overlay problems | DB2OVRLAY/K |
Fixes for Db2 SQL incorrect output problems. (too few rows, too many rows, wrong rows, no rows, etc.) |
DB2INCORR/K |
Fixes that allow the earlier Db2 release to migrate to or fallback from Db2 9 for z/OS | DB2MIGV9/K |
Fixes that allow the earlier Db2 release to migrate to or fallback from Db2 10 for z/OS | DB2MIGV10/K |
Fixes that allow the earlier Db2 release to migrate to or fallback from Db2 11 for z/OS | DB2MIGV11/K |
Fixes that allow the prior release of Db2 to migrate to or fallback from Db2 12 for z/OS | DB2MIGV12/K |
Fixes that allow the earlier Db2 release to migrate to or fallback from Db2 13 for z/OS | DB2MIGV13/K |
Fixes for Db2 Sort related issues | DB2SORT/K |
Fixes for IBM Db2 AI for z/OS, V1.1, and fixes for other z/OS software to support IBM Db2 AI for z/OS, V1.1. | DB2AIV1R1/K |
Fixes for IBM Db2 AI for z/OS, V1.2, and fixes for other z/OS software to support IBM Db2 AI for z/OS, V1.2. | DB2AIV1R2/K |
Fixes for IBM Db2 AI for z/OS, V1.3, and fixes for other z/OS software to support IBM Db2 AI for z/OS, V1.3. | DB2AIV1R3/K |
Fixes for IBM Db2 AI for z/OS, V1.4, and fixes for other z/OS software to support IBM Db2 AI for z/OS, V1.4. | DB2AIV1R4/K |
Fixes for IBM Db2 AI for z/OS, V1.5, and fixes for other z/OS software to support IBM Db2 AI for z/OS, V1.5. | DB2AIV1R5/K |
Fixes that are required for z/OS software products to support the IBM Smart Analytics Optimizer for Db2 for z/OS, V1.1 (5697-AQT) running on an IBM zEnterprise BladeCenter Extension (zBX). | ISAOPT/K |
Fixes that are required for z/OS software products to support the IBM Db2 Analytics Accelerator for z/OS, V3.1 (5697-AQT) running on an IBM zEnterprise BladeCenter Extension (zBX). | IDAAV3R1/K |
Fixes that are required for z/OS software products to support the IBM Db2 Analytics Accelerator for z/OS, V4.1 (5697-AQT) running on an IBM zEnterprise BladeCenter Extension (zBX). | IDAAV4R1/K |
Fixes that are required for z/OS software products to support the IBM Db2 Analytics Accelerator for z/OS, V5.1 (5697-AQT) running on an IBM zEnterprise BladeCenter Extension (zBX). | IDAAV5R1/K |
Fixes that are required for z/OS software products to support the IBM Db2 Analytics Accelerator for z/OS, V6.1 (5697-AQT) running on an IBM zEnterprise BladeCenter Extension (zBX). | IDAAV6R1/K |
Fixes that are required for z/OS software products to support the IBM Db2 Analytics Accelerator for z/OS, V7.1 (5697-AQT) running on an IBM zEnterprise BladeCenter Extension (zBX). | IDAAV7R1/K |
Fixes that are required for z/OS software products to support the IBM Db2 Analytics Accelerator for z/OS, V7.5 (5697-AQT) running on an IBM zEnterprise BladeCenter Extension (zBX). | IDAAV7R5/K |
Fixes for the Db2 Extended RBA function | DB2EXTRBA/K |
Fixes for FTB (Fast Traversal Blocks) |
DB2FTB/K
|
Fixes for IAG2 (Insert Algorithm 2) | DB2IAG2/K |
Db2 SQL Data Insights | DB2SQLDI/K |
See also: https://www-03.ibm.com/systems/z/os/zos/features/smpe/fix-category.html
General Db2 Keywords
Term
|
Keyword to use when searching
|
Comments
|
=- (minus) | SQLMINUS | |
(= equal) | SQLEQUAL | |
=+ (plus) | SQLPLUS | |
< (less than) | SQLLT | |
> (greater than) | SQLGT | |
Abend | ABENDxxx | Where xxx is the 3-5 character abend code. Example: ABEND04E. If it is a USER ABEND it is ABENDU2017. If the abend code includes an S (for example S301), drop the S. Example: ABEND301 |
Access Control Authorization Exit | ACAE | Use for external security exit |
Access path impact | SQLACCESSPATH | This keyword should find all APARs that affect access path |
ALIAS | SQLALIAS | |
All SQL | SQLALL | |
ALTER | SQLALTER | |
AND | SQLAND | |
Application Period Temporal Table (Business_Time) | SQLAPTT | |
Asensitive cursor | SQLASENSITIVE SQLSCROLL | Use both keywords |
AVG | SQLAVG | |
BETWEEN | SQLBETWEEN | |
BIND | SQLBIND | |
BiTemporal Table | SQLBITEMPORAL | |
CASE expression | SQLCASE | |
CAST | SQLCAST | |
CCSID | SQLCCSID | |
CHECK CONSTRAINT | SQLCONSTRAINT | |
Clone tables | SQLCLONE | |
Column Mask | SQLCOLUMNMASK | |
Comment on | SQLCOMMENTON | |
Common Table Expression | SQLCTE | |
Concentrate Statement With Literals | SQLCSWL | |
Correlated subquery | SQLCORRSUBQ | |
CORRELATION | SQLCORRELATION | |
COUNT | SQLCOUNT | |
CREATE | SQLCREATE | |
Created Global Temp Table | SQLGTT | |
GTT | ||
Created Temporary Table | SQLCGTT | |
CURRENT DEBUG MODE | SQLDEBUGMODE | |
DEBUGMODE | ||
Data integrity-related INCORROUT | DB2INCORR/K | Examples: More rows, fewer rows, wrong rows, or wrong data |
DATE | SQLDATE | |
Db2 | DB2 9 for z/OS | |
Db2 10 for z/OS | ||
Db2 11 for z/OS | ||
Db2 12 for z/OS | ||
Db2 13 for z/OS | ||
Db2 coexistence | DB2COEXIST/K | |
Db2 co-processor | DB2COPROCESSOR | |
Db2 data sharing | DB2DSHR | |
SYSPLEXDS | ||
Db2 pre-compiler | DB2PRECOMPILER | |
Db2 Resource Limit Facility | DB2RLF | For general RLF-related issues |
Db2 V10 Required for non-Db2 product APAR | DB2V10TGT/K | This keyword is for other IBM (non-Db2) products to put in their APARs that require Db2 V10. |
Declared Temporary Table | SQLDGTT | |
Decimal floating point | SQLDECFLOAT | |
DELETE | SQLDELETE | |
DENSE_RANK | SQLDENSERANK | |
DEPLOY | SQLDEPLOY | |
DESCRIBE statement | SQLDESCRIBE | |
DISTINCT | SQLDISTINCT | |
Documentation error | DOC xxxxxxxx | Where xxxxxxxx is the document number |
DRDA | SQLDRDA | |
DROP | SQLDROP | |
Dynamic Statement Cache | SQLDYNSTMTCACHE | |
Encoding scheme | SQLENCODING | |
ERQUAL | ERQUALxxxx | Where xxxx is the reason code qualifier |
ESCAPE | SQLESCAPE | |
EXCEPT | SQLEXCEPT | |
EXCEPT ALL | SQLEXCEPTALL | |
EXISTS | SQLEXISTS | |
EXPLAIN | SQLEXPLAIN | |
Fast join | SQLFASTJOIN SQLUNMATCHEDJOIN | |
FETCH FIRST n ROWS | SQLFFNR | |
FIELDPROC | SQLFIELDPROC | |
Filter factor | FILTERFACTOR | |
Fixes that allow the earlier Db2 release to migrate to or fall back from version 9. | DB2MIGV9/K | |
Fixes that allow the earlier Db2 release to migrate to or fall back from Db2 10. | DB2MIGV10/K | |
Fixes that allow the earlier release of Db2 to migrate to or fall back from Db2 11. | DB2MIGV11/K | |
Fixes that allow the earlier Db2 release to migrate to or fall back from Db2 12. | DB2MIGV12/K | |
Fixes that allow the earlier Db2 release to migrate to or fall back from Db2 13. | DB2MIGV13/K | |
Fixes that are required for z/OS software products to support the IBM Smart Analytics Optimizer for Db2 for z/OS, V1.1 (5697-AQT) running on an IBM zEnterprise BladeCenter Extension (zBX). | ISAOPT/K | |
Fixes that are required for z/OS software products to support the IBM Db2 Analytics Accelerator for z/OS, V2.1 (5697-AQT) running on an IBM zEnterprise BladeCenter Extension (zBX). | IDAAV2R1/K | |
Fixes that are required for z/OS software products to support the IBM Db2 Analytics Accelerator for z/OS, V3.1 (5697-AQT) running on an IBM zEnterprise BladeCenter Extension (zBX). | IDAAV3R1/K | |
FOR statement in a native SQL procedure | SQLFORLOOP | |
FUNCTION | SQLFUNCTION | |
GENERATE_UNIQUE | SQLGENUNIQUE | |
GET DIAGNOSTICS | SQLGETDIAG | |
GETHINT | SQLGETHINT | |
Global optimization | SQLGLOBALOPT | |
GRAPHIC | SQLGRAPHIC | |
GROUP BY | SQLGROUPBY | |
Hang | DB2HANG | |
HAVING | SQLHAVING | |
Host variables | SQLHOSTVAR | |
HOUR | SQLHOUR | |
Hybrid join | SQLHYBRID | |
SQLHYBRIDJOIN | ||
IFCID XXX | IFCIDXXX | Where XXX is the number of IFCID with proceeding 0s |
IN (inlist) | SQLIN | |
In-list table | SQLINLISTTABLE | |
In subquery | SQLINSUBQ | |
INCLUDE function or INCLUDE clause | SQLINCLUDE | |
Incorrect output | DB2INCORR/K | |
INCORROUT | ||
SQLINCORR | ||
SQLINCORROUT | ||
Index on expression | SQLINDEXONEXP | |
Index only | INDEXONLY | |
SQLINDEXONLY | ||
Index probing | INDEXPROBING | |
Inline User-Defined Function | SQLINLINEUDF | |
Insensitive cursor | SQLINSENSITIVE SQLSCROLL | Use both keywords |
INSERT | SQLINSERT | |
Insert Algorithm 2 | IAG2 | |
Insert with subselect | SQLINSWSELECT | |
INTERSECT | SQLINTERSECT | |
INTERSECT ALL | SQLINTERSECTALL | |
IS NOT NULL | SQLISNOTNULL | |
IS NULL (predicate) | SQLISNULL | |
JOIN back phase (for pairwise JOIN) | SQLJOINBACK | |
LABEL ON | SQLLABELON | |
Large object, LOB | SQLLOB | |
LEFT OUTER JOIN | SQLLEFT | |
SQLLEFTJOIN | ||
LIKE | SQLLIKE | |
Limited partition scan | PAGERANGE | |
LOBs | DB2LOB | |
Lock | SQLLOCK | |
Loop | LOOPxxxxxxxx | Where xxxxxxxx is the csect looping |
Mask | SQLMASK | |
Materialized Query Table | SQLMQT | |
MAX | SQLMAX | |
Media Manager regressions | REGRESSION MEDIAMGR | |
MERGE statement | SQLMERGE | |
Message DSNxxxxxx | MSGDSNxxxxx | Where xxxxx is the message number |
MIN | SQLMIN | |
MINUTE | SQLMINUTE | |
MONTH | SQLMONTH | |
Multi-Index Access | MIDX | |
Multi-row FETCH | SQLMULTIROW SQLFETCH | Use both keywords |
Multi-row INSERT | SQLMULTIROW SQLINSERT | Use both keywords |
Multi-row SELECT | SQLMULTIROW SQLSELECT | Use both keywords |
Native SQLPL | SQLNATIVESQLPL | |
Nested loop JOIN | NLJ | |
SQLNLJ | ||
Non-correlated subquery | SQLNONCORRSUBQ | |
NOT | SQLNOT | |
NOT NULL | SQLNOTNULL | |
NULL (column definition) | SQLNULL | |
NULLIF | SQLNULLIF | |
OFFSET | OFFSETxxxx | Where xxxx is 4 hex digits, padded with leading zeros as needed |
OLAP specification | SQLOLAP | |
Omnifind Text Search | TEXTSEARCH | |
ON | SQLON | SQL ON Predicate |
OPTIMIZE FOR n ROWS | SQLOFNR | |
Optimizer hint | OPTHINT | |
OPTHINTS | ||
OR | SQLOR | |
ORDER BY | SQLORDERBY | |
OUTER JOIN | SQLFULL | |
SQLFULLJOIN | ||
SQLJOIN | ||
SQLOUTER | ||
SQLOUTERJOIN | ||
Pair-wise join | SQLPAIRWISEJOIN | |
Parallel CPU <degree (any)> | SQLCPUP | |
Parallel I/O <degree (any)> | SQLIOP | |
Parallel Sysplex <degree (any)> | SQLSYSPLEXP SYSPLEX | |
Parallelism | DB2PARALL/K | |
PARALLELISM | ||
SQLPARALLELISM | ||
Parameter marker | PARAMETERMARKER | |
SQLPMARKER | ||
SQLPMK | ||
Partition-By-Growth | PBG | |
SQLPBG | ||
Performance degradation | PERFM | |
Permission | SQLPERMISSION | |
Private protocol | SQLPRIVATE | |
Pruning | SQLPRUNING | |
Range list access | SQLRANGELIST | |
RANK | SQLRANK | |
Reason code | RCxxxxxxxx | Where xxxxxxxx is the reason code, for example: RC00C90101 |
Referential integrity | SQLRI | |
REOPT(AUTO) | SQLREOPTAUTO | |
REOPTAUTO | ||
RIGHT OUTER JOIN | SQLRIGHT | |
SQLRIGHTJOIN | ||
ROW_NUMBER | SQLROWNUMBER | |
ROWSET positioning | SQLROWSET | Multi-row cursor |
Scalar fullselect | SQLSCALAR SQLFULLSELECT | Use both keywords |
SQLSCALARFULSEL | ||
Scalar User-Defined Function | SQLSCALARUDF | |
Scrollable cursor | SQLSCROLL | |
SELECT FROM.... DELETE | SQLSELWDELETE | |
SELECT FROM.... INSERT | SQLSELWINSERT | |
SELECT FROM.... MERGE | SQLSELWMERGE | |
SELECT FROM.... UPDATE | SQLSETWUPDATE | |
SECOND | SQLSECOND | |
Sensitive cursor | SQLSENSITIVE SQLSCROLL | Use both keywords |
Sequence | SQLSEQUENCE | |
SET CURRENT LOCALE | SQLLOCALE | |
SET function | SQLSETFUNCTION | |
Sideway reference | SQLSIDEWAY | |
SQLSIDEWAYREF | ||
Sort merge join | MSJ | |
SMJ | ||
SQLMSJ | ||
SQLSMJ | ||
Sparse index | SQLSPARSEINDEX | |
SPARSEINDEX | ||
Spatial index | SQLSPATIAL | |
Special register | SQLSPECIALREG | |
SQL code | SQLCODExxx | Where xxx is the SQL code without a minus or plus sign |
SQL performance (performance of SQL statements is impacted) | SQLPERFORMANCE | |
SQL predicate pushdown | SQLPREDPUSHDOWN | |
SQL procedure | SQLPROCEDURE | |
SQL procedure - external | SQLEXTERNALSQLPL | |
SQL statistics, how the optimizer handles statistics | SQLSTATS | |
Star join | SQLSTARJOIN | |
Storage | SQLSTORAGE | |
Storage leak | DB2STGLK/K | |
Storage overlay | DB2OVRLAY/K | |
SMCOVERLAY | ||
Stored procedure | SQLSP | |
SQLSTOREDPROC | ||
Subquery | SQLSUBQUERY | |
SUM | SQLSUM | |
SYNONYM | SQLSYNONYM | |
System Period Temporal Table | SQLSPTT | |
Table expression | SQLTABLEEXPR | |
Table UDF | SQLTABLEUDF | |
SQLTUDF | ||
TIME | SQLTIME | |
TIMESTAMP | SQLTIMESTAMP | |
TIMESTAMP with time zone | SQLTIMESTAMPTZ | |
Transitive | SQLTRANSITIVE | |
Transitive closure | SQLTRANSCLOSURE | |
Trigger | SQLTRIGGER | |
TRUNCATE function | SQLTRUNCATE | |
Trusted Context | SQLTRUSTED | |
Type 1 indexes | SQLTYPE1 | |
Type 2 indexes | SQLTYPE2 | |
UNION | SQLUNION | |
UNION ALL | SQLUNIONALL | |
UPDATE | SQLUPDATE | |
User | SQLUSER | |
User-defined function | SQLUDF | |
User-defined type | SQLUDT | |
Value | SQLVALUE | |
View | SQLVIEW | |
View merge | SQLVIEWMERGE | |
VRACE | VRACExxxx | Where xxxx is the reason code qualifier Note: For DDF, please see VRADC |
Wait | WAITxxxxxxxx | Where xxxxxxxx is the csect causing the wait |
WHEN | SQLWHEN | |
WHERE | SQLWHERE | |
YEAR | SQLYEAR |
Term | Keyword to use when searching |
ALL | XMLALL |
AND | XMLAND |
AVG | XMLAVG |
DATE | XMLDATE |
DELETE | XMLDELETE |
INSERT | XMLINSERT |
NOT | XMLNOT |
OR | XMLOR |
ORDERBY | XMLORDERBY |
PARSE | XMLPARSE |
Predicate pushdown | XMLPREDPUSHDOWN |
SUM | XMLSUM |
TIME | XMLTIME |
UPDATE | XMLUPDATE |
Version or versioning | XMLVERSION |
Where | XMLWHERE |
< (less than) | XMLLT |
(= equal) | XMLEQUAL |
> (greater than) | XMLGT |
(INCORROUT) | XMLINCORR |
XML index | XMLINDEXES |
XML schema | XMLSCHEMA |
Term | Keyword to use when searching |
Reason code | RCxxxxxxxx where xxxxxxxx is the reason code, for example: RC00E40090 |
Term | Keyword to use when searching | Comments |
Abend ID | ABNDIDnnnn | Where nnnn is the abend ID number in hexadecimal notation Note: When using ABNDIDnnnn, always indicate the VRADC key |
Abnormal termination | DB2ABTERM DB2TERM |
|
APARS specific to IDAA | DB2DDF | Use both keywords DB2DDF and the applicable IDAA keyword |
DDF | DB2DDF | This keyword indicates that the APAR is a DDF-related APAR. |
Compatibility ZPARM DDF_COMPATABILITY | DDFCOMPAT | |
Distributed 2-phase commit | DB2D2PC | |
DRDA exception | DB2DRDAE | |
DRDA protocol | DB2DRDA | |
High-performance DBAT | DB2HighPerfDBAT | |
Hop site or intermediate servers | DB2HOP | |
Inactive thread support | DB2INACTIVE | See Informational APAR II12675 |
LOB | DB2LOB | Use both keywords DB2DDF and DB2LOB |
Max Block Extra | DB2MBE | |
Native REST services | DB2REST | Alternative keywords REST, RESTFul, DDFREST |
Open group XA transaction manager support | DB2XA | |
Private protocol | DB2PRVT | |
SNA | DB2SNA | |
Stored procedures | DB2SP | |
System profile monitoring | DB2SPM | Use both keywords DB2DDF and DB2SPM |
TCPIP | DB2TCPIP | |
VRADC | VRADCxxxx | Where xxxx is the ABNDID number that is issued for DDF abends |
zLoad | DB2Zload |
Term | Keyword to use when searching |
Access path | SQLACCESSPATH |
Common Table Expression | SQLCTE |
Declared Temporary Table Created Temporary Table |
SQLDGTT SQLCGTT |
Materialized Query Table | SQLMQT |
Parallelism | SQLPARALLELISM |
Performance | SQLPERFORMANCE |
REOPT settings | SQLNOREOPT SQLREOPTALWAYS SQLREOPTONCE |
Statistics | SQLSTATS |
View merge | SQLVIEWMERGE |
Term | Keyword to use when searching | Comments |
Message DXRxxxxxx | MSGDXRxxxxx | Where xxxxx is the message number |
Return code xx | RCxx | Where xx is the return code, example: RCB9 |
Term | Keyword to use when searching |
Db2 Universal Driver Version 2.5.36 is provided by this APAR. | JCCV2536 |
This APAR is applicable to both JCC Db2 z/OS V7 and V8. | JCCZOSDB2V7 JCCZOSDB2V8 |
APAR deployment platform: | |
JDB7712 | JCCZOSDB2V7 |
JDB8812 | JCCZOSDB2V8 |
HDDA210 | JCCZOST4XA |
Driver-type specificity: | |
JCC common | JCCCOMMON |
Type-2 z/OS connectivity | JCCT2ZOS |
Type-4 connectivity | JCCT4 |
Type-4 XA connectivity | JCCT4XA |
SQLJ | JCCSQLJ |
Driver version: | |
JCC Version | JCCVxxxxxx Examples: JCCV251, JCCV21015, JCCV30105 |
JCC error codes: | |
See SQLCODE | |
See erqual | |
See vrace | |
General JDBC terms: | |
Java Virtual Machine | JVM |
Java Development Kit | JDK |
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"ARM Category":[{"code":"a8m0z000000075EAAQ","label":"Install and Migrate-\u003EMaintenance"}],"ARM Case Number":"","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"11.0.0;12.0.0;13.0.0"}]
Was this topic helpful?
Document Information
Modified date:
15 September 2022
UID
swg21210011