VMS Catastrophic Database Errors?

Fairly regularly I hear stories about VMS database errors (across a variety of vendors). Does anyone have personal experiences?

I am a little confused about why this would happen (or at least why it seems to happen as often as it appears to be). Relational database management systems are basically a solved problem and have been so for years. While most every web applications use a database (Postgres, MySQL, SQLite, etc.), the instances of catastrophic database failures are few and far between. The same thing with DVRs, hard drives fail, power supplies fail, etc. but database issues?

Anyone with experiences or insights to share here?

Login to read this IPVM discussion.
Why do I need to log in?
IPVM conducts unique testing and research funded by member's payments enabling us to offer the most independent, accurate and in-depth information.

* *** *** *** ********* ******** ** ***** *******, ******* due ** * ***** **** ** **** *** ***** ****, or * ******* **** *****... *** **** ** ****** ***'* expect ** ***** ******** ******.

**'* * ********, *** * ******'* **** ** "************", ** just ***** *** ***** ***'* ********** (****** ** ***** ********* the ***** ****, **** *** ******** *** ****** ********), *** most ***** **'* ****** ****** ** ******* *** ******** ******* utility (******* ******** **** *** ** ***** ***** ** ********, depending ** *** ****** ** *****). ***** ****, ** ***** running * ****** ** ********** **** *** **-****** *** ********, followed ** *** ******* *******.

*** ********** ******* ****** *** * *********** ******** ******, *** certain ** *** *********, *** ***** *** * ******* **** them ****** **** ****** **** **** **** ***** ****'* ****** memory ********, ***** ****** **** ****** ********* ***** ******* *** index ****'* **** ****** ******, *** **** *** ***** **** a ****** ****** ******* *** * ******.

***'* ***** * **** **** ****** ** ******* ***** ***** would ** **** *********, *** * ******** ***** *** *** then **** ** *** ***** ***** ***** ** *** ********* Micros *******.

******* * **** *** *** **** ******** "************" ** * long ****.

John, **** ** * **** ********* *****. * **** ******** ******* * ****** ***** ** *** ******** ********** ********* ********.

*** ****** ** **** *********** **** * ******* ******* **** year.*** ****** *** ** ** *** *****-*** ****, *** *** server *** ******* *** ********** ******** *** ** ******* ** orderly ******** ** *** ******. *******, *** ******* ***** *** a ******** ********* *** (***** ****** * ******* ******) *** was *** *** *** ******* ********.

**** *** ***** **** ******** *** * **** ******* **** (hard ****** *** **** * *** ** *****), *** ******* array **** **** **** **** ********* **** **********.

****** *** ******* ****, *** **********'* **** **** **** ***** wasn't * *** ** **** **** *** ******* *****. "** contacted *** ****** *** *** ***'* ** **." * ********* the **** ******, *** **** ** ***** *********** **** ** how ** ** **. **'* * *-****** ************* ******. **** have *****-** ******* *** **** ********** ***.

*** ********** *** ** ****** ***** ******** *** ** ***** deficiencies ** *** ***, *** ** *** *** ********** **** take **** ** **.

** ******* **** **** ****, **** * ******* ******,** ******** ****** (********* ******) ***** ****** *** *** ***** database *** *********, *** **** ** *** ***** ***** *** be *****. ****, *** ***** *** ***** ** *** *****, in * ****** ********* ** ****, ***** *** ***, **** files **** **** *** ********* ** *** ********. ******* *** a ******* **** ***** ***** "********" ***** ***** *** ****** them **** **** *** ********.

* **** ** ******* *** ******* **** ***** *** ***** data ** ******** ***** ******* ** *** ********/******/***** *********** ********.

From ***** ********** ** ****, *'* *** **** "***** **** **** ** ****** *****" *** "**** ***** ****" *** *** *** ******* ****** ** ******** **********. But an experienced integrator can usually recover the data for a VMS system with a well-designed database and video file structure.

There ** ** ****** *** ****** ***** *** ** ***** *******. If it is important enough to record and retain the video for some period of time, its important enough to spend $900 or so on a good UPS.

COMPLEX ******* *******

*** ** *** **** * ***** ***, ** * ******* storage *****, *** **** ** **** **** **** *** *** elements **** ******* ** ******* ******** *** ******* ******* ** the ***** ********. **** ******* **** ******* *** ** ******** the ***********, **** *** ****** (***** *** **** * *** minutes), **** *** ********* ******, **** *** ******* ***** ** Video ***. ******* ** ******* ** *** ******* *****--*** *** have ** **** ******* ********* ******* ***** *** ******* ******** different **** *** ******** *****. ** ** ******* * **** array *** ** ******* **** *** **** **** *** ******* startup ***** * ***, *** *** *** ***** ***** ** another ******* ** *******, *** ** ** ****** * ****-******* one.

*** **** ** **** **** **** *** *** *** *** software ** **** **** ** *** ***** ***** *** **** plenty ** **** **** *** *** ******** *******. *** **** to **** *** ***** *** ******** (****** ********) ** *** UPS ** ****, *** **** *** ************* ******* *** ******* uptime **** **** *** ***** *****. ******** ***** ************ *** important, ********** **** * ***** *** ** ********.

All **** *** ** ** ****** *** ****** *** *** **** **** **** **.

** ******* **** **** *** ***** ****** *********** **** ***** outage, ***** *** *** **** ** ******* ** ********* ******* shutdown. ****** *** ******* *** ******* *** *** ** ********* power, ***** ** ** ***** ****** *** ****** **, ****** you **** ********* ****** ** ******** *****, ** ***** **** you *** ******** ***** ** ** *** * ***** *******.

