PQ99206: DB2 V 8 THE ERROR IS, DSNT SQLCODE206 AUO@IOIC ARE MISSING.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When selecting option IC from the AUO main panel, user's may
  experience a SQLCODE805 stating that packages AUO@IOSC and
  AUO@IOIC are missing. This error occurs only on a DB2 Version 8
  NFM subsystem that has been migrated from V7.
  
  For additional clarification:
  * Anyone who built a V8 NFM repository before
    this PTF was issued will need to rebuild the
    index as non-unique evidenced if they run into -803.
  
    Please do as the HOLD ACTION from PTF UQ97079 describes:
  
    "Users will need to drop UNIQUE
     index AUOVR.X01_SYSCOLUMNS and recreate it
     as non-unique with the new AUO#DDL8 supplied
     in the SAUOSAMP library and
     then reload the repository using AUOVRUPD member"
  
     This is regardless of whether or not the repository
     was upgraded from v7 or built new from scratch on
     a v8 nfm system.
  
  Other keywords:
  sqlcode803
  

Local fix

• The following ZAPs should fix this problem:
  //AUZAP JOB ,AUOZAP,CLASS=A,MSGCLASS=X,NOTIFY=&SYSUID
  //ZAP3 EXEC PGM=AMASPZAP
  //SYSPRINT DD SYSOUT=*
  //SYSLIB DD DSN=AUO.PRODUCT.LOADLIB,DISP=SHR
  //SYSIN DD *
    NAME AUO$MAIN AUO$MAIN
    VER 1610 9180A977
    REP 1610 9140A977
    VER 1578 9180A977
    REP 1578 9140A977
  /*
  //ZAP2 EXEC PGM=AMASPZAP
  //SYSPRINT DD SYSOUT=*
  //SYSLIB DD DSN=AUO.PRODUCT.LOADLIB,DISP=SHR
  //SYSIN DD *
    NAME AUO$D8TB AUO$TBR8
    VER 03F8 D40E9180
    REP 03F8 D40E9140
  /*
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Restore.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: When selecting option IC from the AUO   *
  *                      main panel, user's may experience a     *
  *                      SQLCODE805 stating that packages        *
  *                      AUO@IOSC and AUO@IOIC are missing. This *
  *                      error occurs only on a DB2 Version 8    *
  *                      NFM subsystem that has been migrated    *
  *                      from V7.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  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:

  UQ97079

Modules/Macros

•    AUO$D8TB AUO$MAIN AUO$TBR8 AUO#DDL8
  

Fix information

• Fixed component name

  DB2 OBJECT REST

• Fixed component ID

  5655E7201

Applicable component levels

• R210 PSY UQ97079

     UP05/02/01 P F501

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.