config.jython 2.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. node = AdminConfig.getid('/Cell:DefaultCell01/Node:DefaultNode01/Server:server1/')
  2. print node
  3. #JDBC Provider
  4. n1 = ['name', 'DB2 Universal JDBC Driver Provider (XA)']
  5. implCN = ['implementationClassName', 'com.ibm.db2.jcc.DB2XADataSource']
  6. cls = ['classpath', '${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar;${UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar;${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar']
  7. provider = ['providerType', 'DB2 Universal JDBC Driver Provider']
  8. jdbcAttrs = [n1, implCN, cls, provider]
  9. jdbc = AdminConfig.create('JDBCProvider', node, jdbcAttrs)
  10. print jdbc
  11. AdminConfig.save()
  12. #JASS Auth
  13. userAlias='10_10_10_36'
  14. alias = ['alias', userAlias]
  15. userid = ['userId', 'db2inst1']
  16. password = ['password', 'mdw4dm1n']
  17. jaasAttrs = [alias, userid, password]
  18. security = AdminConfig.getid('/Security:/')
  19. j2cUser=AdminConfig.create('JAASAuthData', security, jaasAttrs)
  20. AdminConfig.save()
  21. print j2cUser
  22. #DS MWAPP_DS
  23. newjdbc = AdminConfig.getid('/Cell:DefaultCell01/Node:DefaultNode01/Server:server1/JDBCProvider:DB2 Universal JDBC Driver Provider (XA)/')
  24. name = ['name', 'DS_MWAPP']
  25. jndi = ['jndiName', 'jdbc/db2/mwapp_mwapp_ds']
  26. auth = ['authDataAlias' , userAlias]
  27. helper = ['datasourceHelperClassname', 'com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper']
  28. dsAttrs = [name, jndi, auth, helper]
  29. newds = AdminConfig.create('DataSource', newjdbc, dsAttrs)
  30. print newds
  31. #DS properties
  32. propSet = AdminConfig.create('J2EEResourcePropertySet', newds, [])
  33. AdminConfig.create('J2EEResourceProperty', propSet, [["name", "driverType"], ["value", "4"]])
  34. AdminConfig.create('J2EEResourceProperty', propSet, [["name", "databaseName"], ["value", "MWAPP"]])
  35. AdminConfig.create('J2EEResourceProperty', propSet, [["name", "serverName"], ["value", "db2-mwapp"]])
  36. AdminConfig.create('J2EEResourceProperty', propSet, [["name", "portNumber"], ["value", "50000"]])
  37. AdminConfig.create('J2EEResourceProperty', propSet, [["name", "currentSchema"], ["value", "MWAPP"]])
  38. AdminConfig.save()
  39. # list Websphere Variable
  40. variables = [
  41. {
  42. 'name': 'DB2UNIVERSAL_JDBC_DRIVER_PATH',
  43. 'value': '/home/was/lib',
  44. 'description': 'Path to DB2 Universal JDBC Driver'
  45. },
  46. {
  47. 'name': 'OS400_TOOLBOX_JDBC_DRIVER_PATH',
  48. 'value': '/home/was/lib',
  49. 'description': 'Path to OS400 Toolbox JDBC Driver'
  50. }
  51. ]
  52. for var in variables:
  53. AdminTask.setVariable('[-variableName ' + var['name'] +
  54. ' -scope Node=DefaultNode01,Server=server1 ' +
  55. ' -variableValue ' + var['value'] +
  56. ' -variableDescription "' + var['description'] + '"]')
  57. AdminConfig.save()