By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,609 Members | 2,246 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,609 IT Pros & Developers. It's quick & easy.

db2exfmt - client

P: n/a
Is Admin client is mandatory to use db2exfmt ? I've only run time
client now so unable to generate the access plan using db2exfmt.

Mar 6 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"db2udbgirl" <Vi**********@gmail.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
Is Admin client is mandatory to use db2exfmt ? I've only run time
client now so unable to generate the access plan using db2exfmt.


I don't have a machine with a DB2 client only, so I don't know if db2exfmt
is installed on the any clients. But that program only formats reports from
the explain tables that are already populated with data as a result of the
"EXPLAIN PLAN" statement. So it does not actually generate an access plan.
Mar 7 '06 #2

P: n/a
I agree to your view that db2exfmt just formats and shows me the
explain plan. But when I try to use db2exfmt command from my db2 client
it says db2exfmt not found so I feel that I need to have administrative
client to use db2exfmt.

It would be great if someone could confirm me the same

Mar 7 '06 #3

P: n/a
Explain plans are used by developpers and administrators. The db2exfmt as
well as the db2 set explain commands are found only on the Development and
the Admin Clients to my knowledge.
Beware, I've found wrong before but not on that one I think, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"db2udbgirl" <Vi**********@gmail.com> a écrit dans le message de news:
11**********************@e56g2000cwe.googlegroups. com...
I agree to your view that db2exfmt just formats and shows me the
explain plan. But when I try to use db2exfmt command from my db2 client
it says db2exfmt not found so I feel that I need to have administrative
client to use db2exfmt.

It would be great if someone could confirm me the same


Mar 8 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.