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 Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am

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