IBM Support

PK62738: H, T, AND C RECORDS IN IXF EXPORTED TABLE OR DATA INCREASED TO LRECL 93 IN QMF V810 OR V910.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In QMF V8 or V9, the LRECL of H, T, and C records in IXF
    formatted exported data sets increased to 93 bytes; they
    had been LRECL 81 in QMF V7 for tables or data that had no
    no long column names.
    This causes problems with user applications that expect
    81-byte H, T, or C records.  Also, existing data sets
    created for exported tables in V7 cannot be used to
    export the same tables in V8 or V9; receive message
    DSQ22982.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All QMF for TSO and CICS V810 and V910       *
    *                 users who export tables or data in IXF       *
    *                 format.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: A QMF V7 IXF format exported file for   *
    *                      particular a table that has no long     *
    *                      column names contains H, T, and C       *
    *                      records with LRECL 81, while the SAME   *
    *                      table exported in V8 can contain H, T,  *
    *                      and C records with LRECL 93, although   *
    *                      the IXF version in the H record shows   *
    *                      0000, indicating short column names.    *
    *                      QMF documents that C records for short  *
    *                      column names will have LRECL 81.        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When long name support was added to QMF in V8, the default
    length for H, T, and C records of exported IXF format tables
    and data was increased to 93 bytes.  Prior to long name
    support, these records were 81 bytes long, thus making the
    minimum LRECL for IXF export data sets LRECL 81.  In V8, tables
    with short column name and whose D records (data records) were
    less than 81 bytes were exported with adjusted H, T, and C
    records rather than the default of 93 bytes.  However, tables
    with short column names and D records greater than 81 bytes were
    exported with the default 93 byte long H, T, and C records.
    These longer records meant files could no longer be exported
    to existing data sets that were created under QMF V7 with
    smaller LRECLs, and user applications that expected 81-byte
    records no longer worked.
    

Problem conclusion

  • IXF export code was altered to write all H and T records with
    LRECL 81, regardless of whether long column names are being
    used.  C records will have LRECL 93 only if long names are
    being used; otherwise, C records are LRECL 81.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK62738

  • Reported component name

    QMF-QUERY MGMT

  • Reported component ID

    566872101

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-03-13

  • Closed date

    2008-05-01

  • Last modified date

    2008-06-02

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

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

    UK36121 UK36122

Modules/Macros

  • DSQDEXID
    

Fix information

  • Fixed component name

    QMF-QUERY MGMT

  • Fixed component ID

    566872101

Applicable component levels

  • R810 PSY UK36121

       UP08/05/02 P F805

  • R910 PSY UK36122

       UP08/05/02 P F805

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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCWRCK","label":"QMF for TSO\/CICS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
02 June 2008