marrowyung
asked on
DB2 file corruption
hi,
Did you all experienced any kind of DB2 file corruption on unix/linux OS?
Did you all experienced any kind of DB2 file corruption on unix/linux OS?
ASKER
you know from time to time MySQL has this problem.
and in Oracle 18C, they has 2x big feature, is about AI to detect file corruption and online service pack upgrade.
why, as it seems on linux file system DB is easy to have this kind of problem.
and in Oracle 18C, they has 2x big feature, is about AI to detect file corruption and online service pack upgrade.
why, as it seems on linux file system DB is easy to have this kind of problem.
The delayed writes that are typical of most modern databases can result in data corruption if the server loses power or otherwise fails before the writes have completed. A battery backup on the server is crucial to reduce the chances of a power failure/flicker causing a problem. If you've got external (SAN) storage it should be on a battery backup, too.
I've always run DB2 in commercial environments and never had to deal with data corruption. I have dealt with it with other databases and the techniques are similar, but the tools are very different between vendors.
I've always run DB2 in commercial environments and never had to deal with data corruption. I have dealt with it with other databases and the techniques are similar, but the tools are very different between vendors.
ASKER
"The delayed writes that are typical of most modern databases can result in data corruption if the server loses power or otherwise fails before the writes have completed. "
no .. what I experienced is, even it is on normal operation, it will happen to both MySQL and Oracle, that's what Oracle 18c is going to protect, they can't get ride of it and that's why they use AI to detect it and repair it automatically for us. as a selling point.
"I have dealt with it with other databases and the techniques are similar, but the tools are very different between vendors.
'
which DB are you saying . :):) it NEVER happen to me on MS SQL on an e-commerce production platform even in super stressed situation.
what file system your production using..
no .. what I experienced is, even it is on normal operation, it will happen to both MySQL and Oracle, that's what Oracle 18c is going to protect, they can't get ride of it and that's why they use AI to detect it and repair it automatically for us. as a selling point.
"I have dealt with it with other databases and the techniques are similar, but the tools are very different between vendors.
'
which DB are you saying . :):) it NEVER happen to me on MS SQL on an e-commerce production platform even in super stressed situation.
what file system your production using..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
"Both running on Windows Server."
that's why! as you might know we are considering oracle upgrade/migration to MS SQL / stay the same oracle, I suggested only on Windows server, as currently their Oracle runs on Windows...... :):)
that's why! as you might know we are considering oracle upgrade/migration to MS SQL / stay the same oracle, I suggested only on Windows server, as currently their Oracle runs on Windows...... :):)
ASKER
tks.
I've never had to deal with physical corruption (write failures) and the only time I've had logical failures was self-induced (large inserts without logging).
Do you have issues that you suspect to be corruption?
Kent