IBM Support

PH53580: DBCS DATA CORRUPTED AFTER MIGRATION FROM JAVA METADATA TO IMS MACB/CATALOG

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DBCS data corrupted after migration from Java metadata to IMS
    mACB/catalog
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All V15 users of IMS Catalog, DBDGEN FIELD DFSMARSH          *
    * statements or DDL CREATE TABLE statement.                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Customer has used the double byte character set (DBCS) as a  *
    * character encoding system in database schemas for non-Latin  *
    * scripts.                                                     *
    * Java Metadata Class supports the marshal attribute DBCS of a *
    * FIELD statement of a SEGM statement of a DBD definition.     *
    * Customer migration to IMS Managed ACBs discovered IMS        *
    * catalog does not support DBCS.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * INSTALL CORRECTIVE SERVICE FOR APAR/PTF                      *
    ****************************************************************
    

Problem conclusion

  • Catalog enhancement to support DBCS.
    Added the new parameter PUREDBCS=Y|N to DBDGEN DFSMARSH
    statement and PUREDBCSYES | PUREDBCSNO to DDL CREATE TABLE
    statement ims-column syntax.
    PUREDBCS specifies a DATATYPE=CHAR field in the marshall
    attribute specification.
    The new information is stored in the DBDLIB, ACBLIB, IMS
    directory, IMS catalog database.
    Updated catalog writers or readers to build or retrieve the
    information as required:
    . Catalog populate utility DFS3PU00 reads input ACBLIB and
    migrates new option to catalog.
    . Data Definition utility DFS3ID00 reads input DDL statements
    and dynamically builds new option to catalog.
    . Library builder utility DFS3LU00 reads input directory and
    builds new option back to sources.
    . Directory recovery utility DFS3RU00 reads input catalog
    databases and recovers new option back to directory.
    . Catalog API DFS3CATQ: retrieves new option from directory.
    . DB DLI API Get unique record GUR retrieves new option from
    catalog database.
    . DDL generation batch utility reads catalog and builds new
    option back to DDL statements.
    . IMS Explorer for developers E4D manages new option in catalog.
    
    IMSMGDACBS/K
    IMSDDL/K
    

Temporary fix

Comments

  • REPINNED RP25/01/16 (ATXT) TO ADD POSTREQ PH64828  INFO.
    **** PE25/01/16 PTF IN ERROR. SEE APAR PH64828 FOR DESCRIPTION
    ×**** PE25/01/14 FIX IN ERROR. SEE APAR PH64828  FOR DESCRIPTION
    REPINNED RP25/03/19 (ATXT) TO ADD POSTREQ PH65725 INFO.
    **** PE25/03/19 FIX IN ERROR. SEE APAR PH65725 FOR DESCRIPTION
    **** PE25/03/19 PTF IN ERROR. SEE APAR PH65725 FOR DESCRIPTION
    ×**** PE25/03/19 FIX IN ERROR. SEE APAR PH65725  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PH53580

  • Reported component name

    IMS V15

  • Reported component ID

    5635A0600

  • Reported release

    503

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-03-29

  • Closed date

    2025-01-02

  • Last modified date

    2025-04-01

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

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

    UI99563

Modules/Macros

  • DFSSQL10 DFS3TR10 DFSSQL30 DFSCD000 DFS3GSAM DQFHPTAB DFSFTAB
    DFS3DEDB DFS3PEX0 DFS3LOG0 DFS3DBDG DFS3GUR1 DFS3CNST DFSDDL20
    DFSIDBDX DFSMARSH DBDGEN   DFS3DDB0 DFS3DSEG FIELD    DFSSQL20
    DQFHSYMH DFS3INDX DQFHPSRV DQFHSM5B DFS3DBD0 DQFHAPLY DFSDDL10
    DFS3MSDB
    

Publications Referenced
SC276785SC276779GC276790  

Fix information

  • Fixed component name

    IMS V15

  • Fixed component ID

    5635A0600

Applicable component levels

  • R500 PSY UI99563

       UP25/01/04 P F501

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":"BU048","label":"IBM Software"},"Product":{"code":"SSEPH2","label":"IMS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"15","Line of Business":{"code":"LOB70","label":"Z TPS"}}]

Document Information

Modified date:
02 April 2025