SCE Collection Manager prunetable.sh

[mcrosio]

I am trying to use the command prunetable.sh but it doesn't work.

The command is the following:

----------------------------------------------

-bash-3.2$ ./prunetable.sh 85 INI_VALUES

Are you sure you want to prune table INI_VALUES ? (yes/no): yes

Periodic delete not created. Use user guide to create periodic delete procedures.

-bash-3.2$

--------------------------------------------

I also checked the periodic delete configuration:

-----------------------------------------------------------------------------------------

-bash-3.2$ ./dbperiodic.py --dump

[4 hourly 30 days]

active = true

daystokeep = 30

tablenames = RPT_LUR,RPT_TOPS_PERIOD1

minute = 0

hour = 0,4,8,12,16,20

day = *

month = *

Warning: table name 'RPT_UVLINK' not found in DB, proceeding anyway

Warning: table name 'RPT_DVLINK' not found in DB, proceeding anyway

[4 hourly 7 days]

active = true

daystokeep = 7

tablenames = RPT_SUR,RPT_TOPS_PERIOD0,RPT_UVLINK,RPT_DVLINK

minute = 0

hour = 2,6,10,14,18,22

day = *

month = *

[4 hourly 14 days]

active = true

daystokeep = 14

tablenames = RPT_PUR,RPT_VLUR

minute = 0

hour = 1,5,9,13,17,21

day = *

month = *

[4 hourly 2 days]

active = true

daystokeep = 2

tablenames = RPT_TR,RPT_MALUR

minute = 0

hour = 3,7,11,15,19,23

day = *

month = *

-bash-3.2$

-------------------------------------------------------------------

What could be the problem ?

Thanks,

Marco

[Shelley Bhalla]

INI_VALUES is a hidden table and does not require pruning. INI_VALUES tables does not store RDR's but stores state and field format of all the SCE and its protocols.

This does not require pruning.

If all others are pruning fine then we dont have any issue here.

Shelley.

[mcrosio]

Thank you for your reply.

I just used prunetable.sh with a table that stores RDRs and it works.

I wanted to delete old entries in the INI_VALUES table because some SCEs were removed from the network but they are still present in the SCABB reporter. If I had deleted the INI_VALUES table I would have to reload the service configuration on all the SCEs to regenerate this table. Is it correct ?

Do you have any suggestion to avoid deleting the INI_VALUES table ?

Thanks,

Marco

[Shelley Bhalla]

Yes. If you delete the INI_VALUES table and apply the config once from the SCA-BB it will recreate the INI_VALUES table.

for confirmation that the INI_VALUES table will be recreated, You should see "updating the CM" in the logs at the bottom of SCA-BB.

Shelley.