467,882 Members | 1,159 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,882 developers. It's quick & easy.

db2exfmt - client

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
  • viewed: 2794
Share:
3 Replies
"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
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
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.

Similar topics

15 posts views Thread by Michael Rybak | last post: by
6 posts views Thread by Ken Allen | last post: by
2 posts views Thread by J Huntley Palmer | last post: by
1 post views Thread by Sam Durai | last post: by
2 posts views Thread by nsaffary | last post: by
3 posts views Thread by =?ISO-8859-2?Q?Gregor_Kova=E8?= | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.