Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Operating System - OpenVMS
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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.

Highlighted
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