II14425: DB2 V7 MIGRATION INFOAPAR TO DB2 V8 CM/ENFM/NFM (CONTINUED FROM II14416)

APAR status

• INTRAN

Error description

• 5740XYR00 R810
  DB2 V7 MIGRATION INFOAPAR TO DB2 V8 CM/ENFM/NFM
  (Continued from II13695)
  
  FOLLOWING PTFS ARE FOR DB2 V8 MIGRATION:
  (Updated on Oct/12/2008)
  
  
    PK15146/UK12110(F603)
      Corrections and updates to the DB2 V8 premigration
      healthcheck jobs, DSNTIJP8 (shipped with V7) and DSNTIJPM
      (shipped with V8):
      (1) Report 3 incorrectly states that SELECTIVE PARTITION
          LOCKING (SPL) is deprecated in V8.  Change the wording
          to state that the LOCKPART clause on ALTER or CREATE
          TABLESPACE has been deprecated, although it is still
          supported for compatibility purposes.
      (2) Report 4 (table space candidates with truncated limit
          keys) will be discontinued.
  
    PK18164/UK11738(PE)(F603) -- by PK21827(PE)/UK14914(F606)
      There is a problem with the IDP (Index Directory Page) for
      the catalog indexes DSNSPT01 & DSNSPT02 that are built
      after migrating from DB2 V7 to DB2 V8 and then on to NFM.
  
    PK20127/UK14078(F605)
      In the migration from V7 to V8 compat mode, the TEXT column
      in SYSVIEWS is marked FOR BIT DATA. This prevents a
      non-EBCDIC application (such as Java) from doing a
      conversion on the field and makes it so it cannot be
      displayed.
  
    PK21827(PE)/UK14914(F606)
      Fixes UK11738(PK18164).
  
    PK22212/UK14724(F606)
      During migration to v8, a control block overlay occurred
      causing abendOC4 in DSNB1DCM.
  
    PK22584/UK22031(F702)
      In particular warns that during migration to V8, the
      SYSPROC.DSNWZP definition needs to be modified:
      - Users of DSNWZPR need to change the external module name
        to DSNWZP
      - Users of the DSNWZP module need specify a WLM environment
        instead of NO WLM ENVIRONMENT
      This requirement is also reported by the V8 premigration
      jobs, DSNTIJP8 and DSNTIJPM.
  
    PK23321(PE)/UK17148(F608)
      Unexpected DSNU758I message issued from REPAIR DBD utility
      or ABEND04E RC00E40601 from DSNUEXDL.
  
    PK23868/UK15046(F606)
      After customer migrating to V8, customer's java application
      stops running, it receives blank screen.
  
    PK24331/UK16572(F608)
      SQLCODE601 when trying to CREATE SYSDUMMY1 table in
      SYSEBCDC.  It had a RESTRICT ON DROP set, so it wasn't
      dropped in ENFM processing.  This can also occur for other
      catalog tables that are dropped in the ENFM process, such
      as SYSLINKS and SYSPROCEDURES. SQLCODE607 is returned when
      trying to ALTER DROP RESTRICT ON DROP for these catalog
      tables.
  
    PK24494/UK14994(F606)
      Currently, field 15 STAR JOIN MAX POOL on DB2 V8
      installation panel DSNTIP8 does not accept an entry of 0.
      It should accept any integer in the range 0 to 1024.
  
    PK25542/UK17442(PE)(F609) -- by PK34517(PE)/UK21071(F701)
      ABEND04E RC00C90101 from DSNIHPGM:500C when running REORG
      TABLESPACE DSNDB01.DBD01. This happens when the REORG is
      run from one data sharing member after the step ENFM0187
      in DSNTIJNE has completed from another data sharing member.
  
    PK25975(PE)/UK17726(F609)
      With PK07107 applied, after running REPAIR REBUILD DBD
      utility, original DBET states of objects are reset to RW.
  
    PK26764/UK16322(F607)
      After migration to V8 compatability mode, an internal field
      may have incorrect value in the OBD of index
      SYSIBM.DSNDPX01.  This will result in incorrect output from
      an index only query on table SYSIBM.SYSTABLEPART
  
    PK27526/UK16671(F608)
      After migrating to V8, SELECT from a table with decimal
      columns displays an incorrect value for the decimal columns.
  
    PK29307/UK19264(F611)
      DSNTIJNE, the catalog conversion job for DB2 V8 enabling
      new function mode (ENFM), fails due to insufficient space
      in shadow data sets allocated for user-maintained indexes
      that reside on DB2-managed storage and that are defined on
      DB2 catalog tables in table spaces affected by V8 ENFM.
  
    PK29308/UK21204(F701)
      Migration or ENFM catmaint job changed key length on a
      catalog index DSNDXX02. A LOAD RESUME was being run on
      another member that need to access SYSINDEXES through that
      index. There is a timing window that an internal control
      block was build with old index key length, but the next use
      of the control block was after catmmaint had increased
      the key length.  This caused the LOAD job abend.
  
    PK30029 (DOC)
      With DB2 Version 7, The RACF External Security Module
      (IRR@XACS) did not issue ICH408I messages when the RACF
      profile protecting the resource was in WARNING mode.  With
      DB2 Version 8 (DSNXRXAC), the ICH408I message is issued.
      This behavior was not documented as a migration
      consideration.
  
    PK34517(PE)/UK21071(F701)
      Fixes UK17442(PK25542).
  
    PK37371/UK22506(F703)
      ABEND04E DSNIMOFR ERQUAL5006 with MSGDSNI014I when running
      CATMAINT in an attempt to convert to DB2 V8 compatibility
      mode.
  
    PK37666/UK21909(PE)(F702) -- b7 PK45376(PE)/UK29761(F710)
      ABEND04E RC00E40005 during Enabling New Function Mode
      (enfm) DSNTIJNE REORG of DSNDB06.SYSSTATS due to an
      incorrect estimate of the number of rows in the table space.
  
    PK37766(DOC)
      In migration to V8, the last panel DSNTIPCitem 13, for IRLM
      LOCK MAXIMUM SPACE the value comes as 0.  The formula was
      (MAX USERS + MAX REMOTE ACTIVE) * LOCKS PER USER * 540.
      The calculation was rounded to 0 if the value was less than
      1 GB.
  
    PK41661/UK26033(F706)
      Client applications changes are necessary in order to
      tolerate the SQL Interrupt environment that DB2 z/OS V8
      server systems now support. As a result, the user is unable
      to migrate to DB2 z/OS V8 until all susceptible client
      applications can be modified to eliminate their exposure.
  
    PK45376(PE)/UK29761(F710)
      During Enabling New Function Mode (enfm) DSNTIJNE REORG
      with ptf UK21909 applied, MSGICE046A SORT CAPACITY EXCEEDED
      occurrs when REORGing SPT01.
  
    PK45722/UK27799(F708)
      The DSNH CLIST has two different input parms for BIND
      REOPT options.
  
    PK46170/UK28485(F709)
      This APAR will provide the V7 DB2 UDB for OS/390 and z/OS
      Precompiler with DB2 UDB for z/OS V8 to allow customers to
      migrate to V8 more easily.
  
    PK47893/UK21046(PE)(F712) -- by PK63288(PE)/UK36794(F806)
      Update the DB2 administrative enablement interface,
      including the administrative scheduler.
  
    PK49077/UK33785(F803)
      At least one of the trace class startup fields on the V8
      and V9 DSNTIPN (tracing parms) panel is too small to enter
      a desired combination of classes for that trace type.
  
    PK48984  (F801)  INTERNAL STRUCTURE BUILT INCORRECTLY AFTER
    MIGRATION TO V8  CAUSING 04E RC00C200BA WHEN LOADING DATA
    INTO NEW PARTITIONS AGAINST A TBS 8K OR LARGER.
  
    PK49588/UK32489(PE)(F801) -- by PK65834(PE)/UK38429(F808)
      A database is used in CM mode, and then DB2 is migrated to
      ENFM or NFM.  After migration, REPAIR DBD TEST/DIAGNOSE on
      the database may report errors shown above.
  
    PK50691/UK30825(F711)
      ZPARM ABIND=COEXIST behavior needs to be extended to apply
      to all data-sharing systems and not limited to only
      coexistence systems.
  
    PK50989/UK31536(F712)
      The sample data provided in IVP job DSNTEJ3M is not enough
      to substitute an MQT for the sample queries. As a result,
      the output of the EXPLAIN facility shows that base tables
      were used instead of Materialized Query Tables.
  
    PK51958/UK30463(F711)
      When the user executed RUNSTATS TABLESPACE SYSIBM.SYSALTER
      during ENFM mode, the utility encountered an ABEND04E
      RC00C90101 in DSNIZMOS ERQUAL:5002.
  
    PK54738/UK32702(F801)
      EIBNFM bit is NOT set ON at the completion of the migration
      from DB2 z/OS V8 Compat mode to New Function mode even
      though the new functions in the New Function mode are
      available.
  
    PK55632/UK31192(PE)(F711) -- by PK59305(PE)/UK34888(F804)
      User-defined indexes on SYSGROUP tablespace (SYSVOLUMES or
      SYSSTOGROUP table) cause abend 00D70001 in Step ENFM0067 of
      DSNTIJNE during execution of ENFM.
  
    PK59305(PE)/UK34888(F804)
      Running ENFM migration job DSNTIJNE at step ENFM0027 REORG
      DSNDB06.SYSDBASE may receive following abend:
        ABEND0C4 in DSNKISPL or DSNB1SWS
        ABEND04E RC00C90101 DSNKFRMT ERQUAL5005.
  
    PK63288(PE)/UK36794(F806)
      Fixes UK21046(PK47893).
  
    PK65834(PE)/UK38429(F808)
      Fixes UK32489(PK49588).
  
    PK66563/UK38612(F808)
      The authorization check for DISPLAY THREAD command resulted
      in ABEND0C4 with RC00000038, when DB2 is started in
      ACCESS(MAINT).
  
    PK67968/UK38776(F808)
      Corrupted LOB data in catalog tablespace SYSJAUXB after
      Unicode conversion of base tablespace SYSJAVA during
      catalog migration in V8.
  
    PK67272  (F811 )  INCORRECT DEFAULT FOR BLANK CHAR AFTER
    FALLBACK FROM V8 CM TO V7 X'0020' (CCSID 1200 BLANK), INSTEAD
    OF CCSID 1208 BLANK X'20'.   ,
  

Local fix

• N/A
  

Problem summary

Problem conclusion

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

Applicable component levels