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
 

 

Use of "--#SET MAXERRORS" parameter on DB2 V8

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

New User


Joined: 11 May 2009
Posts: 4
Location: Brazil

PostPosted: Fri Jun 19, 2009 2:06 am    Post subject: Use of "--#SET MAXERRORS" parameter on DB2 V8
Reply with quote

I am trying to use the --#SET MAXERRORS -1 parameter to run DDL on DB2 v8 and I got the following error message:

*** ERROR **************************************************************
* DSNTEP2 halted due to a functional comment (--#SET) statement error:
* Invalid value, "MAXERRORS", specified for function.
************************************************************************

Can anybody tell me how to use this parameter of if there is another way to set MAXERRORS?

Thanks in advance.
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: Fri Jun 19, 2009 2:27 am    Post subject:
Reply with quote

Hello and welcome to the forum,

Why do you want a process to continue if there is an error. . .?
Back to top
View user's profile Send private message
Marcos Torres

New User


Joined: 11 May 2009
Posts: 4
Location: Brazil

PostPosted: Fri Jun 19, 2009 3:11 am    Post subject:
Reply with quote

Hi dick, thanks for answering.

I need that the process continue because the error is that I´ve already did that definition, and I am running the JCL after some corrections. There is a lot of definitions and I cannot drop the definitions every time I got an error.

I know that the default value for MAXERRORS on DB2 is 10, but the way that the DB2 manual specify the SET MAXERRORS use doesn´t work.

I really need this parameter works.
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: Fri Jun 19, 2009 3:20 am    Post subject:
Reply with quote

Hi Marcos,

Maybe someone will be able to provide direction.

I looked in the db2 manuals we have linked (IBM Manuals at the top of the page), but i could not find it.

Which version of db2 are you using?

I'm going to be on the road here shortly, but will try to look some more later this evening.
Back to top
View user's profile Send private message
Marcos Torres

New User


Joined: 11 May 2009
Posts: 4
Location: Brazil

PostPosted: Fri Jun 19, 2009 3:24 am    Post subject:
Reply with quote

Dick,

the DB2 is version 8.

Tks.
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: Fri Jun 19, 2009 5:00 am    Post subject:
Reply with quote

Hi Marcos,

If i'd paid attention to your topic/subject. . . . icon_redface.gif

See if this will help:
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2tools.adb.doc.ug/upasect.htm
Back to top
View user's profile Send private message
Marcos Torres

New User


Joined: 11 May 2009
Posts: 4
Location: Brazil

PostPosted: Wed Jun 24, 2009 8:27 am    Post subject:
Reply with quote

Hi Dick.

I found out today why the parameter --#SET MAXERRORS -1 was not working at that day.

I was using a DB2 V8 subsystem at COMPATIBILITY MODE. By other reasons than this, I changed to a DB2 V8 subsystem at NEW FUNCTION MODE.

This parameter only works for DB2 V8 at NEW FUNCTION MODE. A DB2 V8 at COMPATIBILITY MODE is, for all efects, a DB2 V7.

Best regards, and thanks for your helping,

Marcos Torres.
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: Wed Jun 24, 2009 8:31 am    Post subject: Reply to: Use of "--#SET MAXERRORS" parameter on D
Reply with quote

You're welcome and thanks for telling us the solution icon_smile.gif

d
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 Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
No new posts DDNAME parameter mistah kurtz JCL & VSAM 6 Mon Dec 19, 2016 4:41 pm
No new posts Execessive parameter issue Sumeendar JCL & VSAM 5 Mon Dec 19, 2016 4:35 pm
No new posts TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
No new posts Amount field is getting corrupted whe... thesumitk SYNCSORT 5 Tue Oct 18, 2016 8:20 pm


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