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
 
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: 1783
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: 1783
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 Format Last Record differently from r... Learncoholic DFSORT/ICETOOL 5 Tue Oct 24, 2017 12:01 pm
No new posts Format issues using XMITIP MSGDD ssdjp1 CLIST & REXX 5 Mon Oct 23, 2017 8:47 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Where is output from PARM ABEXIT (SNA... packerm CA Products 3 Thu Sep 28, 2017 4:06 pm
No new posts MQ command in option 6 of ISPF! Vignesh Sid All Other Mainframe Topics 3 Tue Sep 26, 2017 6:01 pm

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