Hi everyone,
Can anyone answers my questions. My server is AIX and is 5.2 and the
db2 udb of V 8.1 Fixpak 9.
What exactly is the tools catalog for?
How it is uaseful in performing automatic runstats and reorgs?
Can the tools catalog be centralized for a given server (AIX/LINUX)?
How can I know if there is a tools catalog existing for a given
database or an instance?
Thanks!
2  3463 
The tools catalog is used by the task manager functions of the DAS. Store,
categorize, schedule, ...
Once a task is created (scripts, batch files, programs, ...) it can be
stored in the task center, in category (ies) that you create, given a
schedule at which to execute and execute other different tasks on success or
failure as well as notify a contact on execution.
The following link will help you: db2 create tools catalog command http://publib.boulder.ibm.com/infoce...e/r0008881.htm
identified by doing a Google searcj on db2 tools catalog (very difficult!).
The other link will explain how the DAS may use it. You'll find it at the
bottom of the one above.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<sa************ **@gmail.com> a écrit dans le message de news: 11************* *********@f6g20 00...legro ups.com... Hi everyone,
Can anyone answers my questions. My server is AIX and is 5.2 and the
db2 udb of V 8.1 Fixpak 9.
What exactly is the tools catalog for?
How it is uaseful in performing automatic runstats and reorgs?
Can the tools catalog be centralized for a given server (AIX/LINUX)?
How can I know if there is a tools catalog existing for a given
database or an instance?
Thanks!
Thanks Pierre for your reply.
I have created a tools catalog database for server1 and want to use the
same tools catalog database for the server2.
I have cataloged the database on the server2 and when I tried to create
a tools catalog with the existing database ie
db2 create tools catalog use existing database toolsdb force
it gives me an error
SQL30082N Attempt to establish connection failed with security reason
"3"
("PASSWORD MISSING"). SQLSTATE=08001
The database which is on the server1 is a remote database for the
server2 and I know I have to give the password but there is no option
of mentioning the password in the create tools catalog command.
Is there any way, please give me your advise.
Thanks.
Pierre Saint-Jacques wrote: The tools catalog is used by the task manager functions of the DAS. Store,
categorize, schedule, ...
Once a task is created (scripts, batch files, programs, ...) it can be
stored in the task center, in category (ies) that you create, given a
schedule at which to execute and execute other different tasks on successor
failure as well as notify a contact on execution.
The following link will help you: db2 create tools catalog command
http://publib.boulder.ibm.com/infoce...e/r0008881.htm
identified by doing a Google searcj on db2 tools catalog (very difficult!).
The other link will explain how the DAS may use it. You'll find it at the
bottom of the one above.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<sa************ **@gmail.com> a écrit dans le message de news:
11************* *********@f6g20 00...legro ups.com... Hi everyone,
Can anyone answers my questions. My server is AIX and is 5.2 and the
db2 udb of V 8.1 Fixpak 9.
What exactly is the tools catalog for?
How it is uaseful in performing automatic runstats and reorgs?
Can the tools catalog be centralized for a given server (AIX/LINUX)?
How can I know if there is a tools catalog existing for a given
database or an instance?
Thanks! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: wm2004 |
last post by:
Which is the best javascript compiler and tools to use?
Get An Online Business and Make Money!
Learn the secrets of many ordinary people who quit their day jobs to
pursue an online business. There are many affiliate programs to choose
from, but choose an interest you are passionate about and sell it
online!
Please subscribe to the newsletter below for updates and news:
|
by: Kexiao Liao |
last post by:
Hi,
I have two db2 Version8.1 instances running on IBM AIX 5.2 platform.
Db2inst1 is migrated from V7.2 and db2inst2 is the instance to be created
while install db2 Version8.1. The db2 V7.2 DAS server was dropped after
migrated to V8.1.
New DAS server on V8.1 was created (using dascrt) successfully after db2
FixPak 4a was updated, then I try to create the tools catalog from db2inst2
by using following command:
CREATE TOOLS CATALOG...
|
by: GL |
last post by:
New to DB2 on AIX. Is there a preferred location for the install of the
tools catalog database on DB2? I understand it's normally under the
instance 'umbrella' but is there any particular directory that is
preferable?
Thanks in advance.
Gerry
|
by: sea |
last post by:
I had stopped all database services before running the setup program
for upgrading from 7.2 to 8.1. During the installation process though,
I got a message to the effect saying the tools server could not be
installed because no start database command was issued. Does anyone
know how I can now install the tools server separately? Should I
simply re-install the DB2 8.1 and hope that this would install the
missing tools? Or can I re-install...
|
by: datapro01 |
last post by:
Running db2 8.1.1 on AIX 5.1
Recently created a Tools catalog and db on a test database server.
Since then a shell script that runs the offline backups has been
failing with the db2dasstm process maintaining a connection with the
target database.
The first time it happened I thought I had placed the tools catalog in
the existing target database so I dropped the tools db and recreated it
with
| | |
by: arandhawa1 |
last post by:
Does anyone know how to correctly setup the Administration DB for fail
over clustering on a MSCS server running DB2.
Problem I have when I follow IBM's docs is that I install the Tools
catalog on the first node but when I failover the cluster to the second
node - DB2's Task Center no longer works since the Tools Catalog still
points to the first node. Is there anyway to re-catalog the tools db so
|
by: neelimabandiwsu |
last post by:
Hi,
can anyone know the answers for this question:
How many tools catalogs do we need on an AIX/Linux server for the db2
V8.1 Fix pack 9 ? i.e. Can the tools catalog be centralized for each
environment (dev/test/ite/prod)?
Thanks!
|
by: Laurence |
last post by:
Hi folks,
I installed DB2 V9.1 FP2 on RHEL AS V4 (DB2 Server) and Win XP SP2
(DB2 Client).
The strange thing, there were two database aliases TOOLS0 & TOOLS1 in
the DB2 Client that were mapping to the same remote tools catalog
database TOOLSDB in the DB2 Server after I created a new tools catalog
database by Control Center.
|
by: aj |
last post by:
DB2 LUW 8.2 FP14 Red Hat AS 2.1
Help gurus:
I'm seeing this in my db2diag.log:
2007-08-28-15.57.58.858627-240 E8785115G359 LEVEL: Warning (OS)
PID : 18117 TID : 8194 PROC : db2dasstm
INSTANCE: md NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
