IBM Support

PH49531: SQL EXECUTION FAILS ON SEQ DATASET INPUT S001-01

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • For a basic format sequential dataset, track calculations
    lead to an invalid track number when the MapReduce boundary
    falls at the end of a volume. This only applies to
    multivolume basic format sequential files.
    

Local fix

  • Allocate extended format files.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: ALL USERS                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: PH49531                                 *
    *                      SQL execution fails on Seq Dataset      *
    *                      input S001-01                           *
    ****************************************************************
    * RECOMMENDATION: APPLY PTF                                    *
    ****************************************************************
    PH49531
    SQL execution fails on Seq Dataset input S001-01
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH49531

  • Reported component name

    DATA VIRT MGR Z

  • Reported component ID

    5698DVM00

  • Reported release

    110

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-09-15

  • Closed date

    2022-10-14

  • Last modified date

    2022-11-01

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

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

Modules/Macros

  • AVZ$F52M AVZ$F53M AVZ$OLGS AVZCADRD AVZCDSOP AVZCTGRD AVZCTSOP
    AVZCTSRD AVZCTVRD AVZCTZRD AVZCVPAL AVZOBJ   AVZOBRSQ AVZOBRTV
    AVZOCXRU AVZODF9D AVZODF9N AVZODFAD AVZODFAN AVZODFBD AVZODFBN
    AVZODFCD AVZODFCN AVZODFDD AVZODFDN AVZODMWR AVZSFDV1 AVZSFDV2
    AVZSFDV3 AVZSFDV4 AVZSFDV5 AVZSFDV6 AVZSFWS1 AVZSFWS2 AVZSQ29D
    AVZSQ29N AVZSQ2BN AVZSQ2CN AVZSQ2DN AVZSQL9D AVZSQL9N AVZSQLBN
    AVZSQLCN AVZSQLDN AVZYSLOG
    

Fix information

  • Fixed component name

    DATA VIRT MGR Z

  • Fixed component ID

    5698DVM00

Applicable component levels

  • R110 PSY UI82842

       UP22/10/27 P F210

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":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"110"}]

Document Information

Modified date:
01 November 2022