ZUP files centralized, TMP files created

alijarte

All,

we have Navision running over TerminalServer of which we have 2 servers for the same DB.
We have centralized the ZUP files on a shared drive where they are all kept.
Taking a look at the folder, we see that along with the ZUP files, there's an amount of what I believe temporary files names like "__TEMP__.QD6" and other similar names.

Does anyone know what these files are and whether they are really temporary? Can they be safely deleted?

Any information is welcome.

Thanks,
Ch.

Marije_Brummel

One of the things they (should) contain are the temporary tables, created during run-time.

kine

They can be deleted, if all clients are closed (to prevent deleting file for running client).

kriki

kine wrote:

They can be deleted, if all clients are closed (to prevent deleting file for running client).

If they are still in use, in general they can't even be deleted.
But to be on the safe side, delete only those that are a day old.

And even better would be, that you keep the tempfiles on a local disk, this to increase performance. Tempfiles can be created when for example a big temptable is in use.

GoMaD

An example of a batch file to delete all the files in the temp folder (this batch file doesn't remove the locked files)

@echo off
IF NOT %temp% == %tmp% GOTO both
GOTO single

:both
CD %temp%
cd ..
cd temp
DEL *.* /F /S/ Q

CD %tmp%
cd ..
cd temp
DEL *.* /F /S /Q
GOTO end

:single
CD %temp%
cd ..
cd temp
DEL *.* /F /S/ Q

:end
@echo on

Can be called from inside navision by using the SHELL command.