IBM Support

PH59808: INSERT SELECT - FIELD TIMESTAMP - ERROR SQL CODE -1844, SQLSTATE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • INSERT SELECT - Field Timestamp - Error SQL code -1844, sqlstate
    22008
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: ALL USERS                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: PH59808                                 *
    *                      INSERT SELECT - Field Timestamp -       *
    *                      Error SQL code -1844, sqlstate 22008    *
    ****************************************************************
    * RECOMMENDATION: APPLY PTF                                    *
    ****************************************************************
    PH59808
    INSERT SELECT - Field Timestamp - Error SQL code -1844,
    sqlstate 22008
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH59808

  • 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

    2024-02-14

  • Closed date

    2024-04-25

  • Last modified date

    2024-05-01

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

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

Modules/Macros

  • AVZCCKST AVZCCMAL AVZCGTMM AVZCUSPW AVZMTMT6 AVZO319D AVZO319N
    AVZO31AD AVZO31AN AVZO31BD AVZO31BN AVZO31CD AVZO31CN AVZO31DD
    AVZO31DN AVZO649D AVZO649N AVZO64AD AVZO64AN AVZO64BD AVZO64BN
    AVZO64CD AVZO64CN AVZO64DD AVZO64DN AVZOAUCK AVZOCKLM AVZODARU
    AVZOHOPA AVZOIO31 AVZOISTD AVZOPPA  AVZOPST  AVZORBIS AVZPB
    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 UI96671

       UP24/04/26 P F404

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:
02 May 2024