PM14259: SQLCODE-206 MAY OCCUR DURING RECOVERY PLAN GENERATION OR SLR UPDATE ON DB2 V10

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE206 may occur during recovery plan generation or SLR
  update on DB2 V10.  After migrating to DB2 V10 from an earlier
  version view creator.ARYVSLRDT00 may be missing column
  INLINE_LENGTH causing a -206.
  
  This APAR also changes sample ARYMIG84, STEP43, ICDSN DD from
  '#SSID.IC.#DATABASE ARYVRTS2.N1001' to
  '#SSID.IC.#DATABASE.ARYVRTS2.N1001'.
  

Local fix

• Drop and recreate view creator.ARYVSLRDT00 using the DDL in
  sample ARYDDLX1.
  DROP VIEW #CREATOR.ARYVSLRDT00;
  COMMIT;
  
  CREATE VIEW  #CREATOR.ARYVSLRDT00
    AS SELECT *
    FROM #CREATOR.ARYDATATYPES;
  COMMIT;
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Recovery Expert for Z/OS.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE206 may occur during recovery    *
  *                      plan generation or SLR update on DB2    *
  *                      V10.  After migrating to DB2 V10 from   *
  *                      an earlier version view                 *
  *                      creator.ARYVSLRDT00 may be missing      *
  *                      column INLINE_LENGTH causing a -206.    *
  *                      This APAR also changes sample ARYMIG84, *
  *                      STEP43, ICDSN DD from                   *
  *                      '#SSID.IC.#DATABASE ARYVRTS2.N1001' to  *
  *                      '#SSID.IC.#DATABASE.ARYVRTS2.N1001'.    *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK57170

Modules/Macros

•    ARYMIGX3 ARYMIG84
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R220 PSY UK57170

     UP10/05/26 P F005

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.