EXHIBIT 3.4.2 CONSENT, WAIVER AND AMENDMENT NO. 2 AMENDED AND RESTATED LIMITED PARTNERSHIP AGREEMENT