PGW Database

Answered Question
Jun 2nd, 2010
User Badges:
  • Bronze, 100 points or more

Hi All,


Is there any way to create a new database for example a new CISCO.PORTEDNUMBERS database ?


or


Is there any way to truncate the database ?


Thanks,

Correct Answer by scpage about 6 years 11 months ago

Unload the in memory resident database by stopping the PGW platform (/etc/init.d/CiscoMGC stop)

Then issue this command as user mgcusr:


ttIsql -connStr "DSN=howdydb;overwrite=1" -f /opt/CiscoMGC/local/create_white.sql


This null the Timesten Database by creating new datastore tables.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
scpage Wed, 06/16/2010 - 12:15
User Badges:
  • Cisco Employee,

Unload the in memory resident database by stopping the PGW platform (/etc/init.d/CiscoMGC stop)

Then issue this command as user mgcusr:


ttIsql -connStr "DSN=howdydb;overwrite=1" -f /opt/CiscoMGC/local/create_white.sql


This null the Timesten Database by creating new datastore tables.

Actions

This Discussion