PK55413: MSGINZI010E IS ISSUED WHEN DOING A SELECT ON A TABLE FROM THE DB2 CATALOG, VIEW WITH A NAME LONGER THAN 18 CHAR EXIST ON TS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• MsgINZI010E is issued when doing a SELECT on a table from the
  DB2 catalog, or when doing a physical unload on one of the
  catalog table spaces, and when a view with a name longer than 18
  char exist on one of the tables of the unloaded tablespace. This
  problems only occurs when running with DB2 V8 or V9.
  This problem occurs only on HPU 310. PB 9059
  ADDITIONAL SYMPTOMS
  1. AN HPU job receives an ABENDU1019 with the following
     error messages:
     LSCX041 **** ERROR ****
     ABEND occurred in line 377 of @@406282(IRUNH) ,offset 000540
     Extended name: inzrunhUnload
     Program terminated by operating system. ABEND code = U1019
     A non-C or system routine was running at the time of ABEND
     Calling trace:
     Function Line Offset Context
     @@406282(IRUNH) == "inzrunhUnload"
     377 000540
     @@218816(IRUN) == "inzrunRun"
     379 000B82
     MAIN(IMAIN) 775 001082
     This only fails with DB2 YES specified and works OK with
     DB2 FORCE specified.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Following are for HPU220:               *
  *                      1. Regression introduced in HPU 2.2 by  *
  *                      APAR PK53363. Fix of PB 8983 initialy   *
  *                      fixed by APAR PK51131 (S0C4 when        *
  *                      unload table with FIELDPROC in DB2 V8   *
  *                      if SQLACCESS is set to YES) occurs      *
  *                      again after applying APAR for PK53363.  *
  *                      PB 8983                                 *
  *                      2. SQLCODE -911 on the DATABASE when    *
  *                      trying to do an ALTER, DROP or CREATE   *
  *                      on an object located in the same        *
  *                      database as a TS being unloaded by      *
  *                      HPU. The PREPARE statement issue to     *
  *                      check the authority of the userid kept  *
  *                      a lock on the DATABASE during all the   *
  *                      unload. This same problem is fixed by   *
  *                      APAR PK57697 in HPU 310. PB 9038        *
  *                      Following are for HPU220 and HPU310:    *
  *                      3. msgSE180 TABLESPACE NOT FOUND or     *
  *                      other miscelaneous symptom may occur    *
  *                      when running HPU with SQLACCESS<>NO     *
  *                      against a V8 NFM DB2 subsystem, when    *
  *                      accessing objects wich name contains    *
  *                      characters that are stored on more      *
  *                      than one byte in unicode. PB 9081       *
  *                      Following are for HPU310:               *
  *                      4. Abend U1019 when processing          *
  *                      natively (DB2 NO) a very complex WHERE  *
  *                      clause (at least 150 predicates or      *
  *                      expressions). PB 6253                   *
  *                      5. In DB2 V8 CM, for tablespaces        *
  *                      created with LOCKPART NO, HPU tries to  *
  *                      issue a lock per partition, while it    *
  *                      is only allowed in V8 NFM. DB2 issues   *
  *                      a SQLCODE -240 in this case. PB 8737    *
  *                      6. When QUIESCE YES is requested on a   *
  *                      partitioned table space and at least    *
  *                      one of the partitions is in status      *
  *                      UT,COPY, this partition is left in      *
  *                      status STOP,COPY after the execution    *
  *                      of the unload. PB 9052                  *
  *                      7. MsgINZI010E issued when doing a      *
  *                      SELECT on a table from the DB2 catalog, *
  *                      or when doing a physical unload on one  *
  *                      of the catalog table spaces, and when   *
  *                      a view with a name longer than 18 char  *
  *                      exist on one of the tables of the       *
  *                      unloaded tablespace. PB 9059            *
  *                      8. Potential abend S0C4 when            *
  *                      processing natively (DB2 NO) a catalog  *
  *                      table that contains internal pointers   *
  *                      (for example SYSTABLESPACE or           *
  *                      SYSTABLES). PB 9087                     *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. Module odb2x2 was change to fix the regression.
  2. Modules INZCRXSM, INZCRXSQ, INZQUERY were changed to do a
  commit after the PREPARE and after the OPEN of the cusrsor. The
  cursor is now also prepared with the WITH HOLD clause.
  3. Module ochar was changed to process the object names on a
  number of unicode characters and not on a number of bytes.
  4. Module inzpabf was changed to calcule correcly the length
  required to process long where clause.
  5. Module oddldb2 was changed to check the LOCKPART attribute
  in DB2 V8 CM.
  6. Module oddlcmd was changed to generate the start command
  depending on the initial status of the partition.
  7. Module oddldb2 was changed to convert correcly the unicode
  names in this case.
  8. Module inzpabf was changed to process correctly the tables
  that contain internal pointers.
  

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:

  UK32783 UK32784

Modules/Macros

•    INZCRXSM INZCRXSQ INZQUERY INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R220 PSY UK32783

     UP08/01/11 P F801

• R310 PSY UK32784

     UP08/01/11 P F801

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.