WebSphere brand IBM WebSphere Telecom Web Services Server, Version 7.1

Database tables and stored procedures for Web service implementations

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.

During the standard installation and configuration process, the First Steps script sets up database tables and stored procedures as shown here. For each Web service implementation, the following are listed:

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.

Note: You need to create tables and stored procedures only for the Web service implementations that you plan to deploy.
Table 1. Database tables for Web services
Web service DDLs Database tables created or updated
Parlay X Call Notification over SIP/IMS

CallNotifyDbDb2.ddl
AdminCnDb2.ddl
CallNotifyDbOra.ddl
AdminCnOra.ddl

CALLNOTIFICATIONADDRESS

Parlay X Presence over SIP/IMS

AdminPresDb2.ddl
AdminCmnDbDb2.ddl
AdminPresOra.ddl
AdminCmnDbOra.ddl

None
Parlay X Terminal Status over SIP/IMS

AdminTsDb2.ddl
AdminCmnDbDb2.ddl
AdminTsOra.ddl
AdminCmnDbOra.ddl

None
Parlay X Third Party Call over SIP/IMS

ThirdPartyDbDb2.ddl
AdminTpcDb2.ddl
ThirdPartyDbOra.ddl
AdminTpcOra.ddl

THIRDPARTYCALL

Parlay X Payment (PostPaid)

AdminPmtDb2.ddl
AdminPmtOra.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
AdminWAPPushDB2.ddl
WAPPushOra.ddl
AdminWAPPushOra.ddl  

WAPPUSHSENDDATA
WAPPUSHNOTIFICATIONDATA

Parlay X SMS over SMPP

SmsDbDb2.ddl
AdminSmsSmppDb2.ddl
SmsDbOra.ddl
AdminSmsSmppOra.ddl

SMSSENDDATA
SMSRECEIVEDATA
SMSNOTIFICATIONDATA

Parlay X Terminal Location over MLP

TermLocMLPDbDb2.ddl
AdminLocMLPDb2.ddl
TermLocMLPDbOra.ddl
AdminLocMLPOra.ddl

TLMLPNOTIFYDATA

Parlay X Multimedia Messaging over MM7

AdminMmsMm7Db2.ddl
MmsAttachmentDb2.ddl
MmsDataDb2.ddl
AdminMmsMm7Ora.ddl
MmsAttachmentOra.ddl
MmsDataOra.ddl

MMSATTACHCONTENT  
MMSATTACHMETADATA
MMSNOTIFICATIONDATA
MMSSENDDATA
MMSRECEIVEDATA

Parlay X Terminal Status over Parlay

AdminTsParlayDb2
TermStatDbDb2.ddl
AdminTsOra.ddl
TermStatDbOra.ddl

TERMINALSTATUSNOTIFICATIONDATA
TERMINALSTATUSPENDINGNOTIF

Parlay X Terminal Location over Parlay

AdminTlDb2.ddl
TermLocDbDb2.ddl
AdminTlOra.ddl
TermLocDbOra.ddl

TERMINALLOCATIONNOTIFICATIONDATA

Parlay X SMS over Parlay

SmsDbDb2.ddl
AdminSmsParlayDb2.ddl
SmsDbOra.ddl
AdminSmsParlayOra.ddl

SMSSENDDATA
SMSRECEIVEDATA
SMSNOTIFICATIONDATA

Parlay X Call Handling over Parlay

CallHandlingParlayDbDb2.ddl
AdminChParlayDb2.ddl
CallHandlingParlayDbOra.ddl
AdminChParlayOra.ddl

CHACCEPTLIST
CHRULE
CHBLOCKLIST
CHCONDITIONALFORWARD
CHNOTIFICATION

Parlay X Call Notification over Parlay

CallNotificationParlayDbDb2.ddl
AdminCnParlayDb2.ddl
CallNotificationParlayDbOra.ddl
AdminCnParlayOra.ddl

CNNOTIFICATIONINFO
CNCALLEVENTS
CNTARGETINFO

Parlay X Third Party Call over Parlay

AdminTpcParlayDbDb2.ddl
AdminTpcParlayDbOra.ddl

ThirdPartyCallParlayDbDb2.ddl
ThirdPartyCallParlayDbOra.ddl

TPCDATA
THIRDPARTYCALLSESSION

Address Masking component Web service

AddressMaskingDbDb2.ddl
AddressMaskingDbOra.ddl

TRANSACTIONIDENTIFIER
INPUTVALUE
OUTPUTVALUE
REQUESTER
INTERNALEXPIRY
EXTERNALEXPIRY
EXECUTECOUNT

Table 2. Stored procedures for Web services
Web service DDLs Stored procedures created
Parlay X Call Handling over Parlay

CallHandlingStoredProcDb2.ddl
CallHandlingStoredProcOra.ddl

LOADRULE
SAVERULE
TESTLOAD

Parlay X Third Party Call over Parlay

ThirdPartyCallParlayDbDb2.ddl
ThirdPartyCallParlayDbOra.ddl

Note: This DDL file creates both database and tables for the Web service. Therefore, you need to execute it only once.

DELETETPCRECORDS




Terms of use
(C) Copyright IBM Corporation 2009. All Rights Reserved.