Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Performance Warning ...

9 posts in General Discussion Last posting was on 2007-07-26 21:46:59.0Z
Robert Paresi Posted on 2007-07-24 13:07:57.0Z
Reply-To: "Robert Paresi" <FirstInitialLastName@innquest.com>
From: "Robert Paresi" <FirstInitialLastName@innquest.com>
Newsgroups: ianywhere.public.general
Subject: Performance Warning ...
Lines: 12
Organization: InnQuest Software
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16480
NNTP-Posting-Host: smtp.innquest.com
X-Original-NNTP-Posting-Host: smtp.innquest.com
Message-ID: <46a5f9ad$1@forums-1-dub>
Date: 24 Jul 2007 06:07:57 -0700
X-Trace: forums-1-dub 1185282477 24.173.150.22 (24 Jul 2007 06:07:57 -0700)
X-Original-Trace: 24 Jul 2007 06:07:57 -0700, smtp.innquest.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6149
Article PK: 2596

I get:

Performance warning: Redundant index "jdatatype_ind" for table
"spt_jdatatype_info"

When starting up a DB.

Can I drop this index without harm? Since it is a system table (the table
containing the column types) - I figured I'd ask first.

-Robert


Breck Carter [Team iAnywhere] Posted on 2007-07-24 14:05:39.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Performance Warning ...
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <hk1ca3d224e6aie6i42ogcr8ulo1qb4dqv@4ax.com>
References: <46a5f9ad$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 199.90.35.10
X-Original-NNTP-Posting-Host: 199.90.35.10
Date: 24 Jul 2007 07:05:39 -0700
X-Trace: forums-1-dub 1185285939 199.90.35.10 (24 Jul 2007 07:05:39 -0700)
X-Original-Trace: 24 Jul 2007 07:05:39 -0700, 199.90.35.10
Lines: 76
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6150
Article PK: 2595

What version are you running? What version was used to create the
database?

My guess is, you're running V9 but the database was created with V6;
here's what Foxhound says about that table in that situation:

-- dbo.spt_jdatatype_info (table_id 179) in db_6_0_4_3594.db - Jul 24
2007 10:02:11AM - Print - Foxhound © 2007 RisingRoad

-- Note: The table dbo.spt_jdatatype_info has more than one index on
-- columns ( TYPE_NAME ):
-- Unique constraint "spt_jdatatype_info UNIQUE
(TYPE_NAME)"
-- Unique index "jdatatype_ind"

CREATE TABLE dbo.spt_jdatatype_info ( -- 25 rows
ss_dtype TINYINT NOT NULL,
TYPE_NAME /* U */ VARCHAR ( 30 ) NOT NULL,
DATA_TYPE SMALLINT NOT NULL,
typelength INTEGER NOT NULL,
LITERAL_PREFIX VARCHAR ( 32 ) NULL,
LITERAL_SUFFIX VARCHAR ( 32 ) NULL,
CREATE_PARAMS VARCHAR ( 32 ) NULL,
NULLABLE SMALLINT NOT NULL,
CASE_SENSITIVE SMALLINT NOT NULL,
SEARCHABLE SMALLINT NOT NULL,
UNSIGNED_ATTRIBUTE SMALLINT NULL,
FIXED_PREC_SCALE SMALLINT NOT NULL,
AUTO_INCREMENT SMALLINT NULL,
LOCAL_TYPE_NAME VARCHAR ( 128 ) NOT NULL,
MINIMUM_SCALE SMALLINT NULL,
MAXIMUM_SCALE SMALLINT NULL,
SQL_DATA_TYPE SMALLINT NULL,
SQL_DATETIME_SUB SMALLINT NULL,
NUM_PREC_RADIX SMALLINT NULL,
is_unique BIT NOT NULL,
CONSTRAINT UNIQUE (
TYPE_NAME ) );

-- Parents of dbo.spt_jdatatype_info

-- none --

-- Children

-- none --

CREATE UNIQUE INDEX jdatatype_ind ON dbo.spt_jdatatype_info (
TYPE_NAME ASC );






On 24 Jul 2007 06:07:57 -0700, "Robert Paresi"

<FirstInitialLastName@innquest.com> wrote:

