IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 Load using DSNUTILB with FORMAT INTERNAL option


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
yogi.47eie

New User


Joined: 16 Aug 2006
Posts: 45
Location: india

PostPosted: Wed May 28, 2014 4:54 pm
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
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: 1788
Location: Bloomington, IL

PostPosted: Wed May 28, 2014 5:05 pm
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: 45
Location: india

PostPosted: Wed May 28, 2014 7:01 pm
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: 1788
Location: Bloomington, IL

PostPosted: Wed May 28, 2014 8:26 pm
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: 45
Location: india

PostPosted: Thu May 29, 2014 1:18 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Populate last day of the Month in MMD... SYNCSORT 2
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts How to load to DB2 with column level ... DB2 6
No new posts SCOPE PENDING option -check data DB2 2
Search our Forums:

Back to Top