How To Clean Subscribers Profiles From SPR Database for GEO/Non GEO Systems

Asset ID:	1-71-2213073.1
Update Date:	2016-12-15
Keywords:

Solution Type Technical Instruction Sure

Solution 2213073.1 : How To Clean Subscribers Profiles From SPR Database for GEO/Non GEO Systems

Applies to:

Oracle Communications Subscriber Data Management (SDM) - Version SDM 9.0 to SDM 9.3 [Release SDM 9.0]
Tekelec

Goal

This document provides instructions on How to clean all the subscribers profiles from SPR Database for GEO/Non GEO system

Solution

Precaution:

1. Stop all the provisioning and SH traffic
2. Take a complete backup of subscriptions in WebCi and mysql using DB backup
3. Make sure no activity on the Database before starting the said procedure.
4. Your system (reference and replica site) should be idle.
5. Perform this activity only in reference protected site Active BE. After that tungsten replication will clean remaining BEs.
6. Following Mysql tables will be clean/affect for this activity
a. bluedbvol.hsssprrepositorydata : (contains the SPR repository data for the service indications designated as volatile (quota, pool-quota, dynamic-quota, pool-dynamic-quota, state, pool-state)
b. bluedb.hsssprprofilerepositorydata ( contains the SPR repository data for the service indications designated as non-volatile (user and pool)
c. poldb.IdMap(IMSI/MSISDN/NAI key)
d. spdb.subscription(table for all SDM/SPR subscriptions)
e. bluedbvol.hssasnotifysubscription(contains the application-servers which have subscribed to receive PNRs for subscriber repository data changes.)
7. Perform in maintenance window.

Procedure:

1. Take the complete backup
2. Take the back up of individual tables .

mysql -u root -p bluedbvol hsssprrepositorydata > /tmp/hsssprrepositorydata.sql;
mysql -u root -p bluedb hsssprprofilerepositorydata > /tmp/hsssprprofilerepositorydata.sql;
mysql -u root -p poldb IdMap > /tmp/IdMap.sql;
mysql -u root -p spdb subscription > /tmp/subscription.sql;
mysql -u root -p bluedbvol hssasnotifysubscription > /tmp/hssasnotifysubscription.sql;

3. Get the count from all the DBs

echo " select count(*) from bluedbvol.hsssprrepositorydata" | mysql -uroot -proot
echo " select count(*) from bluedb.hsssprprofilerepositorydata" | mysql -uroot -proot
echo " select count(*) from poldb.IdMap" | mysql -uroot -proot
echo " select count(*) from spdb.subscription" | mysql -uroot -proot
echo " select count(*) from bluedbvol.hssasnotifysubscription" | mysql -uroot -proot

4. Delete the subscribers details from all the DBs

echo " delete from bluedbvol.hsssprrepositorydata" | mysql -uroot -proot
echo " delete from bluedb.hsssprprofilerepositorydata" | mysql -uroot -proot
echo " delete from poldb.IdMap" | mysql -uroot -proot
echo " delete from spdb.subscription" | mysql -uroot -proot
echo " delete from bluedbvol.hssasnotifysubscription" | mysql -uroot -proot

POST CHECK

1. Get the count from all the DBs to confirm

2. All above output should come 0.
3. check the count for all remaining 3 BEs for GEO system and Standby BE for Non-GEO using below commands , it should be also Zero.

Attachments

This solution has no attachment