On the other Database server (DevDB) I am able to see the files on the OS as
they are created and populated.



On the ProdDB I don't see any files. If that is how it should work then
there is no problem. I thought that there was something wrong because it
wasn't showing on the OS as in the other Database.



Thank You,



Ed Mendez



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Dimitry Sibiryakov
Sent: Monday, March 08, 2010 2:45 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird 2.1.1 and Global Temporary Tables





08.03.2010 17:33, Edward Mendez wrote:

> The issue is with ProdDB.
>
> On ProdDB we have implemented GTTs, but the Operating System files are not
> getting created at all. We have run the Queries in IbExpert and the
> Performance Analysis shows that GTT is being populated. The GTT was

created

> as "On Commit Delete Rows".
>
> fb_inet_s 7508 root 5u REG 253,2 131072
> 65830917 /tellidata/db/tmp/fb_table_tIDBVP (deleted)
>
> But when I do an ls on the directory I do not see the files.
> Any help is appreciated.

But what's the problem? Files for GTT are created pre-deleted for
security reason.

--
SY, SD.





[Non-text portions of this message have been removed]