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