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 copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts How to Use DebugTool CodeCoverage Uti... neo4u IBM Tools 0 Thu Jun 22, 2017 6:38 pm


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