#Sharing - Access AS400 DB2 Here I want to sharing steps for access A

#Sharing - Access AS400 DB2

Here I want to sharing steps for access AS400 DB2 Database from Appian Query Database Smart Service.

Steps:
1. Create a folder <JBOSS_HOME>\\modules\\com\\ibm\\as400\\main. Copy AS400 DB2 driver ('jt400.jar') and file module.xml (attached).
2. Update driver datasources list in 'standalone.xml' file :
<driver name="as400" module="com.ibm.as400">
<driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>
<xa-datasource-class>com.ibm.as400.access.AS400JDBCXADataSource</xa-datasource-class>
</driver>
3. Add datasource in standalone.xml between "<subsystem xmlns="urn:jboss:domain:datasources:1.2">". My script like this (or you can add the datasource in Jboss Management Console):
<datasource jta="true" jndi-name="java:/jdbc/as400" pool-name="AS400" enabled="true" use-ccm="true" statistics-enabled="false">
<connection-url>jdbc:as400://HOSTNAME</connection-url> <!-- Fill your AS400 server Hostname -->
<driver-class>com.ibm.as40...

module.xml

OriginalPostID-208453

OriginalPostID-208453