D3 will only go up into third gear, and will not shift up any higher. 2 will do the same, only shifting up to 2nd gear. I have a 2000 Accord, and I'm pretty sure that's what mine do.
It can help to slow you down when going down hills. Thats what I use it for sometimes.