RE: Error with sysmaster DB creation

> OS UNIX IBM AIX 4.1.4 > ONLINE 7.12 UC2 > HARDWARE IBM RS6000 (R30) SMP > > I am having problems creating the sysmaster DB for an additional instance. > It is not being created! The SQL (sysmaster.sql) is okay, yet after > compeletion of execution no sysmaster is being created and the following > message appears on the log: > Building 'sysmaster' database ... > 19:25:39 Error building 'sysmaster' database. > 19:25:39 See '/tmp/buildsmi.82244'. I had a similar error when OnLine initialization was performed with LANG environment variable set in Unix. My platform was: OS UNIX ICL NX 7MPlus ONLINE 7.11 UC1X2 HARDWARE ICL Sparc server In my case, the `/tmp/buildsmi...' file was not removed and contained the information about LANG (or LC_COLLATE) not set properly. The solution was: (1) unset LANG (from Unix prompt) (2) oninit -i (3) set LANG=...... To add more, sth strange is with this LANG, because when later I tried to bring the instance up by doing the following: (1) set LANG=...... (2) oninit --- no problems reported in `online.log' (3) ontape <with any parameters> --- just hangs... (Unix process sleeping) and needed to be killed (4) dbaccess --- didn't want to select any database and reported problems with LANG (or LC_COLLATE) settings Again, `unset LANG' before oninit was the solution. -- Hanna Kolodziejska <h.kolodziejska.pol0101@oasis.icl.co.uk>