Uncatalog the admin node and catalog the admin node with the right name.
Kish >From: Juan Lanus <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: Re: DB2EUG: how to change system name >Date: Thu, 11 Oct 2001 17:14:02 -0300 > >Hi, Pierre >Thanks for your reply, but I think I didn't explain well my problem. >Not at all critical: it's a development environment. > >I'll try to explain it in steps: >1- I set an NT server named "SOL" in 1999 that runs DB2 5.2 and later >7.1 no problem. It appears as "SOL" in the CC. >2- Last month I set a new server "SOLAR" intended to replace "SOL" and >install DB2 7.1, copy a couple DBs. >3- I stop the older server "SOL". From now on it will run my little >children's games under W98 (it's a Pentium 133). >4- I go to some NT gizmo and rename "SOLAR" to "SOL" as of the OS. >Reboot several times. >5.- In the CC the new "SOL" server still appears as "SOLAR". DB2's >system name isn't the same as NT's system name. >When I try to change DB2's system name using the CC it says that the >local object can't be renamed. >I spend half a day delving into the docs but still unable to change the >name. >Unistalling and installing DB2 is a simple and efective solution. DB2 >installs as a charm. > >But I still want to know how to change that #%@* name. >Thanks again >Juan Lanus >TECNOSOL > > > > >Pierre Saint-Jacques wrote: > >>You'll need to play with the node entries in the admin nnode directory. >>Assume your current system name is SYST1 in the cc. >> >>You switch to a new system and find that the name is now SYSTNEW >>How to get to SYST1 ?? >> >>On a command line do: >>1) db2 list admin node directory >> You should see an entry for SYSTNEW >>2) db2 uncatalog node SYSTNEW >>3) db2 CATALOG [ADMIN] TCPIP NODE node-name REMOTE_INSTANCE DB2DAS00 (or >>whatever name your DAS is) >>SYSTEM system-name (this you get by doing a db2set -all and find the >>db2system >>entry) OSTYPE os-type WITH "comment string" >> >> Here fit the entries as you have defined them. I chose tcpip but use >>whatever protocol you are to support. This is documented in the Command >>Ref. by >>the way. >>4)db2stop >>5)db2admin stop >>6)db2admin start >>7)db2start >>8)db2cc >>You should now see the new system name in the cc. >> >>HTH' Pierre. >> >>Juan Lanus wrote: >> >>>Hi >>>Recently I switched NT servers and was unable to change the new >>>server's system name to match the orlginal server's name. >>>I solved it by reinstalling DB2 on the new server. >>>But I'd like to know how to do it the next time I replace a server, two >>>or three years from now :-) >>>TIA >>>Juan Lanus >>>TECNOSOL >>> >>>===== >>>To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] >>>For other info (and scripts), see >>>http://people.mn.mediaone.net/scottrmcleod >>> >>> > > > > >===== >To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] >For other info (and scripts), see >http://people.mn.mediaone.net/scottrmcleod > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
