Good news (kind of) on your transmission. How long should it last?... Much longer than 100k that's why Honda put an extended warranty on them.

The average here seems to be 60-70k for those that have had transmission problems. Don't be scared though, some members here have gotten 150k+ out of a transmission and a few have almost 200k on them. Seems to be the luck of the draw for each transmission.
I kind of feel your dealer is taking the lazy/cheap way out of your CAT issue. By resetting your code they are just basically betting the next time it comes on you will be out of warranty.

There are other issues that could cause the code you got besides just the cat. O2 sensors might need to be replaced for example. The Ody has two O2 sensors (one before and one in the cat). The computer reads these two and if the readings or not within a range between the two that codes gets tripped. So you could have an O2 sensor that's not working correctly not your cat.
With all that being said... I get that code once or twice a year. I have also replaced my cat (used an aftermarket one) and still receive that code. Since I'm no longer under any warranties I do too just reset it and go on. I am still getting great gas mileage (~25 mpg Hwy) so I have no motivation to fix what might be the real problem, my O2 sensors.
