Renaming Windows DB2 Server Machine

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shepherd.Travis@gmail.com - 20 Sep 2007 21:19 GMT

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/tech/faq/individual.jsp?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?

Reply to this Message

Sanjuro - 20 Sep 2007 21:51 GMT

> 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
[quoted text clipped - 28 lines]
>
> 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?

Reply to this Message

Shepherd.Travis@gmail.com - 20 Sep 2007 22:51 GMT

> > 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
[quoted text clipped - 37 lines]
>
> - 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.

Reply to this Message

Shepherd.Travis@gmail.com - 25 Sep 2007 16:22 GMT

> > > 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
[quoted text clipped - 43 lines]
>
> - 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.

Reply to this Message