Question

1
Replies
145
Views
Close popover
Robert Knebel (RobertK1983)
Scotiabank

Scotiabank
CA
RobertK1983 Member since 2015 5 posts
Scotiabank
Posted: April 9, 2019
Last activity: April 12, 2019
Closed

Reduce backup time for DB2 10.5 database which is 2.7TB in size

Has this been tried before? Any experiences?

The backup time of the current table space will be reduced, and hopefully the new tablespace backup can run in parallel.

There are 3,345 tables with ‘HISTORY’ keyword in table name (all under schema DATA), though only 41 tables have data currently. They are using about 600GB space.

Suggestion is to create new history tablespaces(DATA, INDEX & LOB) and bufferpool, then use DB2 online table move function move these 41 tables one by one to new tablespaces during a weekend maintenance window.

We can monitor backup time after the change. If the new backup time is still not good enough, we can think about move the huge 1.2TB table DATA.PC_DATA_WORKATTACH to a standalone new tablespace.

Top 20 tables listed:

SCHEMA TABLE NAME DATA_SIZE INDEX_SIZE TABLE_SIZE Summary
DATA PR_HISTORY_XXX_CB_BFA_WORK 131158016 9869312 141027328 141027328
DATA PC_HISTORY_XXX_CB_SS_RSC_WORK 50284544 6961152 57245696 57245696
DATA PC_HISTORY_XXX_CEA_WORK 51401728 5598208 56999936 56999936
DATA PC_HISTORY_XXX_CB_RB_MTG_WORK 36471808 6100992 42572800 42572800
DATA PC_HISTORY_XXX_CB_DFOB_WORK 33820672 5958656 39779328 39779328
DATA PC_HISTORY_XXX_CB_CCOB_WORK 32603136 4847616 37450752 37450752
DATA PR_HISTORY_XXX_CB_BFA_WORK_PRO 29696000 3586048 33282048 33282048
DATA PR_HISTORY 23605248 3128320 26733568 26733568
DATA PC_HISTORY_XXX_CB_SS_SSC_257C8 22736896 3357696 26094592 26094592
DATA PC_HISTORY_XXX_CB_SSG_WORK 22841344 2742016 25583360 25583360
DATA PC_HISTORY_XXX_CB_RB_MCB_WORK 18850048 2584064 21434112 21434112
DATA PC_HISTORY_XXX_CB_SS_SSIS_WORK 17866752 2361344 20228096 20228096
DATA PC_HISTORY_XXX_CB_SS_UNP_1F3AE 15543296 2716672 18259968 18259968
DATA PC_HISTORY_XXX_CB_RB_SMA_AEA7B 12367872 1224704 13592576 13592576
DATA PC_HISTORY_XXX_CB_CCSOLNPA_WOR 7964672 1486848 9451520 9451520
DATA PC_HISTORY_XXX_CB_SC_SCOB_WORK 8264704 1004544 9269248 9269248
DATA PR_HISTORY_DATA 8227840 1008640 9236480 9236480
DATA PC_HISTORY_XXX_FW_RSCFW_WORK 7211008 1000448 8211456 8211456
DATA PC_HISTORY_XXX_CB_SS_BCAS_WORK 7007232 1039360 8046592 8046592

***Edited by Moderator Marissa to update platform capability tags****

Pega Platform Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.