Renaming Windows DB2 Server Machine

[Database Administrator]

I'm attempting to rename a Windows 2003 Server machine that has DB2
9.1 Express with Fixpack 2 installed. After I rename the machine and
reboot, I get an error:

DB2 UDB:
SQL1042C An unexpected system error occurred.

Service Control Manager:
At least one service or driver failed during system startup. Use
Event Viewer to examine the event log for details.

Inside the event log I find:
The DB2 - DB2COPY1 - DB2 service terminated with service-specific
error 4294966274 (0xFFFFFC02).

Inside db2diag.log I find this error several times:
2007-09-20-12.09.32.109000-420 E68293H405 LEVEL: Error (OS)
PID : 2860 TID : 2848 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloGetAccountSID, probe:30
MESSAGE : ZRC=0x83000534=-2097150668
CALLED : OS, -, LookupAccountName
OSERR : 1332 "No mapping between account names and security IDs was
done."

I found an article about renaming the DB2 Server machine, but I am
unable to do this after renaming the machine:
http://www-304.ibm.com/jct09002c/isv...sp?oid=1:23295
(the db2 ... command fails).

I looked up the windows error message and didn't find anything useful.

How do I rename a DB2 Server Machine?

[Database Administrator]

On Sep 20, 3:19 pm, Shepherd.Tra...@gmail.com wrote:
> I'm attempting to rename a Windows 2003 Server machine that has DB2
> 9.1 Express with Fixpack 2 installed. After I rename the machine and
> reboot, I get an error:
>
> DB2 UDB:
> SQL1042C An unexpected system error occurred.
>
> Service Control Manager:
> At least one service or driver failed during system startup. Use
> Event Viewer to examine the event log for details.
>
> Inside the event log I find:
> The DB2 - DB2COPY1 - DB2 service terminated with service-specific
> error 4294966274 (0xFFFFFC02).
>
> Inside db2diag.log I find this error several times:
> 2007-09-20-12.09.32.109000-420 E68293H405 LEVEL: Error (OS)
> PID : 2860 TID : 2848 PROC : db2syscs.exe
> INSTANCE: DB2 NODE : 000
> FUNCTION: DB2 UDB, oper system services, sqloGetAccountSID, probe:30
> MESSAGE : ZRC=0x83000534=-2097150668
> CALLED : OS, -, LookupAccountName
> OSERR : 1332 "No mapping between account names and security IDs was
> done."
>
> I found an article about renaming the DB2 Server machine, but I am
> unable to do this after renaming the machine:http://www-304.ibm.com/jct09002c/isv...sp?oid=1:23295
> (the db2 ... command fails).
>
> I looked up the windows error message and didn't find anything useful.
>
> How do I rename a DB2 Server Machine?

DB2 (and many other services in Win NT type machines) depend upon
NetBIOS service mappings for proper operation. Just a wild guess that
might be related to that. Check 'nbtstat -n' to see if there are any
discrepancies there.

Is your instance service installed as a local userid or domain userid?

[Database Administrator]

On Sep 20, 1:51 pm, Sanjuro wrote:
> On Sep 20, 3:19 pm, Shepherd.Tra...@gmail.com wrote:
>
>
>
>
>
> > I'm attempting to rename a Windows 2003 Server machine that has DB2
> > 9.1 Express with Fixpack 2 installed. After I rename the machine and
> > reboot, I get an error:
>
> > DB2 UDB:
> > SQL1042C An unexpected system error occurred.
>
> > Service Control Manager:
> > At least one service or driver failed during system startup. Use
> > Event Viewer to examine the event log for details.
>
> > Inside the event log I find:
> > The DB2 - DB2COPY1 - DB2 service terminated with service-specific
> > error 4294966274 (0xFFFFFC02).
>
> > Inside db2diag.log I find this error several times:
> > 2007-09-20-12.09.32.109000-420 E68293H405 LEVEL: Error (OS)
> > PID : 2860 TID : 2848 PROC : db2syscs.exe
> > INSTANCE: DB2 NODE : 000
> > FUNCTION: DB2 UDB, oper system services, sqloGetAccountSID, probe:30
> > MESSAGE : ZRC=0x83000534=-2097150668
> > CALLED : OS, -, LookupAccountName
> > OSERR : 1332 "No mapping between account names and security IDs was
> > done."
>
> > I found an article about renaming the DB2 Server machine, but I am
> > unable to do this after renaming the machine:http://www-304.ibm.com/jct09002c/isv...sp?oid=1:23295
> > (the db2 ... command fails).
>
> > I looked up the windows error message and didn't find anything useful.
>
> > How do I rename a DB2 Server Machine?
>
> DB2 (and many other services in Win NT type machines) depend upon
> NetBIOS service mappings for proper operation. Just a wild guess that
> might be related to that. Check 'nbtstat -n' to see if there are any
> discrepancies there.
>
> Is your instance service installed as a local userid or domain userid?- Hide quoted text -
>
> - Show quoted text -

