More DB2 Vista NewBee questions

[gimme_this_gimme_that]

1. What is the syntax to create a node when the server is running on
the local machine?

Does one still use the word remote?

catalog tcpip node webi remote localhost server 50000

2. If I execute "db2 get dbm cfg c:/output.txt" and grep output.txt
on SVCENAME I see this:
TCP/IP Service name (SVCENAME) = db2c_DB2

To set the SVCNAME to 50000 (or any other number) and type:

db2 update db cfg using svcname 50000
QL0104N An unexpected token "svcname" was found following "USING".
Expected
okens may include: "ADSM_MGMTCLASS". SQLSTATE=42601

Why is this instruction failing?

Thanks.

[w.l.fischer]

On Nov 2, 9:44*pm, "[e-mail]"
<[e-mail]:

1. What is the syntax to create a node when the server is running on
the local machine?

Does one still use the word remote?

catalog tcpip node webi remote localhost server 50000

2. If I execute "db2 get dbm cfg c:/output.txt" and grep output.txt
on SVCENAME I see this:

*TCP/IP Service name * * * * * * * * * * * * *(SVCENAME) = db2c_DB2

To set the SVCNAME to 50000 (or any other number) and type:

db2 update db cfg using svcname 50000
QL0104N *An unexpected token "svcname" was found following "USING".
Expected
okens may include: *"ADSM_MGMTCLASS". *SQLSTATE=42601

Why is this instruction failing?

Thanks.

You can easily answer the questions yourself.

First question: try it out, or search for keywords in google.

Second question: You've made a syntax error.

[Mark A]

<gi*******************@yahoo.comwrote in message
news:01**********************************@g17g2000 prg.googlegroups.com...

1. What is the syntax to create a node when the server is running on
the local machine?

Does one still use the word remote?

catalog tcpip node webi remote localhost server 50000

2. If I execute "db2 get dbm cfg c:/output.txt" and grep output.txt
on SVCENAME I see this:
TCP/IP Service name (SVCENAME) = db2c_DB2

To set the SVCNAME to 50000 (or any other number) and type:

db2 update db cfg using svcname 50000
QL0104N An unexpected token "svcname" was found following "USING".
Expected
okens may include: "ADSM_MGMTCLASS". SQLSTATE=42601

Why is this instruction failing?

Thanks.

I don't understand why you need to create a node if the database is on the
local machine. The local node and database are already catalogued (db2 list
node directory, db2 list database directory). For a type 4 driver, all you
need is the hostname, port, database, user, password (and default schema if
different than user).

Please take a look at C:\Windows\system32\drivers\etc (/etc/services on
Linux/UNIX) to see how the label "db2c_DB2" is translated into the port
number. You can change the port number on the services file, or you set it
directly to a port number in the dbm cfg (if you can type SVCENAME
correctly). These entries are automatically created when the default
instance is created.
db2c_DB2 50000/tcp

[mvsmsh]

Hi ,
svcname is part of DB Manger configuration not part of DB
Configuration.

Try this ,
db2 update DBM cfg svcname 50000

Hope this works .

Regards
Myoungsoo

>db2 update db cfg using svcname 50000
QL0104N An unexpected token "svcname" was found following "USING".
Expected
okens may include: "ADSM_MGMTCLASS". SQLSTATE=42601
Why is this instruction failing?

[Tapio =?iso-8859-1?Q?V=E4=E4tt=E4nen?=]

On 2008-11-03, mvsmsh <mv****@gmail.comwrote:

svcname is part of DB Manger configuration not part of DB
Configuration.

Try this ,
db2 update DBM cfg svcname 50000

Hope this works .

Well it does not, since you too made a mistake. SVCENAME is DBM
configuration parameter, not DB as you pointed out. Parameter is
not svcname, it is SVCENAME. Case does not matter, but it needs to
be typed correctly.

Correct syntax would be:

db2 update dbm cfg using SVCENAME 50000

You also need to have db2comm set to tcpip. This can be checked
with command:

db2set -all

Set it with command:

db2set db2comm=tcpip

After these, instance restart is needed.

--
sip:ta*@tav.iki.fi http://tav.iki.fi

"Writing a new OS only for the 386 in 1991 gets you your second 'F' for
this term." -- Prof. Andrew S. Tanenbaum