Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Thumbs up Unanswered: how to create dbspaces

    i installed Informix dynamic server 9.4 on linux . i have one dbspace by default that is "rootdbs"

    all my tables and logs(both physical and logical) r storing in "rootdbs" , how can i create saperate dbspace and how to move logs to that newly created dbspace

    reply is appreciable

  2. #2
    Join Date
    May 2004
    New York
    Take a look at onspaces and the onparams command.

    First create a dbspace then create the logs. Remember you have to have a minimum of 3 logical logs present at all times.
    Do the same with physical log, and I would recommend taking you database and out of rootdbs also. Create a tempdbspace as well


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts