The install file in the <ATG9dir>/Portal/install/database-vendor directory runs a set of scripts that create the required tables for the Portal Application Framework (PAF) and baseline gears.
Note: These scripts also create the tables for the ATG Adaptive Scenario Engine; you do not need to run the DAS, DPS, and DSS scripts separately. Note also that the install file uses the <ATG9dir>/Portal/install/minimal-data.xml file to create the minimum set of data structures necessary to run ATG Portal.
Use the following syntax to run the install file appropriate for your DBMS:
install-db2userid password databaseinstall-mssqluserid password host databaseinstall-oracleuserid password database
The table creation scripts for ATG Portal are located in the following directories:
<ATG9dir>/Portal/paf/sql/install/database-vendor<ATG9dir>/Portal/gear_dir/sql/install/database-vendor
Note: These scripts use an ATG-specific JTDatasource and TransactionManager, and cannot be used with your application server’s data source or transaction manager.
Script name | Purpose |
|---|---|
| Creates tables for the Alerts Gear |
| Creates tables for the Bookmarks Gear |
| Creates tables for the Calendar Gear |
| Creates tables for the Communities Gear |
| Creates tables for the Discussion Gear |
| Creates tables for the Document Exchange Gear |
| Creates tables for storing membership requests |
| Creates tables used by sample mappers to record portal events |
| Creates tables for the Portal Application Framework |
| Creates tables for the Poll Gear |
| Creates tables for storing profile data for personalized communities and pages |
| Creates tables for the Web Services Client Gear |
