Hi, Getting problem in LOAD utility when uploading data

vijayalayancse · New User Joined: 29 Aug 2005 Posts: 25 Location: Chennai

Hi,

I need to upload all my data from a flat file to DB2 table. I am using DB2 Load utilty for doing that. I have been using this since, 2 moths. there has been no problem. recently, I could not able to load my data into the table. still, the problem exists and there are records in my flat file.

The following is what i am getting in the spool..

THE COMPRESSION DICTIONARY WAS NOT BUILT FOR TABLE SPACE DPR6PTX.PRPTX1NL,
(RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR TABLE PRHDW.F_TE_SLS_SKU
(RE)LOAD PHASE STATISTICS - TOTAL NUMBER OF RECORDS LOADED=0 FOR TABLESPACE
(RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS NOT LOADED=3260593
E)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=3260593
E)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:41
BUILD PHASE STATISTICS - NUMBER OF KEYS=0 FOR INDEX PRHDW.X0PR1NLP PART 74
ILD PHASE STATISTICS - NUMBER OF INDEXES=0

Can someboby help me on this..?

sandeep1dimri · New User Joined: 30 Oct 2006 Posts: 76

Hi

Please provide the load utiilty name, load/merge card and SYSPRINT message.

Are you merging or refreshing the table?

Sandeep

vijayalayancse · New User Joined: 29 Aug 2005 Posts: 25 Location: Chennai

This is DSNU.. utility. i am trying to load the data. here is the sample of the sysincard..

LOAD DATA INDDN SYSREC01 LOG NO EBCDIC CCSID(500)
INTO TABLE PRHDW.F_TE_SLS_SKU PART 74 REPLACE
(SLS_DT POSITION(1:10) DATE EXTERNAL(10),
BU_ID POSITION(11:34) CHAR(24),
RGSTR_NBR POSITION(35:36) SMALLINT,
POS_TRANS_ID POSITION(37:40) INTEGER,
POS_SEQ_NBR POSITION(41:42) SMALLINT,
CRT_TS POSITION(43:68) TIMESTAMP EXTERNAL(26),
SYSUSR_ID POSITION(69:92) CHAR(24),
SKU_NBR POSITION(93:96) INTEGER NULLIF(97)='?',
UNT_SLS POSITION(98:107) DECIMAL PACKED,
LVL1_TE_XRETL_AMT POSITION(108:117) DECIMAL PACKED
LVL2_TE_XRETL_AMT POSITION(118:127) DECIMAL PACKED
HDISS_TAX_EXMPT_ID POSITION(128:133) DECIMAL PACKE
CUST_ORD_NBR POSITION(135:138) INTEGER NULLIF(139)
TE_NTWK_RSPN_CD POSITION(140:141) CHAR(2) NULLIF(1
TAX_EXMPT_TYP_CD POSITION(143:144) SMALLINT NULLIF
UPC_CD POSITION(146:160) CHAR(15) NULLIF(161)='?')

Thank you for ur follow up. let me know, if u need any more help.