That seems a lot of extra effort. The problem with the << error is that the closing EOD must be at the beginning of the line, not indented, as you have it.
Tried it again with your suggestion. Everything left justified, same error:
also tried it without skipping lines
still not working... any other thoughts? I really like the idea of keeping it contained within the coding instead of creating a seperate file.
Hello everybody
I need help calling sql file from shell script.
Can anyone help me creating a small shell script which calls an sql file .
The .sql file should contain some select statements like
select emp_no from emp_table;
select emp_id from emp_table;
And the results should be... (6 Replies)
Hi
I have a shell script that call a sql file. The sql file will create a spool file.
My requirement is, when ever i get an OS error like file not found. I have to log it in a log file.
Could some who worked in a like scenario help me by giving the code sample.
Many Thanks.. (1 Reply)
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Hi,
I want to call a sql file in my shell script. see the below code:-
if ]
then
(
isql -U${S_USER} -S${S_SERV} -w100 -b -h0 <<ENDSQL | sed -e "s/Password://"
${S_PWD}
set nocount on
go
use ${S_DB}
go
// need to call a file name... (16 Replies)
Hi,
I am calling a sql file script.sql from shell script and passing few parameters also as shown below:
sqlplus -S id/password @script.sql $param1 $param2
Now,In sql file I have to create a extract text file after querying oracle tables based on the parameters passed(param1,param2) as... (7 Replies)
Hi I am new to shell scripting. There is a requirement to write a shell script to meet follwing needs.Prompt reply shall be highly appreciated.
script that will compare two config files and produce 2 outputs - actual config file and a report indicating changes made.
OS :Susi linux ver 10.3.
... (4 Replies)
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
hi ,
the below script contains sql query and after executed it sends the output of the query (output.txt) to an email body with conditional subject line based on the output of all_counts_match.txt.
i want to make this script generic so that it can accept the sql file as parameter and can... (5 Replies)
Discussion started by: itzkashi
5 Replies
LEARN ABOUT X11R4
ionice
IONICE(1) User Commands IONICE(1)NAME
ionice - set or get process I/O scheduling class and priority
SYNOPSIS
ionice [-c class] [-n level] [-t] -p PID...
ionice [-c class] [-n level] [-t] -P PGID...
ionice [-c class] [-n level] [-t] -u UID...
ionice [-c class] [-n level] [-t] command [argument...]
DESCRIPTION
This program sets or gets the I/O scheduling class and priority for a program. If no arguments or just -p is given, ionice will query the
current I/O scheduling class and priority for that process.
When command is given, ionice will run this command with the given arguments. If no class is specified, then command will be executed with
the "best-effort" scheduling class. The default priority level is 4.
As of this writing, a process can be in one of three scheduling classes:
Idle A program running with idle I/O priority will only get disk time when no other program has asked for disk I/O for a defined grace
period. The impact of an idle I/O process on normal system activity should be zero. This scheduling class does not take a priority
argument. Presently, this scheduling class is permitted for an ordinary user (since kernel 2.6.25).
Best-effort
This is the effective scheduling class for any process that has not asked for a specific I/O priority. This class takes a priority
argument from 0-7, with a lower number being higher priority. Programs running at the same best-effort priority are served in a
round-robin fashion.
Note that before kernel 2.6.26 a process that has not asked for an I/O priority formally uses "none" as scheduling class, but the
I/O scheduler will treat such processes as if it were in the best-effort class. The priority within the best-effort class will be
dynamically derived from the CPU nice level of the process: io_priority = (cpu_nice + 20) / 5.
For kernels after 2.6.26 with the CFQ I/O scheduler, a process that has not asked for an I/O priority inherits its CPU scheduling
class. The I/O priority is derived from the CPU nice level of the process (same as before kernel 2.6.26).
Realtime
The RT scheduling class is given first access to the disk, regardless of what else is going on in the system. Thus the RT class
needs to be used with some care, as it can starve other processes. As with the best-effort class, 8 priority levels are defined
denoting how big a time slice a given process will receive on each scheduling window. This scheduling class is not permitted for an
ordinary (i.e., non-root) user.
OPTIONS -c, --class class
Specify the name or number of the scheduling class to use; 0 for none, 1 for realtime, 2 for best-effort, 3 for idle.
-n, --classdata level
Specify the scheduling class data. This only has an effect if the class accepts an argument. For realtime and best-effort, 0-7 are
valid data (priority levels), and 0 represents the highest priority level.
-p, --pid PID...
Specify the process IDs of running processes for which to get or set the scheduling parameters.
-P, --pgid PGID...
Specify the process group IDs of running processes for which to get or set the scheduling parameters.
-t, --ignore
Ignore failure to set the requested priority. If command was specified, run it even in case it was not possible to set the desired
scheduling priority, which can happen due to insufficient privileges or an old kernel version.
-h, --help
Display help text and exit.
-u, --uid UID...
Specify the user IDs of running processes for which to get or set the scheduling parameters.
-V, --version
Display version information and exit.
EXAMPLES
# ionice -c 3 -p 89
Sets process with PID 89 as an idle I/O process.
# ionice -c 2 -n 0 bash
Runs 'bash' as a best-effort program with highest priority.
# ionice -p 89 91
Prints the class and priority of the processes with PID 89 and 91.
NOTES
Linux supports I/O scheduling priorities and classes since 2.6.13 with the CFQ I/O scheduler.
AUTHORS
Jens Axboe <jens@axboe.dk>
Karel Zak <kzak@redhat.com>
SEE ALSO ioprio_set(2)AVAILABILITY
The ionice command is part of the util-linux package and is available from https://www.kernel.org/pub/linux/utils/util-linux/.
util-linux July 2011 IONICE(1)