Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us