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
 

 

DSNU335I problem in DB2 Loading

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

New User


Joined: 11 Mar 2010
Posts: 59
Location: China,Shanghai

PostPosted: Fri Jul 02, 2010 11:14 am    Post subject: DSNU335I problem in DB2 Loading
Reply with quote

The job log is:

Code:
  DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = LDDATA                       
  DSNUGTIS - PROCESSING SYSIN AS EBCDIC                                     
  DSNUGUTC -  LOAD DATA REPLACE STATISTICS NOCOPYPEND LOG NO INDDN(SYSREC00)
-DSTA DSNURWI -  INTO TABLE PERFDAT                                         
-DSTA DSNURWI -   (SYEAR POSITION(1:4) CHAR(4),                             
-DSTA DSNURWI -    SMONTH POSITION(6:7) CHAR(2),                             
-DSTA DSNURWI -    SDAY POSITION(9:10) CHAR(2),                             
-DSTA DSNURWI -    STIME POSITION(12) TIME EXTERNAL,                         
-DSTA DSNURWI -    ID POSITION(21:25) INTEGER EXTERNAL(5),                   
-DSTA DSNURWI -    ISHOLIDAY POSITION(27:27) INTEGER EXTERNAL(1),           
-DSTA DSNURWI -    COMMENT POSITION(28:28) CHAR(1),                         
-DSTA DSNURWI -    VALUE POSITION(29) FLOAT(21))                             
-DSTA DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE                   
-DSTA DSNURWBG - INPUT FIELD 'VALUE' NOT ENTIRELY WITHIN INPUT RECORD       
-DSTA DSNURWBG - INPUT FIELD 'VALUE' NOT ENTIRELY WITHIN INPUT RECORD       
-DSTA DSNURWBG - INPUT FIELD 'VALUE' NOT ENTIRELY WITHIN INPUT RECORD       
-DSTA DSNURWBG - INPUT FIELD 'VALUE' NOT ENTIRELY WITHIN INPUT RECORD       
-DSTA DSNURWBG - INPUT FIELD 'VALUE' NOT ENTIRELY WITHIN INPUT RECORD       
-DSTA DSNURWBG - INPUT FIELD 'VALUE' NOT ENTIRELY WITHIN INPUT RECORD       
-DSTA DSNURWBG - INPUT FIELD 'VALUE' NOT ENTIRELY WITHIN INPUT RECORD       
-DSTA DSNURWBG - INPUT FIELD 'VALUE' NOT ENTIRELY WITHIN INPUT RECORD       
-DSTA DSNURWBG - INPUT FIELD 'VALUE' NOT ENTIRELY WITHIN INPUT RECORD       


load file content is:

Code:
2010 05 04 00:00:00 21581 0 15.7   
2010 05 04 00:00:00 21582 0 2.6   
2010 05 04 00:00:00 21583 0 0.3   
2010 05 04 00:00:00 21584 0 1.5   
2010 05 04 00:00:00 21585 0 7.9   
2010 05 04 00:00:00 21586 0 2.8   
2010 05 04 00:00:00 21587 0 636.7 
2010 05 04 00:00:00 21588 0 1427.0
2010 05 04 00:00:00 21589 0 0.0   
2010 05 04 00:00:00 21590 0 0.0   
2010 05 04 00:00:00 21591 0 0.7   
2010 05 04 00:00:00 21592 0 0.5   
2010 05 04 00:00:00 21593 0 0.0   
2010 05 04 00:00:00 21594 0 1.1   
2010 05 04 00:00:00 21595 0 0.0   
2010 05 04 00:00:00 21596 0 0.0   
2010 05 04 00:00:00 21597 0 0.0   
2010 05 04 00:00:00 21598 0 0.0   
2010 05 04 00:00:00 21599 0 18.0   

DDL of destination table is :

