Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Robert Knebel (RobertK1983)
Scotiabank

Scotiabank
CA
RobertK1983 Member since 2015 5 posts
Scotiabank
Posted: Apr 9, 2019
Last activity: Apr 12, 2019
Posted: 9 Apr 2019 9:41 EDT
Last activity: 12 Apr 2019 1:50 EDT
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:

Show More

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****


Show Less
To see attachments, please log in.
Pega Platform
Data Integration

Posted: 5 years ago
Posted: 12 Apr 2019 1:50 EDT
Jie Long (LONGJ)
PEGA
Fellow, Software Architect, Services Engineering
Pegasystems Inc.
US

Sounds this is not a partitioned database? Create separate/multiple tablespaces, increased buffer size and parallelism is the recommendation from DB2

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.ha.doc/doc/c0006205.html

 

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice