Compression problems

I am trying to evaluate the compression in my database (using OAT) . I receive the message that the table mon__compression_estimates is not in the database. How I create this table? Anyone can help me? Informix 11.50 FC4 OAT 2.24 database: query failed - Query: SELECT first 1 est_estimate , est_date FROM mon_compression_estimates WHERE est_partnum = 1048860 AND est_date = ( SELECT MAX(est_date) FROM mon_compression_estimates WHERE est_partnum = 1048860 ) Error: -206 [Informix][Informix ODBC Driver][Informix]The specified table (mon_compression_estimates) is not in the database. (SQLPrepare[-206] at ext\\\\pdo_informix\\\\informix_driver.c:131) - C:\\\\Arquivos de programas\\\\OpenAdmin\\\\Apache_2.2.4\\\\htdocs\\\\openadmin\\\\lib\\\\database.php - 155 Celso Cabral Coimbra Administrador de Banco de Dados ClearTech Ltda "Trust at the heart of Communications" Tel. (11) 3576-4509

Regards, Celso. I had the same trouble trying to evaluate my tables, and the answer is here: -------------------------------------------------------- Unfortunately the sysmaster database does not get updated when upgrading from 11.50.FC3 to 11.50.FC4! So check with IBM on how to correct this or you can run the $INFORMIXDIR/etc/conv/rebuildsmi.sh script as user informix. Test this on your development server first, and do full backups; it should be safe and you shouldn't need to bounce the engine. Ron --------------------------------------------- Alexandre Marini Analista de Tecnologia da Informação - DBA SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW Celso Cabral Coimbra escreveu: > I am trying to evaluate the compression in my database (using OAT) . I > receive the message that the table mon__compression_estimates is not in > the database. > How I create this table? > > Anyone can help me? > > Informix 11.50 FC4 > OAT 2.24 > > database: query failed - Query: SELECT first 1 est_estimate , est_date > FROM mon_compression_estimates WHERE est_partnum = 1048860 AND > est_date = ( SELECT MAX(est_date) FROM mon_compression_estimates WHERE > est_partnum = 1048860 ) Error: -206 [Informix][Informix ODBC > Driver][Informix]The specified table (mon_compression_estimates) is not > in the database. (SQLPrepare[-206] at > ext\\\\pdo_informix\\\\informix_driver.c:131) - C:\\\\Arquivos de > programas\\\\OpenAdmin\\\\Apache_2.2.4\\\\htdocs\\\\openadmin\\\\lib\\\\database.php - 155 > > Celso Cabral Coimbra > Administrador de Banco de Dados > ClearTech Ltda > "Trust at the heart of Communications" > Tel. (11) 3576-4509 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > >