In my experience, that question is an awkward one for a surprising number of people. For some this question is awkward because they are looking for work or don't need to work. For others, this question implies that all you care about them is what they "do".
At the moment, I'm asking people "So, how do you stay busy?". This question has been the start of far more interesting conversations than "So, what do you do?".