It depends. DB2 comes in several editions. The DB2 that IBM mostly sells nowadays is ok but there's also DB2/400, which -as the name suggests - comes with all sorts of quirks and funny mainframey limitations.

Big banks still use it.