When you first install the ATG platform, it is configured to use its own data sources (JDBC connection pools) and transaction manager. The data sources point to the SOLID demonstration database that is installed with ATG. This database contains the tables necessary for running ATG and the demo applications.
When you deploy your site, however, you should reconfigure your installation to use the data sources and transaction manager that your application server uses. The SOLID database is suitable for evaluation and development, but not for a high-volume site. Also, if your ATG installation uses a different data source you’re your application server, your site cannot access application server resources and ATG components in the same transaction.
Note that datasources for all application servers should always use the READ_COMMITTED isolation level (on DB2, use the equivalent CURSOR STABILITY).
