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
 

 

BMC UNLOAD ADUUMAIN: SYSREC LRECL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
raghav08
Currently Banned

New User


Joined: 03 Jun 2008
Posts: 94
Location: Bangalore

PostPosted: Thu Sep 16, 2010 6:31 pm    Post subject: BMC UNLOAD ADUUMAIN: SYSREC LRECL
Reply with quote

Hello,

We are using BMC unload utility ADUUMAIN to unload the data from DB2 table to flat file.

Please tell me how to calculate the LRECL of SYSREC (unload dataset) ?

Manually we need to calculate LRECL required by looking at SELECT query?

Thanks.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Sep 16, 2010 7:52 pm    Post subject:
Reply with quote

Hello,

If not specified doesn't the utility automatically generate proper dcb info?

Why is this needed externally and before the unload is run?
Back to top
View user's profile Send private message
raghav08
Currently Banned

New User


Joined: 03 Jun 2008
Posts: 94
Location: Bangalore

PostPosted: Fri Sep 17, 2010 11:09 am    Post subject: Reply to: BMC UNLOAD ADUUMAIN: SYSREC LRECL
Reply with quote

Hi.

We ran without specifing DCB, unload dataset created with invalid blocksize.

Tried with BLKSIZE=0 and BLKSIZE=0 with LRECL=0 also, both the cases unload dataset created with invalid block size error while accessing the dataset.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


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

PostPosted: Fri Sep 17, 2010 12:02 pm    Post subject:
Reply with quote

How do you know the blocksize is invalid ?
Back to top
View user's profile Send private message
raghav08
Currently Banned

New User


Joined: 03 Jun 2008
Posts: 94
Location: Bangalore

PostPosted: Fri Sep 17, 2010 1:36 pm    Post subject: Reply to: BMC UNLOAD ADUUMAIN: SYSREC LRECL
Reply with quote

Hi.

When I tried to browse it shows invalid blocksize, same error when the unloaded dataset accessed or read by another job.

Thanks.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Fri Sep 17, 2010 1:40 pm    Post subject:
Reply with quote

Don't know if this might help, just a passing thought ambling across the grey cell, but,

have you tried using an output of RECFM=VB and LRECL=27994, which if it works will probably cater for most unloads without need for change.

Usually I'd try this before posting, but not having that tool installed here, I can't.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


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

PostPosted: Fri Sep 17, 2010 2:14 pm    Post subject:
Reply with quote

I couldnt find any sample of ADUUMAIN jobs with dcb parameters defined
on the output dataset. So i go with Dick Scherrer.
What kind of program you used for reading the unload dataset ?
A BMC load job?
And browsing with what? And what kind of error messages?

If the output is on dasd, you could look at the vtoc info for that
dataset. It could be that the recfm is undefined.

Questions, questions....
Back to top
View user's profile Send private message
raghav08
Currently Banned

New User


Joined: 03 Jun 2008
Posts: 94
Location: Bangalore

PostPosted: Fri Sep 17, 2010 2:49 pm    Post subject: Reply to: BMC UNLOAD ADUUMAIN: SYSREC LRECL
Reply with quote

Hi

1) Output used as input to Teradata MLOAD utility JCL
2) With manual browse (option 'B') of unload dataset , error message 'Invalid Block Size'
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Sep 17, 2010 3:21 pm    Post subject:
Reply with quote

what are the results of a 3.4 I ?
Back to top
View user's profile Send private message
raghav08
Currently Banned

New User


Joined: 03 Jun 2008
Posts: 94
Location: Bangalore

PostPosted: Fri Sep 17, 2010 4:24 pm    Post subject: Reply to: BMC UNLOAD ADUUMAIN: SYSREC LRECL
Reply with quote

Sorry All,

The issue not with DCB parameters.

1) When the ouput of SELECT query is zero rows then it having error - invalid block size.

2) For the successful SELECT, BMC utility creates a valid unload (SYSREC) dataset.

Thanks.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Sep 17, 2010 7:26 pm    Post subject: Reply to: BMC UNLOAD ADUUMAIN: SYSREC LRECL
Reply with quote

Good to hear it is working - thank you for letting us know icon_smile.gif

d
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 PL/I: opening file w/ dynamically det... Sam Dodgers PL/I & Assembler 6 Wed Jul 27, 2016 4:05 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


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