oarnodesetting(1) OAR commands oarnodesetting(1)NAME
oarnodesetting - Change the state and properties of a node in OAR.
SYNOPSIS
oarnodesetting [-h hostname | [[-r resource_number][--sql "sql syntax"] | -a]]
DESCRIPTION
This command is used to Change the state and properties of a node in OAR.
OPTIONS -a, --add
Add a new resource.
-s, --state STATE
Set the new state of the node. The available states are: Alive, Absent and Dead.
-m, --maintenance on/off
Set the maintenance mode on/off (resource state will be set to absent and available_upto field set to 0).
-h, --hostname HOSTNAME
Set the node hostname.
-r, --resource
Set the resource.
--sql
Get resource identifiers which respond to the SQL where clause on the table jobs (ex: "type = 'default'").
-p, --property "PROPERTY=VALUE"
Set the property of the node to the given value.
-n, --nowait
Do not wait for job ends when the node switches to Absent or Dead.
EXAMPLES
oarnodesetting -s Alive -h node012
oarnodesetting -s Absent -h node012
COPYRIGHTS
Copyright 2003-2012 LIG http://lig.imag.fr This software is licensed under the GNU General Public License Version 2 or above. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
oarnodesetting 2012-05-23 oarnodesetting(1)
Check Out this Related Man Page
oardel(1) OAR commands oardel(1)NAME
oardel - delete or checkpoint job(s).
SYNOPSIS
oardel [-c|-b][--array][job_ids][-h][-V]
DESCRIPTION
This command is used to delete or checkpoint job(s). Jobs are designed by their number.
OPTIONS -c, --checkpoint
Send the checkpoint signal designed from the "--signal" oarsub command option (default is SIGUSR2) to the process launched by the job
"job_id".
-s, --signal
Send the signal given as parameter to the process launched by the job "job_id".
-b, --besteffort
Tag specified jobs as besteffort (or remove it if they are already besteffort)
--array
Delete/checkpoint array job(s) passed as parameter (all the sub-jobs of the given array job(s))
--sql
Delete/checkpoint jobs which respond to the SQL where clause on the table jobs (ex: "project = 'p1'").
-V, --version
Print OAR version number.
-h, --help
Print help command message.
SEE ALSO oarsub(1), oarstat(1), oarnodes(1), oarhold(1), oarresume(1)COPYRIGHTS
Copyright 2008 Laboratoire d'Informatique de Grenoble (http://www.liglab.fr). This software is licensed under the GNU Library General Public License. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
oardel 2012-05-23 oardel(1)
Hi,:cool:
I have several file names with .sql extension and i need to replace them with .plb extensiom.
ex:p_ebiz_vehlog.sql-->p_ebiz_vehlog.plb.
any idea pls.
cheers
RRK (7 Replies)
Hi,
I need to get the value from the table using the sql command and store this value into the unix variable so that i can use this value for furthure use..
Please can any body help me in this regards
Thanks & Regards
Abdul Hafeez Shaik (17 Replies)
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 all experts,
I want to replace RORPELL_SYSTEM_REG_IND by this RORPELL_SYSTEM_REQ_IND. The script name is rorpelli_0713003.sql and it has thousands of RORPELL_SYSTEM_REQ_IND . How i can do the replacement. I did VI to rorpelli_0713003.sql and then press /.
-----Post Update-----
... (6 Replies)
My sql file xyz_abc.sql in this file there are multiple sql block in this block I need to find the following block
rem Subset Rows (&&tempName.*)
CREATE VIEW &&tempName.* AS
SELECT *
FROM &&tempName.*
WHERE f is not null
and replace with following code
rem Subset Rows... (9 Replies)
I have sql's in a file separated by ";", need to put the sql in one single line till i find a ";" The input file is like this
SELECT s.sid,
s.serial#,
p.spid as "OS PID",
s.username,
s.module,
... (6 Replies)
Hi all,
I need to add the contents from a file into a sql stament in the where clause.
file1:
id
1
2
3
10
11
...
script should look like :
select name from tab_user tus where tus.id in (1,2,3,10,11..)
any ideas or suggetions will be appreciatte. (5 Replies)
I am running a sql session within a shell script. Later I am performing some validations on the value coming from the sql session.
The problem is that, the value I am getting from sql session have an extra white space at the begining(I am actually, assigning the outcome of the sql session to a... (5 Replies)
Dear Experts,
I have a scenario where I have to form sql queries in a file using echo command.
I have file1 which has more than 10 lac numbers. For each Number in file 1, I need to create 5 sql queries resulting in 50 lac queries totally.
For doing this I use the below simple method,
for i... (5 Replies)
Hi, We are having multiple .sql files generated programatically which is not containing..
create or replace -- at the start
and
/ -- at the end
We need to append those .sql files with the above 2 statements at their respective positions.
We will be really thankful to get responses... (6 Replies)
I tried executing set of queries from shell script but not able to capture the input query in the log file,but the input query is not displayed along with output. Only the outputs are being captured in the log file. Is there a way to capture the input query along with the corresponding input?? (8 Replies)
Hi Friend,
I have one file in which some number are mentioned and number of lines are vary every time
And i need to pass that number to my sql command from script.
Suppose i have file acc.txt
45456546456
45464564565
67854353454
67657612132
Number of records are vary every time.... (20 Replies)
Hi Guys,
i am having .sql script which inserts data from one table to another table based on date condition, i need to pass range on based on how many number of months, for e.g
set timing on;
whenever sqlerror exit failure;
spool myscript.log append
accept start_date... (7 Replies)
Hello ,
Im calling every single file inside my script like 1.sql,2.sql so on it looks so tedious. I want to replace with for loop where every file gets executed. When i use for loop im getting errorUnexpected EOF] , can anyone please help me out in this..
How i can use for loop to invoke my... (6 Replies)
Hi,
We have a Solaris 10 machine with update 11 and was configured with IBM storage. It was assigned 2 LUNs (each 70GB) which were striped to make it 140GB. we have taken full backup of entire machine and Our storage team replaced IBM storage with Nimble storage (they did storage-level... (6 Replies)