2004 Mazda 6 diagnostic code PO174

P0174= System too lean bank 2,
You may have a vacuum leak, get a can of spray gumout, spray the vac lines and maniflod area, when the idle changes, youve found the leak! You want the engine running and spray on the outside but do direct the stream onto the hoses, if it is a vacuum leak, the engine idle will change speed, then you have detected a leak, repair the vacuum leak and see how it runs! If that doesnt do it, you may need a new idle air control valve, it's bolted to the throttlebody
After the right number of drive cycles it will reset.