Clearing out old DBISESSIONS records

[BARRY RUTHERFORD]

This past Monday our DBISESSIONS file reached 2GB on our development server and as result, became corrupted and brought down DesignBais.  I fear this could happen on our live system as well.   Does anyone know of a utility that safetly removes old DBISESSION records to prevent the file from becoming too large?

[Dick Thiot]

Are you on jBASE?  If so, which version?

Dick

[Rick Weiser]

Barry,

This should happen automatically. What version of DB are you on?

There are 2 ways to clear the DBISESSIONS file. First and safest is
to go into the Active Users menu option and click on Clear XML Log.
The second is to make sure all DB users are logged off and run a CLEAR-
FILE DBISESSIONS from TCL.

Rick

[BARRY RUTHERFORD]

To answer Mr. Thiot's question - we using Universe, not JBase.   Rick - we're using DesignBais version 4.34.  I just recently cleared the file and as I'm writing this email, no one is logged in and I have 384 records in DBISESSIONS, so obviously the records are not being cleared automatically.  Given enough users and enough time, I'm sure this number will grow to 2GB of data again.   It appears the records are date stamped - however, not in a consistent manner - meaning the date seems to appear in different places thus making it difficult to select old records for deletion.  It would be nice if the date was in the same position for all the various record types in the file.   Barry --- On Wed, 10/7/09, Rick Weiser <ri...@designbais.com> wrote:

[Rick Weiser]

Barry,

More than likely, your problem is in your login proc. DB uses the
phantom processes to purge this file. So, if the login proc does not
do the following:

IF @TTY = “phantom” THEN GO END

then the proc will try and process the TCL login and never get to the
purge.

I hope this helps,

Rick

On Oct 8, 8:55 am, BARRY RUTHERFORD <bear_h...@yahoo.com> wrote:
> To answer Mr. Thiot's question - we using Universe, not JBase.
>  
> Rick - we're using DesignBais version 4.34.  I just recently cleared the file and as I'm writing this email, no one is logged in and I have 384 records in DBISESSIONS, so obviously the records are not being cleared automatically.  Given enough users and enough time, I'm sure this number will grow to 2GB of data again.
>  
> It appears the records are date stamped - however, not in a consistent manner - meaning the date seems to appear in different places thus making it difficult to select old records for deletion.  It would be nice if the date was in the same position for all the various record types in the file.
>  
> Barry
>

> --- On Wed, 10/7/09, Rick Weiser <r...@designbais.com> wrote:

[BARRY RUTHERFORD]

No - There's no login process for the DesignBais account.  We use System Builder on our main account, so we created a seperate account just for DesignBais and then we build Q-pointers to our data files as needed.

--- On Thu, 10/8/09, Rick Weiser <ri...@designbais.com> wrote: