Re: Tbcheck hangs OnLine 5.0 (UC3) engine

> I have reported this problem to Informix tech support, but I have not yet > gotten any answers, yet. The problem is that when I (we) run the tbcheck > utility to collect extents, data & index page .... information, it hangs > the OnLine engine. Tech support indicates that this problem was resolved > in release 5.00 UC1. We're using 5.00 UC3. I'm not sure what you mean by 'hanging' the Online engine. But my experience with tbcheck is that it always aborted, or get hung, or whatever when I run it on a large database (1.5 gigabytes or more). For example, running tbcheck -pe is totally useless because it generates a huge temporary file. For tbcheck options which let you specify whole database or tables, I would simply generate list of tables I want tbcheck to check, and run tbcheck on each table. This is easily done as follows: $ isql <database> - > unload to "tables" select tabname from systables where tabid > 99; > <control-d> $ IFS='|' $ while read table; do > tbcheck -pt <database>:$table > $table.pt> done < tables $ If I try to use 'tbcheck -pt <database>', I will always get ISAM error after some Nth table. Does not matter how big the database is, just how many tables you have in the database. > I cannot upgrade the server to a newer release of the software, because > it is in a production mode. I can agree with that ! We have over 100 runtime sites, and we are locked in at particular version level until we upgrade ALL sites first. We are still using Online 4.00 (gasp!!!) at sites, and I think by next week (I hope !!!) we will be getting Online 5.01 to send out to all sites world wide. The Online 4.00 was installed more than three years ago. We had to live with Online 4.00 bugs for a long, long time. > Has anyone else experienced this problem? Can I run the tbcheck utility > from version 5.02 against the 5.00 engine? How about it Informix? Is > there anyone out there? Yes, I'm pretty sure you can use 5.02 tbcheck with 5.00 engine. Try it, the worst you would get is hung tbcheck. Remember, try it on a system you can afford to lose ;-) (means you back it up, or try it on a demonstration system). > Btw, the information contained in the tbcheck utility is vital because we > are currently sizing another database which is anticipated to be about 4 > to 8 times larger. Any help is greatly appreciated! Hope I have been of some help ! -- ------------------------------------------------------- | Paul T. Pryor | Computer Data Systems, Inc | | (703) 756-8350 Voice/TDD | Falls Church, VA USA | |-------------------------------------------------------| | ptp@fallschurch-acirs2.army.mil [192.86.95.3] | -------------------------------------------------------