Eamonn Downey - when using load u can use the "nonrecoverable" option so if there is a problem it will not place the tablespace into "backup pending" state
Hi Team,
When you are using db2 load command to load data to table, we must speicify "nonrecoverable" option .
Sample:
db2 load CLIENT from "C:WSAD51dsw87SQOprcbk_quote_line_item_config_runt_101905.ixf" of ixf messages "e:tempduke.msg" replace into ebiz1.prcbk_quote_line_item_config(quote_id, quote_seq_num, add_date, add_by_user_name, mod_date, mod_by_user_name) NONRECOVERABLE
Please keep in mind. Thanks!
Load command:
load CLIENT from "D:tempcfpi.csv" of del modified by keepblanks timestampformat="M/D/YYYY H:M:SS.UUUUUU TT" method p(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,36,37,38,39,40,41,42,43,44,45,46,47,48,49) insert into wwpp2.cambrdg_fnshd_part_info(PART_NUM, PART_DSCR, PROD_OBSLTE_FLAG, PROD_EOL_DATE, MFR_CO_NAME, PROD_UOM_CODE, UNITS_PER_CARTON, CARTONS_PER_PALLET, UNIT_WEIGHT, UNIT_HEIGHT, UNIT_WIDTH, UNIT_DEPTH, FCS_PLAN_DATE ,FCS_ACTL_DATE ,UPC_EAN_MFR_ID ,UPC_EAN_PROD_ID ,UPC_EAN_CHECK_DIGIT ,PROD_VER ,WWIDE_PROD_CODE ,REVN_STREAM_CODE ,SEAT_QTY ,PROD_LANG_CODE ,OS_CODE ,PROD_DISTRIBTN_CODE ,CTRCT_PROG_CODE ,PROD_MEDIA_CODE ,UNIT_COGS_AMT ,UNIT_MATL_COGS_AMT ,FULFLLMT_CO_NAME ,PROD_MIX_ID ,CATALOG_WWIDE_PROD_CODE ,FNCL_RPTG_CODE ,PART_DSCR_LONG ,RENWL_NOT_AVAIL_FLAG ,CNTRIBTN_PTS ,CNTRIBTN_USERS ,PROD_TRGT_MKT_CODE ,IBM_PROD_ID ,CATALOG_IND ,IBM_WHLSL_DIV_CODE ,DURATION_IND ,SAP_SELL_FLAG ,SW_SBSCRPTN_ID ,TRAN_SYS_ADD_DATE ,TRAN_SYS_MOD_DATE ,ADD_DATE ,ADD_BY_EMP_NUM ) NONRECOVERABLE
Query command:
db2 load query table RNWL1.MAINT_RENWL_FACT_TRG
Terminate command:
load CLIENT from "D:tempdwdm2.MAINT_RENWL_FACT_TRG.ixf" of ixf messages
terminate into RNWL1.MAINT_RENWL_FACT_TRG NONRECOVERABLE
Release Table:
db2 set integrity for odsf1.top_cntribtr_distribtr_cust immediate checked
如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!
赞0
添加新评论0 条评论