: Re: [U2] is this an INDEX ISSUE?
Hello David
1) Is your file you're indexing corrupt or does it have any errors or warnings
as reported by 'fixtool'? If corrupt, can you repair it (after backing it up:))
?
2) What queries using the indices are slow? All or one?
3) What UV rele
Hi.
If you have a lot of nulls in CALL.FILE field, you should create this index
with NO.NULLS clause.
Regards
--
Augusto
2013/4/16 Anthonys Lists
> Not to say this has anything to do with it, but it sounds like this is a
> big file. Does CALL.STATUS just have a few valid values? And when you're
users@listserver.u2ug.org
Subject: [U2] is this an INDEX ISSUE?
hello,
We have a file that is updated almost every minute for transportation
appointment, we index a field in a file to make the reporting much faster but
recently we noticed when we ran the report not all the transportation appt
s
Not to say this has anything to do with it, but it sounds like this is a
big file. Does CALL.STATUS just have a few valid values? And when you're
running this report are you selecting a lot of values for one value of
CALL.STATUS?
It shouldn't mess up, but indexing used to be iffy if you indexe
We did not have any OS or Universe upgrade.
here is the list.index
>LIST.INDEX CALL.FILE ALL
Alternate Key Index Summary for file CALL.FILE
File... CALL.FILE
Indices 4 (2 A-type, 1 C-type, 1 D-type, 0 I-type, 0 SQL, 0 S-type)
Index Updates.. Enabled, No updates pending
Index nam
hout index the report take more than 2
> hours
> > and by the time the report output is done it is not a valid report.
> >
> >
> >
> >
> >
> >
> >
> > ------------------
> >
-
>
> Message: 1
> Date: Sun, 14 Apr 2013 08:41:38 -0400
> From: Tom Whitmore
> To: U2 Users List
> Subject: Re: [U2] is this an INDEX ISSUE?
> Message-ID:
> Content-Type: text/plain; charset="us-ascii"
>
> Hi David,
> To your real problem and question
.
--
Message: 1
Date: Sun, 14 Apr 2013 08:41:38 -0400
From: Tom Whitmore
To: U2 Users List
Subject: Re: [U2] is this an INDEX ISSUE?
Message-ID:
Content-Type: text/plain; charset="us-ascii"
Hi David,
To your real problem and question. We are on UniVe
-boun...@listserver.u2ug.org] On Behalf Of John Jenkins
Sent: Saturday, April 13, 2013 3:30 AM
To: david yu; U2 Users List
Cc: u2-users@listserver.u2ug.org
Subject: Re: [U2] is this an INDEX ISSUE?
Was the file open to a UniVerse session! Or we're you EXECUTING the RESIZE from
a process that had the file
Was the file open to a UniVerse session! Or we're you EXECUTING the RESIZE from
a process that had the file open? The latter can cause issues -close the file
first. If it's AIX and you are running multiple UniVerse shells from crown tab
as foreground tasks (I.e. not as phantoms or by using execu
May I presume this is Unidata? Make sure everyone is logged off when the
index is rebuilt.
On Fri, Apr 12, 2013 at 5:46 PM, david yu wrote:
> hello,
>
> We have a file that is updated almost every minute for transportation
> appointment, we index a field in a file to make the reporting much fa
hello,
We have a file that is updated almost every minute for transportation
appointment, we index a field in a file to make the reporting much faster but
recently we noticed when we ran the report not all the transportation appt
shows up on the report, so customer doesnt get their transportat
12 matches
Mail list logo