Question

1
Replies
95
Views
RobertK1983 Member since 2015 5 posts
Scotiabank
Posted: 1 year ago
Last activity: 1 year 6 months ago
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:

SCHEMATABLE NAMEDATA_SIZEINDEX_SIZETABLE_SIZESummary
DATAPR_HISTORY_XXX_CB_BFA_WORK1311580169869312141027328141027328
DATAPC_HISTORY_XXX_CB_SS_RSC_WORK5028454469611525724569657245696
DATAPC_HISTORY_XXX_CEA_WORK5140172855982085699993656999936
DATAPC_HISTORY_XXX_CB_RB_MTG_WORK3647180861009924257280042572800
DATAPC_HISTORY_XXX_CB_DFOB_WORK3382067259586563977932839779328
DATAPC_HISTORY_XXX_CB_CCOB_WORK3260313648476163745075237450752
DATAPR_HISTORY_XXX_CB_BFA_WORK_PRO2969600035860483328204833282048
DATAPR_HISTORY2360524831283202673356826733568
DATAPC_HISTORY_XXX_CB_SS_SSC_257C82273689633576962609459226094592
DATAPC_HISTORY_XXX_CB_SSG_WORK2284134427420162558336025583360
DATAPC_HISTORY_XXX_CB_RB_MCB_WORK1885004825840642143411221434112
DATAPC_HISTORY_XXX_CB_SS_SSIS_WORK1786675223613442022809620228096
DATAPC_HISTORY_XXX_CB_SS_UNP_1F3AE1554329627166721825996818259968
DATAPC_HISTORY_XXX_CB_RB_SMA_AEA7B1236787212247041359257613592576
DATAPC_HISTORY_XXX_CB_CCSOLNPA_WOR7964672148684894515209451520
DATAPC_HISTORY_XXX_CB_SC_SCOB_WORK8264704100454492692489269248
DATAPR_HISTORY_DATA8227840100864092364809236480
DATAPC_HISTORY_XXX_FW_RSCFW_WORK7211008100044882114568211456
DATAPC_HISTORY_XXX_CB_SS_BCAS_WORK7007232103936080465928046592

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

Pega Platform Data Integration
Moderation Team has archived post
Share this page LinkedIn