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

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)
  
  
    PQ48486/UQ81009(F310)
      This APAR must be applied to allow fallback to DB2 Version
      7 Release 1 of DB2(7.1) after a migration to DB2 Version 8.
  
    PQ62695/UQ72083(PE)(F212) -- by PQ72453(PE)/UQ79255(PE)(F308)
      New functionality is needed to provide a uniform view of
      metadata information from the DB2 catalog, for use by the
      the DB2 Universal Driver.
  
    PQ72453(PE)/UQ79255(PE)(F308) -- by PQ78165(PE)/UQ80515(F310)
      This APAR addresses several errors in the DB2-provided
      Metadata Stored Procedures that were originally delivered
      in APAR PQ62695.
  
    PQ78165(PE)/UQ80515(F310)
      Modifications by PQ72453/UQ79255 to install job DSNTIJSG,
      step DSNTIRU, updated 12 BIND PACKAGE statements for
      collection id DSNASPCC, inadvertantly omitted the command
      continuation character, in each case in the line preceding
      the one that contains the LIBRARY keyword parameter.
  
    PQ84421/UQ85439(F403)
      Add DSNTIJP8 to identify conditions in DB2 V7 catalog that
      need to be corrected before you begin migrating to DB2 V8.
  
    PQ86134/UQ88217(F405)
      After V7 to V8 migration, user receives SQLCODE904, reason
      code RC00E7009E when trying to reference certain views.
  
    PQ86572/UQ87166(F404)
      DB2 ABEND 04E-00C90101 LOC=DSNIRCCS:5065
      after ENFM job is completed.
  
    PQ86628/UQ93023(F410)
      DSNTIJMC, job step DSNTIRU, ends with return code 8:
        DSNT408I SQLCODE = -407, ERROR: AN UPDATE, INSERT,
                 OR SET VALUE IS NULL, BUT THE OBJECT COLUMN
                 TABLE_NAME CANNOT CONTAIN NULL VALUES
  
    PQ88888/UQ90623(F407)
      DSNTIJP8 & DSNTIJPM ends with code 8 in job step UNLOAD
      (IKJEFT01, DSNTIAUL).
  
    PQ89409/UQ93024(F410)
      NEW CHANGES FOR DSNTIJMC AND DSNTIJSG
  
    PQ90772/UQ91069(F408)
      This APAR fixes two problems:
      1. CATMAINT filled in incorrect text for message DSNU777I.
      2. CATENFM START did not block the execution of DSNTIJNE
         job when system is already in New Function Mode.
  
    PQ92083/UQ94063(F411)
      After enabling datasharing for DB2 V8, the DSNTIJUZ job
      was being modified incorrectly for any subsequent members
      that were being added to the datasharing group.  DSNTINST
      did not delete the linkedit control cards for DSNZPARM,
      which leads to a linkedit error when running newly
      customized, 'bad' copy of DSNTIJUZ.
  
    PQ92130/UQ93543(F410)
      ABEND04E RC00E40601 DSNUECM5 +34F4 with key D0=00C90607
      during catmaint after correcting problem due to rc00D70014
  
    PQ92958/UQ93272(F410)
      ABEND04E-RC00E2002A in DSNSFB+01DE during catalog
      migration.
  
    PQ95043/UQ93915(F410)
      DSNTIJSG does not warn users of DBCS-enabled systems who
      are migrating to DB2 Version 8 to expect SQLCODE -130 from
      BIND PACKAGE(DSNASPCC) statements when running job step
      DSNTIRU.
  
    PQ97172/UQ96520(F501)
      When running the DSNTIJNE job, step ENFM0001 results in
      ABEND0C4 RC0000004 in module DSNUECM0.
  
    PQ97816/UQ95698(F412)
      The DSNJCNVB BSDS conversion utility fails with
      MSGDSNJ212I and MSGDSNJ261I.
  
    PQ98462/UK04897(F507)
      The SYSUT1 DD of IVP job DSNTEJ6R job step PH06RS00
      intakes instream data and specifies DLM='AA' as the
      terminator. However, the data is not terminated with AA.
      This can result the remainder of the job being treated as
      input to SYSUT1. Also, query/report 23 of V8 premigration
      jobs DSNTIJPM (ships with DB2 V8) and DSNTIJP8 (ships with
      DB2 V7) needs to be clarified to indicate that it always
      reports the collection ids for all routines that use the
      DBINFO control block, even if you have already rebound the
      packages.
  
    PQ99507/UK00290(F502)
      Abend04E RC00C90202 DSNIPOSP ERQUAL5004  during CATMAINT
      MIGRATION to V810.
  
    PK00824/UK02275(F504)
      ABEND04E RC00C90101 IN DSNGEPLC ERQUAL5004 when DB2 tries
      to load and run packages after the REORG of SPT01 as part
      of the ENFM process.
  
    PK01445/UK04082(F506)
      This APAR makes 4 DB2-supplied stored procedures
      DB2_INSTALL_JAR, DB2_REPLACE_JAR, DB2_REMOVE_JAR, and
      DB2_UPDATEJARINFO available in DB2 V7. It also modifies
      DB2 installjob DSNTIJSG and CLIST member DSNTINS1. It adds
      an optional install job DSNTIJDJ for existing DB2 V7
      installations.  It modifies CLIST member DSNTINS1 for V8
      and does similar changes to V8 customization center DSNCIM
      for workstation-based users.
  
    PK02428/UK01775(F504)
      Abend04E RC00C90207 DSNIOW ERQUAL5002 during CATMAINT for
      V8
  
    PK04270/UK04292(F506)
      ABND=0C4-00000010,LOC=DSNLZLLM.DSNLZOSR+398E occurs due to
      a long running application connected to V7 system.  The
      DB2 system where the application is located has retained
      information and after upgraded to V8, the application
      re-connects to the upgraded system.  But, the DB2 system
      incorrectly uses the V7 information to communicate with
      the upgraded server instead of refreshing the information
      with the new server attributes.
  
    PK04726/UK03051(F505)
      After running the DSNTIJNE job to convert SYSVIEWS
      tablespace to New Function Mode, some entries of the
      SYSVIEWS.TEXT column were truncated.
  
    PK04997/UK03365(F505)
      Running Catmaint on V8 using other than the default ebcdic
      CCSID can cause links in SYSDBASE to be broken.
  
    PK05198/UK06864(F509)
      Improve data sharing migration to V8 while in a
      coexistence environment when using DB2 Connect connection
      concentrator.
  
    PK05421/UK03239(F505)
      A REORG of a catalog or directory tablespace with links in
      V8 ENFM can cause catalog and directory tablespace data to
      be lost.
  
    PK06196/UK04275(F506)
      When DB2 z/OS V8 is in compat mode, disable the Get
      Diagnostics capability at the server.
  
    PK06413/UK05959(PE)(F508) -- by PK23321(PE)/UK17148(F608)
      CATMAINT utility received ABEND04E RC00C90101 in
      DSNIRCCS:5065 during migration to DB2 V8.
  
    PK06697/UK12978(F604)
      Sysplex load balancing stops during the process of
      migrating a Data Sharing Group from V7 and V8 Coexistence
      to V8 NFM.
  
    PK07002/UK05926(F508)
      This APAR addresses the problem by using the EBCDIC CCSID
      from the  installation-defined DSNHDECP module to convert
      the SYSADM, DEFLTID, SYSADM2, SYSOPR1, SYSOPR2, RGFCOLID,
      RGFNMPRT, RGFNMORT, and RLFAUTH parameters to Unicode.
  
    PK07107/UK05955(PE)(F508) -- by PK25975(PE)/UK17726(F609)
      RC00C20103 and RC00C20206 on restart of DSNTIJTC after
      previous DB2 crash while running the DSNTIJTC CATMAINT
      migration job.
  
    PK08508/UK07720(PE)(F510) -- by PK15951(PE)/UK10183(F512)
      When running the DB2 V8 premigration checkout jobs
      (DSNTIJPM in DB2 V8 and DSNTIJP8 in DB2 V7), customers who
      maintain a shadow catalog with the same table and index
      names as the DB2 catalog will receive an incorrect list of
      user-defined indexes on the DB2 catalog that reside on
      user-defined storage.
  
    PK08982/UK05759(F508)
      DSNTWR, the external module for the WLM_REFRESH sample
      stored procedure, currently sets the migration id attribute
      when activating an Extended MCS Console.  This attribute
      will be removed in a future release of z/OS.
  
    PK11058/UK09579(F512)
      During the migration process of V8 CM to V8 NFM, the CCSID
      setting for catalog tables was set incorrectly.
  
    PK12280/UK08355(F511)
      ABEND0C4 DSNXGRDS.DSNXOATV+1B28 occurred on an ALTER TABLE
      statement that alters the data type of a column.  In
      addition to the ALTER TABLE statement, this problem can
      occur when views are processed during migration by the
      CATMAINT utility.
  
    PK12595/UK09351(F512)
      Due to a storage handling problem, running REPAIR DBD could
      receive an ABEND04E with RC00E40600 in some cases.
  
  
    PK15951(PE)/UK10183(F512)
      DB2 UDB for z/OS Version 8 installation CLIST (member
      DSNTINS3) does not edit the subsystem name / subsystem id
      (SSID) parameter for DSNTIJNE job step ENFM009A EXEC
      PGM=DSNTICPS.
  
    PK14064/UK09842(F512)
      DSNKINSN ERQUAL 5002 abend following an ALTER of an
      associated table. This problem can occur after migrating
      from DB2 version 5 or a prior release to version 8.
  
    PK14817/UK10478(F601)
      The REORG TABLESPACE Utility on a linear tablespace that
      contains at least 1 table created prior to DB2 V4, abends
      with ABEND04E RC00E40319 in DSNURFIT.  This problem occurs
      after migration from V7 to V8.
  
    PK14444/UK09128(F511)
      During editing of job DSNTIJSG, the DB2 installation CLIST
      halts in EDIT mode after the following message is issued:
        IKJ56500I SUBCOMMAND COMMIT NOT FOUND
  

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