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.
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
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
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
Last modified date: 08/29/2024