|
Problem IT40125
|
Status: Closed |
FILE HANDLES CAN REMAIN OPEN EVEN WHEN INSERT INTO SELECT USING EXTERNAL TABLE WITH FILE PRESENT ON DISK COMPLETES.
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem 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. |
| Problem Summary: |
|
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.03.2022
22.07.2022
08.09.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
