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.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
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
4. UNIX for Dummies Questions & Answers
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
5. Homework & Coursework Questions
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
6. AIX
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
7. UNIX for Dummies Questions & Answers
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
8. IP Networking
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
9. Shell Programming and Scripting
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
10. Shell Programming and Scripting
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
LEARN ABOUT DEBIAN
myloader
MYLOADER(1) mydumper MYLOADER(1)
NAME
myloader - multi-threaded MySQL loader
SYNOPSIS
myloader --directory = /path/to/mydumper/backup [OPTIONS]
DESCRIPTION
myloader is a tool used for multi-threaded restoration of mydumper backups.
OPTIONS
The myloader tool has several available options:
--help Show help text
--host, -h
Hostname of MySQL server to connect to (default localhost)
--user, -u
MySQL username with the correct privileges to execute the restoration
--password, -p
The corresponding password for the MySQL user
--port, -P
The port for the MySQL connection.
Note For localhost TCP connections use 127.0.0.1 for --host.
--socket, -S
The UNIX domain socket file to use for the connection
--threads, -t
The number of threads to use for restoring data, default is 4
--version, -V
Show the program version and exit
--compress-protocol, -C
Use client protocol compression for connections to the MySQL server
--directory, -d
The directory of the mydumper backup to restore
--database, -B
An alternative database to load the dump into
Note For use with single database dumps. When using with multi-database dumps that have duplicate table names in more than one database
it may cause errors. Alternatively this scenario may give unpredictable results with --overwrite-tables.
--queries-per-transaction, -q
Number of INSERT queries to execute per transaction during restore, default is 1000.
--overwrite-tables, -o
Drop any existing tables when restoring schemas
--enable-binlog, -e
Log the data loading in the MySQL binary log if enabled (off by default)
--verbose, -v
The verbosity of messages. 0 = silent, 1 = errors, 2 = warnings, 3 = info. Default is 2.
AUTHOR
Andrew Hutchings
COPYRIGHT
2011, Andrew Hutchings
0.5.1 June 09, 2012 MYLOADER(1)