PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → JNL log files size
JNL log files size
Débuté par Noel Tanti, 27 juin 2015 09:32 - 4 réponses
#1
Posté le 27 juin 2015 - 09:32
Hi All

I have a situation where the history is not being recorded any more (for one particular file in a hypersql server). I have just discovered that the JNL file has yesterday exceeded 2GB. I have now ticked the <Allow system files to excedd 2GB.

1. is there a way of reducing the size of the file without loosing the data?
2. from your experience, will the server automatically correct this issue?

Thanks
Noel
#2
Posté le 30 juin 2015 - 14:27
Any ides please?

thanks
#3
Posté le 01 juillet 2015 - 14:15
Hello Noel,

I asume dat it is an xxxJnl.Fic?

In that case you could write a simple routine that deletes the first x records.
#4
Posté le 03 juillet 2015 - 07:41
Hi Frans

did not cross my mind to treat it as a normal file.

Thanks
Noel
#5
Posté le 04 juillet 2015 - 12:14
Afaik you can just set the "2gb flag" and the files are modified without loss of data. I'm talking about the data file.
But I would try that first in a test situation to see what happens.

According the log-files this is what the help says:
Automatic data modification and log process
When the automatic modification of data files is performed on the logged files:
1.The log files are automatically saved.
2.The log files are flushed.

Why are you using the logfile in the first place? They are ment for regenerating datafiles to a given point in time, after restoring a backup.
If you need historical data (ie to see what a user changed last Friday) I always implement this myself. So I am in control of what is logged and how. Most of the time I need this for a few particular files only.
→ Revenir à WINDEV 2024