The Web service implementations provided with Telecom Web Services Server require several different database tables and stored procedures. These entities are defined during the installation and configuration process.
Each subcomponent has separate DDL files for DB2 and Oracle.
The DDL files named Adminxxx are invoked automatically by the First Steps script. Should you ever need to run one of these files manually in a distributed database configuration, run it against the database instance that contains the CONFIGPROPERTIES table (which is used by the TWSS Administration Console)–not against the database instance that contains the tables used by the Web service implementation.
Refer to the topic Database tables for Telecom Web Services Server subcomponents for a list of the database tables that are required for the base components.
Web service | DDLs | Database tables created or updated |
---|---|---|
Parlay X Call Notification over SIP/IMS | CallNotifyDbDb2.ddl |
CALLNOTIFICATIONADDRESS |
Parlay X Presence over SIP/IMS | AdminPresDb2.ddl |
None |
Parlay X Terminal Status over SIP/IMS | AdminTsDb2.ddl |
None |
Parlay X Third Party Call over SIP/IMS | ThirdPartyDbDb2.ddl |
THIRDPARTYCALL |
Parlay X Payment (PostPaid) | AdminPmtDb2.ddl |
None Note: Under some circumstances, a CEI repository
may be required to maintain transaction details.
|
Parlay X Address List Manager over XCAP | None | None |
WAP Push over SMPP | WAPPushDb2.ddl |
WAPPUSHSENDDATA |
Parlay X SMS over SMPP | SmsDbDb2.ddl |
SMSSENDDATA |
Parlay X Terminal Location over MLP | TermLocMLPDbDb2.ddl |
TLMLPNOTIFYDATA |
Parlay X Multimedia Messaging over MM7 | AdminMmsMm7Db2.ddl |
MMSATTACHCONTENT |
Parlay X Terminal Status over Parlay | AdminTsParlayDb2 |
TERMINALSTATUSNOTIFICATIONDATA |
Parlay X Terminal Location over Parlay | AdminTlDb2.ddl |
TERMINALLOCATIONNOTIFICATIONDATA |
Parlay X SMS over Parlay | SmsDbDb2.ddl |
SMSSENDDATA |
Parlay X Call Handling over Parlay | CallHandlingParlayDbDb2.ddl |
CHACCEPTLIST |
Parlay X Call Notification over Parlay | CallNotificationParlayDbDb2.ddl |
CNNOTIFICATIONINFO |
Parlay X Third Party Call over Parlay | AdminTpcParlayDbDb2.ddl |
TPCDATA |
Address Masking component Web service | AddressMaskingDbDb2.ddl |
TRANSACTIONIDENTIFIER |
Web service | DDLs | Stored procedures created |
---|---|---|
Parlay X Call Handling over Parlay | CallHandlingStoredProcDb2.ddl |
LOADRULE |
Parlay X Third Party Call over Parlay | ThirdPartyCallParlayDbDb2.ddl Note: This DDL file creates both database and tables
for the Web service. Therefore, you need to execute it only once.
|
DELETETPCRECORDS |