(BTS73) - bts error
I am trying to create a bts index on a clob column using dbaccess. Here is the
complete error:
(BTS73) - bts error - sbspace btssbspace is not logged
The os is HPUX.
IBM Informix Dynamic Server Version 11.50.FC9W2X2 -- On-Line -- Up 04:16:24 --1357044 Kbytes
This is the sql that results in the error:
create index 'informix'.ix_dps_report_data_datavalue on
'informix'.dps_report_data
(
data_value bts_clob_ops
)
using bts
in btssbspace;
A little help?
Thanks - Bevis
never mind - I found the onspaces -ch command.
Totally embarrassed - Bevis
>>> "BEVIS KENNEDY" <bkennedy@utah.gov> 9/6/2012 11:16 AM >>>
I am trying to create a bts index on a clob column using dbaccess. Here is the
complete error:
(BTS73) - bts error - sbspace btssbspace is not logged
The os is HPUX.
IBM Informix Dynamic Server Version 11.50.FC9W2X2 -- On-Line -- Up 04:16:24 --1357044 Kbytes
This is the sql that results in the error:
create index 'informix'.ix_dps_report_data_datavalue on
'informix'.dps_report_data
(
data_value bts_clob_ops
)
using bts
in btssbspace;
A little help?
Thanks - Bevis
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
You need to change the sbspace, btssbspace, to logged:
onspace -ch btssbspace -Df LOGGING=on
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Thu, Sep 6, 2012 at 1:16 PM, BEVIS KENNEDY <bkennedy@utah.gov> wrote:
> I am trying to create a bts index on a clob column using dbaccess. Here is
> the
> complete error:
> (BTS73) - bts error - sbspace btssbspace is not logged
>
> The os is HPUX.
>
> IBM Informix Dynamic Server Version 11.50.FC9W2X2 -- On-Line -- Up
> 04:16:24 --> 1357044 Kbytes
>
> This is the sql that results in the error:
>
> create index 'informix'.ix_dps_report_data_datavalue on
> 'informix'.dps_report_data
>
> (
>
> data_value bts_clob_ops
>
> )
> using bts
> in btssbspace;
>
> A little help?
>
> Thanks - Bevis
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae9340af32dbd9d04c90d1536