[Maruthi]

How to Increase the DBSpaces in Informix Dynamic Server for WinNT.

Plz help me.


Maruthi

[vpshriyan]

Hi,

Create a DBspace:
onspaces -c -d <DBspacename> -p <pathname> -o <offset> -s <size>

Add a chunk to an existing DBspace:
onspaces -a <DBspacename> -p <pathname> -o <offset> -s <size>

Generally offset is kept as 0 (zero), but may vary according to a disk setup. Make sure that the instance where you are doing this admin job is free from user sessions.

Regards,
Shriyan

[Maruthi]

Hi..Thank u for reply.


I dont have the telnet. I am connecting to ServerStudio JE

Where i need to give the said command.


Regards
maruthi

Originally posted by vpshriyan
Hi,

Create a DBspace:
onspaces -c -d <DBspacename> -p <pathname> -o <offset> -s <size>

Add a chunk to an existing DBspace:
onspaces -a <DBspacename> -p <pathname> -o <offset> -s <size>

Generally offset is kept as 0 (zero), but may vary according to a disk setup. Make sure that the instance where you are doing this admin job is free from user sessions.

Regards,
Shriyan

[lloydnwo]

Originally posted by Maruthi
Hi..Thank u for reply.


I dont have the telnet. I am connecting to ServerStudio JE

Where i need to give the said command.


Regards
maruthi

Hi,

You will have to give this command in the command window where you started your IDS server. Eg. Start - Programs - Informix Dynamic server - Select your server
A command window will open, here you can give the above commands.

Regards,

lloyd

[Maruthi]

Hi..Thnx for u r suggetions.

still i am getting problem with onspaces. here i am attaching the error message.

Plz help me.

[lloydnwo]

Originally posted by lloydnwo
Hi,

You will have to give this command in the command window where you started your IDS server. Eg. Start - Programs - Informix Dynamic server - Select your server
A command window will open, here you can give the above commands.

Regards,

lloyd

Hi Maruti,

Here's how you do it.

To Create new Dbspace

1 Go to command prompt
2 Create a new file – edit abc.dat with zero bytes
(eg edit abc.dat)
3 Save it
4 At the server end –
Onspaces –C –D Abc_dbs –P C:\data\abc -O 10 -S 50000
5 Take a level 0 archive – Ontape -S


Add new chuck to a dbspace
Follow the same 4 steps and
Onspaces – a ocslink -o 0 -p c:\ifmxdata\ocslink\ocslink_dat1 –s 50000

This should help.

Regards,

Lloyd