How to delete old PI statistics and debug log files from the Foglight Agent Manager (FglAM) (4290328)

A Foglight Agent Manager (FglAM) bundle cannot be generated because the process times out.

The Statistics logs collected by the database agents take up a lot of space on the FglAM (Foglight Agent Manager) and cause FglAM support bundles to be larger. Aside from deleting old Statistics files for previous database cartridge releases, is there anything else that can be done to reduce space?

Old database cartridge agent log files are being stored on server preventing FglAM support bundles from being created.

WORKAROUND

Delete old Statistics log files for SQL PI from the following locations on the Foglight Agent Manager servers

1. At the FglAM OS level, navigate to {FglAM}\state\default\agents\fb8be857-fbcf-4747-973d-295a8570e581\DB_Oracle\
2. Delete all of the folders to cartridge versions before the current cartridge (i.e. if the current cartridge is 5.9.2.1, then delete 5.7.5.50, 5.7.5.1, etc folders)
3. Navigate into the current cartridge version folder.
4. Delete all of the compressed statistics files ending in .gz, .1, .2, .3, .4, etc.
5. Navigate to {FglAM}\state\default\agents\fb8be857-fbcf-4747-973d-295a8570e581\DB_SQL_Server\
6. Delete all of the folders to cartridge versions before the current cartridge (i.e. if the current cartridge is 5.9.2.1, then delete 5.7.5.50, 5.7.5.1, etc folders)
7. Navigate into the current cartridge version folder.
8. Delete all of the compressed statistics files ending in .gz

Delete the old database agent log files from the Foglight Agent Manager servers

1. At the FglAM OS level, navigate to {FglAM}\state\default\logs\fb8be857-fbcf-4747-973d-295a8570e581\DB_Oracle\
2. Delete all of the folders to cartridge versions before the current cartridge (i.e. if the current cartridge is 5.9.2.1, then delete 5.7.5.50, 5.7.5.1, etc folders)
3. Repeat steps 1 and 2 for the other cartridges installed in {FglAM}\state\default\logs\fb8be857-fbcf-4747-973d-295a8570e581\

Remove any old memorywarning files

1. Delete any files located in {fglam}\state\default\memorywarning

Attempt to regenerate the FglAM support bundle.

STATUS

Defect PIFOG-80 was fixed beginning in the 5.9.2.1 cartridges for the Disabled PI statistics button to function. After the cartridge has been upgraded to a version at the 5.9.2.1 level or higher, please run the following scripts to disable SQL PI statistics from being generated for existing SQL Server and Oracle agents.

Please, go to Tooling | Script Console | click on the Add button, paste a groovy script from the list below, and then run the groovy script.

NOTE: Users must be logged into Supportlink to access and download these scripts

For Oracle database agents (non-RAC)

Run the attached script called "List_all_of_the_Oracle_PI_Debug_Statistics_settings.groovy" to list the current status the PI statistics for all Oracle (non-RAC) database agents.

• The value "0" indicates that PI statistics is disabled for the agent.
• The value "1" indicates that PI statistics are enable for the agent

Run the attached script called "Update_all_Oracle_PI_Statistics_debug_to_off.groovy" to turn off the PI statistics for all Oracle (non-RAC) database agents.

For Oracle RAC database agents

Run the attached script called "List_all_of_the_Oracle_RAC_PI_Debug_Statistics_settings.groovy" to list the current status the PI statistics for all Oracle (non-RAC) database agents.

• The value "0" indicates that PI statistics is disabled for the agent.
• The value "1" indicates that PI statistics are enable for the agent

Run the attached script called "Update_all_Oracle_RAC_PI_Statistics_debug_to_off.groovy" to turn off the PI statistics for all Oracle (non-RAC) database agents.

• The value "0" indicates that PI statistics is disabled for the agent.
• The value "1" indicates that PI statistics are enable for the agent

For SQL Server agents

Run the attached script called "List_all_of_the_SQL_PI_Debug_Statistics_settings.groovy"  to list the current status the PI statistics for all SQL Server database agents.

• The value "0" indicates that PI statistics is disabled for the agent.
• The value "1" indicates that PI statistics are enable for the agent

Run the attached script called "Update_all_SQL_PI_Statistics_debug_to_off.groovy" to turn off the PI statistics for all SQL Server database agents.

Delete old Statistics log files for SQL PI from the following locations on the Foglight Agent Manager servers

1. At the FglAM OS level, navigate to {FglAM}\state\default\agents\fb8be857-fbcf-4747-973d-295a8570e581\DB_Oracle\
2. Delete all of the folders to cartridge versions before the current cartridge (i.e. if the current cartridge is 5.9.2.1, then delete 5.7.5.50, 5.7.5.1, etc folders)
3. Navigate into the current cartridge version folder.
4. Delete all of the compressed statistics files ending in .gz, .1, .2, .3, .4, etc.
5. Navigate to {FglAM}\state\default\agents\fb8be857-fbcf-4747-973d-295a8570e581\DB_SQL_Server\
6. Delete all of the folders to cartridge versions before the current cartridge (i.e. if the current cartridge is 5.9.2.1, then delete 5.7.5.50, 5.7.5.1, etc folders)
7. Navigate into the current cartridge version folder.
8. Delete all of the compressed statistics files ending in .gz