Oncheck -pe output
Mark saw oncheck -pe entries whose object names appear to contain/start with a space (e.g. db1:'informix'. 34900_4135). Answer: these are indexes automatically created by the server to support primary key or other constraints; their names genuinely begin with a space. You can look them up in sysindices/sysindexes and trace them via sysconstraints, where the corresponding constraint name has a character in that first position (e.g. u<tabid>_999) — that is the name to use when dropping the constraint. Question resolved; Mark used the info to plan moving objects before emptying dbspaces.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
When I run oncheck -pe I get entries with a space in them:
db1:'informix'. 34900_4135 15977 16000
What am I looking at here? I've been all over the docs and can't find any
thing that helps me interpret this.
Thanks.
--mark
Read this chapter of the manual:
http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqls.doc/ids
_sqs_0528.htm
Probably you will find your answer there...
Regards
Cesar
--- Em seg, 20/9/10, MARK MILLS <mm4@rawlingscompany.com> escreveu:
De: MARK MILLS <mm4@rawlingscompany.com>
Assunto: Oncheck -pe output [21362]
Para: ids@iiug.org
Data: Segunda-feira, 20 de Setembro de 2010, 12:45
When I run oncheck -pe I get entries with a space in them:
db1:'informix'. 34900_4135 15977 16000
What am I looking at here? I've been all over the docs and can't find any
thing that helps me interpret this.
Thanks.
--mark
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Mark,
These are indexes created by the server when you create a primary key or
constraint. The index name begins with a space.
Regards - Lester
On 9/20/10 11:45 AM, MARK MILLS wrote:
> When I run oncheck -pe I get entries with a space in them:
>
> db1:'informix'. 34900_4135 15977 16000
>
> What am I looking at here? I've been all over the docs and can't find any
> thing that helps me interpret this.
>
> Thanks.
>
> --mark
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
--
______________________________________________________________________
Lester Knutsen lester@advancedatatools.com
Advanced DataTools Corporation Voice: 703-256-0267 x102
Visit our Web page: http://www.advancedatatools.com
______________________________________________________________________
Thanks! A couple of DBSpaces are about to be "ALTER"ed to empty and recovered. Now I know what to move to make it happen.
This is an index that was auto created for a constraint. You can find the
index name, with the embedded leading space in the sysindices table (or the
sysindexes VIEW) and references to it in the sysconstraints table.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
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 Mon, Sep 20, 2010 at 11:45 AM, MARK MILLS <mm4@rawlingscompany.com>wrote:
> When I run oncheck -pe I get entries with a space in them:
>
> db1:'informix'. 34900_4135 15977 16000
>
> What am I looking at here? I've been all over the docs and can't find any
> thing that helps me interpret this.
>
> Thanks.
>
> --mark
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0016e64f51b4d7506d0490b3d4c6
Note that in the sysconstraints table the entry will have a value in that
first position. A primary key constraint for example will be 'u<tabid>_999';
When you want to alter the table and drop the constraint, that is the name you
will want to use.
j.
Sep 20, 2010 04:59:36 PM, ids@iiug.org wrote:
===========================================
This is an index that was auto created for a constraint. You can find the
>index name, with the embedded leading space in the sysindices table (or the
>
>sysindexes VIEW) and references to it in the sysconstraints table.
>
>Art
>
>Art S. Kagel
>Advanced DataTools (www.advancedatatools.com)
>IIUG Board of Directors (art@iiug.org)
>
>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 Mon, Sep 20, 2010 at 11:45 AM, MARK MILLS <mm4@rawlingscompany.com>wrote:
>
>> When I run oncheck -pe I get entries with a space in them:
>>
>> db1:'informix'. 34900_4135 15977 16000
>>
>> What am I looking at here? I've been all over the docs and can't
>find any
>> thing that helps me interpret this.
>>
>> Thanks.
>>
>> --mark
>>
>>
>>
>>
>*******************************************************************************
>
>> Forum Note: Use "Reply" to post a response in the discussion
>forum.
>>
>>
>
>--0016e64f51b4d7506d0490b3d4c6
>
>
>*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>