Control-M: 32_NAP_NONSAP - Event: JOB NOT OK App: BEACON-IS-BI-PROD-P16 Job: 9N1PR32_BEA-DATABASE-BOBI Folder: 9N1PR32_BEA-DATABASE-BOBI
'+ /usr/sap/scripts_local/sapops/scripts/hanacleaner.sh 
VERSION WARNING: You are among the first using HANACleaner on Python 3. As always, use on your own risk, and please report issues t\ 
o christian.hansen01@sap.com. Thank you! 
Will now check most used memory in the file systems. If it hangs there is an issue with  df -h, then see if the -fs flag helps. 
The most used filesystem is using  
65% 
*********************************************************** 
2025-12-31 03:00:01 
hanacleaner as pcwadm by HANACLEANERKEY on PCW(00)  with  
/usr/sap/PCW/HDB00/exe/python_support/hanacleaner.py -k HANACLEANERKEY -tc 30 -tf 30 -td true -to true -dr 10 -ar 42 -ad true -bd 3\ 
0 -op /usr/sap/PCW/HDB00/dbpcw1/trace/DB_PCW 
Cleanup Statements will be executed (-es is default true) 
 Before using HANACleaner read the disclaimer! 
    python hanacleaner.py --disclaimer 
*********************************************************** 
1 data backup entries and 194 log backup entries were removed from the backup catalog (-be and -bd) 
 
BEFORE: 
| HOST   | FILE_NAME                                                | FILE_SIZE            | FILE_MTIME                    | USED_S\ 
IZE            | 
| ------ | -------------------------------------------------------- | -------------------- | ----------------------------- | ------\ 
-------------- | 
| dbpcw1 | backup.log                                               |            175814289 | 2025-12-31 03:00:03.000000000 |       \ 
     176431104 | 
| dbpcw1 | backint.log                                              |            185723679 | 2025-12-31 03:00:03.000000000 |       \ 
     185827328 | 
| dbpcw1 | indexserver_dbpcw1.30040.001.trc                         |              6482709 | 2025-12-31 02:55:56.000000000 |       \ 
       6488064 | 
| dbpcw1 | indexserver_dbpcw1.30040.executed_statements.001.trc     |              2070001 | 2025-12-31 02:51:29.000000000 |       \ 
       2076672 | 
| dbpcw1 | indexserver_dbpcw1.30040.unloads.000.trc                 |              1312593 | 2025-12-31 02:50:16.000000000 |       \ 
       1318912 | 
| dbpcw1 | indexserver_dbpcw1.30040.loads.000.trc                   |              4208455 | 2025-12-31 02:50:16.000000000 |       \ 
       4214784 | 
| dbpcw1 | indexserver_dbpcw1.30040.table_consistency_check.000.trc |              2519392 | 2025-12-30 08:14:37.000000000 |       \ 
       2527232 | 
| dbpcw1 | indexserver_dbpcw1.30040.expensive_statements.000.trc    |               721191 | 2025-12-27 03:00:06.000000000 |       \ 
        724992 | 
| dbpcw1 | indexserver_dbpcw1.30040.executed_statements.000.trc     |             10000103 | 2025-12-23 14:46:29.000000000 |       \ 
      10006528 | 
| dbpcw1 | indexserver_dbpcw1.30040.executed_statements.stat        |                    8 | 2025-12-23 14:46:29.000000000 |       \ 
          4096 | 
| dbpcw1 | indexserver_dbpcw1.30040.component_history.000.csv       |               388793 | 2025-11-08 12:01:21.000000000 |       \ 
        389120 | 
 
AFTER: 
| HOST   | FILE_NAME                                                | FILE_SIZE            | FILE_MTIME                    | USED_S\ 
IZE            | 
| ------ | -------------------------------------------------------- | -------------------- | ----------------------------- | ------\ 
-------------- | 
| dbpcw1 | backup.log                                               |            175814289 | 2025-12-31 03:00:03.000000000 |       \ 
     176431104 | 
| dbpcw1 | backint.log                                              |            185723679 | 2025-12-31 03:00:03.000000000 |       \ 
     185827328 | 
| dbpcw1 | indexserver_dbpcw1.30040.001.trc                         |              6482709 | 2025-12-31 02:55:56.000000000 |       \ 
       6488064 | 
| dbpcw1 | indexserver_dbpcw1.30040.executed_statements.001.trc     |              2070001 | 2025-12-31 02:51:29.000000000 |       \ 
       2076672 | 
| dbpcw1 | indexserver_dbpcw1.30040.unloads.000.trc                 |              1312593 | 2025-12-31 02:50:16.000000000 |       \ 
       1318912 | 
| dbpcw1 | indexserver_dbpcw1.30040.loads.000.trc                   |              4208455 | 2025-12-31 02:50:16.000000000 |       \ 
       4214784 | 