>I get:
>
>Performance warning: Redundant index "jdatatype_ind" for table
>"spt_jdatatype_info"
>
>When starting up a DB.
>
>Can I drop this index without harm? Since it is a system table (the table
>containing the column types) - I figured I'd ask first.
>
>-Robert

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Robert Paresi Posted on 2007-07-24 17:48:44.0Z
Reply-To: "Robert Paresi" <FirstInitialLastName@innquest.com>
From: "Robert Paresi" <FirstInitialLastName@innquest.com>
Newsgroups: ianywhere.public.general
References: <46a5f9ad$1@forums-1-dub> <hk1ca3d224e6aie6i42ogcr8ulo1qb4dqv@4ax.com>
In-Reply-To: <hk1ca3d224e6aie6i42ogcr8ulo1qb4dqv@4ax.com>
Subject: Re: Performance Warning ...
Lines: 88
Organization: InnQuest Software
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16480
NNTP-Posting-Host: smtp.innquest.com
X-Original-NNTP-Posting-Host: smtp.innquest.com
Message-ID: <46a63b7c$1@forums-1-dub>
Date: 24 Jul 2007 10:48:44 -0700
X-Trace: forums-1-dub 1185299324 24.173.150.22 (24 Jul 2007 10:48:44 -0700)
X-Original-Trace: 24 Jul 2007 10:48:44 -0700, smtp.innquest.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6153
Article PK: 2594

Hello,

I never had this database in Version 6 - let alone any version in 9. The
database was created last year with version 9.

-Robert

"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:hk1ca3d224e6aie6i42ogcr8ulo1qb4dqv@4ax.com...
> What version are you running? What version was used to create the
> database?
>
> My guess is, you're running V9 but the database was created with V6;
> here's what Foxhound says about that table in that situation:
>
> -- dbo.spt_jdatatype_info (table_id 179) in db_6_0_4_3594.db - Jul 24
> 2007 10:02:11AM - Print - Foxhound © 2007 RisingRoad
>
> -- Note: The table dbo.spt_jdatatype_info has more than one index on
> -- columns ( TYPE_NAME ):
> -- Unique constraint "spt_jdatatype_info UNIQUE
> (TYPE_NAME)"
> -- Unique index "jdatatype_ind"
>
> CREATE TABLE dbo.spt_jdatatype_info ( -- 25 rows
> ss_dtype TINYINT NOT NULL,
> TYPE_NAME /* U */ VARCHAR ( 30 ) NOT NULL,
> DATA_TYPE SMALLINT NOT NULL,
> typelength INTEGER NOT NULL,
> LITERAL_PREFIX VARCHAR ( 32 ) NULL,
> LITERAL_SUFFIX VARCHAR ( 32 ) NULL,
> CREATE_PARAMS VARCHAR ( 32 ) NULL,
> NULLABLE SMALLINT NOT NULL,
> CASE_SENSITIVE SMALLINT NOT NULL,
> SEARCHABLE SMALLINT NOT NULL,
> UNSIGNED_ATTRIBUTE SMALLINT NULL,
> FIXED_PREC_SCALE SMALLINT NOT NULL,
> AUTO_INCREMENT SMALLINT NULL,
> LOCAL_TYPE_NAME VARCHAR ( 128 ) NOT NULL,
> MINIMUM_SCALE SMALLINT NULL,
> MAXIMUM_SCALE SMALLINT NULL,
> SQL_DATA_TYPE SMALLINT NULL,
> SQL_DATETIME_SUB SMALLINT NULL,
> NUM_PREC_RADIX SMALLINT NULL,
> is_unique BIT NOT NULL,
> CONSTRAINT UNIQUE (
> TYPE_NAME ) );
>
> -- Parents of dbo.spt_jdatatype_info
>
> -- none --
>
> -- Children
>
> -- none --
>
> CREATE UNIQUE INDEX jdatatype_ind ON dbo.spt_jdatatype_info (
> TYPE_NAME ASC );
>
>
>
>
>
>
> On 24 Jul 2007 06:07:57 -0700, "Robert Paresi"
> <FirstInitialLastName@innquest.com> wrote:
>
>>I get:
>>
>>Performance warning: Redundant index "jdatatype_ind" for table
>>"spt_jdatatype_info"
>>
>>When starting up a DB.
>>
>>Can I drop this index without harm? Since it is a system table (the table
>>containing the column types) - I figured I'd ask first.
>>
>>-Robert
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book:
> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> breck.carter@risingroad.com


