Datasource Class Name For Db2







In the case of DB2 you would have multiple files, one for the driver and two additional files. IBM DB2 LUW IBM DB2 LUW 8 and 9 IBM DB2 UDB Client for Windows 7. 3 - DB2 UDB 7 - Windows NT I'm trying to configure Tomcat to set up a DB2 data source by using t NoInitialContextException Using DB2 Data Source and JNDI - General e-Business discussion - Tek-Tips. See IBM's site for more information. Steps: Download the driver pack from IBM. Exception: COM. The ODBC IBM DB2 Driver configuration dialog opens. In the Saving Information dialog, enter a Data source name (e. driver-class-name = com. These examples are extracted from open source projects. IBM DB2 Database Type 2 DataDirect JDBC Driver. This package includes the following class and abstract interfaces: • DriverManager. The JNDI style is typical when using an application server or a web container. The drivers are compliant with Type 4 architecture, but provide advanced features that define them as Type 5 drivers. Unzip the downloaded archive. Class DataSource. For exception and spring. Connecting to a data source using the DriverManager interface with the DB2 Universal JDBC Driver. hostname is the name of the machine that runs the Oracle database. DB2 operational database solutions provide the right data foundation with on-premises and cloud deployment options, best-in-class data compression, robust performance for mixed workloads, modern data security and the ability to scale and adjust without redesign. DataJoiner users: this situation can be detected by DataJoiner or by the data source. Java DataSource and JDBC DataSource programming is the way to work with database in our java programs. The Server key value syntax is a server name / ip address and an optional port number (note the : in between). ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [Answered] RSS 4 replies Last post Aug 18, 2010 12:52 AM by xangth2008. So your lov would work even with just one column with the datasource name and there would be no need to change such lovs. Killing off all remaining connections in the connection pool. when setting up the data source. Accessing multiple databases in enterprise applications can be a challenge. The name of the class is COM. The fully qualified class name of the XA datasource class The datasource deployment schema is defined in doc/datasources_1_0. Here is detailed steps of how to setup the JDBC Universal Driver setup in the SQuirreL SQL Client. How to Configure JDBC Datasource (JNDI) in Tomcat 7 with DB2 in Ecplise Example. restart listenerlsnrctl stop lsnrctl start 12. Also make sure that database driver is present in the tomcat lib directory, so in this case mysql jdbc jar have to be present in the tomcat lib. It is a simple blueprint application that shows and updates the content of two Derby databases in a single atomic transaction controlled via the JTA API. How to Configure Multiple Datasources with Spring Boot April 19, 2017 March 5, 2018 javaoptimum In this tutorial I will show you how to connect a Spring Boot application to multiple datasources and create respective entity and repositories. xml without intereference with each other. In the following sample odbc. where CUSTDEV is the name of yor database. PLEASE MAKE SURE to confirm the details of this vehicle with the dealer to ensure its accuracy. The DataSource Class. So it does seem unrelated to the datasource, I just thought it was since pdq. Accessing multiple databases in enterprise applications can be a challenge. For each data source listed in the [ODBC Data Sources] section, there is a section that lists additional information about that data source. This sample application demonstrates how you can run TransactionsEssentials and Hibernate without any form of application server nor even Spring. To correct this problem:. The following are the JMC configuration data for IBM DB2Connect driver: JNDI Name: jdbc/DB52 Driver Class Name : COM. A data source may be configured separately or combined with other data sources as a multiDataSource. To create an ODBC data source for the SLM Database (DYK_CAT), located on the system named myMachine. 1 you can now select multiple drivers from the creation pool wizard on the Geronimo Administration Console. In this example, we will retrieve all users from the user1 table in database 1, then append to all users retrieved from user2 table in database 2. Fill out the download form and download the zip file. This usually entails installing the IBM DB2 Client software. Click on the toolbar (ALT+F+N+O). Creating a Data Source Name (DSN) in Windows. jar Step 3 : Make sure the JRE is from IBM Websphere. where is the data source name of string type, and is the remote data set name of string type. public class DB2Connect public static Logger log=Logger. This article shows you how to configure a DB2 datasource in Apache Geronimo v1. jar, db2jcc_license_cu. You will get db2jcc. In our example Name is Employee and JNDI name is /jdbc/EmployeeDS , Database Name is Employee , Driver Type 4 , Server Name (ip address of server where db2 is installed) , Port Number then apply->save ->save. Accounting uses the DB2 IFCIDs 3 and 239 (DB2 trace type Accounting, DB2 trace class 1) as input for the reports and traces. It seems to me that old versions of DB2 drivers had "COM. driver-class-name = com. DB2Driver; In User Name and Password, enter your credentials to IBM DB2. The key of this dictionary contains the name of a dbProvider and its value is a dbProvider object. com> cc: Subject: RE: Cannot load JDBC Driver class com. This is shipped as part of the IBM Developer Kit for Java (57xxJV1). Since that is not always an option we have a handful of examples for non-pooling datasources listed here as well. I followed above all the steps and successfully installed the ODBC driver for DB2 but, I don’t know how to create a linked server using this data source in SQL Server. This sample demonstrates how to configure multiple datasources with multiple databases and JdbcTemplate in Spring Boot Application. DB2 12 is the latest release of DB2 for z/OS. A data source is a complete database configuration that uses a JDBC driver to communicate with a specific database. In this tutorial, you will create a Java application to retrieve bank information from the FDIC Institutions database. Using DB2 Commands. There are two sources of database connections - either a DataSource or a DriverManager. mappers package and its sub-packages from the classpath. 1 Tutorial: Spring Framework DB2. Without HikariCP, the datasource configuration is as follows: @Bean//(destroyMethod = "close") public DataSource dataSource(Environment env). jar, click Add File. DataSources are the link between models and the source of data that models represent. This article is intended to assist in troubleshooting some common issues when setting up JasperReports Server Data Sources. The DB2 CLP allows you to create an ODBC Datasource. We are all aware that the process of creating a traditional Spring JDBC application is little tedious because of its XML configurations and we need to follow few steps to configure any datasource. After creating the datasource inject the datasource to the DAO class. At least for me the default settings for SQuirreL DB2 driver didn’t work. Set Up Data Sources - Add more data to this data source or prepare your data before you analyze it. Enter values for the following fields when using the default RDBMS datasource configuration: Data Source Type: RDBMS; Name: Name of the datasource (must be a unique value) Data Source Provider: Specify the datasource provider. To create a DB2 iSeries ODBC connection. If more than one JDBC driver implementation is found, you will be prompted to select one. Abstract JDBC resource allows you to extract metadata from any relational database that you can connect to through JDBC. The example below is a module. JDBC requires that a DataSource be configured via JavaBean properties, shown in Table 11. NOTE: When using a v8 client. "DB2_IP_SYS1_DSN1D037_ConnectionString"), click Universal data link and Initialization string file, and then click Next. You may update config. To configure a new data source, select the link for the JDBC provider DB2 Universal JDBC Driver Provider and click on the Data sources link in the Additional Properties header. IfxXADataSource. Step 4 : Bind the ConnectionPoolDataSource with the JNDI context. JDBC Driver Class: The class name of the DataDirect Connect for JDBC driver, for example, com. In the environment where multiple DataSources are used, the name is important. I'm trying to get a DB2 XA connection. Oracle is the most popular database used in the enterprise. In some cases you will have to catalog a database in both the 32 bit and the 64 bit ODBC data sources. Could not connect to the specified data source. BTW: The DataSource currentSchema setting could be co-exist with the openjpa. I create two Datasource. So how can I add DB2 ODBC Driver to my User Data soruces (my OS is ""Windows 7 64-bit""). checker class-name="org. sql package to use JDBC. DB2Driver # Keep the connection alive if idle for a long time (needed in production) spring. setSecurityMechanism method after you create a DataSource object. The [ODBC Data Sources] section lists the name of each available data source and the description of the associated driver. jdbcDriver[db2-driver] using the library db2-library. getConnection() method 2. One for DB1 and one for DB2. If I publish report with embedded data source I can render views without any problems. 24) and they do not have the setURL method either. Abstract JDBC resource allows you to extract metadata from any relational database that you can connect to through JDBC. We will use Spring Data JPA system with multiple databases. Connection strings for IBM DB2. The default value is the full qualified name of the implementation class of Config. Install a driver on a MID Server. jar: JDBC 3. MySQL Connector/J 8. xa-datasource-property : The xa-datasource-property element allows for specification of the properties to assign to the XADataSource implementation class. Some DataJoiner data sources do not provide the appropriate values for "". Create a data source bound to jdbc/LiferayPool by editing jndi-definitions and creating liferay. It is implemented by making native method calls to the SQL CLI (Call Level Interface). Business data source are used to store data relating to applications designers build within Appian. In the following sample odbc. The "Native" JDBC driver. jar contains the driver classes and db2_license_cisuz. To correct this problem:. The exception message was: java. IBM_WebSphere]LAB_JDBC & DataSource (db2) 안녕하세요. Creo que license_cu y license_cisuz no debe ser utilizado. Version 5 data sources for applications that are written according the J2EE 1. It does this by adding a method to the data source called Future getConnectionAsync(). db2 quartz, spring issue. Thank you for using Embarcadero DBArtisan, the award winning DBA tool for enterprise-wide database administration. Report Designer includes three built-in data sources: Data Source (formerly Pentaho Datasets) is used to access the relational, OLAP (Mondrian), Pentaho metadata, and XML data source types. I'm facing a problem while deploying the EAR in glassfish V2. This includes the Connection URL (which may contain the Server name or IP address and the port), the login credentials, and a Test Query that will run to verify the Connection details. This usually entails installing the IBM DB2 Client software. In some cases you will have to catalog a database in both the 32 bit and the 64 bit ODBC data sources. i've got a problem to connect me with the odbc driver manager in my java application. Configuring Spring Boot for Oracle Spring Framework is the most popular Java framework used for building enterprise class applications. ----- I am at a loss, since I cannot find a db2profile file on my PC, although I do have the DB2 server software installed as well as the DB2 client software. As shown above, the main thing is to get the correct Data source followed by the OLEDB provider. DB2DataSource implements connection pooling AND it appears to be deprecated. If you are creating a data source to a database on another machine, you will need to adjust accordingly. Thanks in advance. xml file add following code into su JBOSS 7. This usually entails installing the IBM DB2 Client software. Extend the available JDBC driver options by creating a new choice list entry to specify the JDBC driver Java package name. Connection strings for IBM DB2. pdf), Text File (. You must provide Jetty with the libraries necessary to instantiate the datasource you have configured by putting the corresponding Jar in JETTY_HOME/lib/ext. db2 » jcc IBM Data Server Driver for JDBC and SQLJ is a pure-Java driver (Type 4) that supports the JDBC 4 specification. Build Charts and Analyze Data - Begin your data analysis. 1, so I can't use db2java. ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified * but it's working fine if i change ODBC 5. Extend the available JDBC driver options. The DB2 under UNIX and PC hosts specific syntax for the LIBNAME statement is as follows: LIBNAME libref db2 ; Arguments libref is any SAS name that serves as an alias to associate SAS with a database, schema, server, or group of tables and. Introduction. DB2Driver # Keep the connection alive if idle for a long time (needed in production). In this example, we will retrieve all users from the user1 table in database 1, then append to all users retrieved from user2 table in database 2. Provide details and share your research! But avoid …. On UNIX systems, check the class path for your data source. DataSourceUtils,http-bio-8080-exec-5 - Fetching JDBC Connection from DataSource ERROR c. jboss-jira [jboss-jira] [JBoss JIRA] (WFLY-3569). So it does seem unrelated to the datasource, I just thought it was since pdq. Business data source are used to store data relating to applications designers build within Appian. No SQL queries will work against it. I n this article, I am going to explain you how to create / configure a datasource in Spring boot with an example. In our example Name is Employee and JNDI name is /jdbc/EmployeeDS , Database Name is Employee , Driver Type 4 , Server Name (ip address of server where db2 is installed) , Port Number then apply->save ->save. Using the FILLBY Method to Filter DB2 9 Data Setswith a Twist By Paul Zikopoulos Since the middle of 2006, I’ve been writing about all the great integration features in IBM DB2 9 for the Microsoft Visual Studio 2005 integrated development environment (IDE) and the accompanying ADO. 2, start with getting the driver. NET membership system, and is used in the Visual Studio 2013 or Visual Studio 2013 Update 1 project templates for ASP. The following jar files are required to run the. The bean definition should look like the example below: The bean definition should look like the example below:. Some of the important classes under this package include JdbcTemplate, SimpleJdbcInsert, SimpleJdbcCall and NamedParameterJdbcTemplate. The world of JDBC drivers can be a bit difficult if you aren't used to them (well, and I know that the DB2 JDBC driver lives in. It seems to me that old versions of DB2 drivers had "COM. When you add a data source, you assign it a data source name (DSN) and set all information required to establish a connection. To create a linked server to DB2, it requires the SQL DBA to know or guess a lot of parameters that are not familiar or intuitive. In this article, we will show you how to create a Spring Boot + Spring Data JPA + Oracle + HikariCP connection pool example. datasource 的相关配置,Spring Boot会在classpath中搜索H2、hsqldb等内存数据库的jar包,如果找到了,就会自动配置一个内存数据库. Server name. The alternative is to use the JDBC tab and set up only JDBC access (which restricts you to Dynamic Query Mode) - in which case you will need the Class 4 DB" JDBC for your version of DB2 to be on the Cognos server, plus the relevant license file that goes along with it. Could your check the server log and see what is says about binding jdbc/Connection ? Could you run dumpnamespace and see what it shows about jdbc/Connection ?. Fill out the download form and download the zip file. 注入sessionFactory,sessionTemplate. If you are creating a data source to a database on another machine, you will need to adjust accordingly. Although many of. Now to setup Hikari, I configured the same bean in the following manner: @Bean public DataSource dataSource(Environment env). Looking for the correct databse connection string syntax? Look no further we got them all!. driver-class-name = com. The command for this is: db2 catalog odbc datasource CUSTDEV. db2 connect to CUSTDEV using userid (you will be prompted for the password) Creating an ODBC Datasource. zip file in the java12 directory, you are using the JDBC 1. You must configure the fairQueue property to be true. 0 specification introduced the java. com , using default port number 50000,. liberty -> usr -> servers -> defaultServer -> server. The DB2 CLP allows you to create an ODBC Datasource. IBM DB2 z/OS IBM DB2 z/OS 7 and 8 When going through a DB2 Connect gateway, DB2 UDB Client for Windows 6. While I was digging through my old examples, I found JDBC connection string examples for other databases, and thought I'd share them all here. After setting up the IBM DB2 database to replace the default H2 database, either change the default configurations of the WSO2_CARBON_DB datasource, or configure a new datasource to point it to the new database as explained below. This reference is a continuous work in progress. Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. db2_instance_name string. For DB2 for z/OS Version 9. The default value is the full qualified name of the implementation class of Config. Where did the comment section go? Red Hat's documentation publication system recently went through an upgrade. The Data Link Tool can save a data source definition as an OLE DB universal data link (UDL) file. In this tip we will provide the steps to install a data source driver and to configure an ODBC connection to the IBM DB2 for i (iSeries). I have no problem doing ODBC connections to it naturally, but it's been well documented here and elsewhere that right now power query does not support generic data connections of that sort. As this question comes up frequently with DB2/ODBC: It is possible to use the same DSN's but they should be the same major release. sql-server - Jboss - 自动重新连接到XA数据源后的奇怪异常; 带有Oracle的Jboss XA数据源无法打开连接; java - 如何在JBoss应用服务器中创建一个DataSource. Ensure that the connection and signon settings are correct and that the database server is running. hostname is the name of the machine that runs the Oracle database. Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. DataSource that is configured via JavaBeans properties. There are two sources of database connections - either a DataSource or a DriverManager. I am now trying to figure out how to remove these aliases. Using the FILLBY Method to Filter DB2 9 Data Setswith a Twist By Paul Zikopoulos Since the middle of 2006, I’ve been writing about all the great integration features in IBM DB2 9 for the Microsoft Visual Studio 2005 integrated development environment (IDE) and the accompanying ADO. Name of the resource. DB2DataSource. Description. jar Step 3 : Make sure the JRE is from IBM Websphere. Within the query designer, i add the [DB2]. The JNDI style is typical when using an application server or a web container. (You can also provide this dictionary as a constructor argument. Testing the application Consider the following basic example to test the application : Le'ts create an author to which a book will be associated. A data source may be configured separately or combined with other data sources as a multiDataSource. Restriction: Do not select Connection Pool Data Source if your installation has the z/OS Application Connectivity to DB2 for z/OS feature defined to WAS for z/OS. where CUSTDEV is the name of yor database. It applies to PowerExchange 9. They say that the best way to connect a database is throught ODBC Driver. A full-featured, Java-based, In-process job scheduler. 166)(PORT = 1522)) (CONNECT_DATA = (SID = plmdb2)) (HS=OK)) OK (0 msec) [root#plm5q101 admin]# 11. Note: Your element in persistence. DB2 operational database solutions provide the right data foundation with on-premises and cloud deployment options, best-in-class data compression, robust performance for mixed workloads, modern data security and the ability to scale and adjust without redesign. These data sources are commonly used to fill the item band. DataSource() DataSource() DataSource() Initializes a new instance of the DataSource class using the default values. Any idea how to connect spring bean (datasource) to DB2? It says to me cannot find jdbc driver for db2. Connecting to DB2 databases via ODBC or JDBC with information on DB2 UDB for Linux, Unix, and Windows, DB2 for iSeries and AS400, and DB2 for OS/390 and z/OS. A multi data source is like a pool of data sources configured to supply failover and/or load-balancing across DBMSes (Database Management Systems). Using JDBC with DB2 Index. xml]: Could not resolve placeholder 'hibernate. AutoDriverDataSource is provided as the default, which will automatically select between the old SimpleDriverDataSource and a new DBCPDriverDataSource implementation based on if Apache Commons DBCP has been provided on the classpath and OpenJPA is not running in a container managed mode or with. Driver Detais Some of the most used drivers to connect to DB2 database from java are. Figure 2 shows the naming convention for DB2 data sets. basically what you need is JNDI name to refer, from server. PHP Database Programming with DB2. 7 version with studio plug-in. 1のリリースから、Geronimo管理コンソールの接続プール作成ウィザードで複数のJDBCドライバーを選択できます。 このシナリオでは、DB2データベースの接続プールを作成しています。. We will use Spring Data JPA system with multiple databases. Get database connection There are two sources of database connections - either a DataSource or a DriverManager. Its a 300 student data list. This works when using RESOURCE_LOCAL transaction-type (direct to DB2). sql-server - Jboss - 自动重新连接到XA数据源后的奇怪异常; 带有Oracle的Jboss XA数据源无法打开连接; java - 如何在JBoss应用服务器中创建一个DataSource. IBM DB2 z/OS IBM DB2 z/OS 7 and 8 When going through a DB2 Connect gateway, DB2 UDB Client for Windows 6. MybatisDBAConfig. DataJoiner users: this situation can be detected by DataJoiner or by the data source. NAME RUNTIME-NAME ENABLED STATUS db2 db2 true OK But when I try to define a datasource using this driver-name, I get : "JBAS014653: Composite operation failed and was rolled back. SQLNonTransientException: DSRA4000E: A valid JDBC driver implementation class was not found for the jdbcDriver com. Get database connection. Fill out the download form and download the zip file. The code should be added in the GlobalNamingResources element. This relationship has expanded to include joint solution development and marketing. DataSource's name ¶ Return a DataSource's name from the getDataSourceName method. If you compile PDO_ODBC using the db2 flavour, this setting sets the value of the DB2INSTANCE environment variable on Linux and UNIX operating systems to the specified name of the DB2 instance. 1 driverClassName value com. It is a simple blueprint application that shows and updates the content of two Derby databases in a single atomic transaction controlled via the JTA API. Select ODBC Data Sources 64-bit. Choose Microsoft OLE DB Provider for DB2. jar is the required license file that allows you to connect to a DB2 for z/OS server. To establish a database connection using the Driver Manager, an application must register the class name of the JDBC driver with the Driver Manager, and then invoke the DriverManager. This is how Spring Boot can create a datasource, but you have to respect the right names for the properties. One class ALL DataBases (provider must be installed on your PC)Just insert in your web. When going directly to the mainframe from the client, DB2 Connect Personal Edition v6 or higher on the client machine. This post describes how to configure the jetty-maven-plugin and the Jetty servlet container to run a web application that uses a data source and requires users. Figure 2 shows the naming convention for DB2 data sets. xml file add following code into su JBOSS 7. In the DAO class we use this datasource to create the JDBCTemplate object. Spring MVC with JNDI Datasource for DB2 on AS/400 using Tomcat In this tutorial we will discuss how to set up Spring MVC web services and configure a JNDI Datasource using Tomcat and connect to IBM DB2 Database on a AS/400. A typical example code of connect to database will look like this. SMS Storage Groups To understand how DB2 accommodates these situations we will need to take a look at how DB2 data sets are named. This reference is a continuous work in progress. Using Singleton Class for DB Connection Java Posted on December 5, 2013 by admin The Servlet which loads the Singleton class should be loaded during the server startup. The JAR file for DataDirect driver is db2. We have already seen that JDBC DriverManager can be used to get relational database connections. This privilege should be performed on table by table basis. db2 list node directory db2 list database directory db2 connect to user using db2 list tables db2 connect reset If you need to drop the database or instance alias: db2 uncatalog database db2 uncatalog node db2 terminate Adjust the DataSource entry in the server. After you configure a data source, ColdFusion can then communicate with that data source. DRIVER CLASS: COM. Server name. Provide details and share your research! But avoid …. I am able to access DB2 using the DriverManager. xml file into server/default/deploy. This is how Spring Boot can create a datasource, but you have to respect the right names for the properties. You will need an IBM ID, which you can register for in here. You will get db2jcc. 1 Tutorial: Spring Framework DB2. This relationship has expanded to include joint solution development and marketing. 注入sessionFactory,sessionTemplate. DB2DataSource implements connection pooling AND it appears to be deprecated. In the JNDI name box , type IDP_DS. See Accessing IBM DB2 via Connection String for more information. Fill out the download form and download the zip file. jar libs to the project build path, but still the same issue. When using the DataSource interface, and you are creating and deploying your own DataSource objects, invoke the DataSource. ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [Answered] RSS 4 replies Last post Aug 18, 2010 12:52 AM by xangth2008. Here is an example of an IBM DB2 data source: Note: Tableau doesn't support the DECFLOAT data type. DataSource(String, String) DataSource(String, String) DataSource(String, String) nitializes a new instance of the DataSource class using the specified name and identifier. So your lov would work even with just one column with the datasource name and there would be no need to change such lovs. db2 connect to CUSTDEV using userid (you will be prompted for the password) Creating an ODBC Datasource. If you want to use IBM DB2 High Availability Disaster Recovery (HADR), it is recommended that you install IBM WebSphere Application Server, and that you configure Data Sources, so that you can use the J2EE connection to the database in JTS Setup. Go Up to Working with Data Sources The tables below provide details about the data source fields that are specific to a database management system: DB2 LUW , DB2 z/OS , InterBase , Firebird , JDBC , MySQL , ODBC , Oracle , SQL Azure , SQL Server , Sybase , Sybase IQ. The data source is a location of your data (it can be a server, CSV, or a DDL file). zip file in the java12 directory, you are using the JDBC 1. Give a name to the datasource to easily identify it in the console. DB2 Database Forums on Bytes. Database Connectionstrings. You may update config. A data source is a complete database configuration that uses a JDBC driver to communicate with a specific database. Class DataSource. The JDBC provider configured earlier supplies the driver class for the data source. Look in that zip file and confirm that the class is actually in it. You will need an IBM ID, which you can register for in here. The [ODBC Data Sources] section lists the name of each available data source and the description of the associated driver. These data sources are commonly used to fill the item band. Connect to the db2 database through a DataSource object. I've checked in subversion and the same behavior/code seems to exist in JBoss AS 4. default for spm_name is the hostname itself, specifying the hostname DbSchema, type the schema name of the database domain. Exception: COM. DataSource Classname: com. when trying to open a > connection > on my datasource. If your DBA has supplied a common DSN for use across the enterprise, enter it here. We will use Spring Data JPA system with multiple databases. For example, let's configure an H2 in-memory database as a data source for tests:. In that case, please refer to the manual of your driver or database to choose the correct one. db2_instance_name string. Too often, Db2 for z/OS people effect a change aimed at improving workload performance and look, for evidence of improvement, at the total class 2 CPU time for the workload of interest (and by the way, I focus on class 2 CPU time because that is what a Db2 person can influence - class 1 CPU time includes time outside of Db2, over which a Db2. I also copied db2jcc. TgtDBDocumentViewer Class This represents the data-aware document viewer component. After setting up the IBM DB2 database to replace the default H2 database, either change the default configurations of the WSO2_CARBON_DB datasource, or configure a new datasource to point it to the new database as explained below. The [ODBC Data Sources] section lists the name of each available data source and the description of the associated driver. One for DB1 and one for DB2. Then select Generic Data Source. If you use any other kind of driver, you have to look at the manual for the correct driver name. Kiran, I think your Datasource has some problems.