Hi Carla, If you are using V7 then what you want is the "db2dart" utility. It is meant to check the architectural correctness of a database and the objects in it. For example, db2dart will inspect the database page headers and row headers, and will check for things like internal structural problems. There are various options which will allow you to inspect the whole database, individual tablespaces, or individual tables. Just type "db2dart" without any options and it will show you the syntax. One important thing to note is that it is a standalone tool and it must be run while the database is offline (i.e. no users connected).
db2dart is shipped in V8 as well but there is also a new command called "INSPECT". This has some of the db2dart functionality but because it is integrated into the engine you can run it while other users are connected... and the performance is a lot better! Regards, Kelly Kelly Schlamb Database Technology, IBM Toronto Lab, Canada DB2 Online Support Website: http://www.ibm.com/software/data/db2/udb/winos2unix/support Carla Cristina Alonzo Ducl�s To: <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: br> Subject: [DB2EUG] Verify DB2 integrity Sent by: [EMAIL PROTECTED] ash.org 07/24/2003 04:52 PM Please respond to Carla Cristina Alonzo Ducl�s Hello, First, I would like to thank you for help about "db2 archive log". All answers help me a lot. I have other doubt. I'm starting with DB2 and I don't know so much about it. I would like to verify the database integrity before to do a backup. How can I do that? Is there a command to do this? I've tried to found something at google and at Command Reference Guide, but I haven't had success. Thank you very much, Regards, Carla Carla Alonzo Ducl�s Systems Administrator SoLvo - Servi�os de Miss�o Cr�tica @ www.solvo.com.br --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.495 / Virus Database: 294 - Release Date: 30/6/2003 - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
