Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DSNTEP2 - Maximum queries

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

New User


Joined: 21 Jan 2009
Posts: 84
Location: India

PostPosted: Mon Jul 26, 2010 5:46 pm    Post subject: DSNTEP2 - Maximum queries
Reply with quote

Hi,
Can someone please let me know what is the maximum number of queries that could be run in a DSNTEP2 step in a JCL ??

-Thanks in advance,
Rakesh.
Back to top
View user's profile Send private message

PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2441
Location: Netherlands, Amstelveen

PostPosted: Mon Jul 26, 2010 7:09 pm    Post subject:
Reply with quote

Why would you want to know that?
Did you meet some restrictions?
Back to top
View user's profile Send private message
rakesh1155

New User


Joined: 21 Jan 2009
Posts: 84
Location: India

PostPosted: Tue Jul 27, 2010 3:55 pm    Post subject: Reply to: DSNTEP2 - Maximum queries
Reply with quote

Yes... Is there a restriction of the number of queries on DSNTEP2 ?
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 Jul 27, 2010 8:25 pm    Post subject:
Reply with quote

Hello,

What problem did you encounter?

You will get much more useful replies if you post what has actually happened and show the diagnostic information generated by the run. . .

We can ask all sorts of questions to try to get some info, but it all works better if you simply post what has happened. . .
Back to top
View user's profile Send private message
rakesh1155

New User


Joined: 21 Jan 2009
Posts: 84
Location: India

PostPosted: Tue Jul 27, 2010 9:12 pm    Post subject: Reply to: DSNTEP2 - Maximum queries
Reply with quote

Here's the exact scenario....

For the original requirement, the table-names are variable and are received from a file and the query remains the same.

I thought of using dynamic queries but our DBA didnt approve it.

So, I am writing a program where we build these some queries onto an output file and execute the queries using DSNTEP2 in the next JCL step.

I need to know if there's a limit/restriction to the number of queries that we can put in SYSIN.

Please let me know if there's another possible way of doing this.

-Thanks in advance,
Rakesh.
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 Jul 27, 2010 9:40 pm    Post subject:
Reply with quote

Hello,

And still no answer to:
Quote:
What problem did you encounter?


I've stacked more than 1,000 queries in to the same batch run. . .

Depending on the queries you have, the issue may be a time-out or queued output being too large.
Back to top
View user's profile Send private message
rakesh1155

New User


Joined: 21 Jan 2009
Posts: 84
Location: India

PostPosted: Wed Jul 28, 2010 2:59 am    Post subject: Reply to: DSNTEP2 - Maximum queries
Reply with quote

To answer you:
I haven't encountered any problem till now.

I just wanted to know if there are any restrictions so that I can handle it in the program writing these queries.


Thanks a Lot!
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 Jul 28, 2010 3:20 am    Post subject:
Reply with quote

Hello,

None that i'm aware of . . .
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 Need help with below queries ashek15 DB2 3 Thu Mar 23, 2017 1:38 am
No new posts What is the maximum number of sort wo... Pravina M SYNCSORT 2 Mon Mar 14, 2016 4:51 pm
No new posts DB2 plan for DSNTEP2 / DSNTEP4 Mainak_Dalal DB2 3 Thu Jan 21, 2016 1:08 am
No new posts Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm
No new posts Selective execution of a queries Delip DB2 9 Fri Jan 16, 2015 3:51 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us