Are you talking about the db2expln tool or Visual Explain.
db2expln does not populate explain tables to my knowledge (I've been wrong
before)!
You need to either use the Control Center or if using a command line use the
proper option to populate the tables before using db2exfmt.
Regards, Pierre.
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
----- Original Message -----
From: "pavan" <db2udbdba-ezmlmshield-x50898828.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, July 25, 2006 11:49 AM
Subject: db2exfmt.


> All,
> After I do a db2expln for a sql, I want to do db2exfmt for more detailed
> output. But, I get the following error message. Any ideas why am I
> getting this error ?
> How do I properly use db2exfmt to get detailed output of my explain plan ?
>
>>>db2exfmt -d devdb -g -o new2.exfmt
> DB2 Universal Database Version 8.1, 5622-044 (c) Copyright IBM Corp. 1991,
> 2002
> Licensed Material - Program Property of IBM
> IBM DATABASE 2 Explain Table Format Tool
>
> Connecting to the Database.
> Connect to Database Successful.
> Using only explain schema found: DROLIO .
> Enter up to 26 character Explain timestamp (Default -1) ==> -1
> Enter up to 8 character source name (SOURCE_NAME, Default %) ==> %
> Enter source schema (SOURCE_SCHEMA, Default %) ==> %
> Enter section number (0 for all, Default 0) ==> 0
> Error during Prepare, near line 1795.
>
> Error Message =
> SQL0206N "SOURCE_VERSION" is not valid in the context where it is used.
> SQLSTATE=42703
>
>
> SQLCA
> Size = 136
> SQLCODE = -206
> Tokens = SOURCE_VERSION
> Function= SQLNQ074
> RC = 0x801A006D = -2145779603
> Reason = 0x0000 = 0
> Reason2 = 0x0000 = 0
> Line # = -10
> Warning flags =
>
> Press ENTER to Continue ...
>
> thanks,
> pk.
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



DB2 & UDB email list listserv db2-l LazyDBA home page