IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Will QMF also have the plan


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sivatechdrive

Active User


Joined: 17 Oct 2004
Posts: 191
Location: hyderabad

PostPosted: Fri Aug 17, 2007 4:47 pm
Reply with quote

Hi All,

Why do we have the plan name for SPUFI ?

Will there is plan name for QMF also if so how to identify the plan name
Back to top
View user's profile Send private message
kgumraj2

New User


Joined: 01 Aug 2007
Posts: 42
Location: Hyderabad

PostPosted: Fri Aug 17, 2007 7:33 pm
Reply with quote

There is no plan name for QMF, as it is used as a report generation tool and also excecutes Procs and rexx.

SPUFI doen't have a dataBase, while QMF has its own database.
Spufi can we used to get data from diffrent regions, QMF we cant we get data only on the logon reagion
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Tue Aug 21, 2007 6:13 am
Reply with quote

There is a plan name for almost everything that executes SQLs in DB2.

For QMF it should be something like QMF710. Look for QMF% in sysplan table.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts current batch plan DB2 3
No new posts Log an Plan name/id or Job Id using D... DB2 1
No new posts Usage/Utiliy of Plan in DB2 DB2 4
No new posts How do I define a DB2 plan for a web ... CICS 5
No new posts Finding the plan when code compiled u... DB2 2
Search our Forums:

Back to Top