Breck Carter [Team iAnywhere] Posted on 2007-07-24 19:40:08.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Performance Warning ...
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <g3lca3dkes47i473llum92quq61asnngm2@4ax.com>
References: <46a5f9ad$1@forums-1-dub> <hk1ca3d224e6aie6i42ogcr8ulo1qb4dqv@4ax.com> <46a63b7c$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 199.90.35.10
X-Original-NNTP-Posting-Host: 199.90.35.10
Date: 24 Jul 2007 12:40:08 -0700
X-Trace: forums-1-dub 1185306008 199.90.35.10 (24 Jul 2007 12:40:08 -0700)
X-Original-Trace: 24 Jul 2007 12:40:08 -0700, 199.90.35.10
Lines: 106
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6154
Article PK: 2600

What does this query show?

SELECT * FROM SYSHISTORY WHERE operation = 'INIT'

The existence of that index is troubling, not because the index
matters (it doesn't) but because it *might* be a portent :)

Breck

On 24 Jul 2007 10:48:44 -0700, "Robert Paresi"

<FirstInitialLastName@innquest.com> wrote:

>Hello,
>
>I never had this database in Version 6 - let alone any version in 9. The
>database was created last year with version 9.
>
>-Robert
>
>
>"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in
>message news:hk1ca3d224e6aie6i42ogcr8ulo1qb4dqv@4ax.com...
>> What version are you running? What version was used to create the
>> database?
>>
>> My guess is, you're running V9 but the database was created with V6;
>> here's what Foxhound says about that table in that situation:
>>
>> -- dbo.spt_jdatatype_info (table_id 179) in db_6_0_4_3594.db - Jul 24
>> 2007 10:02:11AM - Print - Foxhound © 2007 RisingRoad
>>
>> -- Note: The table dbo.spt_jdatatype_info has more than one index on
>> -- columns ( TYPE_NAME ):
>> -- Unique constraint "spt_jdatatype_info UNIQUE
>> (TYPE_NAME)"
>> -- Unique index "jdatatype_ind"
>>
>> CREATE TABLE dbo.spt_jdatatype_info ( -- 25 rows
>> ss_dtype TINYINT NOT NULL,
>> TYPE_NAME /* U */ VARCHAR ( 30 ) NOT NULL,
>> DATA_TYPE SMALLINT NOT NULL,
>> typelength INTEGER NOT NULL,
>> LITERAL_PREFIX VARCHAR ( 32 ) NULL,
>> LITERAL_SUFFIX VARCHAR ( 32 ) NULL,
>> CREATE_PARAMS VARCHAR ( 32 ) NULL,
>> NULLABLE SMALLINT NOT NULL,
>> CASE_SENSITIVE SMALLINT NOT NULL,
>> SEARCHABLE SMALLINT NOT NULL,
>> UNSIGNED_ATTRIBUTE SMALLINT NULL,
>> FIXED_PREC_SCALE SMALLINT NOT NULL,
>> AUTO_INCREMENT SMALLINT NULL,
>> LOCAL_TYPE_NAME VARCHAR ( 128 ) NOT NULL,
>> MINIMUM_SCALE SMALLINT NULL,
>> MAXIMUM_SCALE SMALLINT NULL,
>> SQL_DATA_TYPE SMALLINT NULL,
>> SQL_DATETIME_SUB SMALLINT NULL,
>> NUM_PREC_RADIX SMALLINT NULL,
>> is_unique BIT NOT NULL,
>> CONSTRAINT UNIQUE (
>> TYPE_NAME ) );
>>
>> -- Parents of dbo.spt_jdatatype_info
>>
>> -- none --
>>
>> -- Children
>>
>> -- none --
>>
>> CREATE UNIQUE INDEX jdatatype_ind ON dbo.spt_jdatatype_info (
>> TYPE_NAME ASC );
>>
>>
>>
>>
>>
>>
>> On 24 Jul 2007 06:07:57 -0700, "Robert Paresi"
>> <FirstInitialLastName@innquest.com> wrote:
>>
>>>I get:
>>>
>>>Performance warning: Redundant index "jdatatype_ind" for table
>>>"spt_jdatatype_info"
>>>
>>>When starting up a DB.
>>>
>>>Can I drop this index without harm? Since it is a system table (the table
>>>containing the column types) - I figured I'd ask first.
>>>
>>>-Robert
>>
>> --
>> Breck Carter [Team iAnywhere]
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> www.risingroad.com
>> The book:
>> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
>> breck.carter@risingroad.com

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Robert Paresi Posted on 2007-07-26 16:49:45.0Z
Reply-To: "Robert Paresi" <FirstInitialLastName@innquest.com>
From: "Robert Paresi" <FirstInitialLastName@innquest.com>
Newsgroups: ianywhere.public.general
References: <46a5f9ad$1@forums-1-dub> <hk1ca3d224e6aie6i42ogcr8ulo1qb4dqv@4ax.com> <46a63b7c$1@forums-1-dub> <g3lca3dkes47i473llum92quq61asnngm2@4ax.com>
In-Reply-To: <g3lca3dkes47i473llum92quq61asnngm2@4ax.com>
Subject: Re: Performance Warning ...
Lines: 123
Organization: InnQuest Software
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16480
NNTP-Posting-Host: smtp.innquest.com
X-Original-NNTP-Posting-Host: smtp.innquest.com
Message-ID: <46a8d0a9$1@forums-1-dub>
Date: 26 Jul 2007 09:49:45 -0700
X-Trace: forums-1-dub 1185468585 24.173.150.22 (26 Jul 2007 09:49:45 -0700)
X-Original-Trace: 26 Jul 2007 09:49:45 -0700, smtp.innquest.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6157
Article PK: 4632

Hi,

Operation = INIT
Version = 9.0.2.3182
Platform: wxp #2600 SP 2 x86
Firsttime: 2005-11-12
Lasttime: 2005-11-12
DT=REMOTE;

-Robert

"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:g3lca3dkes47i473llum92quq61asnngm2@4ax.com...
> What does this query show?
>
> SELECT * FROM SYSHISTORY WHERE operation = 'INIT'
>
> The existence of that index is troubling, not because the index
> matters (it doesn't) but because it *might* be a portent :)
>
> Breck
>
> On 24 Jul 2007 10:48:44 -0700, "Robert Paresi"
> <FirstInitialLastName@innquest.com> wrote:
>
>>Hello,
>>
>>I never had this database in Version 6 - let alone any version in 9. The
>>database was created last year with version 9.
>>
>>-Robert
>>
>>
>>"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in
>>message news:hk1ca3d224e6aie6i42ogcr8ulo1qb4dqv@4ax.com...
>>> What version are you running? What version was used to create the
>>> database?
>>>
>>> My guess is, you're running V9 but the database was created with V6;
>>> here's what Foxhound says about that table in that situation:
>>>
>>> -- dbo.spt_jdatatype_info (table_id 179) in db_6_0_4_3594.db - Jul 24
>>> 2007 10:02:11AM - Print - Foxhound © 2007 RisingRoad
>>>
>>> -- Note: The table dbo.spt_jdatatype_info has more than one index on
>>> -- columns ( TYPE_NAME ):
>>> -- Unique constraint "spt_jdatatype_info UNIQUE
>>> (TYPE_NAME)"
>>> -- Unique index "jdatatype_ind"
>>>
>>> CREATE TABLE dbo.spt_jdatatype_info ( -- 25 rows
>>> ss_dtype TINYINT NOT NULL,
>>> TYPE_NAME /* U */ VARCHAR ( 30 ) NOT NULL,
>>> DATA_TYPE SMALLINT NOT NULL,
>>> typelength INTEGER NOT NULL,
>>> LITERAL_PREFIX VARCHAR ( 32 ) NULL,
>>> LITERAL_SUFFIX VARCHAR ( 32 ) NULL,
>>> CREATE_PARAMS VARCHAR ( 32 ) NULL,
>>> NULLABLE SMALLINT NOT NULL,
>>> CASE_SENSITIVE SMALLINT NOT NULL,
>>> SEARCHABLE SMALLINT NOT NULL,
>>> UNSIGNED_ATTRIBUTE SMALLINT NULL,
>>> FIXED_PREC_SCALE SMALLINT NOT NULL,
>>> AUTO_INCREMENT SMALLINT NULL,
>>> LOCAL_TYPE_NAME VARCHAR ( 128 ) NOT NULL,
>>> MINIMUM_SCALE SMALLINT NULL,
>>> MAXIMUM_SCALE SMALLINT NULL,
>>> SQL_DATA_TYPE SMALLINT NULL,
>>> SQL_DATETIME_SUB SMALLINT NULL,
>>> NUM_PREC_RADIX SMALLINT NULL,
>>> is_unique BIT NOT NULL,
>>> CONSTRAINT UNIQUE (
>>> TYPE_NAME ) );
>>>
>>> -- Parents of dbo.spt_jdatatype_info
>>>
>>> -- none --
>>>
>>> -- Children
>>>
>>> -- none --
>>>
>>> CREATE UNIQUE INDEX jdatatype_ind ON dbo.spt_jdatatype_info (
>>> TYPE_NAME ASC );
>>>
>>>
>>>
>>>
>>>
>>>
>>> On 24 Jul 2007 06:07:57 -0700, "Robert Paresi"
>>> <FirstInitialLastName@innquest.com> wrote:
>>>
>>>>I get:
>>>>
>>>>Performance warning: Redundant index "jdatatype_ind" for table
>>>>"spt_jdatatype_info"
>>>>
>>>>When starting up a DB.
>>>>
>>>>Can I drop this index without harm? Since it is a system table (the
>>>>table
>>>>containing the column types) - I figured I'd ask first.
>>>>
>>>>-Robert
>>>
>>> --
>>> Breck Carter [Team iAnywhere]
>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>> www.risingroad.com
>>> The book:
>>> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
>>> breck.carter@risingroad.com
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book:
> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> breck.carter@risingroad.com


Breck Carter [Team iAnywhere] Posted on 2007-07-26 18:49:37.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Performance Warning ...
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <epqha3ppek10m3vghucpp7h1p3jgvmvanh@4ax.com>
References: <46a5f9ad$1@forums-1-dub> <hk1ca3d224e6aie6i42ogcr8ulo1qb4dqv@4ax.com> <46a63b7c$1@forums-1-dub> <g3lca3dkes47i473llum92quq61asnngm2@4ax.com> <46a8d0a9$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 199.90.35.10
X-Original-NNTP-Posting-Host: 199.90.35.10
Date: 26 Jul 2007 11:49:37 -0700
X-Trace: forums-1-dub 1185475777 199.90.35.10 (26 Jul 2007 11:49:37 -0700)
X-Original-Trace: 26 Jul 2007 11:49:37 -0700, 199.90.35.10
Lines: 158
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6158
Article PK: 2602

Very interesting... everything looks normal there, and no, I haven't
doubted what you have said earlier, I'm just looking for other clues
about this abnormality.

FWIW I can find exactly *one* report of this index "appearing
suddenly", in a V8 database back in 2003:
http://groups.google.com/group/sybase.public.sqlanywhere.general/browse_frm/thread/51523ca6aefd6e89/3ce6d1674be8ab92?lnk=st&q=jdatatype_ind&rnum=1&hl=en#3ce6d1674be8ab92

A CREATE for the index you stumbled upon appears in a file called
jcatalog.sql that shipped with V6, and that file *can* be run against
a V9 database, causing the duplicate message to appear. I'm not saying
you did that, I'm just sharing my detective work :)

It is also conceivable that an unload from a database created with V6
might create that index if it's run against a later database. These
these objects aren't real "system" objects; if they were, a script
like jcatalog would be impossible to run, and it would be impossible
to drop the index.

Anyway, I'm going to hope that there is nothing else strange going on,
and chalk it up to voodoo :)

Breck Santaria



On 26 Jul 2007 09:49:45 -0700, "Robert Paresi"

<FirstInitialLastName@innquest.com> wrote:

>Hi,
>
>Operation = INIT
>Version = 9.0.2.3182
>Platform: wxp #2600 SP 2 x86
>Firsttime: 2005-11-12
>Lasttime: 2005-11-12
>DT=REMOTE;
>
>-Robert
>
>
>"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in
>message news:g3lca3dkes47i473llum92quq61asnngm2@4ax.com...
>> What does this query show?
>>
>> SELECT * FROM SYSHISTORY WHERE operation = 'INIT'
>>
>> The existence of that index is troubling, not because the index
>> matters (it doesn't) but because it *might* be a portent :)
>>
>> Breck
>>
>> On 24 Jul 2007 10:48:44 -0700, "Robert Paresi"
>> <FirstInitialLastName@innquest.com> wrote:
>>
>>>Hello,
>>>
>>>I never had this database in Version 6 - let alone any version in 9. The
>>>database was created last year with version 9.
>>>
>>>-Robert
>>>
>>>
>>>"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in
>>>message news:hk1ca3d224e6aie6i42ogcr8ulo1qb4dqv@4ax.com...
>>>> What version are you running? What version was used to create the
>>>> database?
>>>>
>>>> My guess is, you're running V9 but the database was created with V6;
>>>> here's what Foxhound says about that table in that situation:
>>>>
>>>> -- dbo.spt_jdatatype_info (table_id 179) in db_6_0_4_3594.db - Jul 24
>>>> 2007 10:02:11AM - Print - Foxhound © 2007 RisingRoad
>>>>
>>>> -- Note: The table dbo.spt_jdatatype_info has more than one index on
>>>> -- columns ( TYPE_NAME ):
>>>> -- Unique constraint "spt_jdatatype_info UNIQUE
>>>> (TYPE_NAME)"
>>>> -- Unique index "jdatatype_ind"
>>>>
>>>> CREATE TABLE dbo.spt_jdatatype_info ( -- 25 rows
>>>> ss_dtype TINYINT NOT NULL,
>>>> TYPE_NAME /* U */ VARCHAR ( 30 ) NOT NULL,
>>>> DATA_TYPE SMALLINT NOT NULL,
>>>> typelength INTEGER NOT NULL,
>>>> LITERAL_PREFIX VARCHAR ( 32 ) NULL,
>>>> LITERAL_SUFFIX VARCHAR ( 32 ) NULL,
>>>> CREATE_PARAMS VARCHAR ( 32 ) NULL,
>>>> NULLABLE SMALLINT NOT NULL,
>>>> CASE_SENSITIVE SMALLINT NOT NULL,
>>>> SEARCHABLE SMALLINT NOT NULL,
>>>> UNSIGNED_ATTRIBUTE SMALLINT NULL,
>>>> FIXED_PREC_SCALE SMALLINT NOT NULL,
>>>> AUTO_INCREMENT SMALLINT NULL,
>>>> LOCAL_TYPE_NAME VARCHAR ( 128 ) NOT NULL,
>>>> MINIMUM_SCALE SMALLINT NULL,
>>>> MAXIMUM_SCALE SMALLINT NULL,
>>>> SQL_DATA_TYPE SMALLINT NULL,
>>>> SQL_DATETIME_SUB SMALLINT NULL,
>>>> NUM_PREC_RADIX SMALLINT NULL,
>>>> is_unique BIT NOT NULL,
>>>> CONSTRAINT UNIQUE (
>>>> TYPE_NAME ) );
>>>>
>>>> -- Parents of dbo.spt_jdatatype_info
>>>>
>>>> -- none --
>>>>
>>>> -- Children
>>>>
>>>> -- none --
>>>>
>>>> CREATE UNIQUE INDEX jdatatype_ind ON dbo.spt_jdatatype_info (
>>>> TYPE_NAME ASC );
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On 24 Jul 2007 06:07:57 -0700, "Robert Paresi"
>>>> <FirstInitialLastName@innquest.com> wrote:
>>>>
>>>>>I get:
>>>>>
>>>>>Performance warning: Redundant index "jdatatype_ind" for table
>>>>>"spt_jdatatype_info"
>>>>>
>>>>>When starting up a DB.
>>>>>
>>>>>Can I drop this index without harm? Since it is a system table (the
>>>>>table
>>>>>containing the column types) - I figured I'd ask first.
>>>>>
>>>>>-Robert
>>>>
>>>> --
>>>> Breck Carter [Team iAnywhere]
>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>> www.risingroad.com
>>>> The book:
>>>> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
>>>> breck.carter@risingroad.com
>>
>> --
>> Breck Carter [Team iAnywhere]
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> www.risingroad.com
>> The book:
>> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
>> breck.carter@risingroad.com

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Robert Paresi Posted on 2007-07-26 21:46:59.0Z
Reply-To: "Robert Paresi" <FirstInitialLastName@innquest.com>
From: "Robert Paresi" <FirstInitialLastName@innquest.com>
Newsgroups: ianywhere.public.general
References: <46a5f9ad$1@forums-1-dub> <hk1ca3d224e6aie6i42ogcr8ulo1qb4dqv@4ax.com> <46a63b7c$1@forums-1-dub> <g3lca3dkes47i473llum92quq61asnngm2@4ax.com> <46a8d0a9$1@forums-1-dub> <epqha3ppek10m3vghucpp7h1p3jgvmvanh@4ax.com>
In-Reply-To: <epqha3ppek10m3vghucpp7h1p3jgvmvanh@4ax.com>
Subject: Re: Performance Warning ...
Lines: 174
Organization: InnQuest Software
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16480
NNTP-Posting-Host: smtp.innquest.com
X-Original-NNTP-Posting-Host: smtp.innquest.com
Message-ID: <46a91653@forums-1-dub>
Date: 26 Jul 2007 14:46:59 -0700
X-Trace: forums-1-dub 1185486419 24.173.150.22 (26 Jul 2007 14:46:59 -0700)
X-Original-Trace: 26 Jul 2007 14:46:59 -0700, smtp.innquest.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6159
Article PK: 2606

Hello,

I know that Version 6 can't come into play because Version 6 never existed
in my box or any boxes.

I can tell you that I have done a LOAD and UNLOAD on this database using
Version 9.

-Robert

"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:epqha3ppek10m3vghucpp7h1p3jgvmvanh@4ax.com...
> Very interesting... everything looks normal there, and no, I haven't
> doubted what you have said earlier, I'm just looking for other clues
> about this abnormality.
>
> FWIW I can find exactly *one* report of this index "appearing
> suddenly", in a V8 database back in 2003:
> http://groups.google.com/group/sybase.public.sqlanywhere.general/browse_frm/thread/51523ca6aefd6e89/3ce6d1674be8ab92?lnk=st&q=jdatatype_ind&rnum=1&hl=en#3ce6d1674be8ab92
>
> A CREATE for the index you stumbled upon appears in a file called
> jcatalog.sql that shipped with V6, and that file *can* be run against
> a V9 database, causing the duplicate message to appear. I'm not saying
> you did that, I'm just sharing my detective work :)
>
> It is also conceivable that an unload from a database created with V6
> might create that index if it's run against a later database. These
> these objects aren't real "system" objects; if they were, a script
> like jcatalog would be impossible to run, and it would be impossible
> to drop the index.
>
> Anyway, I'm going to hope that there is nothing else strange going on,
> and chalk it up to voodoo :)
>
> Breck Santaria
>
>
>
> On 26 Jul 2007 09:49:45 -0700, "Robert Paresi"
> <FirstInitialLastName@innquest.com> wrote:
>
>>Hi,
>>
>>Operation = INIT
>>Version = 9.0.2.3182
>>Platform: wxp #2600 SP 2 x86
>>Firsttime: 2005-11-12
>>Lasttime: 2005-11-12
>>DT=REMOTE;
>>
>>-Robert
>>
>>
>>"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in
>>message news:g3lca3dkes47i473llum92quq61asnngm2@4ax.com...
>>> What does this query show?
>>>
>>> SELECT * FROM SYSHISTORY WHERE operation = 'INIT'
>>>
>>> The existence of that index is troubling, not because the index
>>> matters (it doesn't) but because it *might* be a portent :)
>>>
>>> Breck
>>>
>>> On 24 Jul 2007 10:48:44 -0700, "Robert Paresi"
>>> <FirstInitialLastName@innquest.com> wrote:
>>>
>>>>Hello,
>>>>
>>>>I never had this database in Version 6 - let alone any version in 9.
>>>>The
>>>>database was created last year with version 9.
>>>>
>>>>-Robert
>>>>
>>>>
>>>>"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote
>>>>in
>>>>message news:hk1ca3d224e6aie6i42ogcr8ulo1qb4dqv@4ax.com...
>>>>> What version are you running? What version was used to create the
>>>>> database?
>>>>>
>>>>> My guess is, you're running V9 but the database was created with V6;
>>>>> here's what Foxhound says about that table in that situation:
>>>>>
>>>>> -- dbo.spt_jdatatype_info (table_id 179) in db_6_0_4_3594.db - Jul 24
>>>>> 2007 10:02:11AM - Print - Foxhound © 2007 RisingRoad
>>>>>
>>>>> -- Note: The table dbo.spt_jdatatype_info has more than one index on
>>>>> -- columns ( TYPE_NAME ):
>>>>> -- Unique constraint "spt_jdatatype_info UNIQUE
>>>>> (TYPE_NAME)"
>>>>> -- Unique index "jdatatype_ind"
>>>>>
>>>>> CREATE TABLE dbo.spt_jdatatype_info ( -- 25 rows
>>>>> ss_dtype TINYINT NOT NULL,
>>>>> TYPE_NAME /* U */ VARCHAR ( 30 ) NOT NULL,
>>>>> DATA_TYPE SMALLINT NOT NULL,
>>>>> typelength INTEGER NOT NULL,
>>>>> LITERAL_PREFIX VARCHAR ( 32 ) NULL,
>>>>> LITERAL_SUFFIX VARCHAR ( 32 ) NULL,
>>>>> CREATE_PARAMS VARCHAR ( 32 ) NULL,
>>>>> NULLABLE SMALLINT NOT NULL,
>>>>> CASE_SENSITIVE SMALLINT NOT NULL,
>>>>> SEARCHABLE SMALLINT NOT NULL,
>>>>> UNSIGNED_ATTRIBUTE SMALLINT NULL,
>>>>> FIXED_PREC_SCALE SMALLINT NOT NULL,
>>>>> AUTO_INCREMENT SMALLINT NULL,
>>>>> LOCAL_TYPE_NAME VARCHAR ( 128 ) NOT NULL,
>>>>> MINIMUM_SCALE SMALLINT NULL,
>>>>> MAXIMUM_SCALE SMALLINT NULL,
>>>>> SQL_DATA_TYPE SMALLINT NULL,
>>>>> SQL_DATETIME_SUB SMALLINT NULL,
>>>>> NUM_PREC_RADIX SMALLINT NULL,
>>>>> is_unique BIT NOT NULL,
>>>>> CONSTRAINT UNIQUE (
>>>>> TYPE_NAME ) );
>>>>>
>>>>> -- Parents of dbo.spt_jdatatype_info
>>>>>
>>>>> -- none --
>>>>>
>>>>> -- Children
>>>>>
>>>>> -- none --
>>>>>
>>>>> CREATE UNIQUE INDEX jdatatype_ind ON dbo.spt_jdatatype_info (
>>>>> TYPE_NAME ASC );
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On 24 Jul 2007 06:07:57 -0700, "Robert Paresi"
>>>>> <FirstInitialLastName@innquest.com> wrote:
>>>>>
>>>>>>I get:
>>>>>>
>>>>>>Performance warning: Redundant index "jdatatype_ind" for table
>>>>>>"spt_jdatatype_info"
>>>>>>
>>>>>>When starting up a DB.
>>>>>>
>>>>>>Can I drop this index without harm? Since it is a system table (the
>>>>>>table
>>>>>>containing the column types) - I figured I'd ask first.
>>>>>>
>>>>>>-Robert
>>>>>
>>>>> --
>>>>> Breck Carter [Team iAnywhere]
>>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>>> www.risingroad.com
>>>>> The book:
>>>>> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
>>>>> breck.carter@risingroad.com
>>>
>>> --
>>> Breck Carter [Team iAnywhere]
>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>> www.risingroad.com
>>> The book:
>>> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
>>> breck.carter@risingroad.com
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book:
> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> breck.carter@risingroad.com


Breck Carter [Team iAnywhere] Posted on 2007-07-24 14:07:24.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Performance Warning ...
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <vp1ca3hjthe5r2ggqrtns8ke6r1scenioi@4ax.com>
References: <46a5f9ad$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 199.90.35.10
X-Original-NNTP-Posting-Host: 199.90.35.10
Date: 24 Jul 2007 07:07:24 -0700
X-Trace: forums-1-dub 1185286044 199.90.35.10 (24 Jul 2007 07:07:24 -0700)
X-Original-Trace: 24 Jul 2007 07:07:24 -0700, 199.90.35.10
Lines: 26
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6151
Article PK: 2597

Ooops, forgot to actually answer your question: It should be OK to
drop that index. You can do a google groups search for more info:

jdatatype_ind group:*.sqlanywhere.*

On 24 Jul 2007 06:07:57 -0700, "Robert Paresi"

<FirstInitialLastName@innquest.com> wrote:

>I get:
>
>Performance warning: Redundant index "jdatatype_ind" for table
>"spt_jdatatype_info"
>
>When starting up a DB.
>
>Can I drop this index without harm? Since it is a system table (the table
>containing the column types) - I figured I'd ask first.
>
>-Robert

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Chris Keating (Sybase iAnywhere) Posted on 2007-07-24 14:24:01.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.5 (Windows/20070716)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Performance Warning ...
References: <46a5f9ad$1@forums-1-dub>
In-Reply-To: <46a5f9ad$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-d620.sybase.com
X-Original-NNTP-Posting-Host: keating-d620.sybase.com
Message-ID: <46a60b81$1@forums-1-dub>
Date: 24 Jul 2007 07:24:01 -0700
X-Trace: forums-1-dub 1185287041 10.25.99.252 (24 Jul 2007 07:24:01 -0700)
X-Original-Trace: 24 Jul 2007 07:24:01 -0700, keating-d620.sybase.com
Lines: 19
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6152
Article PK: 2599

I looked at the scripts\jcatalog.sql file and there is no index
"jdatatype_ind". What is the history of this database?

That said, a duplicate index generally have no value so dropping them
should have no impact. See
http://www.ianywhere.com/developer/technotes/sas_dup_index_msgs.html

Robert Paresi wrote:
> I get:
>
> Performance warning: Redundant index "jdatatype_ind" for table
> "spt_jdatatype_info"
>
> When starting up a DB.
>
> Can I drop this index without harm? Since it is a system table (the
> table containing the column types) - I figured I'd ask first.
>
> -Robert