If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > hi about dbspace

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-23-06, 23:16
gemgem42 gemgem42 is offline
Registered User
 
Join Date: Nov 2006
Posts: 7
hi about dbspace

how can i increase the dbspace for rootdbs cos one of my database is intialize to this dbspace
if cannot how can i change the dbspace?
Reply With Quote
  #2 (permalink)  
Old 11-24-06, 07:06
stanislav.ondac stanislav.ondac is offline
Registered User
 
Join Date: Aug 2005
Posts: 140
Hi, you can increase the size of dbspace only by adding additional chunks.
You can do it with "onspaces -a dbspacename -p path_to_device_or_file -s size -o offset" command.
If you want to move database to another dbspace the most simple way is:

Export the database. dbexport dbname
Drop the database.
Import the database into the dbspace you want. dbimport dbname -d
dbspacename -l buffered ( Use buffered only if you want buffered
logging )

Hope this helps
Reply With Quote
  #3 (permalink)  
Old 11-26-06, 20:36
gemgem42 gemgem42 is offline
Registered User
 
Join Date: Nov 2006
Posts: 7
i got this error shared memory not initialized for INFORMIXSERVER

anyone have any idea y?
Reply With Quote
  #4 (permalink)  
Old 11-27-06, 04:30
stanislav.ondac stanislav.ondac is offline
Registered User
 
Join Date: Aug 2005
Posts: 140
See the informix system message log file(MSGPATH parameter in onconfig file) for additional information.
Reply With Quote
  #5 (permalink)  
Old 11-29-06, 09:29
DB Guy DB Guy is offline
Registered User
 
Join Date: Mar 2006
Location: New Jersey
Posts: 10
Hey gemgem... I would advise to get some training ASAP...this is basic stuff you are asking
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On