II03560: INFO APAR TO DOCUMENT RDS KEYWORD FOR PERFORMANCE AND OTHER RDS RELATED PROBLEMS

APAR status

• Closed as canceled.

Error description

• 5740XYR00 HIM2302 HDB2210 R302 R210 R220 R230 R310 R710 R810
  THIS INFO APAR WILL DOCUMENT RDS SYMPTON KEYWORD CHANGES FOR
  COMMON WORDS ASSOCIATED WITH DB2 RDS COMPONENT.  FOR RDS KEY
  WORDS, KEYWORD WITH "SQL" APPENDED TO THE BEGINNING OF THE WORD
  WILL NOW BE ADDED TO THE APAR AS ADDITIONAL SYMPTOMS TO AID
  SEARCHABILITY.  THIS WILL NOT AFFECT THE STRUCTURED PART OF AN
  APAR AND NO CHANGES THERE ARE MADE.  THESE KEYWORDS WILL FOLLOW
  THE APAR TEXT AS:  ADDITIONAL SYMPTOMS.  SOME WORDS ARE:
  RDS KEYWORD             NEW ADDITIONAL KEYWORD
  WHERE                   SQLWHERE
  BETWEEN                 SQLBETWEEN
  IN (INLIST)             SQLIN
  AND                     SQLAND
  HAVING                  SQLHAVING
  CREATE                  SQLCREATE
  DROP                    SQLDROP
  UNION                   SQLUNION
  ORDER BY                SQLORDERBY
  GROUP BY                SQLGROUPBY
  TIME                    SQLTIME
  DATE                    SQLDATE
  DISTINCT                SQLDISTINCT
  NOT                     SQLNOT
  ALL                     SQLALL
  USER                    SQLUSER
  LIKE                    SQLLIKE
  OR                      SQLOR
  AVG                     SQLAVG
  MAX                     SQLMAX
  MIN                     SQLMIN
  SUM                     SQLSUM
  COUNT                   SQLCOUNT
  HOUR                    SQLHOUR
  MINUTE                  SQLMINUTE
  MONTH                   SQLMONTH
  SECOND                  SQLSECOND
  YEAR                    SQLYEAR
  VALUE                   SQLVALUE
  EXISTS                  SQLEXISTS
  < (LESS THAN)           SQLLT
  > (GREATER THAN)        SQLGT
  = (EQUAL)               SQLEQUAL
  + (PLUS)                SQLPLUS
  - (MINUS)               SQLMINUS
  TIMESTAMP               SQLTIMESTAMP
  ALTER                   SQLALTER
  COMMENT ON              SQLCOMMENTON
  EXPLAIN                 SQLEXPLAIN
  LABEL ON                SQLLABELON
  LOCK                    SQLLOCK
  UPDATE                  SQLUPDATE
  IS NULL                 SQLISNULL
  SQLIOP                  Parallel I/O <DEGREE(ANY)>
  SQLCPUP                 Parallel CPU <DEGREE(ANY)>  (V4)
  hybrid join             SQLHYBRID
                          SQLHYBRIDJOIN
                          HYBRIDJOIN
  outer join              SQLOUTERJOIN
                          SQLFULLJOIN
                          SQLOUTER
                          SQLFULL
                          SQLJOIN
  left outer join         SQLLEFTJOIN
                          SQLLEFT
  right outer join        SQLRIGHTJOIN
                          SQLRIGHT
  type 2 indexes          SQLTYPE2
  type 1 indexes          SQLTYPE1
  (INCORROUT)             FLDS/SQLINCORR - SEE II03953
  subquery                SQLSUBQUERY
  non-correlated subquery SQLNONCORRSUBQ
  correlated subquery     SQLCORRSUBQ
  Multi-row cursor        SQLMULTIROW  (rowset positioning)
  
  General:
  access path impact      SQLACCESSPATH <-- any/all APARs
                                            affecting access path
  SQL statistics          SQLSTATS <-- how the optimizer handles
                                       statistics
  .
  XML Keywords (added 08/04/2010)
  XML APAR (II11426)      SQLXML
  ALL                     XMLALL
  AND                     XMLAND
  AVG                     XMLAVG
  DATE                    XMLDATE
  DELETE                  XMLDELETE
  INSERT                  XMLINSERT
  NOT                     XMLNOT
  OR                      XMLOR
  ORDER BY                XMLORDERBY
  PREDICATE PUSHDOWN      XMLPREDPUSHDOWN
  SUM                     XMLSUM
  TIME                    XMLTIME
  UPDATE                  XMLUPDATE
  WHERE                   XMLWHERE
  < (less than)           XMLLT
  (= equal)               XMLEQUAL
  > (greater than)        XMLGT
  (INCORROUT)             XMLINCORR
  XML INDEX               XMLINDEXES
  ...
  THE ABOVE IS NOT MEANT TO BE A DEFINITIVE LIST AND ANY KEYWORDS
  NOT MENTIONED HERE CAN BE ENTERED AS 'SQLXXXXX'.  AGAIN, THIS
  WILL NOT AFFECT THE STRUCTURED PART OF THE APAR(EXCEPT
  SQLINCORR) AND MEANT ONLY TO BE ADDED TO THE END OF THE
  SUBMITTOR TEXT AS ADDITIONAL SYMPTOMS.
  .
  For additional keywords please see
  .
  http://www-1.ibm.com/support/docview.wss?rs=64&uid=swg21210011
  .
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• THIS IS AN INFO APAR
  RP90/02/06 TO ADD ADDITIONAL KEYWORDS.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels