Re: [U2] Universe Index not working
Brian Initially testing confirms that a R versus L is the problem. thanks. Roger Original Message - From: Brian Leach Date: Thursday, March 5, 2009 5:41 am Subject: Re: [U2] Universe Index not working To: u2-users@listserver.u2ug.org > Hi > > Over the past months we've seen a number of problems reported on > this list that seem to relate to changes in the way that > UniVerse is interpreting numeric/non-numeric fields. > > Clearly .20 is numerically the same as .2, but they shouldn't be > indexed together. > > If you do a LIST.INDEX, is it reporting the index as left or right justified? > > Brian > > Current problem. > > when selecting for another item, i get 2, one of which is the 'unselected' > record that we have been looking for. > BEEN USING > SELECT FILE WITH INVOICE EQ "509010016.2" and get zero when no > using NO.INDEX > if I switch to another invoice number > >ED FILE.INDEX 509010016.20 > 3 lines long. > 0001: 01*261318*IN.509010016.20 > 0002: 01*261318*IN.509010016.2 > 0003: 01*261318*RF.509010016.2 > Bottom at line 3. > >SELECT AR.OPEN.B4 WITH INVOICE EQ "509010016.20" > 2 record(s) selected to SELECT list #0. > the two selected, first is number 1, 16.20 and the second is the > one i want, # > 2. > --- > > Back in Version 6. I created several nifty indexes for the > order file. Which > had been designed to contain all orders, open or closed. by > marrying the > status flag to the custno, I created a unique enough key as to > not bog down. > Yeah, my first mistake was to create an index based on open or > closed, which > caused quite a performance hit. > But by creating > OPEN.ORDERS > 001 = I > 002 = IF STATUS = 'OPEN' THEN CUSTNO ELSE "" > > and create.index ORDER.DET OPEN.ORDERS NO.NULLS. I created a very useable > index.. ditto when I swapped ORDNO for CUSTNO, so that the index was keyed by > the ORDER NUMBER... > > But I haven't > > - Original Message - > From: Charles Stevenson > Date: Wednesday, March 4, 2009 4:45 pm > Subject: Re: [U2] Universe Index not working > To: u2-users@listserver.u2ug.org > > > In a prior release 10.0 or earlier, I encountered a problem that could > > corrupt an index if a write was issued without an explicit readu > > precedingit. I don't think IBM ever corrected that because > > writing without explicitly locking is Bad Form. > > If I remember, when process A holds a lock on a record and then > > process B issues a write (w/o explicitly locking),by default B sits and > > waits for 20 minutes, then gives up with a write error. (In my opinion, the > > defaultlock.wait should either be forever, or a uvconfig parameter, not 20 > > minutes.) > > > > If process B's write was to a file that had indexes, that complicated > > things - I don't recall the > > tails - and we ended up with > > inconsistencies between the data files and the index files. > > > > How to proceed: - Monotor uv/errlog to see if you have write errors. > > - Look for programs that write without locking. > > - 20 minute wait limit is configurable. I set ours to one > month > > (=2678400seconds), effectively forever, since we'd bring UV > down > > & up more frequently > > then that. To do so, execute a basic program from UV.LOGIN > > (that all uv > > processes execute on startup) that does ASSIGN 2678400 TO > > SYSTEM(1999).TCL command SET.SQL LOCK.WAIT 2678400 > > accomplishes the same. > > > > All that is from memory, by that's the gist of it. > > > > > > Completely separate, but did you know you can create an F- > > pointer to the > > index file itself and then select, ed, basic open/read/write > it > > like any > > other file? The F-pointer would look something like this: > > F > > I_FILE/INDEX.00n > > D_your_debugging_index_dictionary_with trans()s to data file, etc. > > > > Sometimes that can help you troubleshoot or even manually > > correct a critical > > index on the fly. But be careful. You can easily introduce more > > corruption. Especially if you leave the F-pointer lying around > > after you're > > done. > > > > Chuck Stevenson > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe Index not working
Current problem. when selecting for another item, i get 2, one of which is the 'unselected' record that we have been looking for. BEEN USING SELECT FILE WITH INVOICE EQ "509010016.2" and get zero when no using NO.INDEX if I switch to another invoice number >ED FILE.INDEX 509010016.20 3 lines long. 0001: 01*261318*IN.509010016.20 0002: 01*261318*IN.509010016.2 0003: 01*261318*RF.509010016.2 Bottom at line 3. >SELECT AR.OPEN.B4 WITH INVOICE EQ "509010016.20" 2 record(s) selected to SELECT list #0. the two selected, first is number 1, 16.20 and the second is the one i want, # 2. --- Back in Version 6. I created several nifty indexes for the order file. Which had been designed to contain all orders, open or closed. by marrying the status flag to the custno, I created a unique enough key as to not bog down. Yeah, my first mistake was to create an index based on open or closed, which caused quite a performance hit. But by creating OPEN.ORDERS 001 = I 002 = IF STATUS = 'OPEN' THEN CUSTNO ELSE "" and create.index ORDER.DET OPEN.ORDERS NO.NULLS. I created a very useable index.. ditto when I swapped ORDNO for CUSTNO, so that the index was keyed by the ORDER NUMBER... But I haven't - Original Message - From: Charles Stevenson Date: Wednesday, March 4, 2009 4:45 pm Subject: Re: [U2] Universe Index not working To: u2-users@listserver.u2ug.org > In a prior release 10.0 or earlier, I encountered a problem that could > corrupt an index if a write was issued without an explicit readu > precedingit. I don't think IBM ever corrected that because > writing without explicitly locking is Bad Form. > If I remember, when process A holds a lock on a record and then > process B issues a write (w/o explicitly locking),by default B sits and > waits for 20 minutes, then gives up with a write error. (In my opinion, the > defaultlock.wait should either be forever, or a uvconfig parameter, not 20 > minutes.) > > If process B's write was to a file that had indexes, that > complicated things - I don't recall the details - and we ended up with > inconsistencies between the data files and the index files. > > How to proceed: - Monotor uv/errlog to see if you have write errors. > - Look for programs that write without locking. > - 20 minute wait limit is configurable. I set ours to one month > (=2678400seconds), effectively forever, since we'd bring UV down > & up more frequently > then that. To do so, execute a basic program from UV.LOGIN > (that all uv > processes execute on startup) that does ASSIGN 2678400 TO > SYSTEM(1999).TCL command SET.SQL LOCK.WAIT 2678400 > accomplishes the same. > > All that is from memory, by that's the gist of it. > > > Completely separate, but did you know you can create an F- > pointer to the > index file itself and then select, ed, basic open/read/write it > like any > other file? The F-pointer would look something like this: > F > I_FILE/INDEX.00n > D_your_debugging_index_dictionary_with trans()s to data file, etc. > > Sometimes that can help you troubleshoot or even manually > correct a critical > index on the fly. But be careful. You can easily introduce more > corruption. Especially if you leave the F-pointer lying around > after you're > done. > > Chuck Stevenson > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: RE: RE: [U2] Universe Index still not working {Unclassified}
Straws readily accepted.
that index file is 'only' 127,590,400 bytes.
And the selects usually go SELECT FILE WITH INVOICE EQ "100016.2".
Really odd duck.
LIST FILE WITH INVOICE EQ "509010016.20" INVOICE BY INVOICE
FILEINV
01*261318*IN.509010016.20 509010016.20
01*261318*RF.509010016.2 509010016.2
The second one is the missing record that started this reindexing. No. The
record is clean. no control characters.
Tonight, the first thing I'll try is to stop and restart universe. just in
case something/somewhere is hanging fire. And I will move the file into a
much large directory, with 3 times that amount of free space/inodes compared to
the current location.
anybody else got some straws?
thanks.
Roger
- Original Message -
From: "HENDERSON MIKE, MR"
Date: Wednesday, March 4, 2009 3:47 pm
Subject: RE: RE: [U2] Universe Index still not working {Unclassified}
To: u2-users@listserver.u2ug.org
> Roger,
>
> Two possibilities occur to me:-
> * How big is that Index file - it's not getting close to 2GB by any
> chance?
>
> * Maybe it's getting confused between numbers and strings
> somehow: would
> something that works like SELECT FILE WITH " ":INVOICE EQ "
> 0499906608.1" [You could make a new I-Type called SPACE.INVOICE
> to do this and build a new Index]?
>
> Pretty much grasping at straws
>
>
> Regards
>
>
> Mike
>
>
> -Original Message-
> From: owner-u2-us...@listserver.u2ug.org
> [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of
> ro...@optonline.net
> Sent: Thursday, 5 March 2009 8:11 a.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: RE: [U2] Universe Index still not working
>
> Yes, I was retyping, rather then cut and paste.
>
> Actual ids are co*custno*type.invoicemain.invoicesub
> Key INVOICE
> 01*165001*IN.0499906608.1 0499906608.1
> dictionary = 0002: FIELD(FIELD(@ID,'*',3),'.',2,2)
> old dictionary = 0002: FIELD(@ID,'*',3)[4,999]
>
> both outputted what we needed. the old one was used for longer then
> I've been at this company. I tried changing it just in case.
>
> I really don't think it is dictionary related, since we did not change
> it until after the index stopped working.
>
> btw: for those that don't know
> SELECT FILE WITH INVOICE EQ "0499906608.1" NO.INDEX tells the
> command to
> skip the indexes and just go through the file.
> SELECT FILE WITH INVOICE EQ "0499906608.1" will go first to the index
> created for INVOICE. Hence the speed and why people use indexes but
> also the reason why we 'know' that something is broken in the index.
> If skipping the index works, doesn't that suggest something is wrong
> with the index?
>
> Thanks
> Roger
>
>
>
>
>
>
> - Original Message -
> From: kishor
> Date: Wednesday, March 4, 2009 1:56 pm
> Subject: RE: [U2] Universe Index not working
> To: u2-users@listserver.u2ug.org
>
> > Shouldn't dictionary #2
> > Be FIELD(FIELD(@ID,'*',2),'.',3,2)
> > Instead of
> > FIELD(FIELD(@ID,'*',3),'.',2.2)
> >
> > This will return
> > 1123.2
> >
> > Don't know why some selects worked.
> >
> > Regards,
> > Kishor Parmar
> >
> >
> > -Original Message-
> > From: owner-u2-us...@listserver.u2ug.org
> > [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of
> > ro...@optonline.netsent: 04 March 2009 17:37
> > To: u2-users@listserver.u2ug.org
> > Subject: [U2] Universe Index not working
> >
> > AIX 5.3 Universe 10.2.4 300+ user license
> >
> > Moved from older aix/universe 9.5 to current one in September 2008.
> > No index problems.
> >
> > File contains 1.5 million records. key = company number * customer
> > number.xx.invoicenumber.invoicesubnumber.
> > so the key looks like
> > 01*123456.IN.1123.2
> > 01*123456.IN.1123.3
> >
> > The invoice number should be unique, except for the subnumbers.
> > dictionary #2 - FIELD(FIELD(@ID,'*',3),'.',2.2)
> >
> > On Monday, SELECT FILE WITH INVOICE EQ "1000123.2" found 0
> > records. Other
> > SELECTS seemed to work. The keys are clean, no special characters.
> > SELECT FILE WITH INVOICE EQ "1000123.2" NO.INDEX finds 2 records?
> >
> > I did a build.index file on Tuesday morning. didnt work.
> > Late Tuesday evening, I deleted the index and recreated it and
> > then rebuilt
> > it. didnt work.
> > I also copied the contents of the file and the dictionaries
> from
> > one file to
> > a new one. recreated and rebuilt the index. so no luck.
> >
> > There are no error messages. nothing reported when files were
> > copied. same
> > number records before and after.
> >
> > Any thoughts?
> > Tonight I'll try a universe shutdown and restart.
> >
> > Thanks.
> > Roger Glenfield
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mai
Re: RE: [U2] Universe Index still not working
Yes, I was retyping, rather then cut and paste. Actual ids are co*custno*type.invoicemain.invoicesub Key INVOICE 01*165001*IN.0499906608.1 0499906608.1 dictionary = 0002: FIELD(FIELD(@ID,'*',3),'.',2,2) old dictionary = 0002: FIELD(@ID,'*',3)[4,999] both outputted what we needed. the old one was used for longer then I've been at this company. I tried changing it just in case. I really don't think it is dictionary related, since we did not change it until after the index stopped working. btw: for those that don't know SELECT FILE WITH INVOICE EQ "0499906608.1" NO.INDEX tells the command to skip the indexes and just go through the file. SELECT FILE WITH INVOICE EQ "0499906608.1" will go first to the index created for INVOICE. Hence the speed and why people use indexes but also the reason why we 'know' that something is broken in the index. If skipping the index works, doesn't that suggest something is wrong with the index? Thanks Roger - Original Message - From: kishor Date: Wednesday, March 4, 2009 1:56 pm Subject: RE: [U2] Universe Index not working To: u2-users@listserver.u2ug.org > Shouldn't dictionary #2 > Be FIELD(FIELD(@ID,'*',2),'.',3,2) > Instead of > FIELD(FIELD(@ID,'*',3),'.',2.2) > > This will return > 1123.2 > > Don't know why some selects worked. > > Regards, > Kishor Parmar > > > -Original Message- > From: owner-u2-us...@listserver.u2ug.org > [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of > ro...@optonline.netsent: 04 March 2009 17:37 > To: u2-users@listserver.u2ug.org > Subject: [U2] Universe Index not working > > AIX 5.3 Universe 10.2.4 300+ user license > > Moved from older aix/universe 9.5 to current one in September 2008. > No index problems. > > File contains 1.5 million records. key = company number * customer > number.xx.invoicenumber.invoicesubnumber. > so the key looks like > 01*123456.IN.1123.2 > 01*123456.IN.1123.3 > > The invoice number should be unique, except for the subnumbers. > dictionary #2 - FIELD(FIELD(@ID,'*',3),'.',2.2) > > On Monday, SELECT FILE WITH INVOICE EQ "1000123.2" found 0 > records. Other > SELECTS seemed to work. The keys are clean, no special characters. > SELECT FILE WITH INVOICE EQ "1000123.2" NO.INDEX finds 2 records? > > I did a build.index file on Tuesday morning. didnt work. > Late Tuesday evening, I deleted the index and recreated it and > then rebuilt > it. didnt work. > I also copied the contents of the file and the dictionaries from > one file to > a new one. recreated and rebuilt the index. so no luck. > > There are no error messages. nothing reported when files were > copied. same > number records before and after. > > Any thoughts? > Tonight I'll try a universe shutdown and restart. > > Thanks. > Roger Glenfield > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe Index not working
AIX 5.3 Universe 10.2.4 300+ user license Moved from older aix/universe 9.5 to current one in September 2008. No index problems. File contains 1.5 million records. key = company number * customer number.xx.invoicenumber.invoicesubnumber. so the key looks like 01*123456.IN.1123.2 01*123456.IN.1123.3 The invoice number should be unique, except for the subnumbers. dictionary #2 - FIELD(FIELD(@ID,'*',3),'.',2.2) On Monday, SELECT FILE WITH INVOICE EQ "1000123.2" found 0 records. Other SELECTS seemed to work.The keys are clean, no special characters. SELECT FILE WITH INVOICE EQ "1000123.2" NO.INDEX finds 2 records? I did a build.index file on Tuesday morning. didnt work. Late Tuesday evening, I deleted the index and recreated it and then rebuilt it. didnt work. I also copied the contents of the file and the dictionaries from one file to a new one. recreated and rebuilt the index. so no luck. There are no error messages. nothing reported when files were copied. same number records before and after. Any thoughts? Tonight I'll try a universe shutdown and restart. Thanks. Roger Glenfield --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] spooler devices
Anybody know off the top of their heads how many spooler devices are supported on AIX/Universe 10.2? I just noticed that we're at 200+ and suddenly wondered if maybe 256 might be a limit? In which case I may have to change some of practises. One physical printer, but maybe 2 or 3 devices 'records', for different forms, each with their own length, which is supported by the printer. Thanks all. Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] port.status
To all. thanks for your suggestions. there was something hincky with aix and universe. server had been setup in July. Universe added at the same time. Then in August, we imported our files.And started getting 'universe will expire in x days'. Which we hadn't been getting before. Sticky bits had been turned on. invalid expiration date could not be resolved by reconfiging universe. both invalid expiration date and port.status were both resolved by a shutdown and restart of aix. About the only thing that was done to the system between initial setup and the conversion, HP Jetdirect drivers were installed into/onto AIX by our aix/os guru. Sorry, don't know exactly what the guru did. but universe seems okay now. We'll just remember to kick the server more often. Again, thanks all. Roger - Original Message - From: Lloyd Cottrell Date: Thursday, September 4, 2008 11:42 am Subject: Re: [U2] port.status To: u2-users@listserver.u2ug.org > that was my point, easier to remember that +s is that sticky is > easier to > remember or associate with +s. Also, unless i don't understand > what an OS > is, this program (port.status) is not part of the OS but part of > the DB. I > too would not be doing this to an OS program. > > On Thu, Sep 4, 2008 at 6:58 AM, jpb-u2ug wrote: > > > My mistake, thanks Ken. It's just that when you don't do it > too often the > > names get jumbled together. Beside the fact that '+s' sounds > like it should > > be sticky. > > > > Jerry Banker > > > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis > > Sent: Wednesday, September 03, 2008 10:04 PM > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] port.status > > > > OK, I ignored it the first time, but if this is going to keep > rolling then > > I > > need to jump in with a correction before people assume it must > be correct. > > > > This is not the 'sticky' bit. The purpose of the sticky bit > on some > > (older) > > unix implementations is to keep the text segment of an > executable loaded in > > memory once it has been executed rather than unloading it at > completion.> This was designed to make commonly used programs > load faster, but is now > > pretty much irrelevant in that context and is ignored by some unix > > implementations such as Linux. The sticky bit is most often > used now on > > directories such as /tmp where it requires the actual owner of > a file to > > delete or modify that file, even though other users might have write > > permission on the directory. The sticky bit gets set with > chmod +t. > > > > If you want a program to run with the credentials of another > user (such as > > root) when it is executed, then you set the 'setuid' bit with > chmod +s and > > make sure the file is owned by the appropriate user and > executable by > > relevant people. > > > > I won't get into arguments about how good an idea it is to set > the setuid > > bit on random bits of the operating system. > > > > Cheers, > > > > Ken > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG > > Sent: Thursday, 4 September 2008 11:24 AM > > To: u2-users@listserver.u2ug.org > > Subject: Re: [U2] port.status > > > > Yes, but it should have already been set. If you want it to > work with > > everyone then set the sticky bit in the /usr/bin/ipcs. > > > > -- > > From: "Lloyd Cottrell" > > Sent: Wednesday, September 03, 2008 12:19 PM > > To: > > Subject: Re: [U2] port.status > > > > > i've found that you need to flip on the sticky bit on the > list_readu> > program > > > to fix this problem, which makes it run as root > > > > > > On Tue, Sep 2, 2008 at 2:49 PM, wrote: > > > > > >> New install of Universe 10.2.4 > > >> >PORT.STATUS > > >> There are no uniVerse sessions that match the specified > conditions.> >> > > >> But one user is logged on as root and then starting > /usr/ibm/uv/bin/uv.> >> And is running a multple program > jobstream, so something Universe > > should > > >> have been detected. > > >> > > >> And we get the same results if a user logins with a unique > login, is > > then > > >> pointed to the /bin/ksh and starting uv. > > >> > > >> Thanks. > > >> Roger > > >> --- > > >> u2-users mailing list > > >> u2-users@listserver.u2ug.org > > >> To unsubscribe please visit http://listserver.u2ug.org/ > > > --- > > > u2-users mailing list > > > u2-users@listserver.u2ug.org > > > To unsubscribe please visit http://listserver.u2ug.org/ > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://l
Re: [U2] port.status
I've tried it a number of ways. login in as root .profile includes path to /usr/ibm/uv/bin cd /usr/ibm/uv uv escape out of the universe menu >PORT.STATUS There are no uniVerse sessions that match the specified conditions. >LISTU These are the users presently sharing the system. rootpts/0 Sep 03 12:13 (rogergxp.ezp.pri) There are currently 1 users logged on the system. - Original Message - From: jpb-u2ug Date: Tuesday, September 2, 2008 7:07 pm Subject: RE: [U2] port.status To: u2-users@listserver.u2ug.org > Are you running it from the administrators account? > > Jerry Banker > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED]: Tuesday, September 02, 2008 3:49 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] port.status > > New install of Universe 10.2.4 > >PORT.STATUS > There are no uniVerse sessions that match the specified conditions. > > But one user is logged on as root and then starting > /usr/ibm/uv/bin/uv. And > is running a multple program jobstream, so something Universe > should have > been detected. > > And we get the same results if a user logins with a unique > login, is then > pointed to the /bin/ksh and starting uv. > > Thanks. > Roger > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] port.status
New install of Universe 10.2.4 >PORT.STATUS There are no uniVerse sessions that match the specified conditions. But one user is logged on as root and then starting /usr/ibm/uv/bin/uv. And is running a multple program jobstream, so something Universe should have been detected. And we get the same results if a user logins with a unique login, is then pointed to the /bin/ksh and starting uv. Thanks. Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] universe licensing
We're looking to add 100+ more users to our Universe system and management wants some competive pricing. Any reasonable suggestions? Sorry, no source, so we're stuck with Universe and can't consider qm. Thanks. Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe conversion migration
We're moving from one machine running AIX 4.3 and Universe 9.5 to a new machine running AIX 5.3 and Universe 10.2.4. Using tar. The majority of the move goes fine. Usual hassles.Recataloging, Reindexing. But two critical large files repeatedly are a problem. Both are type 30s. And appear fine on the original machine. Once moved, we can't even count them without the following message. WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 2048 bsize: 2048 fsize: 1073741312 WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 2048 bsize: 2048 fsize: 1073741312 Unable to open "GL.DETAILS" file. And uvfilefix just curls up its toes and dies. Production machine shows 1,048,576 -rw-rw-rw- root sys 1,073,741,312 (same as the fsize). The other file PAYABLES shows 1,048,576 -rw-rw-rw- root sys 1,073,741,312 ---was there some change in type 30 formating between 9.5 and 10+? that we didn't know about. I've only been with this company for 7 months, but we so far haven't had to repair any files. These are the only two files with problems and we can break them into smaller non-30 files for the move and then recombine them.But if anybody knows of a type 30 issue, then I'd appreciate any heads up. thanks Roger Glenfield --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] tape backups
Our new machine has a DLT tape carousel system. Since it should just be backing up aix data files, so long as we don't access the files during the backup, there shouldn't be any issues with that type of tape, right? thanks Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: RE: [U2] Why Develop in UniVerse?
Same thing with SAP. And SAPs magic financial systems. - Original Message - From: "Brutzman, Bill" Date: Wednesday, August 13, 2008 10:55 am Subject: RE: [U2] Why Develop in UniVerse? To: "'u2-users@listserver.u2ug.org'" > A lot of CEO's have a finance background. A lot of finance > people revere Oracle financials. They worship the functionality of the > screens and > reports. > That it takes an extra guy or two to admin the database... just > does not matter. > > Invoking one of (soft) rock music's hard lessons... "Give the > people what they want." > > --Bill > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Multiple columns from a LIST statement?
Does Unidata have a SORT.LABEL/LIST.LABEL command? Duplicates how you'd want
a label to print, but does support such multiple columns.
01 LIST.LABEL CUST NAME ADDR1 ADDR2 CSZ
COUNT, ROWS, SKIP, INDENT, SIZE, SPACE {,C} ?2,5,1,10,25,1
Row 1 header?CUSTNO
Row 2 header?NAME
Row 3 header?ADDR1
Row 4 header?ADDR2
Row 5 header?CSZ
CUSTNO 0102
NAME JONES SMITH
ADDR1 100 MAIN STREET 200 MAIN STREET
ADDR2 SUITE 100SUITE 200
CSZADAMSVILLE, NY 10001 BETELGUISE, CA 1
change the count to the number of columns you want. usually do 2-4.
Warning the command uses the formula
((SIZE+INDENT) * COUNT ) which must be smaller then your CURRENT-PAGE-COUNT.
If not, the job won't run/start.
Have fun.
- Original Message -
From: Edward Brown
Date: Wednesday, July 16, 2008 8:45 am
Subject: [U2] Multiple columns from a LIST statement?
To: u2-users@listserver.u2ug.org
> Hello,
>
> This is a unidata (7.1) reporting question, and I'm asking because
> although I can't find the answer in the documentation, I do
> think I've
> seen it once on another developer's screen.
>
> Suppose I list a file with a command like LIST ACCOUNTS. I'd get
> a list
> of the IDs down the left hand side of the page but a lot of
> wasted space
> elsewhere - and a maximum of 22 / 60ish records per screen / A4
> page. So
> what I'm wondering is if there's a way to have the report make
> use of
> multiple columns, using the horizontal space available before
> jumping to
> the next page?
>
> Thanks
>
> Edward
>
> -
>
> --
> Please remember to recycle wherever possible.
> Reduce, reuse, recycle, think do you need to print this e-mail?
> -
>
> --
> This e-mail and any attachment(s), is confidential and may be legally
> privileged. It is intended solely for the addressee. If you are
> not the
> addressee, dissemination, copying or use of this e-mail or any
> of its content
> is prohibited and may be unlawful. If you are not the intended
> recipientplease inform the sender immediately and destroy the e-
> mail, any attachment(s)
> and any copies. All liability for viruses is excluded to the
> fullest extent
> permitted by law. It is your responsibility to scan or otherwise
> check this
> email and any attachment(s). Unless otherwise stated (i) views
> expressed in
> this message are those of the individual sender (ii) no contract
> may be
> construed by this e-mail. Emails may be monitored and you are
> taken to consent
> to this monitoring.
>
> Civica Services Limited, Company No. 02374268; Civica UK
> Limited, Company No.
> 01628868
> Both companies are registered in England and Wales and each has
> its registered
> office at 2 Burston Road, Putney, London, SW15 6AR.
> -
>
> --
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] ouch
We just had something chew up two source programs today. We have restored from yesterday, but that still means 4-5 lost hours. And the programmer is one of those young guys that works directly to/from the screen rather then pencil scribling like this old timer. He still has the latest version of object. Is there a quick/free way to look at his object code and remind him of the program structure? Thanks, Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: RE: [U2] [UV] AR collection software
John Are you making the move from being factored to trying to doing your own credit and collections? So that you need to track outstanding orders and compare them to outstanding invoices and the customer's credit limit? Or do you already have invoicing, cash posting and an aging system?And just want to track dunning your customers? So that you want to keep an electronic phone log of who was called by whom and when and which invoices? Roger - Original Message - From: David Ward Date: Tuesday, July 1, 2008 8:17 am Subject: RE: [U2] [UV] AR collection software To: u2-users@listserver.u2ug.org > Columbia Ultimate http://www.columbiaultimate.com/ will likely > be your only commercial, pick-style option. Ontario Systems > http://www.ontariosystems.com/ used to have a system that ran on pick > variants, but I think they moved everything to the Cache > database (a pick/sql hybrid) > > The software mentioned above would be more for someone starting > an agency, rather than passive or sideline collections. From a quick look > at your site, I expect this is not your primary line of business. They would > probably be far more than you need at a fairly steep price. If you have > accounts in arrears, you might consider outsourcing to an existing agency. > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of John Hester > Sent: Monday, June 30, 2008 2:48 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] [UV] AR collection software > > > Anyone know of a good Pick-based AR collection management > software package? > We're looking for something that we can easily integrate into > our existing > home-grown system. We're a wholesale distributor, so this is > strictly B2B. > We're running UV 10.2.7 on RedHat ES 5.1. > > Thanks, > John > > John Hester > System & Network Administrator > Momentum Group > (949) 833-8886 x623 > http://www.themomgroup.com > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] re:form multiple spreadsheets excel file in universe
Import each excel file on a separate tab? - Original Message - From: Irina Lissok Date: Tuesday, June 3, 2008 5:32 pm Subject: [U2] re:form multiple spreadsheets excel file in universe To: u2-users@listserver.u2ug.org > Hi everyone, > > We have the program which runs and creates separate excel files for > relational data. We want to put all this data in one file but on > separate work sheets. Does anyone know how we can implement it? > > > > Irina Lissok. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] HP Laserjets and AIX/Unix
Looks like HP has discontinued the 4240, 4250, 4350 LaserJets and their various tnd models and replaced them with various models P4014, P4015 and P4515 with some new letters. While we can still find leftovers of the old models, it is only a matter of time. The only Supported operating systems Windows 2000; Windows XP Home; Windows XP Professional; Windows Server 2003; Certified for Windows Vista(R); Mac OS X v 10.2; Mac OS X v 10.3 or higher No Unix or AIX. Nor Linux for that matter. Has anybody tried one of these printers with ##IX or Linux so far? Thanks. Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: RE: [U2] base64 under Universe 10.2.4/AIX 5.3 {Unclassified}
That did the trick, thanks all.
No encodes used in APP.PROGS or UV.BP.
Just in case you need to use it.Remember that our type 1/19 records, when
transferred to the outside world, the char(254)s become char(10)s. So giving
a before and after image to somebody else can make life fun.
Roger
- Original Message -
From: "HENDERSON MIKE, MR"
Date: Tuesday, April 1, 2008 6:56 pm
Subject: RE: [U2] base64 under Universe 10.2.4/AIX 5.3 {Unclassified}
To: u2-users@listserver.u2ug.org
> Roger,
>
> It has in fact been expertly concealed in the PDF manuals,
> although of course not in the table of contents, although if you look in the
> right
> place they are in some but by no means all of the INDEXes.
> The Adobe Reader 'Search' function will, however find the "ENCODE"
> function for you.
> :-(
>
> Look in the Basic Extensions manual under the obvious chapter heading
> "Using SSL with the CallHTTP and Socket Interface" there is "Encoding
> and Cryptographic Functions" pages 3-46ff
> Or "Universe Basic Reference" (that's the one in 'BasicRef.pdf',
> not the one in 'Basic.pdf' and before you ask, no, I've no idea either)
> on page 251 of the 10.1 version.
>
> A triumph of the documenter's art this is NOT
>
>
> Probably worth a quick troll through the APP.PROGS and BP files
> in the UV Account for some examples, you may get lucky
>
> Regards
> Mike
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] base64 under Universe 10.2.4/AIX 5.3
I'm trying to convert a standard Pick data string into base64 format. I don't need to encrypt, just convert to base64 to take off the 'edges'. Googling has found references to a new universe basic command, ENCODE, but my current manuals, pdf version 10.2, dated September 2006 don't list the command. And HELP BASIC ENCODE don't do me any good. BTW Support.HELP BASIC ENCRYPT doesn't work either. Thanks for any help. Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] by.exp when
Yes, sorry make that 001 D 002 1 003, 004 blank 005 10R 006 M And it still doesn't work. - Original Message - From: "DAWES, Ray" Date: Wednesday, January 30, 2008 9:07 am Subject: RE: [U2] by.exp when To: u2-users@listserver.u2ug.org > Surely field 2 of the dictionary should have the location in the > file - > a number. > > > Ray Dawes > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Roger > GlenfieldSent: 30 January 2008 12:29 > To: u2 > Subject: [U2] by.exp when > > Universe version 9.5 > Prime Flavor > Dictionary > CHARGE.CODE > 001 D > 002, 003, 004 blank > 005 10R > 006 M > > SORT FILE BY.EXP CHARGE.CODE WHEN CHARGE.CODE EQ "01" finds zero > recordsand there are lots of records where one of the multi- > values = 01 > > I've also tried the old Pick flavor > SORT FILE BY.EXP CHARGE.CODE EQ "01" without any luck. > > Any other thoughts or does Prime flavor Retrieve just not deal with > by.exp like the Pick & Ideal versions? > > Thanks all. > Roger > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > > CONFIDENTIALITY NOTICE The information contained in this > e-mail is intended only for the confidential use of the above > named recipient. If you are not the intended recipient or person > responsible for delivering it to the intended recipient, you have > received this communication in error and must not distribute or > copy it. Please accept the sender's apologies, notify the sender > immediately by return e-mail and delete this communication. > Thank you. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] forms / imaging / doc overlay software
Since I'm working on a similar project, these responses have been great. But I have a couple of concerns. What impact does printing all those 'blank forms' have on toner yield and/or the impact on the toner 'drum'? 'Our' invoice probably has 3-4 times the amount of text compared to the actual invoice information. Legalese, plus all of the vertical and horizontal lines and the half tone columns. I'm working with a sourceless system. The current invoice prints on lines 3 and line 65. Which means we're printing outside of the usual 1/2 inch margin that many lasers require. Does that mean I'll have to print at only 96%(whatever it would take) of 'normal' size to stay within the margins? Thanks all. Rog - Original Message - From: Terry Stennette Date: Tuesday, January 22, 2008 1:22 pm Subject: Re: [U2] forms / imaging / doc overlay software To: u2-users@listserver.u2ug.org > Thank you all for the many helpful replies on this topic. I have > forwarded these to the decision makers for their review.> > Thanks again, > > Terry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] AIX & Universe version
We're migrating from an older AIX 4.x box with Universe 9.5 to a newer AIX 5.3 box. 200+ Universe users and lots of printers. Almost all of which are tcp addressed. What is the most stable version of Universe for AIX 5.3? Thanks. Rog --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] date on a pick item
If you can modify the process that creates the VOC entries, write a duplicate record to a job file, so you'll know what it tried to do and include a date/time stamp to it. Remember to clear the file on a regular basis. And then include Rex's self deletion procedure. Also look into how to tie the records to the &PH& records, so you can view any messages. Roger - Original Message - From: Rex Gozar Date: Thursday, January 3, 2008 1:45 pm Subject: Re: [U2] date on a pick item To: u2-users@listserver.u2ug.org > Doug, > > You described a system that builds VOC entries and procs; I assume the > problem is that you're ending up with a bunch of temporary procs > cluttering up your system. > > Why not (a) add the date to the "NIGHT-JOBSport" id, or (b) add > lines to the proc to make it self-deleting (it should be simple to find > the program that writes the proc, and add "DELETE VOC NIGHT-JOBSxxx" > at the end.) > > rex > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
