IBM Support

IT11018: WMQ MFT 7.5: SQL FILES ARE MISSING WHICH WERE INTRODUCED UNDER APAR IC86215

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Several ".sql" files are missing after a fix pack has been
    installed which contained the code change for APAR IC86215. The
    files were added as part of the APAR's code change.
    
    These missing files are:
    
      ftelog_tables_zos_bigint.sql
      ftelog_tables_zos_bigint_int-bigint.sql
    
    The original APAR IC86215 was targeted for 7.5.0.1, however the
    files are not installed by fixpacks which contain this APAR.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    This issue affects users of WebSphere MQ Managed File Transfer
    Version 7.5, who are using a database logger with a DB2 database
    which is hosted on a z/OS system.
    
    
    Platforms affected:
    MultiPlatform
    
    ****************************************************************
    PROBLEM DESCRIPTION:
    The files to create and migrate database tables using BIGINT
    were added to WebSphere MQ Managed File Transfer v7.5 under APAR
    IC86215. However these files were not added to the appropriate
    fix pack ship list, which resulted in them not being added to
    the fix pack installation bundles.
    
    The consequence of this is that the files were missing from the
    fixpacks which were intended to add the files to a WebSphere MQ
    Managed File Transfer installation.
    

Problem conclusion

  • The files to create and migrate database tables using BIGINT
    have been added to the fixpack ship list, and so will now be
    installed as part of the fixpack installation.
    
    ---------------------------------------------------------------
    The fix is targeted for delivery in the following PTFs:
    
    Version    Maintenance Level
    v7.5       7.5.0.6
    
    The latest available FTE maintenance can be obtained from
    'Fix List for WebSphere MQ File Transfer Edition 7.0'
    http://www-01.ibm.com/support/docview.wss?uid=swg27015313
    
    The latest available MQ maintenance can be obtained from
    'WebSphere MQ Recommended Fixes'
    http://www-1.ibm.com/support/docview.wss?rs=171&uid=swg27006037
    
    If the maintenance level is not yet available information on
    its planned availability can be found in 'WebSphere MQ
    Planned Maintenance Release Dates'
    http://www-1.ibm.com/support/docview.wss?rs=171&uid=swg27006309
    ---------------------------------------------------------------
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT11018

  • Reported component name

    WMQ MFT

  • Reported component ID

    5724H7242

  • Reported release

    750

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-09-01

  • Closed date

    2015-11-13

  • Last modified date

    2015-12-07

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    WMQ MFT

  • Fixed component ID

    5724H7242

Applicable component levels

  • R750 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSCUHLE","label":"WMQ Managed File Transfer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
07 December 2015