Visual Explain in Navigator problems

[tom]

Hi.
I've created SQL monitor (specific job and username). Then I see list of
statements. But each statement has '?' mark instead of parameter.
Can I somehow check what the parameters was?

Other thing.
One of my statements created temporary index on few fields (AAAA ASCEND,
BBBB ASCEND, *MAP ASCEND, CCCC ASCEND).
What does ASCEND and *MAP means? I've noticed that 2 joined tabels are
joined by indexed fields but that fields are different types. Does SQL
use indexes in that issue?

Regards,
Tomasz

[Kent Milligan]

tom wrote:
> Hi.
> I've created SQL monitor (specific job and username). Then I see list of
> statements. But each statement has '?' mark instead of parameter.
> Can I somehow check what the parameters was?

##Depends on the release level the tooling available to help. The parameter
values are found in the 3010 record. Visual Explain lists the values under
"Host Variable Values" label on the Final Select icon

>
> Other thing.
> One of my statements created temporary index on few fields (AAAA ASCEND,
> BBBB ASCEND, *MAP ASCEND, CCCC ASCEND).
> What does ASCEND and *MAP means? I've noticed that 2 joined tabels are
> joined by indexed fields but that fields are different types. Does SQL
> use indexes in that issue?

DB2 had to create a temporary index with mapping to take care of the data type
mismatch on the join columns. Join columns should have the same type & length
to get the best performance.
>
> Regards,
> Tomasz

--
Kent Milligan
ISV Enablement - System i
km...@us.eye-bee-m.com (spam trick) GO HAWKEYES!!
>>> ibm.com/iseries/db2
(opinions stated are not necessarily those of my employer)

[Dr.Ugo Gagliardelli]

il 29/10/2009 17.14, Scrive Kent Milligan 37952400:

> tom wrote:
>> Hi.
>> I've created SQL monitor (specific job and username). Then I see list
>> of statements. But each statement has '?' mark instead of parameter.
>> Can I somehow check what the parameters was?
> ##Depends on the release level the tooling available to help. The
> parameter values are found in the 3010 record. Visual Explain lists the
> values under "Host Variable Values" label on the Final Select icon
>>
>> Other thing.
>> One of my statements created temporary index on few fields (AAAA
>> ASCEND, BBBB ASCEND, *MAP ASCEND, CCCC ASCEND).
>> What does ASCEND and *MAP means? I've noticed that 2 joined tabels are
>> joined by indexed fields but that fields are different types. Does SQL
>> use indexes in that issue?
> DB2 had to create a temporary index with mapping to take care of the
> data type mismatch on the join columns. Join columns should have the
> same type & length to get the best performance.

And the same CCSID as well, I experienced.

--
Dr.Ugo Gagliardelli,Modena,ItalyCertifiedUindoscrasherA�ejoAlcoolInside
Spaccamaroni andate a cagare/Spammers not welcome/Spammers v�o � merda
Spamers iros a la mierda/Spamers allez vous faire foutre/Spammers loop
schijten/Spammers macht Euch vom Acker/Spamerzy wypierdalac'