Login or Register to Ask a Question and Join Our Community


UNIX and Linux Applications

DB2 - Get the last executed queries

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications DB2 - Get the last executed queries
# 1  
Old 02-19-2013
DB2 - Get the last executed queries
hi Team,

i would like to know how to get the queries executed by a "C" binary which connects to the db2 database .

i tried with snapshot but i am not to proceed due to privileges.

let me know if there are sys table available to reference to.

Note: forgive me if already an answer is available , since i tried searching but unable to find it.
# 2  
Old 02-19-2013
There are many tools for query monitoring:

IBM
® DB2® Query Monitor for z/OS® (also referred to as DB2 Query Monitor)
provides current and historical views of query activity throughout DB2
subsystems.
These topics provide instructions for customizing and using DB2 Query Monitor.
These topics are designed to help database administrators, system programmers,
application programmers, and system operators perform these tasks:

v
Plan for the installation of DB2 Query Monitor

v
Install and operate DB2 Query Monitor

v
Customize your DB2 Query Monitor environment

v
Diagnose and recover from DB2 Query Monitor problems

v
Design and write applications for DB2 Query Monitor

v Use DB2 Query Monitor with other DB2 or IMS™ products.

Here's another procedure:
How can trace the sql queries executed in a database (DB2) ? - Toolbox for IT Groups
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

For Loop queries

I have Existing FOR loop in script like below. But the zip should happen for only those years in another file generated dynamically. Existing FOR LOOP - for i in XYZ_*ABC${YEAR_2014}.csv; do printf "%s\n" "$i" done | zip -@ XYZ_2014.zip >> $XYZ_2014.log 2>&1 ||... (2 Replies)
Discussion started by: weknowd
2 Replies

2. Shell Programming and Scripting

Issue on executing db2 queries through shell script

hi i am trying to execute db2 queries through shell script. it's working fine but for few queries is not working ( those queries are taking time so the script is not waiting to get the complete the execution of that query ) could you please any one help me on this is there any wait... (1 Reply)
Discussion started by: bhaskar v
1 Replies

3. IP Networking

RDNS Queries

Hey everyone, I have a question, I've been playing around with tcpdump, and noticed my machine making numerous rdns look ups. They are displayed like: 10.80.80.141.51234 > 10.80.80.1.domain: 9950+ PTR? 223.114.55.65.in-addr.arpa. (44) My question is, if dns works based on numerical... (0 Replies)
Discussion started by: Lost in Cyberia
0 Replies

4. UNIX for Dummies Questions & Answers

FTP Queries

Hi, 1) How to get exact permissions, group names for files while transferring with FTP 2) Is there any command to transfer entire directory and sub directories. Thanks (1 Reply)
Discussion started by: nag_sathi
1 Replies

5. AIX

Script not getting executed via cron but executes when executed manually.

Hi Script not getting executed via cron but executes successfully when executed manually. Please assist cbspsap01(appuser) /app/scripts > cat restart.sh #!/bin/ksh cd /app/bin date >>logfile.out echo "Restart has been started....." >>logfile.out date >>logfile.out initfnsw -y restart... (3 Replies)
Discussion started by: samsungsamsung
3 Replies

6. Homework & Coursework Questions

Queries

Any help on like where to get started on this? I'm just confused. 1. The problem statement, all variables and given/known data: Enter text here.Queries to satisfy these two report requests (use your CCI database): Retrieve all rows of active inventory where current on hands is less than... (0 Replies)
Discussion started by: lakers34kb
0 Replies

7. UNIX for Dummies Questions & Answers

Exception while loading DB2 driver Class.forName("com.ibm.db2.jcc.DB2Driver")

Hi... I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies

8. Shell Programming and Scripting

my queries

hi guys Well, i need to have a report generation script or any script which will show me all the content/information of a file when i run that script. Please help me on this isssue at the earliest.As i am little bit aware of scripting.Thanks in advance! regards ash (4 Replies)
Discussion started by: whizkidash
4 Replies

9. Shell Programming and Scripting

Run SQL queries in DB2 and output to file

Hi, I new to Unix and scripting. Following is my requirement. Can someone tell me whether its possible or not. Also please let me know how to proceed further if this is possible. List of queries are stored in a file. For example, I have to run a query like this: Select * from &XYZ where... (0 Replies)
Discussion started by: simhasuri
0 Replies

10. UNIX for Advanced & Expert Users

Some queries...

Guys need some advice on how to check some of the questions below? i'm running on an open VMS platform... which i am an idiot to... appreciate if anyone can give some hints or source on how to check on.. a script that is running on cron job... but doesn't run as the login user name.. 1. why... (6 Replies)
Discussion started by: 12yearold
6 Replies
Login or Register to Ask a Question