Hi Terry
Some suggestions, I hope it's as simple as this:
Check the value of the DB2SYSTEM registry variable (db2set -all from the
CLP) and use the db2set command to change it to the new host name.
Once you can start the instance, stop the DAS service, run db2 update admin
cfg using DB2SYSTEM xxx, then start the DAS. Next, connect to the database
and confirm using db2 "values(current server)".
If you use the Control Center, you may need to change/remove/add the system
name there too.
Good Luck
Alex Levy
Sustainable Software Ltd
> -----Original Message-----
> From: Elkington Terry T
> [mailto:db2udbdba-ezmlmshield-x10683676.[Email address protected]
> Sent: 15 April 2008 11:14
> To: LazyDBA Discussion
> Subject: rename Windows 2003 Server after DB2 was installed
>
> Hi, I built a Windows Server 2003 server and installed DB2
> 9.5 Express on it. I created a database and imported tables.
> I then renamed the server to a standard naming convention
> used in our company and rebooted.
> Now I receive an error:
>
> DB2 UDB:
> SQL1042C An unexpected system error occurred.
>
> Could anyone please advise on how to fix \ prevent this.
>
> Thank you
> Terry Elkington
> CSS Infrastructure Development
> Tel: (011) 636-8622
> Mobile: 083-265-0832
>
>
>
> ______________________________________________________________
> ______________________________________________________________
> _________
>
> Standard Bank email Disclaimer and confidentiality note
>
> This e-mail, its attachments and any rights attaching hereto
> are, unless the content clearly indicates otherwise, the
> property of Standard Bank Group Limited and its subsidiaries.
> It is confidential, private and intended for only the addressee.
>
> Should you not be the addressee and receive this e-mail by
> mistake, kindly notify the sender, and delete this e-mail immediately.
> Do not disclose or use it in any way. Views and opinions
> expressed in this e-mail are those of the sender unless
> clearly stated as those of Standard Bank Group.
>
> Standard Bank Group accepts no liability for any loss or
> damages howsoever incurred, or suffered, resulting, or
> arising, from the use of this email or its attachments.
>
> Standard Bank Group does not warrant the integrity of this
> e-mail nor that it is free of errors, viruses, interception
> or interference.
>
> Licensed divisions of the Standard Bank Group are authorised
> financial services providers in terms of the Financial
> Advisory and Intermediary Services Act, No 37 of 2002 (FAIS).
>
> For information about the Standard Bank Group visit our
> website http://www.standardbank.com
> ______________________________________________________________
> ______________________________________________________________
> ____________
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com To Subscribe :
> http://www.LazyDBA.com To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>
> E-mail message checked by Spyware Doctor (5.5.0.212) Database
> version: 5.09630 http://www.pctools.com/en/spyware-doctor/
E-mail message checked by Spyware Doctor (5.5.0.212)
Database version: 5.09630
http://www.pctools.com/en/spyware-doctor/
DB2 & UDB email list listserv db2-l LazyDBA home page