Archiving old data

[illllm]

Hi All,

So, I have about 200 users who use a system maybe once in 3 years or maybe never. Out of this only 8 are actually active. Total size of all the data is about 1 PB.

If i archive the data for all non-active users, will it reduce the DB size ? I am asking this because our DB is close to 7 TB now and affecting performance.

 

[marclant]

If i archive the data for all non-active users, will it reduce the DB size ?

If you archive the data, this will add to the database. You may gain some space if you delete the backup data.

... and affecting performance.

Are you using 12 database directories/LUNs and SSD for DB & active log?

I am asking this because our DB is close to 7 TB now...

Should review this: https://www-01.ibm.com/support/docview.wss?uid=swg21683633

 

[illllm]

reorg runs and completes fine. Its just that we have a lot of data and we are now planning to move to a 3rd TSM server

Date/Time Message 2018-03-27, 13:52:31ANR0293I Reorganization for table DF_BITFILES started.2018-03-27, 14:07:31ANR0293I Reorganization for table DF_SEGMENTS started.2018-03-28, 12:04:54ANR0293I Reorganization for table SD_CONTAINERS started.2018-03-28, 12:19:55ANR0293I Reorganization for table SS_VOLUME_IDS started.2018-03-28, 14:30:59ANR0293I Reorganization for table AF_VOL_PARTIAL_BITFILES started.2018-03-29, 14:19:23ANR0293I Reorganization for table RESTORE_SRVOBJ started.2018-03-30, 13:27:21ANR0293I Reorganization for table TSMMON_ALERT started.2018-04-01, 12:54:33ANR0293I Reorganization for table AF_BITFILES started.2018-04-01, 17:42:33ANR0293I Reorganization for table AF_SEGMENTS started.2018-04-01, 17:57:33ANR0293I Reorganization for table AF_VOL_CLUSTERS started.2018-04-02, 12:02:57ANR0293I Reorganization for table BF_SUPER_AGGREGATES started.2018-04-02, 13:13:18ANR0293I Reorganization for table AS_SEGMENTS started.2018-04-02, 13:28:21ANR0293I Reorganization for table BF_AGGREGATE_ATTRIBUTES started.2018-04-02, 13:43:24ANR0293I Reorganization for table SS_POOL_CONTENTS started.

 

[illllm]

yes 12 directories