469,927 Members | 1,777 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

client instance and server instance

HI,

I have a question...

I have a bunch of instances...
Is there any way to tell which instance is client instance?
Your help is very appreciated.
Thanks.

Jan 7 '06 #1
7 4871
jane wrote:
HI,

I have a question...

I have a bunch of instances...
Is there any way to tell which instance is client instance?


db2 get dbm cfg

It should tell you what type of instance this is right near the top.
Jan 8 '06 #2
HI,

Thanks Darin's reply.

But I cannot find it..

if you could give me an example, I would ver appreciated.

Thanks.

Darin McBride wrote:
jane wrote:
HI,

I have a question...

I have a bunch of instances...
Is there any way to tell which instance is client instance?


db2 get dbm cfg

It should tell you what type of instance this is right near the top.


Jan 9 '06 #3
On a command Line:
D:\SQLLIB\BIN>db2 get dbm cfg

Database Manager Configuration

Node type = Database Server with local clients

The first output line tells you the kind of instance. In my case, mine is a
standalone system which cannot accept remote clients.

A server will always have at least one instance and it should show: ...
Server with Local and Remote Clients.
A client never has an instance. It runs an appl. called run time client
which has a small configuration file that acts somewhat like the instance
dbm cfg.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"jane" <es**********@yahoo.com> a écrit dans le message de news:
11*********************@g14g2000cwa.googlegroups.c om...
HI,

Thanks Darin's reply.

But I cannot find it..

if you could give me an example, I would ver appreciated.

Thanks.

Darin McBride wrote:
jane wrote:
> HI,
>
> I have a question...
>
> I have a bunch of instances...
> Is there any way to tell which instance is client instance?


db2 get dbm cfg

It should tell you what type of instance this is right near the top.


Jan 9 '06 #4
jane wrote:
HI,

Thanks Darin's reply.

But I cannot find it..

if you could give me an example, I would ver appreciated.

Thanks.
dmcbride@teers:~> db2 get dbm cfg

Database Manager Configuration

Node type = Database Server with local and remote clients

[snip]

This is a server instance. A client instance would say "Node type = "...
something about just being a client.
Darin McBride wrote:
jane wrote:
> HI,
>
> I have a question...
>
> I have a bunch of instances...
> Is there any way to tell which instance is client instance?


db2 get dbm cfg

It should tell you what type of instance this is right near the top.


Jan 9 '06 #5
HI,

Thanks for Pierre , Darin's reply.

I understand now..

Jan 10 '06 #6
Pierre Saint-Jacques wrote:
On a command Line:
D:\SQLLIB\BIN>db2 get dbm cfg

Database Manager Configuration

Node type = Database Server with local clients

The first output line tells you the kind of instance. In my case, mine is
a standalone system which cannot accept remote clients.

A server will always have at least one instance and it should show: ...
Server with Local and Remote Clients.
A client never has an instance. It runs an appl. called run time client
which has a small configuration file that acts somewhat like the instance
dbm cfg.


Even a client has instances. An instance is where DB2 stores configuration,
such as cataloged nodes and databases. You can have multiple instances in
a client, just as a server, where you can store different configurations,
e.g., a configuration for each program so that they can't see each others'
databases.

You can also create a client instance inside a server. For example, inside
your DB2 Personal Edition, you can run "db2icrt -s client DB2CLIENT" and
create an instance called DB2CLIENT which won't create any new services,
and can be used to store configuration information about remote databases
and be used to connect to those databases.

Jan 11 '06 #7
I stand duly corrected and glad to know that one stilllearns every day.
Thanks for that, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Darin McBride" <dm******@tower.to.org.no.spam.for.me> a écrit dans le
message de news: Mk8xf.75744$tl.16483@pd7tw3no...
Pierre Saint-Jacques wrote:
On a command Line:
D:\SQLLIB\BIN>db2 get dbm cfg

Database Manager Configuration

Node type = Database Server with local clients

The first output line tells you the kind of instance. In my case, mine is
a standalone system which cannot accept remote clients.

A server will always have at least one instance and it should show: ...
Server with Local and Remote Clients.
A client never has an instance. It runs an appl. called run time client
which has a small configuration file that acts somewhat like the instance
dbm cfg.


Even a client has instances. An instance is where DB2 stores
configuration,
such as cataloged nodes and databases. You can have multiple instances in
a client, just as a server, where you can store different configurations,
e.g., a configuration for each program so that they can't see each others'
databases.

You can also create a client instance inside a server. For example,
inside
your DB2 Personal Edition, you can run "db2icrt -s client DB2CLIENT" and
create an instance called DB2CLIENT which won't create any new services,
and can be used to store configuration information about remote databases
and be used to connect to those databases.


Jan 11 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Tom Leylan | last post: by
2 posts views Thread by mb12036 | last post: by
7 posts views Thread by CT | last post: by
4 posts views Thread by Yasaswi Pulavarti | last post: by
6 posts views Thread by Ken Allen | last post: by
8 posts views Thread by Brian Tkatch | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.