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 Imagecopy unload

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: DB2 Imagecopy unload
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Wed Sep 14, 2011 1:14 pm    Post subject: Reply to: DB2 Imagecopy unload
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    Post subject:
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: 785
Location: Chennai, India

PostPosted: Wed Sep 14, 2011 1:20 pm    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Wed Sep 14, 2011 1:22 pm    Post subject: Reply to: DB2 Imagecopy unload
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    Post subject:
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: 785
Location: Chennai, India

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

Hint:

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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Wed Sep 14, 2011 1:58 pm    Post subject: Reply to: DB2 Imagecopy unload
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    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Wed Sep 14, 2011 4:00 pm    Post subject: Reply to: DB2 Imagecopy unload
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: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Sep 14, 2011 4:07 pm    Post subject:
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: 785
Location: Chennai, India

PostPosted: Wed Sep 14, 2011 4:36 pm    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Wed Sep 14, 2011 4:42 pm    Post subject: Reply to: DB2 Imagecopy unload
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    Post subject:
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: 1278
Location: Belgium

PostPosted: Wed Sep 14, 2011 5:03 pm    Post subject:
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    Post subject:
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    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 Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts DB2 Unload format options Susanta DB2 2 Fri Aug 12, 2016 5:42 pm
No new posts DXT unload utility - DVRE0000 mistah kurtz DB2 1 Thu Jul 07, 2016 4:56 pm
No new posts How to suppress retun code of partil ... mkk157 DB2 9 Fri May 27, 2016 6:59 am
No new posts IBMHPU - Tablespace and Imagecopy chaitanya bharath DB2 1 Fri Apr 15, 2016 5:54 pm


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