Create imadb Database
Note: Perform this step only if you received “Database does not exist: imadb” messages during the DBMS setup phase of your Ingres install. This should only occur if you are upgrading from OpenIngres 1.x to Ingres 2.6 or older.
To create the imadb database, as the installation owner, execute these commands:
UNIX:
ingstart
cd $II_SYSTEM/ingres/bin
createdb '-u$ingres' imadb –f nofeclients
sql '-u$ingres' imadb <makimau.sql
rmcmdgen
ingstop
Windows:
ingstart
cd %II_SYSTEM%\ingres\bin
createdb -u$ingres imadb –f nofeclients
sql -u$ingres imadb <makiman.sql
rmcmdgen
ingstop
As the makimau or makiman SQL scripts run, you see a series of messages such as “E_US0AC1 'some-name' does not exist or is not owned by you.” These are normal and can be ignored.
Note: For versions before Ingres 9.0, the cd command in the above examples would be:
UNIX:
cd $II_SYSTEM/ingres/vdba
Windows:
cd %II_SYSTEM%\ingres\vdba