You mean nightmares?

I have nightmares about serial killers a lot. :( When I try to attack somebody in my dreams my arms and legs move like mollasses and I can barely tap them.

Why are you assuming he's self-medicating? A sleeping medication that would cause symptoms like that is more than likely an Rx that his doctor prescribed. It sounds like he was given a medication he had never been on before when he experienced this. A smaller dosage may or may not work depending on what drug it is. He should definitely be calling the prescribing doctor as soon as the office opens though to get it straightened out ASAP.

I am probably digging a larger grave here but here goes nothing... OP mentioned that he would stop taking the medication which by abruptly stopping doesn't follow the prescription which from there makes it self medicating...

Stopping a medication is not self-medicating. It only takes one dose for someone to have a poor reaction. You can't self-medicate with a medication you're not taking. Self-medicating refers to people who either take more medication than prescribed or take a medication that hasn't been prescribed to them. So say OP has a prescription for a sleep aid, such as Ambien, and his prescription says "1 tablet at bedtime". If he follows the directions on his prescription and only takes 1 tablet at bedtime, that isn't self-medicating. It only becomes self-medicating if he starts taking more than 1 tablet or taking it more often than just bedtime. Or if his doctor refused to give him a re-fill and he started buying it illegally.