client instance and server instance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jane - 06 Jan 2006 19:12 GMT

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.

Reply to this Message

Darin McBride - 08 Jan 2006 15:50 GMT

> 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.

Reply to this Message

jane - 09 Jan 2006 22:05 GMT

HI,

Thanks Darin's reply.

But I cannot find it..

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

Thanks.

> > HI,
> >
[quoted text clipped - 6 lines]
>
> It should tell you what type of instance this is right near the top.

Reply to this Message

Pierre Saint-Jacques - 09 Jan 2006 22:33 GMT

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.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> HI,
>
[quoted text clipped - 16 lines]
>>
>> It should tell you what type of instance this is right near the top.

Reply to this Message

Darin McBride - 11 Jan 2006 14:09 GMT

> On a command Line:
> D:\SQLLIB\BIN>db2 get dbm cfg
[quoted text clipped - 11 lines]
> 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.

Reply to this Message

Pierre Saint-Jacques - 11 Jan 2006 22:30 GMT

I stand duly corrected and glad to know that one stilllearns every day.
Thanks for that, Pierre.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

>
>> On a command Line:
[quoted text clipped - 26 lines]
> and can be used to store configuration information about remote databases
> and be used to connect to those databases.

Reply to this Message

Darin McBride - 09 Jan 2006 22:46 GMT

> HI,
>
[quoted text clipped - 5 lines]
>
> 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.

>> > HI,
>> >
[quoted text clipped - 6 lines]
>>
>> It should tell you what type of instance this is right near the top.

Reply to this Message

jane - 10 Jan 2006 14:13 GMT

HI,

Thanks for Pierre , Darin's reply.

I understand now..

Reply to this Message