Drop Table Operation
The Drop table page drops the table you name.
ATG Installation and Configuration Guide
.
Documentation Home
Feedback
Highlighting
Prev
Up
Next
Contents
Search
Introduction
Document Conventions
Important Terms
Installation Procedure
Preparing Java Application Servers
Oracle WebLogic Server
JBoss Enterprise Application Platform
IBM WebSphere Application Server
Basic Database Configuration
MySQL Databases
Running the Platform Installer
Installing Other Oracle ATG Web Commerce Products
Configuration and Installation Manager (CIM)
Before Using CIM
Using CIM
Adding Modules to Your Application
Installing Demonstration Applications
Default User Accounts
Dynamo Admin Server User
Business Control Center (BCC) User Accounts
Java Application Server Configuration
General Configuration
Configure SSL
GZIP Compression
File Name Character Encoding
Oracle WebLogic
Memory Allocation
Controlling Page Recompilation on WebLogic
WebLogic Installation Results
JBoss
JBoss-Specific Requirements
JBoss Installation Results
IBM WebSphere
WebSphere-Specific Requirements
WebSphere Installation Results
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
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
Direct SQL Deployment and Microsoft SQL Server
Datasource Debugging
Using the JDBC Browser
Configuring the JDBC Browser
Create Table Operation
Drop Table Operation
Execute Query Operation
Metadata Operations
Using Oracle ATG Web Commerce Products with an IBM DB2 Database
Using Oracle ATG Web Commerce Products with a Microsoft SQL Server Database
Moving Data from a Development Database 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 Sorting for Localization
Platform Installation Details
File System Permissions
Performing a Maintenance Installation
Default Ports
Sun T1000 and T2000 Requirements
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
Removing the Oracle ATG Web Commerce Platform from Your System
Running Nucleus-Based Applications
Starting the SQL JMS Admin Interface
Starting Oracle ATG Web Commerce Web Services
Connecting to the Dynamo Administration UI
Connecting to the Business Control Center
Starting the ATG Control Center
Starting the ACC on a Server
Starting the ACC on a Client
Using the Findclass Utility
Stopping an Oracle ATG Web Commerce Application
Stopping Applications on JBoss
Stopping Applications on WebLogic
Stopping Applications on WebSphere
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 Oracle ATG Web Commerce 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 Oracle ATG Web Commerce Applications
Sharing Session Information Among ATG Applications
Session Interaction Outline
Managing User Sessions
Configuring for Production
Enabling liveconfig Settings
Customizing liveconfig Settings
Disabling Checking for Changed Properties Files
Disabling the Performance Monitor
Adjusting the pageCheckSeconds Property
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
SecurityServlet and ParameterValidator
RedirectURLValidator
HttpOnly Attribute for Cookies
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
External Caching for SQL Repositories
Configuring Coherence for External Caching
Using Coherence Utilities With the ATG Server Cluster
Using Portable Object Format (POF) Serialization
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
Using the JBoss Migration Tool
Migrating from Dynamo Application Server
JSP-based Applications
Migrating JHTML-based Applications
Reassembling Your Applications
Data Storage and Access
Database Schema Best Practices
Production Schema
Management Schema
Agent Schema
Data Sources
Repositories
Adjusting the FileCache Size
Index
Search Terms
