PGW Database

Answered Question
Jun 2nd, 2010

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,

I have this problem too.
0 votes
Correct Answer by scpage about 6 years 7 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

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