I had a lumbar puncture this past January and the procedure was not painful. I didn't get the expected headache, but did have some pain in my forearms and had a stiff neck. If you experience any discomfort afterwords get flat on your back, it seems to relieve any discomfort.
Good luck with your procedure. Please let us know how you make out.