How to build sysmaster database?
Hi, Is there anyway to build the sysmaster database after the dbspace has been created? I am able to use my new databases, but when I do certain things it tells me it can't access the sysmaster database. Ideas? Thanks, Dave Brown
In article <MPG.11180ec81a8f6eef989687@news.earthlink.net>, dave_brown@dw-tech.com (Dave Brown) wrote: > Hi, > > Is there anyway to build the sysmaster database after the dbspace has > been created? I am able to use my new databases, but when I do certain > things it tells me it can't access the sysmaster database. > > Ideas? > > Thanks, > > Dave Brown > > Just run $INFORMIXDIR/etc/buildsmi. Before rebuilding sysmaster, though, you should check to see if any processes are locking up tables in the database. One of the first things buildsmi will do is attempt to drop the existing sysmaster. If it cannot get an exclusive lock on the database, you won't be able to rebuild anyway. Bob ------ -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
The sysmaster database is built automatically the first time an instance go online. Try a stop/start and go there... On Tue, 26 Jan 1999 17:42:00 -0700, dave_brown@dw-tech.com (Dave Brown) wrote: >Hi, > >Is there anyway to build the sysmaster database after the dbspace has >been created? I am able to use my new databases, but when I do certain >things it tells me it can't access the sysmaster database. > >Ideas? > >Thanks, > >Dave Brown >
In article <MPG.11180ec81a8f6eef989687@news.earthlink.net>, dave_brown@dw-tech.com (Dave Brown) wrote: > Hi, > > Is there anyway to build the sysmaster database after the dbspace has > been created? I am able to use my new databases, but when I do certain > things it tells me it can't access the sysmaster database. > > Ideas? > > Thanks, > > Dave Brown > > Normally it's cos you haven't let sysmaster finishing building when you configured the instance, there is a script, smibuild, in informix/etc run that. Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 # www.wfsoftware.co.uk