IBM Support

IT37426: DBIMPORT -D AND AUTOLOCATE DO NOT WORK CORRECTLY TOGETHER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When specifying the -d option in dbimport, the intent is to
    control where the entire database is stored.  However, if
    AUTOLOCATE is enabled then only the system catalogs will for
    sure make it in the dbspace specified by -d.  The other database
    objects will go where AUTOLOCATE wishes, likely defeating the
    user's wishes.
    

Local fix

  • To circumvent this behavior, temporarily disable AUTOLOCATE:
    onmode -wm AUTOLOCATE=0
    Then enable when done with dbimport:
    onmode -wm AUTOLOCATE=1
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Server prior to 14.10.xC7.                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Informix Server 14.10.xC7.                        *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix Server 14.10.xC7.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT37426

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-06-25

  • Closed date

    2021-11-02

  • Last modified date

    2024-11-10

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

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

Fix information

  • Fixed component name

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 November 2024