06-05-2008
I'm not familiar with
db2, but if it's not allowing you to run multiple
db2cmd instances at the same time, you will have to serialize them somehow. A common technique is to create a "lock" file in a shared location, and remove it when finished. If the file already exists when you want to create it, back off (maybe sleep for a few seconds) and try again later. How exactly to create a lock file safely depends on your platform etc, but google around for "lock file". If you have Procmail, it comes with a
lockfile utility. Maybe
db2 already has something similar, actually.
(I thought databases were supposed to solve this problem, though. You can't allow concurrent writes to the same record but some databases allow you to lock just the record(s) you want to write to, and allow another process to write to other records at the same time.
Googling for db2 lock brings up some vaguely promising links.)
PS. You might want to go back and edit out the live email link to your Tivoli admin account. I imagine you would not like for it to start receiving spam (maybe it's too late already)
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
program name--test
#!/bin/bash
output1=`/home/user/a.c`
output2=`/home/user/a.c`
k=`$output1 + 1`
m=`$output2 + 1`
echo $k
echo $m
---------------------------------------------------------------------------
prgram name--a.c
#include<stdio.h>
int main() (1 Reply)
Discussion started by: sameworld1980
1 Replies
2. Shell Programming and Scripting
Hi All,
I am trying to write a script in which I need to accept multiple value in the same variable.
The case Is that I have put a FOR loop and inside the FOR loop I am accepting a variable value. And I require all the values which gets inputted in the variable.
To be... (5 Replies)
Discussion started by: rahulmittal87
5 Replies
3. Shell Programming and Scripting
Hello
I am trying to run a python program using shell script, which takes a single argument from a file.
This file has one entry per line :
1aaa
2bbb
3ccc
4ddd
5eee
...
...
...
My shell script runs the program, only for the last entry :
#!/bin/sh
IFS=$'\n'
for line in $(cat... (2 Replies)
Discussion started by: ad23
2 Replies
4. Cybersecurity
Hi,
What should I change in the httpd.conf so that the apache will accept request from page from specific IP and deny all the rest IP.
I am reading the document of the apache but it is very long (700 pages) and I searched but I could not find something about this.
So if someone can explain... (0 Replies)
Discussion started by: programAngel
0 Replies
5. Programming
Hi
I want to accept multiple lines input with spaces from User and i have a working code like this.
char sRes;
char sReq;
printf("Please enter request:");
scanf("%",sReq); /* Accept the input from user */
printf("\nPlease enter response:");
scanf("%",sRes);
but the... (4 Replies)
Discussion started by: AAKhan
4 Replies
6. UNIX for Dummies Questions & Answers
Hello,
So I have approximately 300 files of raw data (.txt) files that I am using to perform statistical analysis. I have been able to construct a Fortran program that is able to perform my statistical analysis on a file by file basis.
However, I now want to be able to loop program through... (19 Replies)
Discussion started by: Jimmyd24
19 Replies
7. Programming
Hi,
I have the following files:
// file.hvoid foo();
int i = 5; // should be just declared as extern int i;
// file1.c#include <stdio.h>
#include "file.h"
void foo() {
i = 10;
printf("%d\n", i);
}
// file2.c#include <stdio.h>
#include "file.h"
int main() {
foo(); (9 Replies)
Discussion started by: royalibrahim
9 Replies
8. Shell Programming and Scripting
Hi
I have the following C code
# cat test.c
#include <stdio.h>
main()
{
printf ("The output is : Power\n");
printf ("The output is : No Power\n");
}
The output of this C code is
# ./test
The output is : Power
The output is : No Power
Now i need to pass this outputs into a shell... (4 Replies)
Discussion started by: Priya Amaresh
4 Replies
9. Shell Programming and Scripting
Hello,
I'm requesting the shell program to compare 2 .csv files which will have large data.
Can any one help me with this linux shell program
Thanks in advance.
Thanks and regards
Ramanjaneya. K (1 Reply)
Discussion started by: pandu19
1 Replies
10. Shell Programming and Scripting
Hello,
Would you suggest me a shell program that would launch the given url and if there is login we have enter the credentials.
If the credentials are correct it would be redirected to home page of that url, the program will check if there are any PDF'S found automatically the PDF'S have... (5 Replies)
Discussion started by: pandu19
5 Replies
LEARN ABOUT LINUX
mail-lock
lockfile-progs(1) Lockfile programs lockfile-progs(1)
NAME
lockfile-progs - command-line programs to safely lock and unlock files and mailboxes (via liblockfile).
SYNOPSIS
mail-lock [--use-pid] [--retry retry-count]
mail-unlock
mail-touchlock [--oneshot]
lockfile-create [--use-pid] [--retry retry-count] [--lock-name] filename
lockfile-remove [--lock-name] filename
lockfile-touch [--oneshot] [--lock-name] filename
lockfile-check [--use-pid] [--lock-name] filename
DESCRIPTION
Lockfile-progs provides a set a programs that can be used to lock and unlock mailboxes and files safely (via liblockfile):
mail-lock - lock the current user's mailbox
mail-unlock - unlock the current user's mailbox
mail-touchlock - touch the lock on the current user's mailbox
lockfile-create - lock a given file
lockfile-remove - remove the lock on a given file
lockfile-touch - touch the lock on a given file
lockfile-check - check the lock on a given file
By default, the filename argument refers to the name of the file to be locked, and the name of the lockfile will be filename .lock. How-
ever, if the --lock-name argument is specified, then filename will be taken as the name of the lockfile itself.
Each of the mail locking commands attempts to lock /var/spool/mail/<user>, where <user> is the name associated with the effective user ID,
as determined by via geteuid(2).
Once a file is locked, the lock must be touched at least once every five minutes or the lock will be considered stale, and subsequent lock
attempts will succeed. Also see the --use-pid option and the lockfile_create(3) manpage.
The lockfile-check command tests whether or not a valid lock already exists.
OPTIONS
-q, --quiet
Suppress any output. Success or failure will only be indicated by the exit status.
-v, --verbose
Enable diagnostic output.
-l, --lock-name
Do not append .lock to the filename. This option applies to lockfile-create, lockfile-remove, lockfile-touch, or lockfile-check.
-p, --use-pid
Write the current process id (PID) to the lockfile whenever a lockfile is created, and use that pid when checking a lock's validity.
See the lockfile_create(3) manpage for more information. This option applies to lockfile-create, lockfile-remove, lockfile-touch, and
lockfile-check.
-o, --oneshot
Touch the lock and exit immediately. This option applies to lockfile-touch and mail-touchlock. When not provided, these commands will
run forever, touching the lock once every minute until killed.
-r retry-count, --retry retry-count
Try to lock filename retry-count times before giving up. Each attempt will be delayed a bit longer than the last (in 5 second incre-
ments) until reaching a maximum delay of one minute between retries. If retry-count is unspecified, the default is 9 which will give
up after 180 seconds (3 minutes) if all 9 lock attempts fail.
EXAMPLES
Locking a file during a lengthy process:
lockfile-create /some/file
lockfile-touch /some/file &
# Save the PID of the lockfile-touch process
BADGER="$!"
do-something-important-with /some/file
kill "${BADGER}"
lockfile-remove /some/file
EXIT STATUS
0
For lockfile-check this indicates that a valid lock exists, otherwise it just indicates successful program execution.
Not 0
For lockfile-check a non-zero exit status indicates that the specified lock does not exist or is not valid. For other programs it
indicates that some problem was encountered.
SEE ALSO
maillock(3)
touchlock(3)
mailunlock(3)
lockfile_create(3)
lockfile_remove(3)
lockfile_touch(3)
lockfile_check(3)
AUTHOR
Written by Rob Browning <rlb@defaultvalue.org>
0.1.12 2008-02-10 lockfile-progs(1)