IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

BMC Unload utility


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

New User


Joined: 26 Sep 2008
Posts: 12
Location: Bangalore

PostPosted: Sat May 10, 2014 2:51 pm
Reply with quote

Hi,

Using BMC unload utility, is it possible to write discarded records, after an unload, from db2 tables to a dataset like disc ddn?

Thanks,
Suja
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Mon May 12, 2014 4:24 pm
Reply with quote

Suja,

Do you have access to a BMC LOADPLUS manual? If not you can get one from the BMC support site.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Mon May 12, 2014 4:40 pm
Reply with quote

How do you discard records during UNload ?
Back to top
View user's profile Send private message
Suja.Sai

New User


Joined: 26 Sep 2008
Posts: 12
Location: Bangalore

PostPosted: Mon May 12, 2014 4:56 pm
Reply with quote

Hi,

Sometimes while unloading, the records get discarded because of bad data. There are very slim chances of records getting discarded during UNLOAD. But still, as a project requirement, I would like to write the discarded records to a dataset. Is there any chance of doing it using BMC Unload?

Thanks,
Suja
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Mon May 12, 2014 9:45 pm
Reply with quote

I believe, Suja-chan, that GuyC was expressing incredulity. Can you show us a sample sysout where records are discarded?
Back to top
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Mon May 12, 2014 11:34 pm
Reply with quote

Maybe there is an exit routine involved? If so, changing that would be an easy way to add a 'discard' dataset.

I use exit routines for IMS datasets with BMC tools all the time. It sounds like there is some data testing happening during this DB2 unload, which almost has to be done via exit routine.
Back to top
View user's profile Send private message
Suja.Sai

New User


Joined: 26 Sep 2008
Posts: 12
Location: Bangalore

PostPosted: Tue May 13, 2014 8:58 am
Reply with quote

Hi Akatsukami,

This is a project requirement that the records that are discarded during unload should be written to a dataset. I haven't encountered any discarded records as of now. Hence, I would like to know, if at all the records are discarded, is it possible to write them to a dataset? If so, how?

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

Moderator Emeritus


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

PostPosted: Tue May 13, 2014 6:37 pm
Reply with quote

Hello,

Suggest you have whoever initiated the requirement explain where/how these "discards" would be found.

Is it possible that these discards are entries that are no longer needed (i.e. expired by date)?
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue May 13, 2014 7:34 pm
Reply with quote

Suja.Sai wrote:
Hi,

Sometimes while unloading, the records get discarded because of bad data. There are very slim chances of records getting discarded during UNLOAD. But still, as a project requirement, I would like to write the discarded records to a dataset. Is there any chance of doing it using BMC Unload?

Thanks,
Suja

Row that would not reflect in SYSREC are a direct consequence of using MAXERR in the unload statement.
I never used MAXERR in an unload.
But to answer your quesiton : It would be unlikely that for a row DB2 is unable to write to sysrec, db2 would find a solution to unload it to a so-called SYSDISC.
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

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts COBOL VS SORT Utility for file format... COBOL Programming 6
No new posts Unload Report in ARCHIVE from CA-Disp... CA Products 0
No new posts Convert a packed decimal value to zon... DB2 6
No new posts Issue in KWIKKEY utility while creat... JCL & VSAM 2
No new posts DSLIST utility ISRDSLST line command CLIST & REXX 5

Back to Top