|
| Iniciado por guest, 27,jun. 2015 09:32 - 4 respuestas |
| |
| | | |
|
| |
| Publicado el 27,junio 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 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 30,junio 2015 - 14:27 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 01,julio 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. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 03,julio 2015 - 07:41 |
Hi Frans
did not cross my mind to treat it as a normal file.
Thanks
Noel |
| |
| |
| | | |
|
| | |
| |
| Publicado el 04,julio 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. |
| |
| |
| | | |
|
| | | | |
| | |
|