IBM Support

IT40125: FILE HANDLES CAN REMAIN OPEN EVEN WHEN INSERT INTO SELECT USING EXTERNAL TABLE WITH FILE PRESENT ON DISK COMPLETES.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as suggestion for future release.

Error description

  • When an INSERT INTO SELECT statement containing multiple joins
    operations on EXTERNAL TABLE is performed then we
    can see file handles on that table remaining even after session
    close.
    This behaviour is seen only when we are running the query with
    PDQPRIORITY set and server is running multiple CPU VPs.
    If the customer is running on UNIX servers like AIX and the
    external file is located on an NFS file system, then the problem
    arises after the user disconnects and they remove/delete the
    external file.  Because the file did not have an appropriate
    close op, the F/S will create an .nfsxxx file
    which might be large and therefore consuming a lot of space.
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • Ther original fix caused a regression. Please refer to
    idsdb00110923 (12.10) and idsdb00110747 (14.10).
    

APAR Information

  • APAR number

    IT40125

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED SUG

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-03-02

  • Closed date

    2022-07-22

  • Last modified date

    2022-09-08

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

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

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]

Document Information

Modified date:
08 September 2022