DB2 cache content

java guy · #1 (**permalink**) 10-24-03, 09:48

Anybody who can tell me what I need to do to see the content (stored procs, db udf, sql statements etc) of DB2 cache? Thx.

sathyaram_s · #2 (**permalink**) 10-27-03, 06:28

SQL Statement Cache can be obtained using

db2 get snapshot for dynamic SQL for <dbname>

Cheers
Sathyaram

Quote:

Originally posted by java guy
Anybody who can tell me what I need to do to see the content (stored procs, db udf, sql statements etc) of DB2 cache? Thx.

java guy · #3 (**permalink**) 10-28-03, 15:05

I don't get it. Could you give me more details?

Marcus_A · #4 (**permalink**) 10-28-03, 15:18

Did you try to issue the command from a command prompt? This command is discussed in the DB2 Command Reference manual.

Internet Services

Web Development

Digital Marketing

Consumer Tech