IBM Support

PH52092: INSERT INTO ORACLE RETURNS SQL RETURN CODE -302

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • -Insert Into ORACLE returns SQL RETURN CODE -302
    -Insert execute failed with SQL code -302 sqlstate 22001
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: ALL USERS                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: PH52092                                 *
    *                                                              *
    *                      INSERT execute failed with SQL code     *
    *                      -302, sqlstate 22001                    *
    *                      Insert Into ORACLE returns -302 using   *
    *                      new level in DVM                        *
    ****************************************************************
    * RECOMMENDATION: APPLY PTF                                    *
    ****************************************************************
    PH52092
    
    INSERT execute failed with SQL code -302, sqlstate 22001
    Insert Into ORACLE returns -302 using new level in DVM
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH52092

  • 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

    2023-01-23

  • Closed date

    2023-03-28

  • Last modified date

    2023-04-03

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

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

Modules/Macros

  • AVZCCAPS AVZCCUBU AVZCPRHL AVZCSWEV AVZO319D AVZO319N AVZO31AD
    AVZO31AN AVZO31BD AVZO31BN AVZO31CD AVZO31CN AVZO31DD AVZO31DN
    AVZO649D AVZO649N AVZO64AD AVZO64AN AVZO64BD AVZO64BN AVZO64CD
    AVZO64CN AVZO64DD AVZO64DN AVZOBRSQ AVZOBRSR AVZOCKLM AVZSFPAR
    AVZSQ29D AVZSQ29N AVZSQ2BN AVZSQ2CN AVZSQ2DN AVZSQL9D AVZSQL9N
    AVZSQLBN AVZSQLCN AVZSQLDN
    

Fix information

  • Fixed component name

    DATA VIRT MGR Z

  • Fixed component ID

    5698DVM00

Applicable component levels

  • R110 PSY UI91163

       UP23/03/30 P F303

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

Document Information

Modified date:
03 April 2023