Any body please suggest whether we can use Toad Data point queries against a DB2 located on z/OS or mainframe ?
Yes - Toad Data Point supports connections to IBM DB2 on z/OS as well as DB2 LUW.
Also in Toad Data Point, you can use an ODBC connection to connect to DB2 on iSeries.