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 utility

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Suja.Sai

New User


Joined: 26 Sep 2008
Posts: 7
Location: Bangalore

PostPosted: Sat May 10, 2014 2:51 pm    Post subject: BMC Unload utility
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: 2158
Location: @my desk

PostPosted: Mon May 12, 2014 4:24 pm    Post subject:
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: 1278
Location: Belgium

PostPosted: Mon May 12, 2014 4:40 pm    Post subject:
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: 7
Location: Bangalore

PostPosted: Mon May 12, 2014 4:56 pm    Post subject: BMC Unload Utility
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: 1738
Location: Bloomington, IL

PostPosted: Mon May 12, 2014 9:45 pm    Post subject:
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    Post subject:
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: 7
Location: Bangalore

PostPosted: Tue May 13, 2014 8:58 am    Post subject:
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

Site Director


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

PostPosted: Tue May 13, 2014 6:37 pm    Post subject:
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: 1278
Location: Belgium

PostPosted: Tue May 13, 2014 7:34 pm    Post subject: Re: BMC Unload Utility
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    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 Any docs / links for isub- cobol comp... SRICOBSAS COBOL Programming 4 Fri Aug 26, 2016 2:35 pm
No new posts DB2 Unload format options Susanta DB2 2 Fri Aug 12, 2016 5:42 pm
No new posts Comparex utility to Syncsort conversion mistah kurtz SYNCSORT 11 Fri Jul 22, 2016 1:53 pm
No new posts DXT unload utility - DVRE0000 mistah kurtz DB2 1 Thu Jul 07, 2016 4:56 pm


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