Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    india
    Posts
    45

    Unanswered: How to add data in Metadata

    I am using informix 9.4 TC1
    I have added SBSPACE
    onspaces -c -S sbspace3 -p D:\IFMXDATA\cdr5\sbspace_dat.003 -o 0 -s 1024

    which has status
    Chunks
    address chunk/dbs offset size free bpages flags pathname
    0CFBD018 61 60 0 256 103 103 POS- D:\IFMXDAT
    A\cdr5\sbspace_dat.003
    Metadata 100 74 100

    I have created table in this spaces using
    create table IFMXprod_serv
    (
    id integer,
    name BLOB
    )
    put name in (sbspace1)

    I am inserting data using command
    insert into IFMXprod_serv values (1,FILETOBLOB("D:\informix\toblob","server"));

    After adding lot of data I got an error that Sbspace is full showing following status
    Chunks
    address chunk/dbs offset size free bpages flags pathname
    0CFBD018 61 60 0 256 0 103 POS- D:\IFMXDAT
    A\cdr5\sbspace_dat.003
    Metadata 100 74 100

    It seems that there is still gree space in sbspace.
    How to add data into that Metadata.
    even thouth i am adding with Ms option in onspaces same thing is happening.

    Can anyone help.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    You can add space in metadata or user data with onspaces -ch, plase run from line command onspaces, for help.
    Remember that next of create a sbspaces or add a chunk must be force change of logical logs.
    Add the name in the SBSPACENAME configuration parameter.
    Use onstat -d, onstat -g smb s, and oncheck -cs, -cS, -ps, or -pS to
    display information about the sbspace.

    Gustavo.

  3. #3
    Join Date
    Feb 2004
    Location
    india
    Posts
    45
    gustav

    Thanks for help.But my problem is slightly different.I want to write into Metadata area of sbspace.
    How can we do it

  4. #4
    Join Date
    Apr 2003
    Location
    Phoenix, AZ
    Posts
    177
    Metadata is the information about the object, not the object itself. You don't store into metatdata, Informix does that. You only allocated 256 pages of which 103 were available for your use before you started. You filled them up.
    Fred Prose

Posting Permissions

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