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

DB2 Imagecopy unload


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
dharani.nagarajan

New User


Joined: 11 Nov 2010
Posts: 21
Location: India

PostPosted: Wed Sep 14, 2011 1:04 pm
Reply with quote

Hi,

I have 5 Jcls that unload data from imagecopy of 5 DB2 tables.
I have used BMCUNLD utility for this.

For 3 unloads the output files is created in FB and for the other 2 the output unload files are in VB format.
But in the JCL the RECFM is specified as FB only but when the job runs it creates in VB format. Please find the below specification

//SYSREC DD DISP=(NEW,CATLG,DELETE),
// UNIT=SYSDA,
// SPACE=(TRK,(25000,2500),RLSE),
// DCB=(BLKSIZE=0,RECFM=FB,LRECL=659),
// LABEL=RETPD=42,
// DSN=TEST.UNLOAD.TABLE1


Can anyone please help me in this.. I need to have the file in FB only.
Also can you please tell me why this is happening.

Thanks for your help

Thanks,
Dharani
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Sep 14, 2011 1:14 pm
Reply with quote

Quote:
Also can you please tell me why this is happening.

most probably because the tables differ on column type definition and attributes

null/not null, varchar ...

browsing the unloaded data might give You more hints
Back to top
View user's profile Send private message
dharani.nagarajan

New User


Joined: 11 Nov 2010
Posts: 21
Location: India

PostPosted: Wed Sep 14, 2011 1:19 pm
Reply with quote

Hi Enrico,

Thanks a lot for the information.
Is there any way that I can create them in FB format.


Thanks,
Dharani
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India

PostPosted: Wed Sep 14, 2011 1:20 pm
Reply with quote

Please check the below options and what values have been set in your SYSPRINT of unload step.

Quote:
USELRECL=
RECFM=
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Sep 14, 2011 1:22 pm
Reply with quote

Quote:
Is there any way that I can create them in FB format.


Why ?
and do not give the stupid reply "that' s the requirement"
Back to top
View user's profile Send private message
dharani.nagarajan

New User


Joined: 11 Nov 2010
Posts: 21
Location: India

PostPosted: Wed Sep 14, 2011 1:33 pm
Reply with quote

Hi Enrico,

I want to know is there any way if I can do this.
Else I can add a step to convert this file to FB.

I saw the DCLGENs for these tables.
For the tables with VARCHAR fields the unloads are created in VB format.
As you said it is because of the data types.

Thank you

Thanks,
Dharani
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India

PostPosted: Wed Sep 14, 2011 1:38 pm
Reply with quote

Hint:

Code:
FIXEDVARCHAR YES
in unload card.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Sep 14, 2011 1:58 pm
Reply with quote

You did not reply to my question ... Why force an FB format
Back to top
View user's profile Send private message
dharani.nagarajan

New User


Joined: 11 Nov 2010
Posts: 21
Location: India

PostPosted: Wed Sep 14, 2011 3:51 pm
Reply with quote

Hi Gnana Sekaran,

The code worked find for me
FIXEDVARCHAR YES

Thanks a lot for your help.

Hi Enrico,

The programs that use this file is expecting a FB file so I need to have the file in FB only.
Since I have more number of programs I thought of trying to create FB file.
If I would say in another way its the requirement (Hope you dont mind).

Thanks,
Dharani
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Sep 14, 2011 4:00 pm
Reply with quote

I just do not care... icon_cool.gif
if Your organization is happy with a silly approach... we are happy icon_biggrin.gif
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Wed Sep 14, 2011 4:07 pm
Reply with quote

Quote:

if Your organization is happy with a silly approach... we are happy


Speak for yourself Enrico icon_mad.gif
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India

PostPosted: Wed Sep 14, 2011 4:36 pm
Reply with quote

Hi Enrico,

Quote:
...with a silly approach...


Sorry for this. icon_sad.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Wed Sep 14, 2011 4:42 pm
Reply with quote

Quote:
Sorry for this.

nothing to be sorry
my comment was not for Your solution, but for the overall approach on TS organization side
and how they throw money down the sewer

and I am still happy icon_biggrin.gif
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Wed Sep 14, 2011 4:43 pm
Reply with quote

Hi,

Option FIXEDVARCHAR is only available in BMCUNLOAD?
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Wed Sep 14, 2011 5:03 pm
Reply with quote

gylbharat wrote:
Hi,

Option FIXEDVARCHAR is only available in BMCUNLOAD?
NOPAD
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Wed Sep 14, 2011 8:12 pm
Reply with quote

Thanks GuyC....
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 Load new table with Old unload - DB2 DB2 6
No new posts Remote Unload of CLOB Columns DB2 6
No new posts Multiple table unload using INZUTILB DB2 2
No new posts changing defaults in db2 admin - Unlo... DB2 0
No new posts DB2 Table - Image copy unload IBM Tools 2
Search our Forums:

Back to Top