Brian Minnick wrote:
> This message is in MIME format. Since your mail reader does not

Naughty.... Don't make me unleash the clown on you.... *stern look*

> onmode -s brings the server to single user mode and all that you
> asked for.

It does not allow access to the database to manipulate data and schema. It
only allows you to administer the engine spaces, configuration and state.

[Oh, and Mark, I suggested this admin mode a few days ago. Clearly grate
minds think alike ;-]

> I know you can create raw tables in XPS that are non-logged and
> bypasses all the overhead and locking logic and will be recorded in
> systables. It would be nice to have that option in IDS.

IDS does since approx 7.2x - you can change tables to raw and back to
standard. IDS does not have the other table modes of XPS but they hardly
seem relevant to transactional applications.