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
 

 

DSNUTILB - how to stop sysprint?

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

New User


Joined: 15 Nov 2005
Posts: 3

PostPosted: Tue Nov 15, 2005 10:29 pm    Post subject: DSNUTILB - how to stop sysprint?
Reply with quote

Hi,

I'm using the utility DSNUTILB to load data into a DB2 table. Is there a parameter you can use to stop it dumping out loads of messages for each insert I'm doing? Maybe just change the message level to only display proper error messages?

Trouble is that each run I'm doing I'm inserting up to 200,000 rows and it is causing the job output to exceed our maximum limit.

Thanks in advance,

Doug
Back to top
View user's profile Send private message

mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Wed Nov 16, 2005 6:39 pm    Post subject:
Reply with quote

Doug,

Remove the displays from your program. Use displays only when there is an abnormal condition.

This will solve your problem

Hope this helps

Regards
Mayuresh
Back to top
View user's profile Send private message
lazysurf

New User


Joined: 15 Nov 2005
Posts: 3

PostPosted: Wed Nov 16, 2005 7:25 pm    Post subject:
Reply with quote

Hi Mayuresh,

I'm not sure i understand what you mean by not using Displays. I'm running that IBM utility in a batch job. Its the JCL that calls the utility, not a program.

I'm feeding the utility the following command:

LOAD DATA RESUME YES LOG NO NOCOPYPEND INDDN SYSREC00 INTO TABLE
DB2Z.DB2TABLE

Thanks,
Doug
Back to top
View user's profile Send private message
arunkumar_aruldoss

New User


Joined: 23 Jun 2005
Posts: 1

PostPosted: Wed Nov 16, 2005 11:49 pm    Post subject: Re: DSNUTILB - how to stop sysprint?
Reply with quote

Hi Doug,

Try using DUMMY keyword for SYSPRINT DD statement.
Back to top
View user's profile Send private message
lazysurf

New User


Joined: 15 Nov 2005
Posts: 3

PostPosted: Thu Nov 17, 2005 4:23 pm    Post subject: Re: DSNUTILB - how to stop sysprint?
Reply with quote

arunkumar_aruldoss wrote:
Hi Doug,

Try using DUMMY keyword for SYSPRINT DD statement.


Yes, but then I wouldn't get any error messages at all!!! I need any the error messages if it should abend.

I've got round it now by writing the sysprint output to a flat file. Not ideal, but it stops the job exceeding our mainframe job output limits.

Thanks,
Doug
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 ICETOOL/SYNCSORT - SYSPRINT output nartcr DFSORT/ICETOOL 17 Wed Oct 05, 2016 10:46 pm
No new posts Stop Process when file is empty Roland Brosio DFSORT/ICETOOL 4 Thu Jun 25, 2015 1:20 pm
No new posts DSNUTILB - parallelism vasanthz DB2 3 Mon Jan 19, 2015 10:16 pm
No new posts DB2 Load using DSNUTILB with FORMAT I... yogi.47eie DB2 4 Wed May 28, 2014 4:54 pm
No new posts DSNUTILB invocation conventions vshchukin PL/I & Assembler 4 Thu Mar 20, 2014 9:53 am


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