Connecting to a mainframe – methods that work for queries

We currently use IDMS-SQL over ODBC (CA drivers)to connect to a mainframe and run queries. (Don’t know what kind of mainframe. Am trying to find out.) The CV100 on the mainframe goes down frequently and we lose connection. Do other people have this problem? What other methods do people use to connect?