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
 

 

DB2 Load using DSNUTILB with FORMAT INTERNAL option

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

New User


Joined: 16 Aug 2006
Posts: 28
Location: india

PostPosted: Wed May 28, 2014 4:54 pm    Post subject: DB2 Load using DSNUTILB with FORMAT INTERNAL option
Reply with quote

Dear Team,
Could you please help in resolving the issue with "FORMAT INTERNAL " option.
1.Data was unloaded using the DSNUTILB with option as
UNLOAD DATA FORMAT INTERNAL FROM TABLE SHEMA.TABLE
2.It created unload file in VB format(4 bytes) + 6 bytes extra in starting of every record.
3.I was trying to load the same file using the utility DSNUTILB with option as LOAD DATA INDDN(SYSREC) LOG NO
RESUME YES
FORMAT INTERNAL
INTO TABLE SHEMA.TABLE

getting the error as below..

DSNU334I .. DSNURWBF - INPUT FIELD 'RECORD HEADER LENGHT FOR FORMAT INTERNAL INVALID FOR 'SHEMA.TABLE', ERROR CODE '34'

My aim is to make sure file unloaded with option 'FORMAT INTERNAL' is giving optimal CPU usage
and the unloaded file can be restored back incase of any issues.I am facing issues in LOAD step

Checked the manual
http://www-01.ibm.com/support/docview.wss?uid=swg1PM91639

But was asked to check the data and resubmit it again..
As per my understanding ,If the file unloaded is in DB2 internal format then with out further modification I should be able to load back.
Any help is much appreciated.
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Wed May 28, 2014 5:05 pm    Post subject:
Reply with quote

Cut and paste from the sysout, using Code tags to maintain alignment. The message that you purport to have received is dubious.
Back to top
View user's profile Send private message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 28
Location: india

PostPosted: Wed May 28, 2014 7:01 pm    Post subject: Reply to: DB2 Load using DSNUTILB with FORMAT INTERNAL optio
Reply with quote

Please find the message...I have masked the job name and table name alone ...
Code:
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Wed May 28, 2014 8:26 pm    Post subject:
Reply with quote

Ah, DB2 V11.

For one or records, the actual record length does not equal the record length specified in the header. Find and correct the discrepancies; Kolusu or Mr. Woodger may be able to advise you how to do this with your sort product, or you may need to write a programette .
Back to top
View user's profile Send private message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 28
Location: india

PostPosted: Thu May 29, 2014 1:18 pm    Post subject: Reply to: DB2 Load using DSNUTILB with FORMAT INTERNAL optio
Reply with quote

Hi All,
It seems like the VB file was edited and caused the records corrupted.Load is working fine now .Thanks for your time.
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 BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
No new posts Low values Results from VARCHAR FORMAT balaji81_k DB2 10 Thu Oct 20, 2016 1:18 am
No new posts output data in CSV Format janmejay COBOL Programming 8 Sat Oct 15, 2016 2:20 pm


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