Tuesday, December 10, 2013

Manually creating a data source for the persistent store

If you chose to manually configure WebSphere® Application Server Network Deployment, you must create a data source in order to store JMS messages in a DB2® database.

About this task

You have the option of having WebSphere Application Server Network Deployment use a DB2 database to store JMS messages. For more information about WebSphere Application Server Network Deployment message storage, including the usage of products other than DB2, seehttp://publib.boulder.ibm.com/infocenter/wasinfo/v7r0/index.jsp?topic=/com.ibm.websphere.nd.multiplatform.doc/info/ae/ae/tjm0045_.html.
To create a data source for the persistent store, complete the following steps:

Procedure

  1. Create a system user and password on the server hosting the database server. For example, a user named mxsibusr with a password ofmxsibusr.
  2. Create and configure the database.
    1. Open DB2 Control Center.
    2. Browse to the Databases folder listed under your system.
    3. Right-click the Databases folder and select Create Database > Standard.
    4. Create a database named maxsibdb using default settings.
    5. After the database has been created, expand the maxsibdb database and select User and Group objects.
    6. Right-click DB Users and select Add.
    7. Select mxsibusr from the User menu.
    8. Grant all authorities to the mxsibusr except Security administrator authority.
    9. Click Apply.
    10. Verify that you can connect to the database using the mxsibusr user by right-clicking maxsibdb and selecting Connect.
  3. Configure J2C authentication data and JDBC provider in WebSphere Application Server Network Deployment.
    1. Open and login to the WebSphere Application Server Network Deployment administrative console.
    2. Browse to Security > Global Security.
    3. Under the Authentication header, click Java Authentication and Authorization Service > J2C authentication data.
    4. Click New.
    5. Complete the following fields in the User identity form.
      Alias
      maxJaasAlias
      User ID
      mxsibusr
      Password
      Password you created for mxsibusr.
      Description
      SIB database user alias.
    6. Click Apply, and then click Save.
    7. From the WebSphere Application Server administrative console, browse to Resources > JDBC > JDBC Providers.
    8. Under Scope, click Show scope selection drop-down list with the all scopes option, select Cell=ctgCell01, and then, underPreferences, click Apply.
    9. Click New.
    10. Specify the following values, and then click Apply:
      Database type
      DB2
      Provider type
      DB2 Universal JDBC Driver Provider
      Implementation type
      XA data source
      Name
      maxJdbcProvider
    11. Click Next.
    12. Complete the WebSphere Application Server variable ${DB2UNIVERSAL_JDBC_DRIVER_PATH} field with a value of<WAS_HOME>ctgMX\lib For example, C:\Program Files\IBM\WebSphere\AppServer\ctgMX\lib.
    13. Click Next.
      Figure 1. Create a new JDBC providerCreate a new JDBC provider.
    14. Click Finish.
    15. Click Save.
  4. Open a command prompt and copy <DB2_HOME>/java/db2jcc.jar and <DB2_HOME>/java/db2jcc_license_cu.jar to the<WAS_HOME>\ctgMX\lib directory. Go back to Resources > JDBC > JDBC Providers > maxJdbcProvider, and correct the class path if required for both db2jcc.jar and db2jcc_license_cu.jar. Ensure that each jar file has the full path from ${DB2UNIVERSAL_JDBC_DRIVER_PATH}
  5. Configure WebSphere Application Server:
    1. From the WebSphere Application Server Network Deployment administrative console, browse to Resources > JDBC > Data sources.
    2. Under Scope, click Show scope selection drop-down list with the all scopes option, select Cell=ctgCell01, and then, underPreferences, click Apply.
    3. Click New.
    4. Specify the following values:
      Data source name
      intjmsds
      JNDI name
      jdbc/intjmsds
    5. From the Component-managed authentication alias and XA recovery authentication alias menu, select maxJaasAlias
    6. Click Next.
    7. Choose Select an existing JDBC provider, and then select maxJdbcProvider from the menu.
    8. Click Next.
    9. Specify the following values:
      Database name
      maxsibdb
      Driver type
      4
      Server name
      Specify the DB2 server host name.
      Port number
      Specify the DB2 port number. For example, 50005.
    10. Ensure the Use this data source in container managed persistence (CMP) option is selected, and then click Next.
    11. Click Finish.
    12. Click Save.
  6. Verify the data source by selecting intjmsds, and then clicking Test Connection.

4 comments:

oakleyses said...

louis vuitton handbags, oakley sunglasses, louboutin, longchamp outlet, nike shoes, louis vuitton outlet stores, chanel handbags, burberry outlet, prada outlet, jordan shoes, tiffany and co, michael kors outlet, tory burch outlet, louis vuitton outlet, longchamp handbags, nike free, true religion jeans, michael kors outlet, kate spade outlet, polo ralph lauren outlet, tiffany and co, prada handbags, polo ralph lauren outlet, michael kors outlet, michael kors outlet, longchamp handbags, oakley sunglasses, ray ban sunglasses, kate spade handbags, burberry outlet, louis vuitton outlet, louboutin outlet, louboutin, coach factory outlet, air max, air max, coach outlet, gucci outlet, christian louboutin shoes, michael kors outlet, coach purses, ray ban sunglasses, michael kors outlet, louis vuitton, coach outlet store online, true religion jeans, oakley sunglasses cheap

oakleyses said...

ralph lauren, lululemon, air max, hollister, north face, nike air max, polo lacoste, vanessa bruno, timberland, vans pas cher, louboutin, louis vuitton, oakley pas cher, air max pas cher, nike roshe run, air max, true religion outlet, barbour, sac longchamp, air force, hollister, sac louis vuitton, nike free, polo ralph lauren, nike trainers, louis vuitton uk, nike roshe, sac hermes, longchamp, michael kors, sac burberry, sac guess, mulberry, new balance pas cher, converse pas cher, sac louis vuitton, hogan outlet, nike tn, north face, true religion outlet, ray ban pas cher, michael kors, air jordan, nike blazer, nike free pas cher, michael kors pas cher, abercrombie and fitch, ray ban sunglasses

oakleyses said...

mac cosmetics, mont blanc, marc jacobs, canada goose outlet, nike huarache, vans shoes, soccer jerseys, hollister, giuseppe zanotti, beats by dre, abercrombie and fitch, longchamp, insanity workout, celine handbags, bottega veneta, ghd, nfl jerseys, north face outlet, chi flat iron, ugg boots, birkin bag, ugg australia, canada goose, herve leger, ugg pas cher, rolex watches, valentino shoes, canada goose uk, canada goose, ferragamo shoes, canada goose, ugg boots, uggs outlet, north face jackets, soccer shoes, asics running shoes, new balance shoes, p90x, lululemon outlet, canada goose jackets, mcm handbags, instyler, babyliss pro, ugg, wedding dresses, jimmy choo outlet, reebok outlet, nike roshe run

oakleyses said...

parajumpers, karen millen, air max, converse, pandora charms, moncler, louboutin, moncler, links of london, lancel, juicy couture outlet, oakley, hollister, pandora charms, supra shoes, thomas sabo, canada goose, gucci, wedding dresses, timberland boots, swarovski crystal, air max, coach outlet store online, moncler, ray ban, canada goose, moncler, ugg, louis vuitton, swarovski, hollister, montre homme, moncler, hollister clothing store, ralph lauren, rolex watches, moncler outlet, moncler, iphone 6 cases, baseball bats, juicy couture outlet, toms shoes, vans, pandora jewelry, ugg, converse shoes