Re: Checking the integrity of a Sybase database on OpenVMS (213 Views)
Reply
Frequent Advisor
A.W.R
Posts: 191
Registered: ‎06-01-2006
Message 1 of 3 (280 Views)

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

 
 
 
 
 
 
 
 
Honored Contributor
Craig A Berry
Posts: 495
Registered: ‎05-06-2003
Message 2 of 3 (226 Views)

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.

Frequent Advisor
A.W.R
Posts: 191
Registered: ‎06-01-2006
Message 3 of 3 (213 Views)

Re: Checking the integrity of a Sybase database on OpenVMS

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

 

Andrew

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.