Operating System - OpenVMS
1748169 Members
3874 Online
108758 Solutions
New Discussion

Re: Checking the integrity of a Sybase database on OpenVMS

 
A.W.R
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 2
Craig A Berry
Honored Contributor

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.

A.W.R
Frequent Advisor

Re: Checking the integrity of a Sybase database on OpenVMS

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

 

Andrew