MULTIPLE ****** *************

*** ******** **** *** * *** ******* *** ** ***** long, *** ** ****** *** ****** *** *** ******* ******** is. ** ** *** *** ** **** ** *** ******* power *** **** **** ****,*** *** ** ********** ** * ****** ****** ************ *** ******** *** **** *****. *** *** *** **** enough **** *** *** ****** ******* ********. **** ** ****** a ************* **** ***** *** ******* ******* *******. *** **** small ******* *** **** **** ************* ** ***** ******* ******** is *****.

** **** ** **** * **** ************* ** *** *******, nature, *** ******** ** ***** ******* **** ********* ******* ****** power. ** ****** ******** **** **** *** **** ** **** as ******-***** *********.

* ***** *** ** ***** **** ** ******* ** **** video ****** ********, ********** ***** **** ** ***/*** ********, ***** the ********* ***** ** *** ***** ** ****-********* *******. **** could **** ***** ******* ****** ***** ** * ****. ** it's ******* *** **** ************* ** ***** **** **** *** and *** **********.

**** *********** ******* *** ******* **** ** ********* ** ****** power. ***'* ** ********* *** ***** **** ** *** ****.

*** ****** ( *** **** ** * *** **** ** here, *'* * *** ****** ( *** ************ ) *** have *** ** **** *** *** ***** ), **** * dual ****** ***** *** **********. ** *** ***** *** *** database *** **** *** **** *** ******** **** ******** ****+ camera ********. ** ************ **** ** *** ******* ******** ** the ********* ****** ****** * ***** ***** **** ** ******. The **** ******** **'** **** ** *** *** ********** ***** outages ***** ** *** ***** ******, ** **** ****** ******* in *** ******. *** ******** ****** ***** ** ** **** reliable.

***********, ****, *** **** ***** ******* ** **** *** *** a **** ****** ***** :) * ** **** ** ***** a ********** **'* **** **** ********* *** ****** ** ******* for ******* *******.

***, ****, ** *** **** ***** ******* *** **** ***** of ****?

**** ** *** **** *** **** ***** ** *** ****, because ** ***'* ******* *** *** **** *** ** ***** days ** ***** *****, **** ******* ***** ** ****** **** footage *** **** * ******** ********, *** ** **** *****, nobody ***** *** **** **** ******** * ***** **** ("**, we *** * ***** *****... ***** **** **** * ****** months ***, * ***'* ******** *******...").

**** ******* **********, ** "*******" ******** (***** ****, ***** ******, etc.) ** *** ****** ****** ***** ** ******** **********. * failing ******* ** ** ******* ***, *********. *** *** ** also * *********** **** ********* ****** ** *** ***** ** strange ****. *** ** ******, ** **** ******** ******* ** an ******** ****** (***/***, *****, *** *****, ***.), *** ************ in *** **** ********** ***** ****** ******.

*** ******* **** ****** ******* ******* ******* *** **** ***** records ***** ***** ******. ******* ********** *** ****** ********** **** alerting *** ** *** ** ** ****** *** ** ******* events, **** ****** *** ** **. ******** ****************** ***************** * **** ******* ** **** -- ** ********* ********** product **** *** ******* ******* *** ******* *********, **** *** how **** **** **** ***** ***** **, *** ** **. I ******'* **** ** *** ** * ***** ****** ******* some **** ** ****** ********** *** ********. **** *** ******* situations ** *********** **** * ****** ****'* **** ******* ******** for **** ****** ** ******.

***** ******** ** *********** **** ** * ****** ***** ** include *** ***** *******, ******** *** ******* ** ***** ********** plan. ** ****'* *** ** ******, *** *** ** ** yourself.*** ** ******** ********** *************, ** ***?

"*** ******* **** ****** ******* ******* ******* *** **** ***** records ***** ***** ******."

**** **, *** ***** ***'* ****** **** *** ** ***** things *** ******* ** *** ***** ** *** ******** ******. A ******* ****** ** *** ****** **** ***** *** *** system *********, *** ******* ** *** ****** ** * ***** outage, ** ******* ******* *** ***** ******, ** ** ** was **** ** ******* ******** **** ********. ****** **** ******, similarly, **** **** *** **** ***** *** **** ******, *** what ******** ** **** ***** ****** *** *********.

*********** **** *** **** ******** ****** ***** *********, *** ** may ** ******** ** ********* ***** ** *** ********** ** disk ****** ** ********, *** ****'* *** **** **** **** circumstantial ********.

"* ******'* **** ** *** ** * ***** ****** ******* some **** ** ****** ********** *** ********. **** *** ******* situations ** *********** **** * ****** ****'* **** ******* ******** for **** ****** ** ******."

**'* * ********* ***** **** *** *** *** **... ************* we **** ********* ***** **** ******* *********** ** ***** ****** fuel ***** *** ***** ********* ****, ***** ****'** *** ******* to ******* *** **** ** *** ******* (*** **** **** would ******* **** ******** ****** ******), *** *** ******* ** install ***** *** ******** ***********. ** ******, ***** *** *** same ***** ***** * *** *** ** ******* **** *** weeks ** * **** **** * ******* *** **** **'* recording ** ****** ******, ** ****'* ******** *** *** ******* in *** **** ** *****, *** **'* **** ******* ***** someone ***** ** **** ** **** *****.

Newest Discussions

Posts Latest
6
less than a minute ago by Undisclosed Integrator #3
24
about 3 hours ago by Undisclosed #4
8
about 1 hour ago by Kevin Bennett
1
7 minutes ago by Rashid Khan
21
3 minutes ago by Michael Miller