VLDB maintenance questions

[groovin]

I've been having lots of problems in Brightstor Arcserve v9 for NT. I think its the database being inconsistant. After a job runs, the media pools disappear and don't come back until I've restarted the db engine. Also, the logs show "unable to open/write to database" errors.

I looked at all the VLDB maintenance utility articles on support.ca.com, and all of them suggest using the dbcheck as follows:

dbcheck -a -L casdb;admin;secret DBNAME

where DBNAME is asjob, asmedia, astpstat, etc...

but when I look in my database folder, I see many many files named:

astpsdat.dbd, astpsdat.000, astpsdat.001,....,astpsdat.020, asmedia.dbd, asmedia.001 and so on.

So when I try to run dbcheck -a -L casdb;admin;secret asmedia for example, I get an error saying it cannot find that database. Do I need to run dbcheck on each dbd and .00* file in that folder?? why are there so many of these .00* files in the first place?

Thanks

 

[davidmichel]

asmedia is the name you would use, and not asmedia.001.
There are so many because that is the way this database works. Take a look in the FAQ section. See faq478-3985 for background data on the database file types. There should be an error code when the command fails, see faq478-3982 for a list of the ones I have been able to reproduce and figure out.

 

[groovin]

thanks for the reply...

i just got a -2005 and according to the list you provided, it seems to be the wrong server name. I'll experiment with it a bit as soon as the tape library finishes its run (in a few hours).

 

[groovin]

i tried again, but i get the following:

E:\Program Files\CA\BrightStor ARCserve Backup>dbcheck -a -L server:administratorassword asmedia

DBCHECK Utility - Velocis 2.1.410 [12-Mar-2001]
Copyright (c) 1992-2001 Centura Software Corporation. All Rights Reserved.

Enter your userid: administrator
Enter your password: ********
Failed to log into server 'server:administratorassword', username 'administrator: error -2005.

I am not sure which user and password it's asking for. the one I used it the domain admin account which I believe brightstor was set up with.

 

[davidmichel]

Your original command was probably correct except for the server name. Exchange casdb with arcserve. BTW there should be a vldm readme in the ARCserve home directory.

 

[pmdye]

I'm having an almost identical problem; I've tried using both casdb and arcserve for the database name parameter to dbcheck, and getting error 2005 every time. The velocis.ini file says "ServerName = CASDB", so I'm pretty sure it's that.

Anybody have any ideas?

 

[davidmichel]

Are you using this format?
dbcheck -a -L casdb;admin;secret DBNAME

 

[pmdye]

Yep, exactly (where DBNAME is astpstat).

 

[pmdye]

Hmmm, it appears that a server reboot (for other reasons) has solved the problem; dbcheck is running now.

If it comes back with stuff I can't deal with, I'm sure I'll be back...

 

[groovin]

i had inconsistencies in my vldb database but rather than run the utilities i migrated the dbase to sql server. everything runs great now. sql pretty much takes care of itself (well, at least the way we have it running) so i dont have to worry about using these utils every so often. many thanks to all those that gave me advice on migrating it!

 

[davidmichel]

Personaly I wish they would dump the Velosis VLDB and go to MySQL. I'm not a database guru but from what I've seen it is a pretty solid database, and as Open Source cheap.