05-13-2013
Thanks got it!!
Since you are inserting the data and not updating it I dont think you need table level exclusive lock. Insert will have its own row level lock which is sufficient.
Table level locks are usually applied when you want to update some data and make sure user access the updated data only..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi...
after unlock my computer from lock,
all telnet windows which i opened previously are closing automaticaly...
i hope u understand....plz give solution... (1 Reply)
Discussion started by: venkatramana
1 Replies
2. Shell Programming and Scripting
Hey guys/gals,
So here is what i'm starting with...its a Solaris patch diag output.
bash-3.0# pca -l
Using /var/tmp/patchdiag.xref from Oct/20/08
Host: seiftsx4140 (SunOS 5.10/Generic_127128-11/i386/i86pc)
List: missing
Patch IR CR RSB Age Synopsis
------ -- - -- --- ---... (3 Replies)
Discussion started by: zeekblack
3 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. Shell Programming and Scripting
Hi,
I am trying to insert a record into a table (say dips_tbl) which resides in Oracle DB through a ksh script. I want to insert records into few of the table columns-not all. I'll give an e.g. for the date column "CREATE_DATE".
For that I first execute
SQL1="SELECT SYSDATE FROM DUAL"
... (1 Reply)
Discussion started by: dips_ag
1 Replies
5. Shell Programming and Scripting
I have a file like below
Iter 1: Best Model = 10.0 12.0 13.0 17.0 23.3 78.7
Iter 2: Best Model = 10.0 20.0 30.0 40.0 50.0 60.0
Iter 3: Best Model = 27.3 46.3 84.5 23.0 34.5 35.4
etc
I want to use a scipts using csh or awk to select the iteration number and show the numbers in a table... (2 Replies)
Discussion started by: kristinu
2 Replies
6. Shell Programming and Scripting
Hi folks
I am trying to use a call to a python command within a shell script to help validate a date. If I hard code the date to be checked in the string it works. As follows
cmd_result=$(/usr/bin/python -c 'import time; print time.strftime("%d",time.strptime("31/02/2008", "%d/%m/%Y"))'... (2 Replies)
Discussion started by: PatMcDonagh
2 Replies
7. 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
8. Programming
Hi,
i have a java based tool which does insert operation in a TABLE, and in parallel the same table is used by my C++ code which does select Query.
the Table will be always busy, but sometimes the table is getting locked when i try to make an insert, am bit confused whether the lock is... (0 Replies)
Discussion started by: senkerth
0 Replies
9. Shell Programming and Scripting
Hello,
Objective is to insert bulk values in DB table using isql.
Following code tried:
isql -SServer_name -Ddb_name -Uuser_name -Ppassword < file.txt
cat file.txt
for i in `cat data_value_file.txt`
do
insert into tempdb..temp_table11 values ('$i')
go
done
cat... (3 Replies)
Discussion started by: manishdivs
3 Replies
10. Shell Programming and Scripting
I have a problem with my shell script. I want to insert data from file to table1(empty) and then, compare table1 with table2 and update some fields.
The first part is correct, but the second part does not work. The only way it works is if after the first part I truncate table1 and run the script... (1 Reply)
Discussion started by: nika_mill
1 Replies
flock(2) System Calls Manual flock(2)
Name
flock - apply or remove an advisory lock on an open file
Syntax
#include <sys/file.h>
#define LOCK_SH 1 /* shared lock */
#define LOCK_EX 2 /* exclusive lock */
#define LOCK_NB 4 /* don't block when locking */
#define LOCK_UN 8 /* unlock */
flock(fd, operation)
int fd, operation;
Description
The system call applies or removes an advisory lock on the file associated with the file descriptor, fd. A lock is applied by specifying
an operation parameter that is the inclusive OR of LOCK_SH or LOCK_EX and, possibly, LOCK_NB. To unlock an existing lock, operation should
be LOCK_UN.
Advisory locks allow cooperating processes to perform consistent operations on files, but do not guarantee consistency; that is, processes
might still access files without using advisory locks, possibly resulting in inconsistencies.
The locking mechanism allows two types of locks: shared locks and exclusive locks. At any time, multiple shared locks can be applied to a
file. However, multiple exclusive locks, or shared and exclusive locks cannot be applied simultaneously on a file.
A shared lock can be upgraded to be an exclusive lock, and an exclusive lock can become shared, simply by specifying the appropriate lock
type. This change results in the previous lock being released and the new lock applied. When upgrading, do not include LOCK_NB in opera-
tion, because there is a possibility that other processes have requests for locks, or have gained or released a lock.
Requesting a lock on an object that is already locked normally causes the caller to blocked until the lock can be acquired. If LOCK_NB is
included in operation, the call is not blocked; instead, the call fails and the error EWOULDBLOCK is returned.
Locks are on files, not file descriptors. That is, file descriptors duplicated through or call do not result in multiple instances of a
lock, but rather multiple references to a single lock. If a process holding a lock on a file forks and the child explicitly unlocks the
file, the parent loses its lock.
Processes blocked awaiting a lock may be awakened by signals.
Return Values
Zero is returned if the operation was successful; on an error, a -1 is returned and an error code is stored in the global variable, errno.
Diagnostics
The call fails under the following conditions:
[EWOULDBLOCK] The file is locked and the LOCK_NB option was specified.
[EBADF] The argument fd is an invalid descriptor.
[EINVAL] The argument fd refers to an object other than a file.
[EOPNOTSUPP] Invalid operation is requested. The argument fd refers to a socket.
Restrictions
File region locking is not supported over NFS.
See Also
close(2), dup(2), execve(2), fork(2), open(2)
flock(2)