Code:
SET CURRENT SQLID='TBSM02';                                 
CREATE TABLE TBSM02.PERFDAT                                 
   (SYEAR                CHAR(4) FOR MIXED DATA NOT NULL,   
    SMONTH               CHAR(2) FOR MIXED DATA NOT NULL,   
    SDAY                 CHAR(2) FOR MIXED DATA NOT NULL,   
    STIME                TIME NOT NULL,                     
    ID                   INTEGER NOT NULL,                 
    "VALUE"              REAL WITH DEFAULT NULL,           
    ISHOLIDAY            INTEGER WITH DEFAULT 0,           
    "COMMENT"            VARCHAR(20) FOR MIXED DATA         
      WITH DEFAULT NULL,                                   
    CONSTRAINT SYEAR                                       
    PRIMARY KEY (SYEAR,                                     
                 SMONTH,                                   
                 SDAY,                                     
                 STIME,                                     
                 ID))                                       
  IN TBSMDB.TSPERFD                                         
  PARTITION BY (SYEAR ASC,                                 
                SMONTH ASC,                                 
                SDAY ASC)                                   
   (PART 1 VALUES('2009', '11', '30'),                     
    PART 2 VALUES('2009', '12', '15'),                     
    PART 3 VALUES('2009', '12', '31'),                     
   ......
         PART 36 VALUES('2011', '05', '15'))     
   AUDIT NONE                                 
   DATA CAPTURE NONE                         
   CCSID      EBCDIC                         
   NOT VOLATILE;                             
 COMMIT;                                     

anyone who can give advice and resolution?thanks in advance!
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Jul 02, 2010 6:47 pm    Post subject:
Reply with quote

Victor Niu,

Quote:
-DSTA DSNURWBG - INPUT FIELD 'VALUE' NOT ENTIRELY WITHIN INPUT RECORD

-DSTA DSNURWI - VALUE POSITION(29) FLOAT(21))


You should try with FLOAT EXTERNAL

Thank You,
Sushanth
Back to top
View user's profile Send private message
Victor Niu

New User


Joined: 11 Mar 2010
Posts: 59
Location: China,Shanghai

PostPosted: Fri Jul 02, 2010 9:34 pm    Post subject:
Reply with quote

tried 'FLOAT EXTERNAL',the same problem
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Jul 02, 2010 9:57 pm    Post subject:
Reply with quote

Niu,

Below is my output,

Code:
DSNU000I    DSNUGUTC - OUTPUT START FOR UTILITY, UTILID = TESTLD               
DSNU1044I   DSNUGTIS - PROCESSING SYSIN AS EBCDIC                               
DSNU050I    DSNUGUTC -  LOAD DATA REPLACE STATISTICS NOCOPYPEND LOG NO INDDN(SYS
DSNU650I  # DSNURWI -  INTO TABLE BOBT1.PERFDAT                                 
DSNU650I  # DSNURWI -   (SYEAR POSITION(1:4) CHAR(4),                           
DSNU650I  # DSNURWI -    SMONTH POSITION(6:7) CHAR(2),                         
DSNU650I  # DSNURWI -    SDAY POSITION(9:10) CHAR(2),                           
DSNU650I  # DSNURWI -    STIME POSITION(12) TIME EXTERNAL,                     
DSNU650I  # DSNURWI -    ID POSITION(21:25) INTEGER EXTERNAL(5),               
DSNU650I  # DSNURWI -    VALUE POSITION(29) FLOAT EXTERNAL(21),                 
DSNU650I  # DSNURWI -    ISHOLIDAY POSITION(27:27) INTEGER EXTERNAL(1),         
DSNU650I  # DSNURWI -    COMMENT POSITION(28:28) CHAR(1))                       
DSNU350I  # DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE                 
DSNU304I  # DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=11 FOR TABLE
DSNU1147I # DSNURWT - (RE)LOAD PHASE STATISTICS - TOTAL NUMBER OF RECORDS LOADED
DSNU302I    DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCE
DSNU300I    DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:08           
DSNU610I  # DSNUSUTP - SYSTABLEPART CATALOG UPDATE FOR BOBT1.TRY2 SUCCESSFUL   
DSNU610I  # DSNUSUTB - SYSTABLES CATALOG UPDATE FOR BOBT1.PERFDAT SUCCESSFUL   
DSNU610I  # DSNUSUTS - SYSTABLESPACE CATALOG UPDATE FOR BOBT1.TRY2 SUCCESSFUL 
DSNU620I  # DSNUSEF2 - RUNSTATS CATALOG TIMESTAMP = 2010-07-02-09.13.25.489937
DSNU010I    DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=0       

Only difference between your table and mine is, yours is MIXED and mine is SBCS.

Thanks,
Sushanth
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 Strings with double quotes having pro... raja Arumugam All Other Mainframe Topics 11 Thu Mar 30, 2017 10:34 am
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts loading a Modified Mapset Susanta CICS 2 Tue Mar 14, 2017 5:43 pm
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am


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