Re: DBSPACE

"T.Jalaludeen" wrote: > > Author : T.Jalaludeen > E-mail : jala@hpsgm99.sgp.hp.com > > Hai, > I created a database in INFOMRIX 7.23 - HP UX. > I created tables also. But later I found thatthe > transaction logging has not been turned ON for this database, > so droped the database and created using > "CREATE DATABASE <db_name> WITH LOG" > > The database created properly, but when I checked the log status > it is still set to "N" , so in this case how do I turn > the transaction logging. I tried on-tape but it needs dba permission. These are the two methods most often used. If you can reproduce this behaviour, I would report it to Informix technical support. > And another question is how do I put my database in a seperate dbspace > other than rootdbs. CREATE DATABASE <db_name> IN <dbspace_name> WITH LOG Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+