473,326 Members | 2,114 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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
3 3040
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: Michael Rybak | last post by:
hi, everyone. I'm writing a 2-players game that should support network mode. I'm now testing it on 1 PC since I don't have 2. I directly use sockets, and both client and server do...
18
by: cjl | last post by:
Hey all: I know that it is silly in the age of Google to 'lose' something on the internet, but I recently checked out a project that had implemented a database with a subset of SQL in pure...
6
by: Ken Allen | last post by:
I am relatively new to .Net and C#, but I hav ebeen programing in other languages and done some COM work for a number of years. I am attempting to understand how to map an older program...
4
by: rs | last post by:
how I the client tell the server that the socket is closed? or this there an even that informs the server that the clients socket is close? Oh, I am using vb.net 2003 Thanks
2
by: J Huntley Palmer | last post by:
I am having a horrific time integrating uw-imap's c-client for imap support in php. The problem is a whole bunch of "Text relocation remains referenced against symbol" errors during linking....
1
by: Sam Durai | last post by:
Hello, When I use db2exfmt to generate the explain plan, under the Operator section I can see the following arguments listed EARLYOUT FETCHMAX ISCANMAX but I'm not sure what it means. Can...
2
by: nsaffary | last post by:
hi I hava a client/server program that run correctly when i run it in one computer(local) but when I run client on a one computer and run server run on another, connection does not stablish.(I set...
3
by: =?ISO-8859-2?Q?Gregor_Kova=E8?= | last post by:
Hi! when I run db2exfmt on DB2 9.1 I get this output: DB2 Universal Database Version 9.5, 5622-044 (c) Copyright IBM Corp. 1991, 2007 Licensed Material - Program Property of IBM IBM DATABASE 2...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.