I plan to call the support center in a bit but thought I'd throw this out to the experts and see if anyone has any thoughts.
TSM Server 4.2.1.7 on AIX 4.3.3 ML6. The time source that we use for our machines got set to the year 2021 recently (that's another whole story!). As a result we have a record in the summary table from 2021. We are in the process of setting up TDS reporting and it turns out that is uses the summary table as part of the input. The command below gets issues when you run the TDS loader. 03/28/2002 06:52:29 ANR2017I Administrator ISMBATCH issued command: DEFINE CURSOR C3330188 SQL="SELECT * from SUMMARY where END_TIME >= '2021-08-18 06:02:19' order by END_TIME" As a result a majority of the cubes that get built as part of TDS are empty. We have been running with the summaryretention set to 30. I reset it to 0 hoping it would reset the table. No luck. Started and stopped TSM while it was set to 0...still no luck. Looking for a way to purge the record from the database. Here's the offending record: START_TIME: 2021-08-18 06:00:06.000000 END_TIME: 2021-08-18 06:02:19.000000 ACTIVITY: STGPOOL BACKUP NUMBER: 440 ENTITY: BACKUPPOOL -> OFFSITE COMMMETH: ADDRESS: SCHEDULE_NAME: COPY_BACKUPPOOL_OFFSITE EXAMINED: 162 AFFECTED: 162 FAILED: 0 BYTES: 28143616 IDLE: 0 MEDIAW: 62 PROCESSES: 1 SUCCESSFUL: YES VOLUME_NAME: DRIVE_NAME: LIBRARY_NAME: LAST_USE: Thoughts? Curt Magura Lockheed Martin EIS Gaithersburg, Md. 301-240-6305
