IC64268: CALLING EXPLAIN_SQL ON HP-UX RETURNS TRUNCATED RESULT

APAR status

• Closed as program error.

Error description

• The IDS internal function "explain_sql" is used to create a
  query plan in XML style which can be processed by third party
  applications (such as IBM Data Studio) to create a visual
  explanation of that plan. When calling this function on a HP-UX
  platform the function only returns 32767 bytes. This is sample
  of a truncated file:
  
  ---------- 8< ---------- 8< ----------
  [...]
                  <descriptor id="d34" name="auser. 107_20"
  type="ids.index">
                          <datatitle
  nametitle="NAME">VALUE</datatitle>
                          <data id="0" name="Index Name"
  group="3"> 107_20</data>
                          <data id="1" name="Index Owner"
  group="3">auser</data>
                          <data id="2" name="Index Key Length"
  group="3">1</data>
                          <data id="3" name="Index State"
  group="3">E</data>
                          <data id="4" name="Index Levels in
  Btree" group="3">1</data>
                          <data id="5" name="I
  ---------- >8 ---------- >8 ----------
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * on HPIA platforms visual explain only                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The server fails to expand the buffer when needed so set     *
  * explain output gets truncated.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xC7 when available.                     *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in IDS 11.50.xC7.
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP