IBM Support

Db2 for z/OS Keywords for searching APAR text

Question/Answer


Question

This document contains keywords that you can use to optimize your search results when searching APAR text.

Answer

IBM® uses the keywords documented below in APAR text. Using these keywords when you search APARs will help you better find the APARs that you need.



Db2 FIXCAT Keywords

General DB2® Keywords

XML Keywords

Utilities Keywords

DDF Keywords

Performance Keywords

IRLM Keywords

JDBC Keywords



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 prior release of DB2 to migrate to or fallback from Db2 9 for z/OS DB2MIGV9/K
Fixes that allow the prior release of DB2 to migrate to or fallback from Db2 10 for z/OS DB2MIGV10/K
Fixes that allow the prior release of DB2 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 for Db2 Sort related issues DB2SORT/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 for the Db2 Extended RBA function. DB2EXTRBA/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 should be 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  
BiTemporal Table SQLBITEMPORAL  
case expression SQLCASE  
cast SQLCAST  
ccsid                   SQLCCSID  
CHECK CONSTRAINT        SQLCONSTRAINT  
clone tables SQLCLONE  
comment on SQLCOMMENTON  
common table expression SQLCTE  
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 more rows, less rows, wrong rows, 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 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 if they require Db2 V10.
declared temporary table SQLDGTT  
decimal floating point  SQLDECFLOAT  
delete SQLDELETE  
DENSE_RANK              SQLDENSERANK  
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 prior release of Db2 to migrate to or fall back from Db2 V9. DB2MIGV9/K  
fixes that allow the prior release of Db2 to migrate to or fall back from Db2 Version 10. DB2MIGV10/K  
fixes that allow the prior release of Db2 to migrate to or fall back from Db2 Version 11. DB2MIGV11/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
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  
private protocol SQLPRIVATE  
pruning SQLPRUNING  
range list access       SQLRANGELIST  
RANK                    SQLRANK  
reason code RCxxxxxxxx where xxxxxxxx is the reason code. 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 wait
when                    SQLWHEN  
WHERE SQLWHERE  
year SQLYEAR  

XML Keywords

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


Utilities Keywords

Term Keyword to use when searching
reason code RCxxxxxxxx
where xxxxxxxx is the reason code,
example: RC00E40090


DDF Keywords

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 also 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  

Performance Keywords

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


IRLM Keywords

Term Keyword to use when searching
message DXRxxxxxx   MSGDXRxxxxx
where xxxxx is the message number
return code xx RCxx    
where xx is the return code, example: RCB9


JDBC Keywords

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
   

Document information

More support for: DB2 for z/OS

Software version: 10.0, 11.0, 12.0

Operating system(s): z/OS

Reference #: 1210011

Modified date: 28 August 2018


Translate this page: