JDBCProviderの作成スクリプトと設定確認スクリプト

jvminfo.txt

yyd1Node01,server1
yyd1Node01,server2
yyd2Node01,server1

Db2版で作成
上がXA版のJDBCプロバイダ
下がONEフェーズコミット版のJDBCプロバイダ

yyd1Node01_server1.jdbc

"DB2","DB2 Using IBM JCC Driver","XA data source","DB2 Using IBM JCC DriverXA"
"DB2","DB2 Using IBM JCC Driver","Connection pool data source","DB2 Using IBM JCC DriverONE"

JDBC_set.py

import csv

with open('jvminfo.txt') as f:
    csvreader = csv.reader(f)
    for row in csvreader:
      nodename=row[0]
      servername=row[1]
      id=AdminConfig.getid('/Node:'+nodename+'/Server:'+servername+'/')

      with open(nodename+'_'+servername+'.jdbc') as f2:
          csvreader2 = csv.reader(f2)
          for row2 in csvreader2:
           J_dtype=row2[0]
           J_ptype=row2[1]
           J_itype=row2[2]
           J_name=row2[3]

           AdminTask.createJDBCProvider('[-scope Node='+nodename+',Server='+servername+' -databaseType "'+J_dtype+'" -providerType "'+J_ptype+'" -implementationType "'+J_itype+'" -name "'+J_name+'"]')

AdminConfig.save()

毎度の設定確認

JDBC_get.py

import csv

with open('jvminfo.txt') as f:
    csvreader = csv.reader(f)
    for row in csvreader:
      nodename=row[0]
      servername=row[1]
      id=AdminConfig.getid('/Node:'+nodename+'/Server:'+servername+'/')

      with open(nodename+'_'+servername+'.jdbc') as f2:
          csvreader2 = csv.reader(f2)
          for row2 in csvreader2:
           J_name=row2[3]
           ProcessID = AdminConfig.list('JDBCProvider',id)
           JDBCList=AdminUtilities.convertToList(ProcessID)
           for jpv in JDBCList:
             if AdminConfig.showAttribute(jpv,'name') == J_name:
               print nodename + servername
               print AdminConfig.showAttribute(jpv,'name')
               print AdminConfig.showAttribute(jpv,'xa')