topic Re: Checking the integrity of a Sybase database on OpenVMS in Operating System - OpenVMS

Checking the integrity of a Sybase database on OpenVMS

A.W.R — Fri, 28 Mar 2014 12:36:25 GMT

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

Re: Checking the integrity of a Sybase database on OpenVMS

Craig A Berry — Tue, 01 Apr 2014 18:19:38 GMT

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.

Re: Checking the integrity of a Sybase database on OpenVMS

A.W.R — Wed, 02 Apr 2014 09:39:59 GMT

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

Andrew