Re: How to change DBID
If you are talking about the NAME of the database, then yes.
dbaccess sysmaster -
rename database tst prd;
[CRTL-C to exit]
Dave Otto
Sr.. Database Administrator
TMS, Mortgage Division
Richard Moldovan wrote in message <34A91730.2ED419FB@mmsi.com>...
>I have transfered an Informix 7.21 database from one to another
>(SAP on Solaris) system using an ontape archive. The problem I
>now have is the new system expect the DBID to be one thing ('prd')
>and the 'old' systems DBID was 'tst'. When SAP tries to connect
>to the system using DBID=prd it fails. If I try to connect as
>DBID=tst the connection is made but screws up everything else.
>Is there a way to change the DBID inside the db?
>Thanks in advance.
>moldovan@mmsi.com