The -s option of the db2icrt command

[Laurence]

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

[Mark A]

"Laurence" <wo**********@gmail.comwrote in message
news:75**********************************@s19g2000 prg.googlegroups.com...

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

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.

[Laurence]

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

[Mark A]

"Laurence" <wo**********@gmail.comwrote in message
news:65**********************************@s8g2000p rg.googlegroups.com...

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

Logon as instance owner and type db2level

[Laurence]

On 12$B7n(B24$BF|(B, $B2<8a(B3$B;~(B25$BJ,(B, "Mark A" <[e-mail]:

"Laurence" <[e-mail] in message

news:65**********************************@s8g2000p rg.googlegroups.com...

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?

[Darin McBride]

Laurence wrote:

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

[Mark A]

On Dec 26, 9:52 am, Darin McBride
<[e-mail]:

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

[swami]

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, 11:22*pm, Mark A <[e-mail]:

On Dec 26, 9:52 am, Darin McBride

<[e-mail]:

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

[Laurence]

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

[Darin McBride]

Mark A wrote:

On Dec 26, 9:52 am, Darin McBride
<[e-mail]:

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

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.