Resolution
To produce a list of TimesTen Data Authority Server (TTDAS) subscribers, perform this procedure:
- Log in to the machine where TTDAS is installed as a SMDS Interface Protocol (SIP) user.
- Navigate to the directory where TTDAS is located (for example, /opt/TimesTen/5_0_30/bin).
- Issue the ./ttIsql -connStr DSN="POP name_0" or "DSN="POP name_1 command.
The output of this command prompts you to the Structured Query Language (SQL) Command Line Interface (CLI).
- Select * from the subpartition map.
The output of this command provides a list of partition-POP_IDs that are in the database.
- Select * from nrs_mapping, where the subpartition_id is the % from the ./ttIsql -connStr DSN="POP name_0" or "DSN="POP name_1 command.
The output of this command provides a list of all the subscribers that belong to a particular POP.
- To generate the subscriber list and send this output to a file, issue the /opt/TimesTen/5_0_30/bin/ttIsql -connStr DSN="POP name_0" -e "select * command from nrs_mapping, where the subpartition_id is similiar to %POP%'; exit" > POP_subscribers.txt.