|
View previous topic :: View next topic
|
| Author |
Message |
lazysurf
New User
Joined: 15 Nov 2005
Posts: 3
|
|
|
|
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 |
|
 |
mdtendulkar
Active User
Joined: 29 Jul 2003
Posts: 237
Location: USA
|
|
|
|
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 |
|
|
lazysurf
New User
Joined: 15 Nov 2005
Posts: 3
|
|
|
|
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 |
|
|
arunkumar_aruldoss
New User
Joined: 23 Jun 2005
Posts: 1
|
|
|
|
Hi Doug,
Try using DUMMY keyword for SYSPRINT DD statement. |
|
| Back to top |
|
|
lazysurf
New User
Joined: 15 Nov 2005
Posts: 3
|
|
|
|
| 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 |
|
|
|
|
