Most, if not all, trains from Hamburg in the Lübeck direction (inc. Ahrensburg, Bartgeheide) are loco hauled, likewise all Metronom trains from Hamburg Hbf. There's one Metronom train every hour which is diesel hauled, from Hamburg-Harburg (or Hbf, can't remember) to Cuxhaven.
A few locos are...