Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Hi, Getting problem in LOAD utility when uploading data

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
vijayalayancse

New User


Joined: 29 Aug 2005
Posts: 25
Location: Chennai

PostPosted: Thu Jul 19, 2007 12:32 pm    Post subject: Hi, Getting problem in LOAD utility when uploading data
Reply with quote

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..?
Back to top
View user's profile Send private message

sandeep1dimri

New User


Joined: 30 Oct 2006
Posts: 76

PostPosted: Thu Jul 19, 2007 2:02 pm    Post subject:
Reply with quote

Hi

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




Are you merging or refreshing the table?


Sandeep
Back to top
View user's profile Send private message
vijayalayancse

New User


Joined: 29 Aug 2005
Posts: 25
Location: Chennai

PostPosted: Thu Jul 19, 2007 3:23 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts 3270 Data stream error Benchwarmer CICS 4 Tue Apr 17, 2018 12:06 am
No new posts How to list data set names with diffe... murali.andaluri CLIST & REXX 8 Thu Apr 12, 2018 11:33 pm
No new posts Invalid XML character while producing... nikhil.bhole IBM Tools 4 Tue Mar 20, 2018 1:24 am
No new posts Get the list of data sets on DASD and... rakaitn JCL & VSAM 3 Thu Mar 08, 2018 12:38 pm
No new posts can we hardcode a value in db2 load c... ram_vizag DB2 2 Wed Feb 28, 2018 11:04 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us