RE: Error with sysmaster DB creation
Your Problem was one of the four attempts of finding the error Informix
Tech had me try. My LANG is set to en_US, yet I unset it and still had the problem.
Thanks anyway.
-------------------------------------------------------------------------
Cheryl Kendricks
Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov
DTSI, Inc. Voice: 1-800-598-5008 Fax: 512-393-7296
Database Administrator - DOL Job Corps San Marcos, Texas
------------------------------------------------------------------------
On Fri, 31 May 1996 h.kolodziejska.pol0101@oasis.icl.co.uk wrote:
}
}
}
}
}
}
} > 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>
}