DB2 for z/OS Keywords for searching APAR text

Technote (FAQ)


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 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
See also: http://w3.pok.ibm.com/~smpdev/fixcat/radarfc.keyword.xml


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 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 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 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
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
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
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
abend ID ABNDIDnnnn
where nnnn is the abend ID number in hexadecimal notation
abnormal termination DB2ABTERM
DB2TERM
DDF
(This keyword indicates that the APAR is a DDF-related APAR.)
DDFL09
DB2DDF
DDF Compatibility ZPARM DDF_COMPATABILITY DDFCOMPAT
distributed 2 phase commit DB2D2PC
DB2 Max Block Extra DB2MBE
DB2 DRDA Exception DB2DRDAE
hop site or intermediate servers DB2HOP
DRDA protocol DB2DRDA
inactive thread support DB2INACTIVE
See Informational APAR II12675
Open group XA transaction manager support DB2XA
private protocol DB2PRVT
SNA DB2SNA
Stored Procedures DB2SP
TCPIP DB2TCPIP
VRADC VRADCxxxx 
where xxxx is the ABNDID number that is issued when DDF abends



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

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

9.0, 10.0, 11.0

Operating system(s):

z/OS

Reference #:

1210011

Modified date:

2014-04-16

Translate my page

Machine Translation

Content navigation