After changing the machine name, nbtstat -n shows the updated machine
name in its list. I installed DB2 using the local administrator
account. The service is set to log on as the Local System account.

[Database Administrator]

On Sep 20, 2:51 pm, Shepherd.Tra...@gmail.com wrote:
> On Sep 20, 1:51 pm, Sanjuro wrote:
>
>
>
>
>
> > On Sep 20, 3:19 pm, Shepherd.Tra...@gmail.com wrote:
>
> > > I'm attempting to rename a Windows 2003 Server machine that has DB2
> > > 9.1 Express with Fixpack 2 installed. After I rename the machine and
> > > reboot, I get an error:
>
> > > DB2 UDB:
> > > SQL1042C An unexpected system error occurred.
>
> > > Service Control Manager:
> > > At least one service or driver failed during system startup. Use
> > > Event Viewer to examine the event log for details.
>
> > > Inside the event log I find:
> > > The DB2 - DB2COPY1 - DB2 service terminated with service-specific
> > > error 4294966274 (0xFFFFFC02).
>
> > > Inside db2diag.log I find this error several times:
> > > 2007-09-20-12.09.32.109000-420 E68293H405 LEVEL: Error (OS)
> > > PID : 2860 TID : 2848 PROC : db2syscs.exe
> > > INSTANCE: DB2 NODE : 000
> > > FUNCTION: DB2 UDB, oper system services, sqloGetAccountSID, probe:30
> > > MESSAGE : ZRC=0x83000534=-2097150668
> > > CALLED : OS, -, LookupAccountName
> > > OSERR : 1332 "No mapping between account names and security IDs was
> > > done."
>
> > > I found an article about renaming the DB2 Server machine, but I am
> > > unable to do this after renaming the machine:http://www-304.ibm.com/jct09002c/isv...sp?oid=1:23295
> > > (the db2 ... command fails).
>
> > > I looked up the windows error message and didn't find anything useful.
>
> > > How do I rename a DB2 Server Machine?
>
> > DB2 (and many other services in Win NT type machines) depend upon
> > NetBIOS service mappings for proper operation. Just a wild guess that
> > might be related to that. Check 'nbtstat -n' to see if there are any
> > discrepancies there.
>
> > Is your instance service installed as a local userid or domain userid?- Hide quoted text -
>
> > - Show quoted text -
>
> After changing the machine name, nbtstat -n shows the updated machine
> name in its list. I installed DB2 using the local administrator
> account. The service is set to log on as the Local System account.- Hide quoted text -
>
> - Show quoted text -

Any other ideas on what the problem could be? I'm running the server
on VMWare, in case that makes a difference.

[saiderico]

1. edit hosts file
add old host name alias to 127.0.0.1 to your C:\WINDOWS\system32\drivers\etc\hosts

2. edit registry at three following places:

[HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\GLOBAL_PROFILE]
"DB2_ADMINGROUP"="your_new_comp_name\DB2ADMNS"
"DB2_USERSGROUP"="your_new_comp_name\DB2USERS"
"DB2SYSTEM"="your_new_comp_name"

[HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopie s\DB2COPY1\GLOBAL_PROFILE]
"DB2_ADMINGROUP"="your_new_comp_name\DB2ADMNS"
"DB2_USERSGROUP"="your_new_comp_name\DB2USERS"
"DB2SYSTEM"="your_new_comp_name"

[HKEY_LOCAL_MACHINE\SOFTWARE\IBM\DB2\InstalledCopie s\DB2COPY1\PROFILES\DB2]
"DB2INSTOWNER"="your_new_comp_name"

3. then following
C:\>db2stop
C:\>db2admin stop
C:\>db2extsec -r
C:\>db2extsec /a DB2ADMNS /u DB2USERS

4. fix db2nodes.cfg
"C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2COPY1\DB2\db2nodes.cfg"

5. db2set -g DB2SYSTEM=your_new_comp_name

6. reboot