ATG Installation and Configuration Guide
.
Documentation Home
Feedback
Highlighting
Prev
Up
Next
Drop Table Operation
The Drop table page drops the table you name.
Contents
Search
Installing the ATG Platform
Document Conventions
Default Ports
Important Terms
Product Requirements
JBoss-Specific Requirements
WebLogic-Specific Requirements
WebSphere-Specific Requirements
Sun T1000 and T2000 Requirements
Running the ATG Setup Program
JBoss Installation Results
WebLogic Installation Results
Performing a Maintenance Installation
Installing the ATG Control Center on a Client Machine
Downloading the ACC Installer
Installing the ACC on a Windows Client
Installing the ACC on a UNIX Client
Installing ATG Development Tools for Eclipse
Using the Configuration and Installation Manager (CIM)
Removing the ATG Platform from Your System
Running Nucleus-Based Applications
Starting the SOLID SQL Database
Running the Demos and Reference Applications
Starting the SQL-JMS Admin Interface
Starting ATG Web Services
Connecting to the Dynamo Administration UI
Connecting to the ATG Business Control Center
Starting the ATG Control Center
Starting the ACC on a Server
Starting the ACC on a Client
Stopping an ATG Application
Stopping ATG Applications on JBoss
Stopping ATG Applications on WebLogic
Stopping ATG Applications on WebSphere
Using the startDynamoOnJBOSS Script
Configuring Nucleus Components
Working with Configuration Layers
Understanding Properties Files
Understanding Configuration Layers
Accessing Configuration Layers in the ACC
Global Configuration Changes
Locking Configuration Layers
Finding Components in the ACC
Changing Component Properties with the ACC
Changing Component Properties Manually
Using Forward Slashes (/) and Backslashes (\)
Modifying Lists of Values
Specifying Directory Paths
Adding Comments to Properties Files
Using the Dynamo Component Browser
Component Browser Structure
Changing the Running Configuration
Starting Nucleus Components
Customizing the Interface
Common Configuration Changes
Modifying Environment Settings
Modifying Custom Module Resource Settings
Enabling checkFileNameCase on Windows
LogListeners
Creating Additional ATG Server Instances
Using the MakeDynamoServer Script
Using the Configuration Manager
Configuring a New Server Instance
Setting Up a Configuration Group
Configuration Group Properties
Storing Group Configuration Files
Downloading Group Configuration
Validating Group Configuration Properties
Session Management in ATG Applications
Sharing Session Information Among ATG Applications
Session Interaction Outline
Managing User Sessions
Configuring Databases and Database Access
Creating Database Tables Using SQL Scripts
Creating Database Tables for ATG Adaptive Scenario Engine
Creating Database Tables for ATG Portal
Destroying Database Tables
Destroying Database Tables for ATG Adaptive Scenario Engine
Destroying Database Tables for ATG Portal
Adding a JDBC Driver
Removing the SOLID JDBC Driver from the CLASSPATH
Configuring ATG Data Sources for Data Import
Configuring Data Sources and Transaction Management
Configuring Data Sources for JBoss
Configuring Data Sources for WebLogic and WebSphere
Configuring Data Sources for an Oracle RAC Cluster
Setting the Transaction Timeout on JBoss
Setting the Transaction Timeout on WebLogic
Setting the Transaction Timeout on WebSphere
Setting the Isolation Level for Transactions in WebSphere
Datasource Debugging
Using the JDBC Browser
Configuring the JDBC Browser
Create Table Operation
Drop Table Operation
Execute Query Operation
Metadata Operations
Using ATG Products with an IBM DB2 Database
Using ATG Products with a Microsoft SQL Server Database
Moving Data from SOLID to the Production Database
Transferring the Demo Data
Copying and Switching Databases
Database Copy Operations
Creating a DBCopier Component
Configuring the DBConnectionInfo
Configuring the DBCopier
Setting the Native SQL Environment
Switching Databases
Configuring a SwitchingDataSource
Database Switching and Query Caching
Database Switching and Repository Caches
Configuring for Production
Enabling liveconfig Settings
Customizing liveconfig Settings
Disabling Checking for Changed Properties Files
Disabling the Performance Monitor
Adjusting the pageCheckSeconds Property
Changing the Default Cookie Hash Key
Fine-Tuning JDK Performance with HotSpot
Configuring Repositories
Setting Cache Modes
Prepopulating Caches on Startup
Enabling the Repository Cache Lock Managers
Configuring Repository Database Verification for Quicker Restarts
Configuring a Content Distributor System
Configuring Targeted E-Mail
Nucleus Components
Configuring Web Applications
Setting Access Levels for Properties Files
Setting Logging Levels
Limiting Initial Services for Quicker Restarts
Disabling Document and Component Indexing
Enabling the ProtocolChange Servlet Bean
Setting up Clustering on JBoss
Configuring the HttpPort Property
Creating ATG Servers
Assembling for a JBoss Cluster
Creating and Configuring JBoss Servers
Deploying Your Application
Setting Up Clustering on WebLogic
Assembling for a WebLogic Cluster
Clustering Example
Setting up Clustering on WebSphere
Installing and Configuring WebSphere
Creating a Cluster
Creating Data Sources
Installing and Configuring Your Web Server
Installing ATG for a WebSphere Cluster
Assembling for a WebSphere Cluster
Session Management in a WebSphere Cluster
Configuring Your WebSphere Servers
Deploying Your Application
General Clustering Information
Specifying the drpPort Setting
Setting up localconfig and Server Configuration Files
Unique Components
Enabling Component Backup
Synchronizing Server Clocks
Performance Diagnostics
Performance Troubleshooting Checklist
Performance Testing Strategies
Graduated Testing of Throughput
Realistic Testing Strategies
Locating Performance Bottlenecks
Monitoring System Utilization
Bottlenecks at Low CPU Utilization
Checking for Database Bottlenecks
Checking for Disk I/O Bottlenecks
Checking for Network-Limited Problems
Bottlenecks at High CPU Utilization
Thread Context Switching Problems
System Resource Bottlenecks
TCP Wait Problem on Solaris
Server Hangs
Paging and Memory Allocation
Garbage Collection
Memory Leaks
Swap Space
Detecting File Descriptor Leaks
Using URLHammer
Command Line Arguments
URLHammer Examples
The -script Argument
Recording a Script
Editing a Script
URLHammer Source Files
Monitoring Site Performance
Performance Monitor
Adding PerformanceMonitor Methods to your Code
Performance Monitor Modes
Viewing Performance Monitor Data
Instrumented ATG Classes
Performance Monitor API
Using the Configuration Reporter
Configuration Reports
Excluding Components from the Configuration Report
Running the Configuration Reporter as a Standalone Utility
Using the VMSystem Component
Using a Sampler
Starting the Sampler
Sampler Information
Sampler Output
Using the Recording Servlet
Inserting the Recording Servlet
Generating Script Files
Keeping Statistics
Tracing Memory
Repository and Database Performance
Database Performance Practices
Repositories and Transactions
Repository Item Property Loading
Database Sorting versus Locale-Sensitive Sorting
Batching Database Transactions
Avoiding Table Scans
Database Caches
Diagnosing Database Performance Problems
Avoid Using Simulated Text Search Queries in Repositories
Tuning Site Performance on JBoss
JBoss File Modifications
JSP Servlet Configuration
Tomcat Connector Thread Configuration
Tomcat Cluster Configuration
JBoss Logging Configuration
Datasource Configuration
Configuring run.bat/sh and run.conf
JBoss Application Framework Trimming
Migration Issues
Migrating from ATG 6 on WebLogic or WebSphere
Using the JBoss Migration Tool
Migrating from Dynamo Application Server
JSP-based Applications
Migrating JHTML-based Applications
Reassembling Your Applications
Setting Up WebSphere Studio Application Developer
Creating an ATG Java Project
Creating a Workspace
Creating a New ATG Module and WSAD Java Project
Creating a WSAD Java Project from an Existing ATG Module
Generating and Importing a J2EE Application
Modifying the Manifest File
Assembling Your J2EE Application
Importing the EAR file into WSAD
Setting Build References
Defining a Utility JAR
Troubleshooting Task Console Errors
Testing Your Development Environment
Adding Dependent JARs
Configuring Additional ATG Servers
Reassembling Your Application for Deployment
Reassembling Your Application Using WSAD
Reassembling Your Application Using Ant
Data Storage and Access
Database Schema Best Practices
Production Schema
Management Schema
Agent Schema
Data Sources
Repositories
Adjusting the FileCache Size
Index
