The -s option of the db2icrt command

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laurence - 24 Dec 2007 04:11 GMT

Hi folks,

I know how to create an instance by db2icrt command, such as

> db2icrt -a server -u db2fenc1 db2inst1

The -s option of the db2icrt command, which specifies the type of
instance to create. Valid values are CLIENT, ESE, and WSE. I always
ignore it when I create an instance.

I was wondering if you could point me when/why I have to specify the -
s option with a value ESE, or WSE.

Thanks in advance,

Laurence

Reply to this Message

Mark A - 24 Dec 2007 04:41 GMT

> Hi folks,
>
[quoted text clipped - 12 lines]
>
> Laurence

You only have to specify when the instance you want to create is different
than the installed version and you want a instance with fewer features. If
you have WSE installed, you cannot select ESE.

Reply to this Message

Laurence - 24 Dec 2007 06:40 GMT

Is there any way to recognize the instance that is created by ESE or
WSE value?

Reply to this Message

Mark A - 24 Dec 2007 07:25 GMT

> Is there any way to recognize the instance that is created by ESE or
> WSE value?

Logon as instance owner and type db2level

Reply to this Message

Laurence - 24 Dec 2007 15:33 GMT

> > Is there any way to recognize the instance that is created by ESE or
> > WSE value?
>
> Logon as instance owner and type db2level

The message is shown below:

DB21085I Instance "db2inst2" uses "32" bits and DB2 code release
"SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.1.64", "s040812", "U498350", and
FixPak "7".
Product is installed at "/usr/opt/db2_08_01".

I can't find any info about ESE or WSE for instance. Have another way
to recognize that?

Reply to this Message

Darin McBride - 26 Dec 2007 14:52 GMT

> Is there any way to recognize the instance that is created by ESE or
> WSE value?

db2 get dbm cfg

Near the top will be a line like:

Node type = Enterprise Server Edition with local and remote clients

That basically tells you what type of instance it is. In fact, that's
nearly everything that the -s flag does: sets up the dbm configuration
appropriately.

(The other thing it does on unix is gets rid of any server-based executables
from sqllib/adm if you use -s client, to save a bit of space and a bit of
confusion.)

Reply to this Message

Mark A - 26 Dec 2007 18:22 GMT

On Dec 26, 9:52 am, Darin McBride
<dmcbr...@naboo.to.org.no.spam.for.me> wrote:

> (The other thing it does on unix is gets rid of any server-based executables
> from sqllib/adm if you use -s client, to save a bit of space and a bit of
> confusion.)

I may be wrong, but I thought those files in sqllib were only symbolic
links to the install directory.

Reply to this Message

swami - 26 Dec 2007 18:55 GMT

I am getting
[db2inst2@SIVA ~]$ db2 "get dbm cfg" | grep -i node
Node type = Database Server with local and remote clients
[db2inst2@SIVA ~]$

for -s wse.

> On Dec 26, 9:52 am, Darin McBride
>
[quoted text clipped - 5 lines]
> I may be wrong, but I thought those files in sqllib were only symbolic
> links to the install directory.

Reply to this Message

Laurence - 27 Dec 2007 12:08 GMT

Yes,

As I create instance for the -s option with ese value, the Node Type
of dbm cfg is like below:

"Node type = Enterprise Server Edition with local and remote clients"

As I create instance for the -s option with wse value, the Node Type
of dbm cfg is like below:

"Node type = Database Server with local and remote clients"

Thank you and for your information!

Laurence

Reply to this Message

Darin McBride - 28 Dec 2007 05:39 GMT

> On Dec 26, 9:52 am, Darin McBride
> <dmcbr...@naboo.to.org.no.spam.for.me> wrote:
[quoted text clipped - 4 lines]
> I may be wrong, but I thought those files in sqllib were only symbolic
> links to the install directory.

Almost all of them are. Some are physical files - you can't do
setuid-instance-owner via symlink (because it gets difficult when you have
more than one instance). Almost all of these are in sqllib/adm.

Reply to this Message