DB2 al perfil Liberty

Puede migrar un origen de datos DB2 al perfil Liberty.

Acerca de esta tarea

Consulte los siguientes ejemplos de código de las configuraciones para un origen de datos DB2 en el perfil completo y el perfil Liberty.

Ejemplo

En el perfil completo:

<resources.jdbc:JDBCProvider xmi:id="JDBCProvider_1321914412932" 
            providerType="DB2 Using IBM JCC Driver" isolatedClassLoader="false" 
            implementationClassName="com.ibm.db2.jcc.DB2ConnectionPoolDataSource" xa="false">
   <classpath>${DB2_JCC_DRIVER_PATH}/db2jcc4.jar</classpath>
   <classpath>${DB2_JCC_DRIVER_PATH}/db2jcc_license_cu.jar</classpath>
   <classpath>${DB2_JCC_DRIVER_PATH}/db2jcc_license_cisuz.jar</classpath>
   <factories xmi:type="resources.jdbc:DataSource" xmi:id="DataSource_1321914498985" 
            name="DefaultDB2Datasource" jndiName="jdbc/DefaultDB2Datasource" 
            providerType="DB2 Using IBM JCC Driver" authMechanismPreference="BASIC_PASSWORD" 
            authDataAlias="IBM-9NE5C7ONIG4Node01/dbuser2" relationalResourceAdapter="builtin_rra"
            statementCacheSize="10" 
            datasourceHelperClassname="com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper">
      <propertySet xmi:id="J2EEResourcePropertySet_1321914499000">
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499000" name="databaseName"
            type="java.lang.String" value="TESTDB" required="true" ignore="false"
            confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499001" name="driverType"
            type="java.lang.Integer" value="4" required="true" ignore="false"
            confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499002" name="serverName"
            type="java.lang.String" value="localhost" required="false" ignore="false"
            confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499003" name="portNumber"
            type="java.lang.Integer" value="50000" required="false" ignore="false"
            confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499010" name="currentLockTimeout"
            type="java.lang.Integer" value="10" required="false" ignore="false"
            confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499013" name="currentSchema"
            type="java.lang.String" value="DBUSER2" required="false" ignore="false"
            confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499015" name="cursorSensitivity"
             type="java.lang.Integer" value="0" required="false" ignore="false"
            confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499016" name="deferPrepares"
            type="java.lang.Boolean" value="true" required="false" ignore="false"
            confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499027" name="loginTimeout"
             type="java.lang.Integer" value="0" required="false" ignore="false"
            confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499032" name="resultSetHoldability" type="java.lang.Integer" value="1" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499034"
            name="retrieveMessagesFromServerOnGetMessage"
            type="java.lang.Boolean" value="true" required="false" ignore="false"
            confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499041" name="traceLevel"
            type="java.lang.Integer" value="-1" required="false" ignore="false"
            confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499052"
            name="beginTranForResultSetScrollingAPIs" type="java.lang.Boolean" value="false"
            required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499053" name="beginTranForVendorAPIs" type="java.lang.Boolean" value="false" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499054" name="connectionSharing"
            type="java.lang.Integer" value="-1" required="false" ignore="false"
            confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499060"
            name="nonTransactionalDataSource" type="java.lang.Boolean" value="false"
            required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499063"
            name="syncQueryTimeoutWithTransactionTimeout" type="java.lang.Boolean" value="false"
            required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499069"
            name="webSphereDefaultIsolationLevel" type="java.lang.Integer" value="2"
            required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
         <resourceProperties xmi:id="J2EEResourceProperty_1321914499070"
            name="webSphereDefaultQueryTimeout" type="java.lang.Integer" value="10"
            required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
      </propertySet>
      <connectionPool xmi:id="ConnectionPool_1321914499012" connectionTimeout="180"
            maxConnections="10" minConnections="1" reapTime="180" unusedTimeout="1800" 
            agedTimeout="7200" purgePolicy="EntirePool"/>
      <mapping xmi:id="MappingModule_1321914681786" mappingConfigAlias="" authDataAlias="IBM-9NE5C7ONIG4Node01/dbuser2"/>
   </factories>
</resources.jdbc:JDBCProvider>
<systemLoginConfig xmi:id="JAASConfiguration_2">
   <authDataEntries xmi:id="auth1" alias="IBM-9NE5C7ONIG4Node01/dbuser2" userId="dbuser2" password="{xor}LDcfLTo7Oz0=" />
</systemLoginConfig>

En el perfil Liberty, la configuración equivalente es:

<variable name="DB2_JCC_DRIVER_PATH" value="C:/Drivers/DB2" />
<library id="db2Lib">
   <fileset dir="${DB2_JCC_DRIVER_PATH}" includes="db2jcc4.jar db2jcc_license_cu.jar db2jcc_license_cisuz.jar" />
</library>
<dataSource id="DefaultDB2Datasource" jndiName="jdbc/DefaultDB2Datasource"
    statementCacheSize="10" 
    beginTranForResultSetScrollingAPIs="false"
    beginTranForVendorAPIs="false"
    connectionSharing="MatchCurrentState"
    transactional="false"
    syncQueryTimeoutWithTransactionTimeout="false"
    isolationLevel="TRANSACTION_READ_COMMITTED"
    queryTimeout="10"
   >
   <jdbcDriver libraryRef="db2Lib" 
            javax.sql.ConnectionPoolDataSource="com.ibm.db2.jcc.DB2ConnectionPoolDataSource"/>
   <properties.db2.jcc
    databaseName="TESTDB"
    driverType="4"
    serverName="localhost"
    portNumber="50000"
    currentLockTimeout="10"
    currentSchema="DBUSER2"
    cursorSensitivity="0"
    deferPrepares="true"
    loginTimeout="0"
    resultSetHoldability="1"
    retrieveMessagesFromServerOnGetMessage="true"
    traceLevel="-1"
    user="dbuser2"
    password="{xor}LDcfLTo7Oz0="
   />
   <connectionManager connectionTimeout="180" maxPoolSize="10" minPoolSize="1" reapTime="180" maxIdleTime="1800" agedTimeout="7200" purgePolicy="EntirePool"/>
</dataSource>

Icono que indica el tipo de tema Tema de tarea

Términos y condiciones para centros de información | Comentarios


Icono de indicación de fecha y hora Última actualización: 15 de junio de 2015
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=phil&product=was-libcore-mp&topic=twlp_migrate_ds_db2
Nombre de archivo:twlp_migrate_ds_db2.html