Running 8.2.8 on aix.

Any reason why the dynamic cache snapshot function would return no
records?

db2 "SELECT * FROM TABLE (SQLCACHE_SNAPSHOT()) as SQLCACHE_SNAPSHOT"

0 record(s) selected.

I can see that there is dynamic sql in the cache from "db2 get
snapshot".

Running 8.2.8 on aix.

>
Any reason why the dynamic cache snapshot function would return no
records?
>
db2 "SELECT * FROM TABLE (SQLCACHE_SNAPSHOT()) as SQLCACHE_SNAPSHOT"
>
0 record(s) selected.
>
I can see that there is dynamic sql in the cache from "db2 get
snapshot".

Hello.

Use SNAPSHOT_DYN_SQL function instead:
http://publib.boulder.ibm.com/infoce...n/r0007094.htm

Sincerely,
Mark B.

<4.spam@mail.ruwrote in message
news:2a33edd5-82f8-4616-8e67-53b6049b6905@x16g2000prn.googlegroups.com...

>
Hello.
>
Use SNAPSHOT_DYN_SQL function instead:
http://publib.boulder.ibm.com/infoce...n/r0007094.htm
>
Sincerely,
Mark B.

I don't think that is the correct one either. The execution time is a bigint
as the number of seconds, with no decimals. I thought they replaced that one
with another updated one in a later fixpack, but even with that one I have
had problems and it never matched the output of the get snapshot command. I
haven't tried the V9 or V9.5 versions.

On Sep 4, 7:49*am, "Mark A" <some...@someone.comwrote:

<4.s...@mail.ruwrote in message
>
news:2a33edd5-82f8-4616-8e67-53b6049b6905@x16g2000prn.googlegroups.com...
>
>
>

>

>

>
I don't think that is the correct one either. The execution time is a bigint
as the number of seconds, with no decimals. I thought they replaced that one
with another updated one in a later fixpack, but even with that one I have
had problems and it never matched the output of the get snapshot command.I
haven't tried the V9 or V9.5 versions.

Got a result.

SELECT * FROM TABLE (SNAPSHOT_DYN_SQL (' ', -1 ) ) as SNAPSHOT_DYN_SQL

Thanks.