| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869 |
- node = AdminConfig.getid('/Cell:DefaultCell01/Node:DefaultNode01/Server:server1/')
- print node
- #JDBC Provider
- n1 = ['name', 'DB2 Universal JDBC Driver Provider (XA)']
- implCN = ['implementationClassName', 'com.ibm.db2.jcc.DB2XADataSource']
- cls = ['classpath', '${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar;${UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar;${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar']
- provider = ['providerType', 'DB2 Universal JDBC Driver Provider']
- jdbcAttrs = [n1, implCN, cls, provider]
- jdbc = AdminConfig.create('JDBCProvider', node, jdbcAttrs)
- print jdbc
- AdminConfig.save()
- #JASS Auth
- userAlias='10_10_10_36'
- alias = ['alias', userAlias]
- userid = ['userId', 'db2inst1']
- password = ['password', 'mdw4dm1n']
- jaasAttrs = [alias, userid, password]
- security = AdminConfig.getid('/Security:/')
- j2cUser=AdminConfig.create('JAASAuthData', security, jaasAttrs)
- AdminConfig.save()
- print j2cUser
- #DS MWAPP_DS
- newjdbc = AdminConfig.getid('/Cell:DefaultCell01/Node:DefaultNode01/Server:server1/JDBCProvider:DB2 Universal JDBC Driver Provider (XA)/')
- name = ['name', 'DS_MWAPP']
- jndi = ['jndiName', 'jdbc/db2/mwapp_mwapp_ds']
- auth = ['authDataAlias' , userAlias]
- helper = ['datasourceHelperClassname', 'com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper']
- dsAttrs = [name, jndi, auth, helper]
- newds = AdminConfig.create('DataSource', newjdbc, dsAttrs)
- print newds
- #DS properties
- propSet = AdminConfig.create('J2EEResourcePropertySet', newds, [])
- AdminConfig.create('J2EEResourceProperty', propSet, [["name", "driverType"], ["value", "4"]])
- AdminConfig.create('J2EEResourceProperty', propSet, [["name", "databaseName"], ["value", "MWAPP"]])
- AdminConfig.create('J2EEResourceProperty', propSet, [["name", "serverName"], ["value", "db2-mwapp"]])
- AdminConfig.create('J2EEResourceProperty', propSet, [["name", "portNumber"], ["value", "50000"]])
- AdminConfig.create('J2EEResourceProperty', propSet, [["name", "currentSchema"], ["value", "MWAPP"]])
- AdminConfig.save()
- # list Websphere Variable
- variables = [
- {
- 'name': 'DB2UNIVERSAL_JDBC_DRIVER_PATH',
- 'value': '/home/was/lib',
- 'description': 'Path to DB2 Universal JDBC Driver'
- },
- {
- 'name': 'OS400_TOOLBOX_JDBC_DRIVER_PATH',
- 'value': '/home/was/lib',
- 'description': 'Path to OS400 Toolbox JDBC Driver'
- }
- ]
- for var in variables:
- AdminTask.setVariable('[-variableName ' + var['name'] +
- ' -scope Node=DefaultNode01,Server=server1 ' +
- ' -variableValue ' + var['value'] +
- ' -variableDescription "' + var['description'] + '"]')
- AdminConfig.save()
|