| dbpcw1 | indexserver_dbpcw1.30040.table_consistency_check.000.trc |              2519392 | 2025-12-30 08:14:37.000000000 |       \ 
       2527232 | 
| dbpcw1 | indexserver_dbpcw1.30040.expensive_statements.000.trc    |               721191 | 2025-12-27 03:00:06.000000000 |       \ 
        724992 | 
| dbpcw1 | indexserver_dbpcw1.30040.executed_statements.000.trc     |             10000103 | 2025-12-23 14:46:29.000000000 |       \ 
      10006528 | 
| dbpcw1 | indexserver_dbpcw1.30040.executed_statements.stat        |                    8 | 2025-12-23 14:46:29.000000000 |       \ 
          4096 | 
| dbpcw1 | indexserver_dbpcw1.30040.component_history.000.csv       |               388793 | 2025-11-08 12:01:21.000000000 |       \ 
        389120 | 
0 trace files were removed (-tc and -tf) 
0 fullsysteminfodump zip files (that can contain both fullsystem dumps and runtime dumps) were removed (-dr) 
    (Cleaning of general files was not done since -gr was -1 (or not specified)) 
    (Compression of the backup logs was not done since -zb was negative (or not specified) or this is not more supported for your H\ 
ANA Version) 
 
REMOVED: 
| SNAPSHOT_ID                   | ALERT_ID    | ALERT_TIMESTAMP               | ALERT_RATING  | 
| 2025-11-18 15:05:51.000000000 |         140 | 2025-11-18 10:05:51.380000000 |             1 | 
 
 
1 alerts were removed (-ar) 
    (Cleaning of unknown object locks entries was not done since -kr was negative (or not specified)) 
    (Cleaning of the object history was not done since -om was negative (or not specified)) 
    (Reclaim of free logsements was not done since -lr was negative (or not specified)) 
    (Cleaning of events was not done since -eh and -eu were negative (or not specified)) 
    (Cleaning audit logs was not done since -ur was -1 (or not specified)) 
    (Cleaning of pending emails was not done since -pe was -1 (or not specified)) 
    (Defragmentation was not done since -fl was negative (or not specified)) 
    (Reclaim of row store containers was not done since -rc was negative (or not specified)) 
    (Compression re-optimization was not done since at least one flag in each of the three compression flag groups was negative (or\ 
 not specified)) 
    (Creation of optimization statistics for virtual tables was not done since -vs was false (or not specified)) 
    (Refresh of optimization statistics for virtual tables was not done since -vnr was not more than 0 (or not specified)) 
    (Cleaning of the hanacleaner logs was not done since -or was negative (or not specified)) 
VERSION WARNING: You are among the first using HANACleaner on Python 3. As always, use on your own risk, and please report issues t\ 
o christian.hansen01@sap.com. Thank you! 
Will now check most used memory in the file systems. If it hangs there is an issue with  df -h, then see if the -fs flag helps. 
The most used filesystem is using  
65% 
*********************************************************** 
2025-12-31 03:00:05 
hanacleaner as pcwadm by HANACLEANERKEY on PCW(00)  with  
/usr/sap/PCW/HDB00/exe/python_support/hanacleaner.py -k HANACLEANERKEY -tc 30 -tf 30 -td true -to true -dr 10 -ar 42 -ad true -bd 3\ 
0 -op /usr/sap/PCW/HDB00/dbpcw1/trace/ 
Cleanup Statements will be executed (-es is default true) 
 Before using HANACleaner read the disclaimer! 
    python hanacleaner.py --disclaimer 
*********************************************************** 
0 data backup entries and 0 log backup entries were removed from the backup catalog (-be and -bd) 
 
BEFORE: 
| HOST   | FILE_NAME                                                | FILE_SIZE            | FILE_MTIME                    | USED_S\ 
IZE            | 
| ------ | -------------------------------------------------------- | -------------------- | ----------------------------- | ------\ 
-------------- | 
| dbpcw1 | backup.log                                               |            175814868 | 2025-12-31 03:00:07.000000000 |       \ 
     176431104 | 
| dbpcw1 | backint.log                                              |            185724363 | 2025-12-31 03:00:07.000000000 |       \ 
     185827328 | 
| dbpcw1 | indexserver_dbpcw1.30040.001.trc                         |              6482709 | 2025-12-31 02:55:56.000000000 |       \ 
       6488064 | 
| dbpcw1 | indexserver_dbpcw1.30040.executed_statements.001.trc     |              2070001 | 2025-12-31 02:51:29.000000000 |       \ 
       2076672 | 
| dbpcw1 | indexserver_dbpcw1.30040.unloads.000.trc                 |              1312593 | 2025-12-31 02:50:16.000000000 |       \ 
       1318912 | 
