Thanks for your query.Based on the facts that you have posted it appears that your brother has Diabetes
and mental problems.
He has two episodes of urinary retention
for which he was catheterised.
Looking at the reports of investigations that you have posted He has got Benign Enlargement of Prostate which needs to be treated .
Please consult qualified Urologist
for clinical evaluation and further treatment.
He may need to undergo surgery of TURP which will help to resolve his problem permanently,else he has to continue taking Tomsulosin.