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 and when do you re-index the file? 5) Has the file been recently been resized/restored or otherwise changed? Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of david yu Sent: Saturday, 13 April 2013 9:47 AM To: u2-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 shows up on the report, so customer doesnt get their transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 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 indexed hundreds of records for a single value of the index. If you're stressing the index that could be the problem. Do you have a date of appointment field? Could you index on that? If you need rapid reports and you could run the report for appointment == today with that indexed, would that give you the fast reports you need? Cheers, Wol On 15/04/2013 22:41, david yu wrote: 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 name Type BuildNulls In DICT S/M Just Unique Field num/I-type CALL.STATUS DNot Reqd YesYes SL N13 __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] is this an INDEX ISSUE?
One other thing you may want to check. See if there are any multivalued or subvalues in the item ids. In unidata this has caused major headaches with indices. HTH -Dan Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go...@interlinebrands.com | Website: www.interlinebrands.com This e-mail and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. Please notify the sender immediately by e-mail if you have received this e-mail in error and delete all copies of this message. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Tuesday, April 16, 2013 3:59 AM To: david yu; U2 Users List Subject: 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 and when do you re-index the file? 5) Has the file been recently been resized/restored or otherwise changed? Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of david yu Sent: Saturday, 13 April 2013 9:47 AM To: u2-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 shows up on the report, so customer doesnt get their transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] is this an INDEX ISSUE
Could you post the LIST.INDEX results for this? If only one field is affected, there might be something specific about that. Regards Brian On 15 April 2013 at 03:20 david yu d...@yahoo.com wrote: hello Tom, I wish I could just ignore it but as I previously mentioned, our patient are not getting their transportation appt which is not good service. I asked assistance to our software vendor and supposedly they open a case with Rocket but still no reply, I am hoping someone from this forum have a solution. like you mentioned, it works in all the files that we have index except for 1 and giving me a big headache since without 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 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, using Linux and we have had problems like what was initially reported. I have not had time to play and figure out what is going on. We have moved from 10.x to 11.1.11 and I have not tried recently. Also, it seems to work fine on some files but other files have problems and we aren't doing anything special with the indexes that have problems (they are simple D or A type dictionaries) Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-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 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 executive) at the same time it could be relevant too. Regards JayJay On 13 Apr 2013, at 00:46, 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 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 transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] is this an INDEX ISSUE
Hi. Have you upgraded O.S. version and/or UV version recently? Regards -- Augusto 2013/4/15 br...@brianleach.co.uk br...@brianleach.co.uk Could you post the LIST.INDEX results for this? If only one field is affected, there might be something specific about that. Regards Brian On 15 April 2013 at 03:20 david yu d...@yahoo.com wrote: hello Tom, I wish I could just ignore it but as I previously mentioned, our patient are not getting their transportation appt which is not good service. I asked assistance to our software vendor and supposedly they open a case with Rocket but still no reply, I am hoping someone from this forum have a solution. like you mentioned, it works in all the files that we have index except for 1 and giving me a big headache since without 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 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, using Linux and we have had problems like what was initially reported. I have not had time to play and figure out what is going on. We have moved from 10.x to 11.1.11 and I have not tried recently. Also, it seems to work fine on some files but other files have problems and we aren't doing anything special with the indexes that have problems (they are simple D or A type dictionaries) Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-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 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 executive) at the same time it could be relevant too. Regards JayJay On 13 Apr 2013, at 00:46, 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 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 transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 name Type Build Nulls In DICT S/M Just Unique Field num/I-type CALL.STATUS D Not Reqd Yes Yes S L N 13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 indexed hundreds of records for a single value of the index. If you're stressing the index that could be the problem. Do you have a date of appointment field? Could you index on that? If you need rapid reports and you could run the report for appointment == today with that indexed, would that give you the fast reports you need? Cheers, Wol On 15/04/2013 22:41, david yu wrote: 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 name Type BuildNulls In DICT S/M Just Unique Field num/I-type CALL.STATUS DNot Reqd YesYes SL N13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] is this an INDEX ISSUE?
Hi David, To your real problem and question. We are on UniVerse, using Linux and we have had problems like what was initially reported. I have not had time to play and figure out what is going on. We have moved from 10.x to 11.1.11 and I have not tried recently. Also, it seems to work fine on some files but other files have problems and we aren't doing anything special with the indexes that have problems (they are simple D or A type dictionaries) Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-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 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 executive) at the same time it could be relevant too. Regards JayJay On 13 Apr 2013, at 00:46, 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 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 transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] is this an INDEX ISSUE
hello Tom, I wish I could just ignore it but as I previously mentioned, our patient are not getting their transportation appt which is not good service. I asked assistance to our software vendor and supposedly they open a case with Rocket but still no reply, I am hoping someone from this forum have a solution. like you mentioned, it works in all the files that we have index except for 1 and giving me a big headache since without 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 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, using Linux and we have had problems like what was initially reported. I have not had time to play and figure out what is going on. We have moved from 10.x to 11.1.11 and I have not tried recently. Also, it seems to work fine on some files but other files have problems and we aren't doing anything special with the indexes that have problems (they are simple D or A type dictionaries) Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-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 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 executive) at the same time it could be relevant too. Regards JayJay On 13 Apr 2013, at 00:46, 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 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 transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 executive) at the same time it could be relevant too. Regards JayJay On 13 Apr 2013, at 00:46, 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 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 transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[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 transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
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 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 transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users