09-10-2014
Hi,
Then it is likely that you will have to follow these steps.
- Ensure that the script has the correct envirinment.
- Pass the output from your select statement to a variable or file.
- Parse the variable or file and check the value.
- If the value is true perform the action.
Regards
Dave
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies
2. Shell Programming and Scripting
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies
3. Shell Programming and Scripting
Hi
I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.)
I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have a list of jobs scheduled in unix. I want to check whether a particular view or table is used in a job. If they are not used, I can make changes to them.
Thanks,
Raaga (2 Replies)
Discussion started by: Raaga
2 Replies
5. UNIX for Dummies Questions & Answers
Hello,
I'm working with putty on Windows 7 professional and I'd like to know if there's a way to gather specific lines from a pre-existing table and make a new table with that information.
More specifically, I'd like the program to look at a specific column, say column N, and see if any of the... (5 Replies)
Discussion started by: Deedee393
5 Replies
6. Shell Programming and Scripting
I am new to this shell scripting....
I have a file which contains list of users. This files get updated when new user comes into the system.
I want to create script which will give a table containing unique list of users. When I say unique, it means script should match table while parsing... (3 Replies)
Discussion started by: dchavan1901
3 Replies
7. Shell Programming and Scripting
I have made a table PRD_WORK_LM.test and it contains one field, ctrl_test. This field contains a 0 or a 1. I want to write a unix script that goes like this:
IF ctrl_test = 1 THEN ... ELSE exit FI
How can I write this in a script? Do I have to do this within bteq? or outside bteq? can... (5 Replies)
Discussion started by: katled
5 Replies
8. Shell Programming and Scripting
I am trying to write a script which allows a user to select the what manipulation he needs to do on a table. I want to check if the table exists or not. If it exists I will continue the other things or else I exit saying table doesn't exist. How might I achieve this. (1 Reply)
Discussion started by: gmatcat
1 Replies
9. Programming
Dear team
I am using DB2 and wish to capture the ETL status on daily basis so that i can run the query and share the details in xls format to respective mail ids .
Currently i am using below query but this displays table name and counts for latest run.
select name ,CARD from... (0 Replies)
Discussion started by: Perlbaby
0 Replies
10. Web Development
Bootstrap is great; but we have had some issues with Bootstrapped <tables> (and legacy <fieldset> elements) showing annoying, wayward lines. I solved that problem today with this simple jQuery in the footer:
<script>
$(function(){
$('tr, td, fieldset,... (0 Replies)
Discussion started by: Neo
0 Replies
TUNA(8) System Administration Utilities TUNA(8)
NAME
tuna - program for tuning running processes
SYNOPSIS
tuna [OPTIONS]
DESCRIPTION
This manual page explains the tuna program. The program can be used to change the attributes of application and kernel threads. The tuna
can operate on IRQs by name or number, and tasks or threads by process ID or command-line. CPUs and sets of CPUs can be specified by CPU or
socket number. IRQ names and process command-lines can include wildcards.
tuna can change scheduling policy, scheduler priority and processor affinity for processes and process threads. tuna can also change the
processor affinity for interrupts. When tuna is invoked without any options it starts up in its graphical interface mode. This manual page
explains only the command-line options for tuna
OPTIONS
tuna has both action options and modifier options. Modifier options must be specified on the command-line before the actions they are
intended to modify. Any modifier option applies to following actions on the same command-line until it is over-ridden.
Actions
-h, --help
Print a list of options. tuna will exit after this action, ignoring the remainder of the command-line.
-g, --gui
Start the GUI. Actions that follow this on the command-line will be processed without waiting for the GUI to complete.
-a, --config_file_apply=profilename
Apply changes described in profile
-l, --config_file_list
List preloaded profiles
-i, --isolate
Move all threads away from CPU-LIST. Requires -c or -S.
-I, --include
Allow all threads to run on CPU-LIST. Requires -c or -S.
-m, --move
Move selected entities to CPU-LIST. Requires -c and either -t or -q.
-p, --priority=[POLICY:]RTPRIO
Set thread scheduler tunables: POLICY and RTPRIO. POLICY is one of OTHER, FIFO, RR, or BATCH. Requires -t.
-P, --show_threads
Show thread list.
-s, --save=FILENAME
Save kthreads sched tunables to FILENAME.
-v, --version
Show version
-W, --what_is
Provides help about selected entities. Requires -t.
-x, --spread
Spread selected entities over CPU-LIST. Requires at least one of -t or -q. The specified threads and IRQs are each assigned to one
cpu in CPU-LIST.
Modifiers
-c, --cpus=CPU-LIST
CPU-LIST affected by commands. Requires a CPU number or a comma-separated list of CPU numbers.
-C, --affect_children
Operation will affect children threads.
-f, --filter
Disable display of selected CPUs in --gui. Requires -c
-G, --cgroup
Display the processes with the type of cgroups they are in. Requires -P
-K, --no_kthreads
Operations will not affect kernel threads.
-q, --irqs=IRQ-LIST
IRQ-LIST affected by commands. Requires an IRQ number or a comma-separated list of IRQ numbers.
-S, --sockets=CPU-SOCKET-LIST
CPU-SOCKET-LIST affected by commands. Requires a socket number or a comma-separated list of socket numbers.
-t, --threads=THREAD-LIST
THREAD-LIST affected by commands. Requires a thread number or thread name, or a comma-separated list of thread numbers and/or names.
Thread names may contain wildcards. Be sure to quote or escape any wildcard specifications.
-U, --no_uthreads
Operations will not affect user threads.
USAGE EXAMPLES
If for instance the Ethernet NICs have multiple queues for both receive and transmit, each with its own IRQ, the Ethernet IRQs can be asso-
ciated with a CPU socket:
tuna -S 2 -i -q 'eth*' -x
Move everything off the CPUs in socket 2, then spread the IRQs for the Ethernet devices acrross those same CPUs.
tuna February 2010 TUNA(8)