Originally posted by: thloeber

Our managed host does not have X Windows installed or GNOME. It's RHEL 7.1 server. We have a DB2 10.5 server database with the Schema and Schema tables created and on the final step of adding this database to cluster for reporting. Since we do not have X Windows installed we have to use dbconfig.sh -console.  Step 5 in these instructions

http://www.ibm.com/support/knowledgecenter/SSVH2B_1.1.0/shared_files/reports_database_move_sym.dita

5.c says select the JDBC driver for your commercial database.  What value goes here since we cannot select from a list provided from a UI?

5.d Mentions an Example URL Format.   Where is that example?

Thanks in adance.

Originally posted by: Wing Lee

If you run the dbconfig.sh -console command, it will guide you through the process.  A list of database drivers will be available for the user to select.

./dbconfig.sh -console
Configure your database connection.

Data source name: ReportDB

User ID: [app]

Password: [***]

JDBC driver class name:
  0 - com.imaginary.sql.msql.MsqlDriver
  1 - org.hsqldb.jdbcDriver*
  2 - com.mckoi.JDBCDriver
  3 - weblogic.jdbc.mssqlserver4.Driver
  4 - org.postgresql.Driver
  5 - uk.co.thinksql.ThinkSQLDriver
  6 - org.gjt.mm.mysql.Driver
  7 - interbase.interclient.Driver
  8 - sun.jdbc.odbc.JdbcOdbcDriver
  9 - COM.ibm.db2.jdbc.net.DB2Driver
  10 - com.sybase.jdbc2.jdbc.SybDriver
  11 - com.novell.sql.LDAPDriver
  12 - oracle.jdbc.driver.OracleDriver*
  13 - com.informix.jdbc.IfxDriver
  14 - com.lutris.instantdb.jdbc.idbDriver
  15 - org.axiondb.jdbc.AxionDriver
To select an item, enter its number. Or press 16 to type a driver not in the list: [0] 12

URL of the JDBC connection : (jdbc:oracle:thin:@hostname:1521:ORCL)

Maximum connections : [30]

Press 1 to Test connection, 2 to Save and exit, 3 to Redisplay, 4 to Cancel:

For an example on the URL format, you can look at $EGO_TOP/perf/conf/driver.properties file.