Torrential monsoon rains have inundated large areas of the northern Philippines, leaving at least two people dead and six missing and halting traffic in parts of the capital for many hours.