General
Showing results for 
Search instead for 
Do you mean 

Checking the integrity of a Sybase database on OpenVMS

Frequent Advisor

Checking the integrity of a Sybase database on OpenVMS

We have an OpenVMS system on an Alphaserver 800. The system runs a Sybase database based application. The other day we had a failure and we were told it was because the databse was corrupt. We restored from backup.

We do not know the Sybase commands to be able to verify the integrity of the database. We would really appreciate it if someone can advise if it is possible to verify the integirty of the Sybase databse on OpenVMS and how to do it?

Thanks
Andrew
Show trimmed content

 
 
 
 
 
 
 
 
2 REPLIES
Honored Contributor [Founder]

Re: Checking the integrity of a Sybase database on OpenVMS

Typically that's done with the DataBase Consistency Checker (dbcc).  If you put "Sybase dbcc" into a search engine, you'll find lots, but the authoritative docs seem to be at http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc36272_1251/html/commands/X60179.htm.  There are examples included there.  I would start with dbcc checkdb.  These commands are ancient, so most of the options mentioned in current documentation would already be present in what you have despite the fact that Sybase was discontinued on VMS in 1998.

Highlighted
Frequent Advisor

Re: Checking the integrity of a Sybase database on OpenVMS

Thank you for your response, I will try it out.

 

Andrew