By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,256 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

how to verify

P: n/a
On Aix or Linux how can I verify if the two instances I have on the
same server are running? If I run ps -ef | grep 'db2inst' command I
see only db2inst1. I cataloged the second instance db2inst2 to the
local node myinst2. Even if I grep for myinst2, I don't see any thing.
Please help.
Thanks,
Yasaswi
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Ian
Yasaswi Pulavarti wrote:
On Aix or Linux how can I verify if the two instances I have on the
same server are running? If I run ps -ef | grep 'db2inst' command I
see only db2inst1. I cataloged the second instance db2inst2 to the
local node myinst2. Even if I grep for myinst2, I don't see any thing.
Please help.


You will see processes running for each DB2 instance owner. If you only
see processes for db2inst1, then the other instance is not running.

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
Nov 12 '05 #2

P: n/a
So when I am logged in as db2inst1 (username as well as instance name)
how can I run db2inst2 the second instance? Or do I need to log out as
db2inst1 and log back in as db2inst2
Please inform me.
Thanks,
Yasaswi

Ian <ia*****@mobileaudio.com> wrote in message news:<41**********@127.0.0.1>...
Yasaswi Pulavarti wrote:
On Aix or Linux how can I verify if the two instances I have on the
same server are running? If I run ps -ef | grep 'db2inst' command I
see only db2inst1. I cataloged the second instance db2inst2 to the
local node myinst2. Even if I grep for myinst2, I don't see any thing.
Please help.


You will see processes running for each DB2 instance owner. If you only
see processes for db2inst1, then the other instance is not running.

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Nov 12 '05 #3

P: n/a
You need to execute:
/home/instance-owner/sqllib/db2profile
for the instance you want to manipulate.

On systems I've set up involving multiple instances; I never attempt to
do this where I manipulate db2inst2 while logged on as db2inst1. I
either login as the appropriate instance owner or use a single DBA
userid that has administrative privileges for all of the instances. This
ID has a mechanism that provides a command window that can be tailored
to attach to any of the instances.

Administration of all of the instances can also be performed from a
single execution of the control center (db2cc).

Phil Sherman
Yasaswi Pulavarti wrote:
So when I am logged in as db2inst1 (username as well as instance name)
how can I run db2inst2 the second instance? Or do I need to log out as
db2inst1 and log back in as db2inst2
Please inform me.
Thanks,
Yasaswi

Ian <ia*****@mobileaudio.com> wrote in message news:<41**********@127.0.0.1>...
Yasaswi Pulavarti wrote:
On Aix or Linux how can I verify if the two instances I have on the
same server are running? If I run ps -ef | grep 'db2inst' command I
see only db2inst1. I cataloged the second instance db2inst2 to the
local node myinst2. Even if I grep for myinst2, I don't see any thing.
Please help.


You will see processes running for each DB2 instance owner. If you only
see processes for db2inst1, then the other instance is not running.

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---


Nov 12 '05 #4

P: n/a
ya*****@encfor.com (Yasaswi Pulavarti) wrote in message news:<aa**************************@posting.google. com>...
So when I am logged in as db2inst1 (username as well as instance name)
how can I run db2inst2 the second instance? Or do I need to log out as
db2inst1 and log back in as db2inst2
Please inform me.
Thanks,
Yasaswi

Logon as the instance owner and type db2start.
Nov 12 '05 #5

P: n/a
phu
What is the 'ps' command thatyou are running? Maybe you can choose
options that displays the processes of all users?

Bill

Yasaswi Pulavarti <ya*****@encfor.com> wrote:
So when I am logged in as db2inst1 (username as well as instance name)
how can I run db2inst2 the second instance? Or do I need to log out as
db2inst1 and log back in as db2inst2
Please inform me.
Thanks,
Yasaswi Ian <ia*****@mobileaudio.com> wrote in message news:<41**********@127.0.0.1>...
Yasaswi Pulavarti wrote:
> On Aix or Linux how can I verify if the two instances I have on the
> same server are running? If I run ps -ef | grep 'db2inst' command I
> see only db2inst1. I cataloged the second instance db2inst2 to the
> local node myinst2. Even if I grep for myinst2, I don't see any thing.
> Please help.


You will see processes running for each DB2 instance owner. If you only
see processes for db2inst1, then the other instance is not running.

----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

--
Bill Phu -- Dalhousie University (phu at cs dal ca)
"Three grand essentials to happiness in this life are something to do,
something to love, and something to hope for."
- Joseph Addison
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.