| dbpcw1 | indexserver_dbpcw1.30040.loads.000.trc                   |              4208455 | 2025-12-31 02:50:16.000000000 |       \ 
       4214784 | 
| dbpcw1 | indexserver_dbpcw1.30040.table_consistency_check.000.trc |              2519392 | 2025-12-30 08:14:37.000000000 |       \ 
       2527232 | 
| dbpcw1 | indexserver_dbpcw1.30040.expensive_statements.000.trc    |               721191 | 2025-12-27 03:00:06.000000000 |       \ 
        724992 | 
| dbpcw1 | indexserver_dbpcw1.30040.executed_statements.000.trc     |             10000103 | 2025-12-23 14:46:29.000000000 |       \ 
      10006528 | 
| dbpcw1 | indexserver_dbpcw1.30040.executed_statements.stat        |                    8 | 2025-12-23 14:46:29.000000000 |       \ 
          4096 | 
| dbpcw1 | indexserver_dbpcw1.30040.component_history.000.csv       |               388793 | 2025-11-08 12:01:21.000000000 |       \ 
        389120 | 
 
AFTER: 
| HOST   | FILE_NAME                                                | FILE_SIZE            | FILE_MTIME                    | USED_S\ 
IZE            | 
| ------ | -------------------------------------------------------- | -------------------- | ----------------------------- | ------\ 
-------------- | 
| dbpcw1 | backup.log                                               |            175814868 | 2025-12-31 03:00:07.000000000 |       \ 
     176431104 | 
| dbpcw1 | backint.log                                              |            185724363 | 2025-12-31 03:00:07.000000000 |       \ 
     185827328 | 
| dbpcw1 | indexserver_dbpcw1.30040.executed_statements.001.trc     |              2072221 | 2025-12-31 03:00:07.000000000 |       \ 
       2076672 | 
| dbpcw1 | indexserver_dbpcw1.30040.001.trc                         |              6482709 | 2025-12-31 02:55:56.000000000 |       \ 
       6488064 | 
| dbpcw1 | indexserver_dbpcw1.30040.unloads.000.trc                 |              1312593 | 2025-12-31 02:50:16.000000000 |       \ 
       1318912 | 
| dbpcw1 | indexserver_dbpcw1.30040.loads.000.trc                   |              4208455 | 2025-12-31 02:50:16.000000000 |       \ 
       4214784 | 
| dbpcw1 | indexserver_dbpcw1.30040.table_consistency_check.000.trc |              2519392 | 2025-12-30 08:14:37.000000000 |       \ 
       2527232 | 
| dbpcw1 | indexserver_dbpcw1.30040.expensive_statements.000.trc    |               721191 | 2025-12-27 03:00:06.000000000 |       \ 
        724992 | 
| dbpcw1 | indexserver_dbpcw1.30040.executed_statements.000.trc     |             10000103 | 2025-12-23 14:46:29.000000000 |       \ 
      10006528 | 
| dbpcw1 | indexserver_dbpcw1.30040.executed_statements.stat        |                    8 | 2025-12-23 14:46:29.000000000 |       \ 
          4096 | 
| dbpcw1 | indexserver_dbpcw1.30040.component_history.000.csv       |               388793 | 2025-11-08 12:01:21.000000000 |       \ 
        389120 | 
0 trace files were removed (-tc and -tf) 
0 fullsysteminfodump zip files (that can contain both fullsystem dumps and runtime dumps) were removed (-dr) 
    (Cleaning of general files was not done since -gr was -1 (or not specified)) 
    (Compression of the backup logs was not done since -zb was negative (or not specified) or this is not more supported for your H\ 
ANA Version) 
0 alerts were removed (-ar) 
    (Cleaning of unknown object locks entries was not done since -kr was negative (or not specified)) 
    (Cleaning of the object history was not done since -om was negative (or not specified)) 
    (Reclaim of free logsements was not done since -lr was negative (or not specified)) 
    (Cleaning of events was not done since -eh and -eu were negative (or not specified)) 
    (Cleaning audit logs was not done since -ur was -1 (or not specified)) 
    (Cleaning of pending emails was not done since -pe was -1 (or not specified)) 
    (Defragmentation was not done since -fl was negative (or not specified)) 
    (Reclaim of row store containers was not done since -rc was negative (or not specified)) 
    (Compression re-optimization was not done since at least one flag in each of the three compression flag groups was negative (or\ 
 not specified)) 
    (Creation of optimization statistics for virtual tables was not done since -vs was false (or not specified)) 
    (Refresh of optimization statistics for virtual tables was not done since -vnr was not more than 0 (or not specified)) 
    (Cleaning of the hanacleaner logs was not done since -or was negative (or not specified))