PI12428: DSN8OD1 SAMPLE JOB HAS INCORRECT TABLE SPACE NAME.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DSN8OD1 sample job has incorrect table space name in V10 & V11:
  strcpy( (char *)utStmt,"RUNSTATS TABLESPACE DSN8D91A.DSN8S91E "
                         "PART 3 TABLE(ALL) INDEX(ALL)\0" );
  
  Change to this in DB2 10:
   strcpy( (char *)utStmt,"RUNSTATS TABLESPACE DSN8D10A.DSN8S10E "
                         "PART 3 TABLE(ALL) INDEX(ALL)\0" );
  Change to this in DB2 11:
   strcpy( (char *)utStmt,"RUNSTATS TABLESPACE DSN8D11A.DSN8S11E "
                         "PART 3 TABLE(ALL) INDEX(ALL)\0" );
  

Local fix

• Change the table space name
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2/ODBC sample job DSNTEJ80    *
  *                 and DB2 ODBC sample application DSN8OD1 in   *
  *                 DB2 10 for z/OS and DB2 11 for z/OS are      *
  *                 affected by this change.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 ODBC sample job DSNTEJ80 job step   *
  *                      PH080S04 (program DSN8OD1) ends with    *
  *                      return code 0 and the following         *
  *                      messages:                               *
  *                                                              *
  *                      DSNU054I -DSN1 hh:mm:ss.nn DSNUGMAP     *
  *                             - TABLESPACE 'DSN8D91A.DSN8S91E' *
  *                             NOT FOUND                        *
  *                      DSNU605I -DSN1 hh:mm:ss.nn DSNUSVAL     *
  *                             - ERROR OCCURRED IN ACCESSING    *
  *                             TABLESPACE DSN8D91A.DSN8S91E     *
  *                      DSNU012I hh:mm:ss.nn DSNUGBAC - UTILITY *
  *                             EXECUTION TERMINATED, HIGHEST    *
  *                             RETURN CODE=8                    *
  ****************************************************************
  * RECOMMENDATION: Apply the fixing PTF for this APAR.          *
  ****************************************************************
  DSN8OD1 is a sample C program that demonstrates using ODBC to
  call SYSPROC.DSNUTILS, the DB2 Utilities Stored Procedure, and
  process the result set from DSNUTILS.
  
  When calling DSNUTILS, DSN8OD1 passes a DB2 RUNSTSATS utility
  statement that specifies partition 3 of the table space that
  contains the DB2 sample employee table, EMP.
  
  Currently, the RUNSTATS statement specifies DSN8D91A.DSN8S91E,
  which is the database and table space for the DB2 9 sample EMP
  table.  If these objects do not exist on a DB2 subsystem that
  is running DB2 10 or DB2 11, the RUNSTATS request fails and
  DSN8OD1 outputs the error messages noted in the Problem
  Description.
  

Problem conclusion

• In response, this APAR modifies DSN8OD1 as follows:
   * In DB2 10, it changes the database and table space specified
     for RUNSTATS to DSN8D10A.DSN8S10E, which contains the DB2 10
     sample EMP table.
   * In DB2 11, it changes the database and table space specified
     for RUNSTATS to DSN8D11A.DSN8S11E, which contains the DB2 11
     sample EMP table.
  

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:

  UI16707 UI16708

Modules/Macros

•    DSN8OD1
  

Fix information

• Fixed component name

  DB2 ODBC/JDBC/S

• Fixed component ID

  5740XYR02

Applicable component levels

• RA17 PSY UI16707

     UP14/04/18 P F404

• RB17 PSY UI16708

     UP14/04/18 P F404

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.