Re: [U2] is this an INDEX ISSUE?

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 shows up on the report, so

Re: [U2] is this an INDEX ISSUE

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 antli...@youngman.org.uk 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

Re: [U2] is this an INDEX ISSUE?

: 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 release? 4) How

Re: [U2] is this an INDEX ISSUE

Whitmore tewhitm...@ratex.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] is this an INDEX ISSUE? Message-ID: BA2E471C9317804EB8470750F458BD9801EC779E3DC4@public Content-Type: text/plain; charset=us-ascii Hi David, To your real problem and question. We are on UniVerse

Re: [U2] is this an INDEX ISSUE

it is not a valid report. -- Message: 1 Date: Sun, 14 Apr 2013 08:41:38 -0400 From: Tom Whitmore tewhitm...@ratex.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] is this an INDEX ISSUE

Re: [U2] is this an INDEX ISSUE

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

Re: [U2] is this an INDEX ISSUE

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

Re: [U2] is this an INDEX ISSUE?

...@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 open

Re: [U2] is this an INDEX ISSUE

.        -- Message: 1 Date: Sun, 14 Apr 2013 08:41:38 -0400 From: Tom Whitmore tewhitm...@ratex.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] is this an INDEX ISSUE? Message-ID: BA2E471C9317804EB8470750F458BD9801EC779E3DC4@public Content-Type: text

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 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

[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 shows up on the report, so customer doesnt get their

Re: [U2] is this an INDEX ISSUE?

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 d...@yahoo.com 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