09-18-2012
I do not know db2 that well, but you appear to have excessive lock contention.
This means a lot of processes are trying to select/insert/execute (pick one) a single database object. It probably means one process is sitting inactive on the object for a long time.
Users who login, then start DB work, but take a break can cause this. Their process can have a lock which does not get released until they complete the transaction they started. We have users who do not log off overnight and leave screens open. We kill off processes like that to prevent lock contention.
10 More Discussions You Might Find Interesting
1. Programming
After my previous thread, I think I found out what causes the long delays.
I run this program on several Linux computers, and the sometimes (after the file with the arrays becomes big) the fwrite takes between 100 ms to 900 ms.
This is very bad for me, as I want a timer to halt each 30 ms.... ... (5 Replies)
Discussion started by: inna
5 Replies
2. UNIX for Advanced & Expert Users
I have a process to terminate, and when keying Control C/ kill -int , it takes 15 minutes to half an hour to terminate the process. I've tried using kill -2, or keying control c twice, however the process seem
to be killed abruptly, without writing into the log file.
So the only way in order to... (8 Replies)
Discussion started by: paqui
8 Replies
3. Shell Programming and Scripting
Hello,
I have a C program that takes anywhere from 5 to 100 arguments and I'd like to run it from a script that makes sure it doesnt take too long to execute. If the C program takes more than 5 seconds to execute, i would like the shell script to kill it and return a short message to the user. ... (3 Replies)
Discussion started by: WeezelDs
3 Replies
4. Shell Programming and Scripting
Hi all,
I wrote this shell script to validate filed numbers for input file. But it take forever to complete validation on a file. The average speed is like 9mins/MB.
Can anyone tell me how to improve the performance of a shell script?
Thanks (12 Replies)
Discussion started by: ozzman
12 Replies
5. Linux
Hi,
I am trying to login using ssh on Red Hat Linux 5 server,
The password appears immediately but after I enter the password it takes about 90 seconds to login completely.
Please suggest what changes require?
Regards,
Manoj (4 Replies)
Discussion started by: manoj.solaris
4 Replies
6. UNIX for Dummies Questions & Answers
Hello,
like the title says, how can i measure the time it takes to load a module in Linux, and how how can i measure the time it takes to load a statically compiled module.
/Best Regards Olle
---------- Post updated at 01:13 PM ---------- Previous update was at 11:54 AM ----------
For... (0 Replies)
Discussion started by: ollebanan
0 Replies
7. UNIX for Dummies Questions & Answers
We are running unix. After a reboot of the server we have found that changing password takes a long time. if type in passwd "username" you can type in the 1st instance of the password , press enter , then it will wait for about 3 minutes before bringing up the confirm password line typing it in... (4 Replies)
Discussion started by: AIXlewis
4 Replies
8. Shell Programming and Scripting
Dear experts
I have a 200MG text file in this format:
text \tab number
I try to sort using options -fd and it takes very long! is that normal or I can speed it up in some ways?
I dont want to split the file since this one is already splitted.
I use this command: sort -fd file >... (12 Replies)
Discussion started by: voolek
12 Replies
9. Shell Programming and Scripting
Hi,
I wish to check the return value for wget $url.
However, some urls are designed to take 45 minutes or more to return.
All i need to check if the URL can be reached or not using wget.
How can i get wget to return the value in a few seconds ? (8 Replies)
Discussion started by: mohtashims
8 Replies
10. Shell Programming and Scripting
It takes 6 hrs for a 90 GB zip file that i am copying / transferring from serverA onto serverB.
scp user1@serverA:/opt/setup/cash.zip .
Output:
cash.zip 21% 19GB 4.7MB/s 4:11:46 ETA
uname -a
SunOS serverB 5.11 11.2 sun4v sparc sun4vCan you please suggest if i could do... (11 Replies)
Discussion started by: mohtashims
11 Replies
LEARN ABOUT OSF1
pthread_attr_setscope
pthread_attr_setscope(3) Library Functions Manual pthread_attr_setscope(3)
NAME
pthread_attr_setscope - Sets the contention scope attribute of the specified thread attributes object.
LIBRARY
DECthreads POSIX 1003.1c Library (libpthread.so)
SYNOPSIS
#include <pthread.h>
int pthread_attr_setscope(
pthread_attr_t *attr,
int scope);
STANDARDS
Interfaces documented on this reference page conform to industry standards as follows:
IEEE Std 1003.1c-1995, POSIX System Application Program Interface
PARAMETERS
Address of the thread attributes object whose contention scope attribute is to be modified. New value for the contention scope attribute
of the thread attributes object specified by attr.
DESCRIPTION
This routine uses the value specified in the scope argument to set the contention scope attribute of the thread attributes object specified
in the attr argument.
When creating a thread, use a thread attributes object to specify nondefault values for thread attributes. The contention scope attribute
specifies the set of threads with which a thread must compete for processing resources. The contention scope attribute specifies whether
the new thread competes for processing resources only with other threads in its own process, called process contention scope, or with all
threads on the system, called system contention scope.
On Tru64 UNIX, DECthreads supports both process contention scope and system contention scope threads.
DECthreads selects at most one thread to execute on each processor at any point in time. DECthreads resolves the contention based on each
thread's scheduling attributes (for example, priority) and scheduling policy (for example, round-robin).
A thread created using a thread attributes object whose contention scope attribute is set to PTHREAD_SCOPE_PROCESS contends for processing
resources with other threads within its own process that also were created with PTHREAD_SCOPE_PROCESS. It is unspecified how such threads
are scheduled relative to threads in other processes or threads in the same process that were created with PTHREAD_SCOPE_SYSTEM contention
scope.
A thread created using a thread attributes object whose contention scope attribute is set to PTHREAD_SCOPE_SYSTEM contends for processing
resources with other threads in any process that also were created with PTHREAD_SCOPE_SYSTEM.
NOTES
The value of the contention scope attribute of a particular thread attributes object does not necessarily correspond to the actual schedul-
ing contention scope of any existing thread in your multithreaded program.
RETURN VALUES
If an error condition occurs, this routine returns an integer value indicating the type of error. Possible return values are as follows:
Successful completion. The value specified by attr is not a valid thread attributes value, or the value specified by scope is not valid.
An attempt was made to set the attribute to an unsupported value.
ERRORS
None
RELATED INFORMATION
Functions: pthread_attr_destroy(3), pthread_attr_init(3), pthread_attr_getscope(3), pthread_create(3)
Manuals: Guide to DECthreads and Programmer's Guide delim off
pthread_attr_setscope(3)