what things can cause database curruption

[ddiamond]

I have a small test db2 8.2 database that is always getting corrupted. Any idea what we are doing that could cause this. We do a lot of bulk loads, inserts, and deletes. Should db2 be able to handle that? Are there any resource issues that can lead to corruption?

 

[gregsimpson]

ddiamond,

as Paul Horth always says

"What do you call a database with no referential integrity?

















Corrupt!!!


On a more serious note. what sort of corruption issues are you encountering?

Cheers
Greg

 

[ddiamond]

It had a couple of tables that when you try to select from them, you would get the error message "Database is damaged". At this point all users would get kicked off the database. I would then have to go to the server and manually restart the database. I then tried to check the state of the tables in question with the following statement:

SELECT TABNAME FROM SYSCAT.TABLES WHERE TABSCHEMA = 'TESTDATA';

That select statement hung the database.

Finally, I tried to drop one of the "problem" tables. This action crashed the database so badly that I can nolonger restart it. The next thing I am going to try is to drop the entire database and recreate it (luckily this database is not a production one). I am just wondering what sort of things can lead to this problem? I am a long time oracle DBA, but I am brand new to DB2 administration, so any advice would be appreciated.

 

[blom0344]

Did you perform a check on the hardware?

Ties Blom

 

[ddiamond]

No. I had assumed it is a software issue. What sort of checks did you have in mind? Normally, our network guys handle all hardware issues, but since this is a test server, it is very low on their priority list.

 

[ddiamond]

Ties,

I think you are right. I just found out that the network guys tried to reboot our test server over the weekend, and it will no-longer restart. They can't even get it to power on. So I'm guessing it is a hardware issue.

- Dan