BMC UNLOAD ADUUMAIN: SYSREC LRECL

raghav08 · New User Joined: 03 Jun 2008 Posts: 94 Location: Bangalore

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.

dick scherrer · Posted: Thu Sep 16, 2010 7:52 pm

Hello,

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

Why is this needed externally and before the unload is run?

raghav08 · New User Joined: 03 Jun 2008 Posts: 94 Location: Bangalore

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.

PeterHolland · Posted: Fri Sep 17, 2010 12:02 pm

How do you know the blocksize is invalid ?

raghav08 · New User Joined: 03 Jun 2008 Posts: 94 Location: Bangalore

Hi.

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

Thanks.

expat · Posted: Fri Sep 17, 2010 1:40 pm

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.

PeterHolland · Posted: Fri Sep 17, 2010 2:14 pm

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....

raghav08 · New User Joined: 03 Jun 2008 Posts: 94 Location: Bangalore

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'

dbzTHEdinosauer · Posted: Fri Sep 17, 2010 3:21 pm

what are the results of a 3.4 I ?

raghav08 · New User Joined: 03 Jun 2008 Posts: 94 Location: Bangalore

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.

dick scherrer · Posted: Fri Sep 17, 2010 7:26 pm

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

d