Hi,

Can anyone help me with this error: (take it from online.log)

15:42:36 Assert Failed: next_possible_data_page:bad bitmap page
15:42:36 Informix Dynamic Server Version 7.31.UC5
15:42:36 Who: Session(51375, hnmadm@impsathnm, 21365, 172743256)
Thread(51409, sqlexec, a49a288, 1)
File: rsbuff.c Line: 2203
15:42:36 Results: affirm:"hnmadm".arg_nrt_calm_2
15:42:36 Action: Run 'oncheck -cD 2097250'
15:42:46 See Also: /tmp/af.ccb994ac, shmem.ccb994ac.0
15:42:46 Process exited with return code 1: /bin/sh /bin/sh -c /opt/informix/log_full.sh 3 1
"Table failure: 'next_possible_data_page:bad bitmap page'." "next_possib

some guys tell me that it is necesary to re-initialize all the Database.

I'll really appreciated any comments.

Thanks in advance

Have you run a oncheck -cD 2097250 yet? If you can figure out which database and table, you should try running the following.

oncheck -cDI <name of database> "informix":<name of table>

I had a lot of problems with bad data pages and/or indexes. This command will allow you figure out if it is an index problem or a data page problem. If it is an index problem, it's easy to fix. Drop and recreate the index. However, if it is a data page problem, you may have restore to another location, unload the table giving you the problems and then load a good table into production.

I hope I didn't confuse you more.

Good Luck!

Thnaks a lot, You have got the point. There was a problem with the indexes..

I just solve the problem,

Thnaks