IDS Forum

RE: installing BTS datablade running on a database

Posted By: Mark Ashworth
Date: Friday, 22 February 2013, at 6:33 p.m.

In Response To: installing BTS datablade running on a database (KARL OLIVER)

Hi Karl,

Version 1 of BTS (IDS 11.10) only used extspaces to store the index. This
essentially stored the index in files in the operating system separate from
the database. In Version 2, we provided support to store the bts index
values in an sbspace. At the minimum, you need a default sbspace created
and specified in the SBSPACENAME onconfig variable where the where BTS
metadata is maintained. With BTS 2.00 you can specify a storage clause on
the index, so the index can be stored in a specific sbspaces or fragmented
across several sbspaces. If no storage clause is specified, the index will
be created in the default sbspace. We strongly urged users to move to
using sbspaces because that are part of the database and do not need, for
example, to be backed up separately. We have kept extspace support for
backward capability but we strongly encourage users to only use sbspaces.

You asked:

1 i did this but cant see any space why not ?

An extspace does not show up with tools like onstat -d because its is
not a dbspace or an sbspace and not part of the database.

2 we need to do this or can we add space to the instance in the normal way

No, you do not need and should not use extspaces with BTS in version
2.00. Go with sbspaces

I hope this helps.

My colleague Jacques Renaut gave a link to the BTS documentation
(http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=%2Fco
m.ibm.dbext.doc%2Fids_dbxt_175.htm) which has a section on preparing to use
BTS in an IDS server. The good news going forward, in 11.70, we have
introduced the AutoReg Feature which will configure and register BTS on
first use. So there is no preparation needed to get started using BTS. It
also applies to types like Spatial and TimeSeries.

Mark Ashworth
IBM Informix Extensibility Architect

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of KARL
OLIVER
Sent: February 7, 2013 8:28 PM
To: ids@iiug.org
Subject: installing BTS datablade running on a database [29485]

IBM Informix Dynamic Server Version 11.50.FC9 Software Serial Number
AAA#B000000
Linux hvgreyst25 2.6.18-308.el5 #1 SMP Fri Jan 27 17:17:51 EST 2012 x86_64
x86_64 x86_64 GNU/Linux

arc sde 10

I dont know much about this sort of thing. Got info from diffrent web sites
I have installed the register bts.2.00 onconfig has SBSPACENAME sblobspace1
# Default smartblob space name - this is where blobs

in some notes
here

https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/bts_
blade_part_two_setup?lang=en
i see you
create an external space for your BTSindex. This is accomplished by the
following onspaces -c -x extdbs -l >path>

2 things
1 i did this but cant see any space why not ?
2. Do we need to do this or can we add space to the instance in the normal
way

****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• installing BTS datablade running on a database
  KARL OLIVER -- Thursday, 7 February 2013, at 8:27 p.m.
  • Re: installing BTS datablade running on a database
    JACQUES RENAUT -- Friday, 8 February 2013, at 12:57 p.m.
    • Re: installing BTS datablade running on a database
      KARL OLIVER -- Tuesday, 12 February 2013, at 3:11 p.m.
  • RE: installing BTS datablade running on a database
    Mark Ashworth -- Friday, 22 February 2013, at 6:33 p.m.
    • Re: RE: installing BTS datablade running on a data
      KARL OLIVER -- Monday, 25 February 2013, at 4:26 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.