tbunload problems

>Sender: gregf@tfs.com (Greg Faulk) >Organization: TRW Financial Systems > >I am having trouble with the tbunload command. > >the following command: > > tbunload -t /dev/rst1 database_name > >produces this error: > > Unknown error message 0. > >We are using Online version 5.00.UC1 on a SUN 690 running SUNOS 4.1.2. > >Any help in correcting this problem would be appreciated. > Greg, This happens to me when I have a garbage number in an integer column. If, from isql, you were to unload the table (ex. output to file.dat select * from table;) you would probably get a dumb message like "data to small to fit into an int" or maybe even something more meaningful. I ended up writing a program to look for bad data, and update those columns with 0's. I believe in one case, the bad data got there by way of an unitialized structure written to the table. The other way to end up with this mess is to run out of locks (pre 5.0) and have it munge your partition. That ordeal was a long sad story, but if you want to know more, drop me a line or give me a call (602-395-1731). Naomi > > -- Naomi Walker (aka N7FSA) Anasazi Inc. Phoenix, Arizona anasaz!qip.naomi@asuvax.eas.asu.edu Imagine the Universe Beautiful, Just, and Perfect. (Messiahs Handbook)