Log in as root (if you wish to fix errors found. Otherwise, it’s not necessary to log in as root)
#1: Shut down the PMI application /hekimian/pmint/rlsbin/stop_pmi_processes
#2: Put Informix in Quiescent Mode Type onmonitor – select Mode – select Gracful Shutdown Force a shutdown if necessary (onstat –u shows users still in db)
#3: Insure Informix is in Quiescent mode by typing the following at the Unix
command prompt: onstat - {will show the mode the database is in and the version of Informix} Informix Dynamic Server Version 7.31.UC5 -- Quiescent -- Up 12:54:03 --251360 Kbytes
#4: Execute the following commands.
oncheck –cr {will check Informix reserved pages} oncheck –cc {will check Informix system catalogs} oncheck –ce {will check and validate table extents} oncheck –cly pmint {will validate the index pages for the tables in the specified database and fix any errors} oncheck – cDy pmint {will validate the data pages for the tables in the specified database and fix any errors } onmonitor {a menu driven program to monitor or change Informix settings. errpt –a {displays the Informix error log}
ALSO, To jump right to a specific table: oncheck –cly pmint:pmiowner.history