Total Cost: 43.712
Query Degree: 1

Rows
RETURN
( 1)
Cost
I/O
|
3.44
HSJOIN
( 2)
43.712
2
/-----+-----\
86 3.44
TBSCAN TBSCAN
( 3) ( 4)
20.7463 22.2771
1 1
| |
86 86
TABLE: LORYSA TABLE: LORYSA
CHILD_TABLE MAIN_TABLE

What tool generating such output?
I would like to read about it and use it if it is available on mainframe.
Thank's in advance.
Leny G.

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200805/1

lenygold via DBMonster.com wrote:
> Total Cost: 43.712
> Query Degree: 1
>
> Rows
> RETURN
> ( 1)
> Cost
> I/O
> |
> 3.44
> HSJOIN
> ( 2)
> 43.712
> 2
> /-----+-----\
> 86 3.44
> TBSCAN TBSCAN
> ( 3) ( 4)
> 20.7463 22.2771
> 1 1
> | |
> 86 86
> TABLE: LORYSA TABLE: LORYSA
> CHILD_TABLE MAIN_TABLE
>
This is db2exfmt. I don't know whether there is a similar tool for DB2
zOS. However the graphical explain shows very similar output and shoudl
be teh same across platforms.
Try Data Studio.

Cheers
Serge


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Thank You Serge.

Serge Rielau wrote:
>> Total Cost: 43.712
>> Query Degree: 1
>[quoted text clipped - 20 lines]
>> TABLE: LORYSA TABLE: LORYSA
>> CHILD_TABLE MAIN_TABLE
>
>This is db2exfmt. I don't know whether there is a similar tool for DB2
>zOS. However the graphical explain shows very similar output and shoudl
>be teh same across platforms.
>Try Data Studio.
>
>Cheers
>Serge
>

--
Message posted via http://www.dbmonster.com

lenygold via DBMonster.com wrote:
> Thank You Serge.
>
> Serge Rielau wrote:
>>> Total Cost: 43.712
>>> Query Degree: 1
>> [quoted text clipped - 20 lines]
>>> TABLE: LORYSA TABLE: LORYSA
>>> CHILD_TABLE MAIN_TABLE
>>
>> This is db2exfmt. I don't know whether there is a similar tool for
>> DB2 zOS. However the graphical explain shows very similar output and
>> shoudl be teh same across platforms.
>> Try Data Studio.
>>
>> Cheers
>> Serge

For DB2 for z/OS v7 and v8, the tool of choice is "DB2 Visual Explain".
For DB2 9 for z/OS there are 3 alternative offerings, one of them is indeed
Data Studio.

See:
http://www.ibm.com/software/data/db2/zos/osc/ve/
where you will find some general info on Visual Explain and download-links
for VE.
Also link to the DB2 9 alternatives.

Further read this article by Craig Mullins:
http://www.ibm.com/developerworks/db...01mullins.html

PS for v8 also consider using the Statistics Advisor that comes as an extra
free tool with VE:
http://www-1.ibm.com/support/docview...id=swg21206998

HTH

--
Jeroen