Using dbtool whilst users are in the database

Drammy

Drammy

Member
Hi all,

I need to update the SQL Field widths whilst users are connected to the database.

Am I safe to run dbtool (option 2) whilst users are connected to a V10 database?


Thanks,
Drammy
 
Yes you are perefectly save.
Although you are more then likely facing a degradation in overall performance since dbtool has lots of work to do in a very short time... :-)

Casper.
 
I've run dbtool and am getting an error saying that the cache has a different time stamp and that it will read the cache from the database instead.

How do I re-cache the schema?
 
You mean clients het this warning? I suppose itis not dbtool which gives this warning.

You can make new schema file by using the following statement:

SAVE CACHE COMPLETE <DatabaseName> TO <CacheFile>.
All clients have to get the generated file.

Casper.
 
Sorry, yeah the clients are now getting this warning. DBTool ran without any errors.


Should I be recaching the schema every time dbtool amends SQL field widths?
 
You must log in or register to reply here.
Back
Top