SQLCACHE_SNAPSHOT function returns no records.

Patrick Finnegan

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".

Sep 3 '08 #1

Subscribe Post Reply

2074

4.spam

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.

Sep 4 '08 #2

Mark A

<4.****@mail.ruwrote in message
news:2a**********************************@x16g2000 prn.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.

Sep 4 '08 #3

Patrick Finnegan

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

<4.s...@mail.ruwrote in message

news:2a**********************************@x16g2000 prn.googlegroups.com...

Hello.

Use SNAPSHOT_DYN_SQL function instead:
http://publib.boulder.ibm.com/infoce...ic/com.ibm.db2....

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.

Got a result.

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

Thanks.

Sep 4 '08 #4

Similar topics

Trouble with system() function

by: Penn Markham | last post by:

Hello all, I am writing a script where I need to use the system() function to call htpasswd. I can do this just fine on the command line...works great (see attached file, test.php). When my...

PHP

How function calls work

by: Michael | last post by:

Guys, I'm interested in how the compiler implements function calls, can anyone correct my understanding/point me towards some good articles. When a function is called, is the stack pointer...

C / C++

DateDiff function question

by: mcbill20 | last post by:

Hello all. I have a really basic question that I hope someone has a better answer for. I apologize in advance-- I know this is probably a really basic question but I am used to Oracle rathern than...

Microsoft Access / VBA

'Data type mismatch error' using Mid function in a query

by: martlaco1 | last post by:

Trying to fix a query that (I thought) had worked once upon a time, and I keep getting a Data Type Mismatch error whenever I enter any criteria for an expression using a Mid function. Without the...

Microsoft Access / VBA

Trouble with concatenated string function

by: Kurt | last post by:

I'm using the fConcatChild function posted at http://www.mvps.org/access/modules/mdl0004.htm to return a field from the Many table of a 1:M relationship into a concatenated string. The function...

Microsoft Access / VBA

Query with user-defined function doesn't appear to work.

by: teddysnips | last post by:

I have to write an application to do some data cleansing. It's a Contact database, but over a number of years there are multiple companies which are all essentially the same entity. For each...

Microsoft Access / VBA

Choose Function

by: Steve | last post by:

Can the Choose function be used to set the criteria for a field in a query to either "Is Null" or "Is Not Null" based on the value of an option Group on a form? Such as:...

Microsoft Access / VBA

Array Function

by: =?Utf-8?B?RGFya21hbg==?= | last post by:

Hi, I am wondering how you multi-dimension an array function? My declared function looks like this: Public Function GetCustomerList(ByVal Val1 As String, ByVal Val2 As Long, ByVal Val3 As...

Visual Basic .NET

making this C# procedural function an OOP function - get rid of theparameters

by: mesut | last post by:

hi colleagues, I don't know if this is the right group for but it's in C# so I try. I have a #3 procedural function called GetInfo.. and those are 3 overloaded methods. I would like to use the...

C# / C Sharp

Wordpress or something else?

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...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

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...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++