In doing a db2 list applications show detail, I have 320 entries
applications. Of those sometimes all of them are "UOW Waiting."
Ususally there are from 1 to 4 marked UOW Executing. The rest are
still waiting.
What is meant by "waiting"? We have set TCPCOMMMGR to 4 (16 CPUs). We
have increased IOCLEANERS and IOSERVERS, which had been set to low.
Still the "waiting".
Thanks in advance,
Ted
3  37920 
Ted wrote:
In doing a db2 list applications show detail, I have 320 entries
applications. Of those sometimes all of them are "UOW Waiting."
Ususally there are from 1 to 4 marked UOW Executing. The rest are
still waiting.
What is meant by "waiting"? We have set TCPCOMMMGR to 4 (16 CPUs). We
have increased IOCLEANERS and IOSERVERS, which had been set to low.
Still the "waiting".
This means that the application is idle (at least as far as the
database is concerned), and is not actively doing any work in the
database.
Good luck,
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Ted wrote:
In doing a db2 list applications show detail, I have 320 entries
applications. Of those sometimes all of them are "UOW Waiting."
Ususally there are from 1 to 4 marked UOW Executing. The rest are
still waiting.
What is meant by "waiting"? We have set TCPCOMMMGR to 4 (16 CPUs). We
have increased IOCLEANERS and IOSERVERS, which had been set to low.
Still the "waiting".
Thanks in advance,
Ted
Chances are the programs/queries being executed do not have a terminate
statement.
Ted,
Not sure if your EEE, but...
One thing that can be confusing about list applications, is that by
defalut it will report the app status on the node where the snapshot was
taken. For EEE, this may not represent the 'overall' status of the app
(the app may be active on other nodes, if the snapshot is not taken at
the application coordinator node). You can use a 'db2 list applications
global' to get back the 'overall' status of the app.
Ted wrote:
In doing a db2 list applications show detail, I have 320 entries
applications. Of those sometimes all of them are "UOW Waiting."
Ususally there are from 1 to 4 marked UOW Executing. The rest are
still waiting.
What is meant by "waiting"? We have set TCPCOMMMGR to 4 (16 CPUs). We
have increased IOCLEANERS and IOSERVERS, which had been set to low.
Still the "waiting".
Thanks in advance,
Ted
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Raquel |
last post by:
UDB PE V8.0 on Win XP. I issue the following commands:
1. CONNECT TO SAMPLE USER db2adming USING xxxxx
The output is:
Database Connection Information
Database server = DB2/NT 8.1.3
SQL authorization ID = DB2ADMIN
Local database alias = SAMPLE
|
by: Peter Sands |
last post by:
Hi,
Some of my users would like to use the 'list applications' command to
view processes being run. But I do not want them to belong to the
SYSMAINT group or any other system group( DBADM/SYSCTRL/SYSADM). As
far as I know this is the only way one can use that command. Is there
any other way where I can give them authority/permissions that just
allows them to run the that command without having other system type
authority.
aix 5.2
|
by: BobTheDatabaseBoy |
last post by:
.... got: win2K, v8.1.6
login to win2K is to the network: user; bob13, domain; foo
it's a win2K domain.
i then login to my local db as db2admin. LIST APPLICATIONS
fails with security error. tells me bob13 doesn't have the
rights. bob13 has all rights in CC user maintenance. bob13
is member of Administrators in win2K on the box. i'm not logged
in to DB2 as bob13, just the box(? domain).
|
by: Bob Stearns |
last post by:
I was under the impression that the primary key had to be a unique
index. Since I usually create my primary indices before my primary keys,
in order to get the indices in the same schema as their tables, it is
possible , by error, to create such an index without the unique
attribute. DB2 UDB 8.1.5 Linux uses such an index for the primary key
anyway, thus losing the unique property of the primary key. Is this a
bug or a feature, i.e. a...
|
by: Bartje |
last post by:
Hey,
I am wondering what the best solution will be to program the following
problem in access, the dutch 97 edition.
I am developing a database for a day care centre (for my girlfriend).
This database consist out of six tables, Child, Employee, Group,
ChildByGroup, EmployeeByGroup (it must be possible to place a child or
an employee in more then 1 group) and GroupSort (this table gives some
information about the different kind of...
| | |
by: db2udbgirl |
last post by:
When I issue an db2 list applications on my DB2 UDB V8.2 database on
AIX 5.3 I get the following o/p
/home/card30/admin] > db2 list applications
Auth Id Application Appl. Application Id DB
# of
Name Handle Name
Agents
-------- -------------- ---------- ------------------------------
-------- -----
|
by: mel_apiso |
last post by:
Hi,
after uncatalog one database, and catalog again with other name, if I
try to connect
with this database, everything is ok, but list applications only show
me the
connection with the uncatalog/catalog database. After I disconnect from
this database,
list applications command show all instances connection.
Below I paste the situation.
|
by: shsandeep |
last post by:
I have DBADM authority over a particular database but I am unable to do a
'list applications show detail'.
Is there any special privilege required for the same? Thanks.
Cheers,
San.
|
by: Rahul B |
last post by:
Hi,
When i do a "db2 list applications", i get the required applications
with their ip addresses.
However, some of the application Ids are ip addresses while some
application Ids are arbitrary(like GA500A2B.K105.014AC7050331) and of
the form "GA500%'.
Can somebody explain what are these indifferent application ids?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
