473,788 Members | 2,861 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

db2stop and db2start require password in partition env

Hi!

I'm trying to set up a database instance on a prime Linux server,
using db2 V9.5 with fixpack 1 applied.
I issued db2set DB2RSHCMD=/usr/bin/ssh
After adding 2 partitions, when issuing db2stop (as instance owner),
I have to give the password 6 times.
When i the run db2start it suffices with 3 times.

What did I miss?
How do I get out of it?

/dg
Jun 27 '08 #1
3 5517
Ian
da******@hotmai l.com wrote:
Hi!

I'm trying to set up a database instance on a prime Linux server,
using db2 V9.5 with fixpack 1 applied.
I issued db2set DB2RSHCMD=/usr/bin/ssh
After adding 2 partitions, when issuing db2stop (as instance owner),
I have to give the password 6 times.
When i the run db2start it suffices with 3 times.

What did I miss?
How do I get out of it?
You need to set up ssh for passwordless login. (i.e. add the
instance owner's public key to its authorized_keys file). Google
"ssh passwordless login"

Jun 27 '08 #2
On Apr 24, 9:49 am, Ian <ianb...@mobile audio.comwrote:
danfa...@hotmai l.com wrote:
Hi!
I'm trying to set up a database instance on a prime Linux server,
using db2 V9.5 with fixpack 1 applied.
I issued db2set DB2RSHCMD=/usr/bin/ssh
After adding 2 partitions, when issuing db2stop (as instance owner),
I have to give the password 6 times.
When i the run db2start it suffices with 3 times.
What did I miss?
How do I get out of it?

You need to set up ssh for passwordless login. (i.e. add the
instance owner's public key to its authorized_keys file). Google
"ssh passwordless login"
The following developerWorks article should help:

http://www.ibm.com/developerworks/db...nie/index.html

Cheers,
Liam.
Jun 27 '08 #3
Thanks Liam.
Going thru the process it came back to me that I did the some thing a year ago on another server.
Compliments to you for a comprehensive and pedagogic article.
/dg
"Liam Finnie" <lf*****@ca.ibm .comwrote in message news:26******** *************** ***********@w7g 2000hsa.googleg roups.com...
On Apr 24, 9:49 am, Ian <ianb...@mobile audio.comwrote:
danfa...@hotmai l.com wrote:
Hi!
I'm trying to set up a database instance on a prime Linux server,
using db2 V9.5 with fixpack 1 applied.
I issued db2set DB2RSHCMD=/usr/bin/ssh
After adding 2 partitions, when issuing db2stop (as instance owner),
I have to give the password 6 times.
When i the run db2start it suffices with 3 times.
What did I miss?
How do I get out of it?
You need to set up ssh for passwordless login. (i.e. add the
instance owner's public key to its authorized_keys file). Google
"ssh passwordless login"

The following developerWorks article should help:

http://www.ibm.com/developerworks/db...nie/index.html

Cheers,
Liam.

Jun 27 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
7335
by: Robert Kane | last post by:
Good afternoon, I'm trying to set up a clustered DB2 v7.1 database on Redhat Linux 7.3. I've followed the instructions (as far as I know) in the accompanying documentation to set up the database on 2 nodes. Running db2start on node 0 I get the following message: 11-19-2000 10:12:44 1 0 SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing.
9
6851
by: ghumman | last post by:
running on windows, I encounter following db2start. SQL6030N START or STOP DATABASE MANAGER failed. Reason code "13". any ideas why db2start is failing ?
1
9393
by: Ranjay | last post by:
i've installed db2 on my aix box with the following configuration bash-3.00$ uname -a -v -r AIX symibm10 2 5 00CE60AA4C00 bash-3.00$ oslevel 5.2.0.0 I installed it in the compact mode and created 2 instances db2inst1 and db2fenc1
1
1246
by: David | last post by:
I have recieved a computer with no acompanying information. In other words I don't have a password to logon. The machine was thrown away because the hard drives did not work. I have fixed that problem by cleaning the PCI bus slot that the hard drive controller was plugged into. (Now the machine Boots). But I have no password for the Windows NT v4.0 Operating System which is on the C:\ hard drive. (Boot drive). The Computer was given to me...
0
2334
by: Phil Sherman | last post by:
This occurred in a non-supported UDB environment. I am providing it as "gotcha" information. SQL1084C error was received when attempting the first connect to the (formerly working) SAMPLE database. This occurred on a FC6 system that was just updated to kernel 2.6.19-1..... with associated updates to SELinux security. Problem: db2start performs kernel updates, setting parameters that are necessary for UDB to function. These updates...
1
2699
by: Laurence | last post by:
Hi folks, The sentence "If you are an HACMPâ„¢ user, you must use the ha_db2stop command to stop DB2 instead of the db2stop command. If you use the db2stop command instead of the ha_db2stop command, you will trigger a failure event.". If I also do HADR with HACMP, should I also use the ha_db2stop command, or just db2stop command? Thanks in advance,
0
3792
debasisdas
by: debasisdas | last post by:
SAMPLE CODE TO CREATE SUB PARTITIONS ======================================= RANGE-HASH-9i ------------------------- CREATE TABLE SUBPART ( ID NUMBER(10) PRIMARY KEY, NAME VARCHAR2(20) )
11
11536
by: zgh1970 | last post by:
Hi, Friends, I need to know how to stop all database process even after db2stop. How can I stop all database processes? I have finished upgraded our system test and UAT region from 32-bit to 64-bit. I followed the following for my system test region: 1. log on aix with root 2. stop the instance 3. db2iupdt -w 64 instance
5
7254
by: sandeep.iitk | last post by:
Hi All, When i am trying to take offline backup of my production db .. it is taking more time in db2stop command (around 15 min.) while earlier max was 2 mins. what might be the reason for this delay. To stop the db I am using following sequence of commands:- db2set db2comm= db2 force application all db2stop force
0
9656
marktang
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...
0
9498
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,...
0
10364
Oralloy
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...
0
9967
tracyyun
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...
1
7517
isladogs
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...
0
5398
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...
0
5536
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4069
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
2
3670
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.