473,399 Members | 3,832 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,399 software developers and data experts.

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 5464
Ian
da******@hotmail.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...@mobileaudio.comwrote:
danfa...@hotmail.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**********************************@w7g2000h sa.googlegroups.com...
On Apr 24, 9:49 am, Ian <ianb...@mobileaudio.comwrote:
danfa...@hotmail.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
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...
9
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
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...
1
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...
0
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...
1
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...
0
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
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...
5
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...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
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...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
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...
0
agi2029
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,...

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.