RE: VOC corruption
Check if any of the following apply to your site (I think we had this problem, on a old release of UV): a) the VOC was 'accidentally' resized to a dynamic file (which isn't recommended) b) the VOC was very badly sized (the VOC contained a LOT of unused and unused/redundant records) Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Logan, David (SST - Adelaide) Sent: Wednesday, April 28, 2004 12:05 PM To: U2 List Subject: VOC corruption Hi Folks, Twice in the past month I have had a major server, with a business critical system, come to a halt with corruption of the VOC file. The first incident was tracked back to the possibility of errors on the SAN. Hardware was replaced and the file has been resized (I assume by this it has also been moved to a different area on the disk or disks) The following incident has no hardware indications in any log thus making it a little hard to trace where the issue occurred. The customer is, understandably, concerned this may happen again as unfortunately both incidents have had a major impact on their business. I am curious to find if any other sites have had a similar issue. Both incidents were backward link errors in the same items. As noted above, the file was resized between incidents and I assume is now in a different area on the SAN. I have found nothing to date in any log on the system. Any suggestions are welcome. Compaq Tru64 UNIX V5.1A (Rev. 1885); Thu Feb 20 14:06:32 EST 2003 UniVerse 10.0.8 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: XML and U2
Havving played with XML (and not very deeply) I got the impression that one can join FILEs to give you effective sub-sub-sub style nesting . However, seeing as my testing was limited to exporting a nearly-flat file into MS's Infopath, I didnt' try digging very deeply. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn M. Wolthuis Sent: 27 April 2004 23:08 To: 'Ronald Bourret' Cc: [EMAIL PROTECTED] Subject: RE: XML and U2 You are correct that the built-in XML -- U2 utilities go to sub-values and I think it makes sense to ignore the text values information at this point. Thanks. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: Ronald Bourret [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 4:01 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML and U2 Thanks. That clarifies things and I'll modify the entry for UniVerse to account for this. You do raise a new question when you say: The database comes pre-loaded with functions on multi-values and multi-valued sub-values and users write similar functions to lower levels if needed. Does this mean that you can have sub-sub-values, sub-sub-sub-values, and so on, ad infinitum? If so, do the XML tools handle this, adding more sub-elements as needed? The XML = DB mapping languages for UniData and UniVerse don't seem to handle this, except that the documentation for UniData seems to allow one level beneath sub-values, saying something about adding another sub-element in the case of text marks. (I dutifully ignored this, having spent too much time on the entries already :) -- Ron Dawn M. Wolthuis wrote: Hi Rob -- It is the rare table, indeed, that is created with a sql CREATE TABLE statement in a U2 database. U2 has SQL as a second language. It is not really an RDBMS, but uses a data model very similar to the one used by XML (a tree or di-graph structure). With the CREATE-FILE command a file gets created and then when a dictionary is populated, it is descriptive of the data (so not quite the same as an RDBMS that way) and can include sub-fields. The database comes pre-loaded with functions on multi-values and multi-valued sub-values and users write similar functions to lower levels if needed. Let me know if that doesn't quite answer the question. Thanks. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, April 27, 2004 11:30 AM To: U2-Users Subject: Fw: XML and U2 I finally got an answer back from Ron Bourret and he has added the U2 products to his XML enabled list of databases. Anybody want to answer his question? I could do it but I'm kind of busy right now. Jerry - Original Message - From: Ronald Bourret [EMAIL PROTECTED] To: Jerry Banker [EMAIL PROTECTED] Sent: Monday, April 26, 2004 6:32 PM Subject: Re: XML and U2 This is to let you know that I've finally added UniVerse and UniData to the list. You can see the entries at: http://www.rpbourret.com/xml/ProdsXMLEnabled.htm#unidata http://www.rpbourret.com/xml/ProdsXMLEnabled.htm#universe Comments / corrections welcome. (One question I had was whether UniVerse supports multi-subvalued columns as well as multi-valued columns. There are a number of references to subvalues in the documents, but the UniVerse CREATE TABLE command does not seem to support them...) Thanks for you patience, -- Ron Jerry Banker wrote: Ronald Bourret, Looking over your list of XML enabled databases I was impressed however I noticed that you included IBM's DB2 product but excluded IBM's most XML like databases referred to as their U2 product line (uniVerse and Unidata). Both U2 products are post-relational and use a nested file architecture very much similar to XML design and do have XML transformation tools (uniVerse more so than Unidata at the latest revision). XML documents can be output through their query language and imported into the database through simple commands. Another advantage is that the database can be accessed through it's native query language or with SQL. You should look into these products if you have not already. http://www-3.ibm.com/software/data/u2/ Jerry Banker Member U2UG -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy
RE: How far can U2 scale?
In reply to what Steve wrote re: app level problems with scability: In a way you're right, in that an app written for small scale systems cannot easily be scaled upward to infinity without having serious bottleneck issues. No matter what tool (read language/RAD/whatever) is used, if the design has built in toe-jammers, it simply aint gonna work. However, if the designers knew upfront what scale to aim at, it's easy. Keys are prefixed with some kind of sub-structure label to break-down the scale to managable levels, eg branch, warehouse, or if requiring specifically numeric, ranges of number are set for each sub-structure, eg 100,000 - 200,000 for New Jersey, with scalability built in with the same number range for each million increase, eg 1,100,000 - 1,200,000, 2,100,000 - 2,200,000, etc (many ways to skin said cat) The thing about bad design is that its faults exponentially increase by number of users. Bigger hardware doesn't help. Developers with tunnel vision don't help. Most of all, patch jobs don't help. Then again, if weren't for all these, we wouldn't have jobs. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
SV: .net provider from Raining Data
Tony, the problem is that there is very little activty in that forum and there has been no answer from Raining Data support either. /Björn Eklund -Ursprungligt meddelande- Från: Tony Gravagno [mailto:[EMAIL PROTECTED] Skickat: den 28 april 2004 00:02 Till: 'U2 Users Discussion List' Ämne: RE: .net provider from Raining Data Björn, I recommend bringing your PDP.NET questions on proper usage to the Raining Data Web Forum, and bugs to Raining Data Support. They should answer questions like this quickly. I'm concerned that your students have found problems and then worked around them rather than reporting them. Problems should be reported to the vendor or they will never be fixed and people will forever be talking about that damned bug that never got fixed. This goes for all products including the DBMS software we use. Students should learn that this is the way things are supposed to work rather than trying to prove how smart they are by coming up with workarounds. In the long run a workaround costs money and is more difficult to maintain in the future. When problems aren't fixed they cost ALL users of the product time and money, and prompts discussions of migration, which drives up costs for everyone and drives our market into the ground even further. Take advantage of your support contract, get bugs fixed, we all benefit. http://forums.rainingdata.com/ Good Luck, Tony Nebula RD we have students working for us on a project evaluating Raining Data's .net provider. They have had a lot of problems and some of them we have found workarounds for. Now they try to update a file but it doesen't seem to work. Anyone with knowledge of this product who could help us with this issue? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: FATAL : Cannot create transaction cache file
Is this UniVerse or UniData? My guess is either that you've hit some limit (disk full?, max number of transaction cache files?), or that there's a permissions issue in the directory where the transaction cache file needs to be created. - Original Message - From: Ang Suan Yong [EMAIL PROTECTED] Date: Wed, 28 Apr 2004 10:33:56 +0800 To: U2-users [EMAIL PROTECTED] Subject: FATAL : Cannot create transaction cache file Dear All, Do any one having facing the below problem before where the program run half way it prompt Cannot create transaction cache file . When such a problem occur, what we do is just rerun the program and is working well. Is it possible that this is due to hitting the maximun record lock ? Program UPD.SUB: Line 45, FATAL: Cannot create transactio n cache file. Rolling back uncommitted transactions begun within this execution environment. Thanks and Regards DISCLAIMER:- This email is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message. Thank you. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: VOC corruption
Are you using UniVerse error message logging (enabled by creating the error message file in the UV account) and, if so, does it tell you anything? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: NT files on Unidata
Eugene Perry wrote: How does one open files in the NT file system on Unidata? Carefully? ;^) Seriously though: if you simply want to look at flat text files in a windows folder then you can set up a DIR pointer in the VOC which references the path to the folder and then just OPEN that VOC pointer and READ/WRITE the text files as though they were records in the file. Or you can OPENSEQ a particular text file within that VOC pointer and READSEQ/WRITESEQ to/from the text file. Alternatively you can simply OSREAD and OSWRITE files based on raw paths, or OSOPEN a path and then OSBREAD/OSBWRITE blocks of raw data. There are probably other options too, but I can't think of them right now. Cheers, Ken -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Flushing memory
I am currently evaluating different platforms and have been lurking here for a bit. Very lively and informative! We currently use D3 on Windows. I had to integrate SYNC from Sysinternals to flush memory since Windows (or D3) does not seem do it right. We've had problems in the past where customers could loose hours worth of data if there was a system halt! So, would I have to do the same thing with Unidata or did Unidata do it right and provide for safe delivery of the data to the harddrive and then if so is it configurable? Thanks, Steve -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: VOC corruption
Hi Ray, I have just switched it on now. I didn't realise you could turn it on and off like that. Thanks David The file is sized pretty well and is a type 11 Thanks Wol, I have had engineers go through all the hardware logs to no avail. There was a couple of small glitches during the last episode but the recommendations of the engineers re: replacement of hardware were heeded and the appropriate replacements were done. Problem has re-occurred since then I'll keep a close eye on the error logs from Universe to see if they can help. In the meantime, I have saved the VOC away each hour and hopefully this will allow a quick recovery if it happens again. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Wednesday, 28 April 2004 7:07 PM To: U2 Users Discussion List Subject: RE: VOC corruption Are you using UniVerse error message logging (enabled by creating the error message file in the UV account) and, if so, does it tell you anything? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: VOC corruption
Is there a particular time of day, day of the week, or system loading consistency in when this corruption of the VOC happens? Any processes writing to the VOC for any reasons? How many users in the particular ACCOUNT where this particular VOC gets corrupted? How do the users access the ACCOUNT where this happens? Are these users physical dispersed throughout a region, country, or the world? Could you please re-post platform particulars? System details - OS, # Processors, Disk configuration, memory configuration, any SAN, any multiple network connections, OS Version and patch levels, U2 product version numbers, etc? Any routine BATCH jobs or PHANTOM processes scheduled to run regularly in this ACCOUNT? What type of application, and explain the typical processing schedule that occurs within this ACCOUNT where VOC gets corrupted. Any significant changes in anything for a month prior to when this problem surfaced, (and I do mean anything). Daylight Savings time kicked in during first weekend of April. When did this problem start? Just trying to brain-storm ideas that may come into play here. Regards, Scott Richardson Senior Systems Engineer / Consultant Marlborough, MA 01752 Email: [EMAIL PROTECTED] Web: http://home.comcast.net/~CheetahFTL/CC/CheetahFTL_1.htm eFax: 208-445-1259 - Original Message - From: Logan, David (SST - Adelaide) [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 8:09 AM Subject: RE: VOC corruption Hi Ray, I have just switched it on now. I didn't realise you could turn it on and off like that. Thanks David The file is sized pretty well and is a type 11 Thanks Wol, I have had engineers go through all the hardware logs to no avail. There was a couple of small glitches during the last episode but the recommendations of the engineers re: replacement of hardware were heeded and the appropriate replacements were done. Problem has re-occurred since then I'll keep a close eye on the error logs from Universe to see if they can help. In the meantime, I have saved the VOC away each hour and hopefully this will allow a quick recovery if it happens again. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Wednesday, 28 April 2004 7:07 PM To: U2 Users Discussion List Subject: RE: VOC corruption Are you using UniVerse error message logging (enabled by creating the error message file in the UV account) and, if so, does it tell you anything? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Timestamp
Hi Ken, At 07:56 PM 28/04/2004, Ken Wallis wrote: Of course one could easily write a FUNCTION that concatenated DATE() and TIME() and used named common to keep track of the last value it gave out to decide if it needed to add an alpha character and if so, which one, but that What about SYSTEM(12) instead of TIME() ? would only be unique inside the user's session, not system wide. If you wanted something that was unique system wide, you might need to go slightly further than one alpha character and you'd need to involve writing something away to a file (or at least locking something) to get coordination between sessions, and there'd be an overhead associated with that of course. Would be much better to have a record in a control file that is regularly incremented. ie in pseudo code: READU COUNTER FROM CONTROL, COUNTERNAME; COUNTER +=1; WRITE COUNTER TO CONTROL,COUNTERNAME ...use COUNTER as you unique id It would also be quite trivial to knock up a CALLC function that obtained the value returned by the time() C runtime function which gives the number of seconds since somewhere in 1970. Computationally that would be the most efficient, but again, it wouldn't be unique system wide. You should have Use CALLC to solve your problem in your sig to save typing it every day. ;-) - Robert -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Timestamp
Bill H. wrote on 04/28/2004 12:27:30 AM: SYSTEM(19) on D3: Returns a unique item-id consisting of the current system date in internal format, followed immediately by the current system time in seconds. If more than one item-id is generated in a second, an alpha character is appended to the item-id. The best way to simulate this - on UniData, UniVerse, or indeed on D3 - is to roll your own solution that doesn't involve contention. When I was working on a Sequoia Pick system we used SYSTEM(19) rather extensively. It was an easy way for multiple processes to generate unique keys to a file. We thought it was a great way to avoid the bottleneck created by a next key record in a control file. We knew that having multiple processes banging against a single locked record was a bottleneck and we pounced upon this wonderful thing called SYSTEM(19). What a wonderful way to avoid bottlenecks. I was young - well younger - then, and didn't understand the way UNIX worked. There was just this magical facility available, so it was used with abandon. It seemed to be the answer to our problems. Then we saw that the system started crawling and, after much work, came to the conclusion that the processes using SYSTEM(19) were the cause. That's when I started learning UNIX terms like semaphore. In other words, when you're guaranteeing uniqueness system-wide, you're going to have to bind on something. That was lesson #1. Lesson 2 reared its ugly head when we were suddenly missing records during a batch update process. After tearing the application apart, and scrutinizing everything including the IDs of the records in a transaction file, we finally discovered that we were over-writing records. As Bill H. mentioned, the date and time was suffixed with a single character. If I recall correctly, they started with the letter A, then incrimented from there. I think when they got to Z they started with numerals. They might have also included some non-alpha-numeric characters. But with 1200 users on a 16-CPU system, there were times when we used all of the available characters in a second, and it started back at the beginning. We were just blindly writing records with SYSTEM(19) as the key, so earlier records within a second were being overwritten by later records within the same second. Clearly, SYSTEM(19) wasn't the best approach. Since we didn't care about the contents of the ID - only system-wide uniqueness - we started using something like this: date*time*port*seqno where date and time represented the beginning of the current process and seqno was a number incremented within the program. This was guaranteed to be unique system-wide. To our great surprise and pleasure, performance also went through the roof, since there was no longer any chance for a bottleneck. So, as a long answer to Eugene's short question - with some old codger reminiscence mixed in - no, SYSTEM(19) isn't available on UniData. Rejoice! Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: VOC corruption
I can relay one UV customer's experience. After months of sporadic file corruption episodes, they finally had their hardware folks come out and check over the system (one of the first things our support group had suggested, of course). They had memory boards seated in improper slots. Once they correctly re-seated the memory boards - all file corruption issues ceased. Even though the hardware diagnostic programs for this platform reported no errors - it is always prudent to check hardware. Anything that interrupts a clean movement of a block of data from memory to the physical disk platters could result in database file corruption. Wally Terhune Manager - U2 Advanced Technical Services IBM DB2 Information Management Software Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV Logan, David (SST - Adelaide) [EMAIL PROTECTED] To om U2 List [EMAIL PROTECTED] Sent by: cc u2-users-bounces@ oliver.comSubject VOC corruption 04/27/2004 08:05 PM Please respond to U2 Users Discussion List Hi Folks, Twice in the past month I have had a major server, with a business critical system, come to a halt with corruption of the VOC file. The first incident was tracked back to the possibility of errors on the SAN. Hardware was replaced and the file has been resized (I assume by this it has also been moved to a different area on the disk or disks) The following incident has no hardware indications in any log thus making it a little hard to trace where the issue occurred. The customer is, understandably, concerned this may happen again as unfortunately both incidents have had a major impact on their business. I am curious to find if any other sites have had a similar issue. Both incidents were backward link errors in the same items. As noted above, the file was resized between incidents and I assume is now in a different area on the SAN. I have found nothing to date in any log on the system. Any suggestions are welcome. Compaq Tru64 UNIX V5.1A (Rev. 1885); Thu Feb 20 14:06:32 EST 2003 UniVerse 10.0.8 Thanks David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Input weirdo...
We have a program looping through all data files searching for something - sometimes it gets to a file containing several million records and we'd like to be able to tell it to skip that file and continue with the next file. We've tried the following approaches with said results: (1) OPT.OUT = KEYIN() ; if OPT.OUT = 1 then EXIT OPT.OUT = 0 the program sits waiting for input in every iteration, ie every record (2) INPUT OPT.OUT,-1 ; if OPT.OUT = 'S' then EXIT OPT.OUT = 0 CLEARDATA CLEARINPUT the program works perfectly until an 'S' is entered then skips every file after that... HOWEVER, if I press Ctrl-Break, enter DEBUG, enter C(ontinue), the program continues as normal until another 'S' is entered.. Obviously the machine still has something in the input buffer, despite the CLEARDATA, something that gets whacked when debug hits the scene... Any ideas? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Input weirdo...
USE INPUTCLEAR not CLEARINPUT Regards Björn Behr Programmer HYFLO Southern Africa (Pty) Ltd Tel : +27 11 386 5800 Fax : +27 11 444 5391 Mail: [EMAIL PROTECTED] WWW : http://www.hyflo.co.za In the beginning, the universe was created. This made a lot of people very angry, and has been widely regarded as a bad idea. - Douglas Noel Adams (b. 1952), British author -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 28 April 2004 04:55 To: 'U2 Users Discussion List' Subject: Input weirdo... We have a program looping through all data files searching for something - sometimes it gets to a file containing several million records and we'd like to be able to tell it to skip that file and continue with the next file. We've tried the following approaches with said results: (1) OPT.OUT = KEYIN() ; if OPT.OUT = 1 then EXIT OPT.OUT = 0 the program sits waiting for input in every iteration, ie every record (2) INPUT OPT.OUT,-1 ; if OPT.OUT = 'S' then EXIT OPT.OUT = 0 CLEARDATA CLEARINPUT the program works perfectly until an 'S' is entered then skips every file after that... HOWEVER, if I press Ctrl-Break, enter DEBUG, enter C(ontinue), the program continues as normal until another 'S' is entered.. Obviously the machine still has something in the input buffer, despite the CLEARDATA, something that gets whacked when debug hits the scene... Any ideas? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Input weirdo...
Also, in place of the INPUT OPT.OUT,1 read to drain, you could use INPUTCLEAR to do the same thing without actually reading anything. At 10:54 AM 4/28/2004, you wrote: We have a program looping through all data files searching for something - sometimes it gets to a file containing several million records and we'd like to be able to tell it to skip that file and continue with the next file. We've tried the following approaches with said results: (1) OPT.OUT = KEYIN() ; if OPT.OUT = 1 then EXIT OPT.OUT = 0 the program sits waiting for input in every iteration, ie every record (2) INPUT OPT.OUT,-1 ; if OPT.OUT = 'S' then EXIT OPT.OUT = 0 CLEARDATA CLEARINPUT the program works perfectly until an 'S' is entered then skips every file after that... HOWEVER, if I press Ctrl-Break, enter DEBUG, enter C(ontinue), the program continues as normal until another 'S' is entered.. Obviously the machine still has something in the input buffer, despite the CLEARDATA, something that gets whacked when debug hits the scene... Any ideas? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Redback SOAP requests from .NET
We've turned back on full logging, and have found an existing SOAP request the new .NET SOAP request. Apart from some (hopefully) superficial differences, the main problem seems to be that the body of the request (ie. the SOAP envelope) doesn't appear in the log at all, followed by 'Content-Length = 0' 'No Content data found (ErrorCode=997 Overlapped I/O operation is in progress.)' messages. This is the code we've got so far:- Dim objWebRequest As Net.HttpWebRequest Dim objMyStream As System.IO.Stream Dim objWebResponse As Net.HttpWebResponse Dim objReader As System.IO.StreamReader Dim objResponseStream As System.IO.Stream Dim strData As String Dim i As Long Dim objXMLDoc As New XmlDocument() Dim soapEnvelope As String soapEnvelope = SOAP:Envelope xmlns:SOAP='urn:schemas-xmlsoap-org:soap.v1' soapEnvelope = SOAP:Body soapEnvelope = m:Create xmlns:m='TDCASH:TEST' soapEnvelope = /m:Create soapEnvelope = /SOAP:Body soapEnvelope = /SOAP:Envelope objXMLDoc.LoadXml(soapEnvelope) strData = objXMLDoc.OuterXml objWebRequest = Net.WebRequest.Create(http://it2:8353;) objWebRequest.ContentType = text/xml objWebRequest.Method = M-POST objWebRequest.ContentLength = strData.Length objWebRequest.UserAgent = RBO objWebRequest.KeepAlive = True objWebRequest.Headers.Add(SOAPMethodName, TDCASH:TEST#Create) Dim arrData As Byte() = System.Text.Encoding.ASCII.GetBytes(strData) objMyStream = objWebRequest.GetRequestStream() objMyStream.Write(arrData, 0, strData.Length) objMyStream.Flush() objWebResponse = objWebRequest.GetResponse() objResponseStream = objWebResponse.GetResponseStream() objReader = New System.IO.StreamReader(objResponseStream) Dim strReturn As String strReturn = objReader.ReadToEnd() MsgBox(strReturn) MsgBox(objWebResponse.Server) MsgBox(objWebResponse.Headers.ToString()) objMyStream.Close() Malcolm Kay Development Team Leader IS Unit Tel: 44 (0) 1823 356396 Web: http://www.tauntondeane.gov.uk -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Cameron Booth Sent: 28 April 2004 00:45 To: U2 Users Discussion List Subject: RE: Redback SOAP requests from .NET Redback should respond to a request even if it is to report that the request is malformed. The rgw.log file should show some activity of what's going on if the log levels in rgwresp.ini are turned on high enough. Cheers, Cam Booth Analyst Programmer Ultradata - Vision to Reality www.ultradata.com.au -Original Message- From: Kay, Malcolm [mailto:[EMAIL PROTECTED] Sent: Tuesday, 27 April 2004 6:29 PM To: U2 Users Discussion List Subject: Redback SOAP requests from .NET We've been trying to create Redback SOAP requests from VB .NET, but the requests always timeout. We think it must be a malformed request. Has anyone else tried this? And do you have a successful example of some code please? Malcolm Kay Development Team Leader IS Unit Tel: 44 (0) 1823 356396 Web: http://www.tauntondeane.gov.uk IMPORTANT NOTICE. This communication is intended solely for the person (s) or organisation to whom it is addressed. It may contain privileged and confidential information and if you are not the intended recipient (s), you must not copy, distribute or take any action in reliance on it. If you have received this e-mail in error please notify the sender and copy the message to [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Disclaimer Notice This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action or place any reliance on it. If you have received this message in error please notify Ultradata immediately on +61 3 9291 1600. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Ultradata Australia Pty. Ltd. To unsubscribe from receiving commercial electronic messages from Ultradata Australia please email [EMAIL PROTECTED] with the subject heading Unsubscribe. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users IMPORTANT NOTICE. This communication is intended solely for the person (s) or organisation to whom it is addressed. It may contain privileged and confidential information and if you are not the intended recipient (s), you must not copy, distribute or take any action in reliance on it. If you have received this e-mail in error please notify the sender and copy the message to [EMAIL PROTECTED] -- u2-users mailing list [EMAIL
HTML to Universe conversion codes
Does anyone have a complete list of the unique HTML conversions 'codes' and their Universe equivalents when passing data from an html page to Universe using the form 'post' method. For example the string '%26' is '' in Universe. Would you share this list with me? Thank you in advance. Lee J Messenger Sr VP Operations [EMAIL PROTECTED] DLT Transportation Services, Inc. Phone :(816) 242-4505 Fax :(816) 483-7222 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: HTML to Universe conversion codes
The numeric after the % is the hex representation of the ascii code for the character: = hex 26 = decimal 38 -Original Message- From: Lee Messenger [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 9:11 AM To: [EMAIL PROTECTED] Com Subject: HTML to Universe conversion codes Does anyone have a complete list of the unique HTML conversions 'codes' and their Universe equivalents when passing data from an html page to Universe using the form 'post' method. For example the string '%26' is '' in Universe. Would you share this list with me? Thank you in advance. Lee J Messenger Sr VP Operations [EMAIL PROTECTED] DLT Transportation Services, Inc. Phone :(816) 242-4505 Fax :(816) 483-7222 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: HTML to Universe conversion codes
These are the ones I have for D3, should be the same in universe I would think: %60 ` %7E ~ %21 ! %40 @ %23 # %24 $ %25 % %5E ^ %26 %2A * %28 ( %29 ) %3D = %2B + %5B [ %7B { %5D ] %7D } %5C \ %7C | %3B ; %3A : %27 ' %22 %2C , %3C %3E %3F ? %20 %0D%0A @am Hope that helps. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Messenger Sent: April 28, 2004 12:11 PM To: [EMAIL PROTECTED] Com Subject: HTML to Universe conversion codes Does anyone have a complete list of the unique HTML conversions 'codes' and their Universe equivalents when passing data from an html page to Universe using the form 'post' method. For example the string '%26' is '' in Universe. Would you share this list with me? Thank you in advance. Lee J Messenger Sr VP Operations [EMAIL PROTECTED] DLT Transportation Services, Inc. Phone :(816) 242-4505 Fax :(816) 483-7222 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: AE_DOCS
Wow. Mines 352 kb. I don't know if IBM will send it to you. You could download the PE version and pull it from there. I don't think it's changed a whole lot. hth -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 10:18 AM To: [EMAIL PROTECTED] Subject: AE_DOCS Hello Group! Can anyone tell me where I can obtain a copy of AE_DOC? My predecessor removed the file(s) to save space on our server some time ago. (We are using UniData 5.1 on an NT 4.0 operating system.) Any help will be appreciated! Sincerely, Grant W. Boice, Jr. Systems Administrator Benchmark Electronics, Inc. Manassas Division 8500 Phoenix Drive Manassas, VA 20110 Phone: (703) 334-0156 Email: [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: HTML to Universe conversion codes
Thank you Michael and Jeff for your timely responses. Lee J Messenger Sr VP Operations [EMAIL PROTECTED] DLT Transportation Services, Inc. Phone :(816) 242-4505 Fax :(816) 483-7222 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Michael Spencer Sent: Wednesday, April 28, 2004 11:25 AM To: U2 Users Discussion List Subject: RE: HTML to Universe conversion codes These are the ones I have for D3, should be the same in universe I would think: %60 ` %7E ~ %21 ! %40 @ %23 # %24 $ %25 % %5E ^ %26 %2A * %28 ( %29 ) %3D = %2B + %5B [ %7B { %5D ] %7D } %5C \ %7C | %3B ; %3A : %27 ' %22 %2C , %3C %3E %3F ? %20 %0D%0A @am Hope that helps. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Messenger Sent: April 28, 2004 12:11 PM To: [EMAIL PROTECTED] Com Subject: HTML to Universe conversion codes Does anyone have a complete list of the unique HTML conversions 'codes' and their Universe equivalents when passing data from an html page to Universe using the form 'post' method. For example the string '%26' is '' in Universe. Would you share this list with me? Thank you in advance. Lee J Messenger Sr VP Operations [EMAIL PROTECTED] DLT Transportation Services, Inc. Phone :(816) 242-4505 Fax :(816) 483-7222 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: HTML to Universe conversion codes
It should be standard URL encoding, which works as follows: Spaces are converted to + Characters below 0x20 or above 0x7F, along with the characters %+=:# are converted to a % followed by their hexadecimal equivalent [ OCONV(SEQ(VAR),'MX') ] Note that spaces are not converted to a +, then the + converted to %2B. Any existing + characters in the string would be converted to %2B, THEN any spaces would be converted to +. Larry Hiscock Western Computer Services http://www.wcs-corp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Messenger Sent: Wednesday, April 28, 2004 9:11 AM To: [EMAIL PROTECTED] Com Subject: HTML to Universe conversion codes Does anyone have a complete list of the unique HTML conversions 'codes' and their Universe equivalents when passing data from an html page to Universe using the form 'post' method. For example the string '%26' is '' in Universe. Would you share this list with me? Thank you in advance. Lee J Messenger Sr VP Operations [EMAIL PROTECTED] DLT Transportation Services, Inc. Phone :(816) 242-4505 Fax :(816) 483-7222 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)
unix generally keeps track of time as number of seconds past midnight GMT, Jan 1, 1970. Is there a conversion code to convert that to from external date time? If not, have you already written a custom conversion care to share? (I am NOT asking how to roll my own. I just don't want to do so if someone already has it, including figuring out flexability in output format.) Chuck Stevenson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Flushing memory
Steven R. Shourds wrote: I am currently evaluating different platforms and have been lurking here for a bit. Very lively and informative! We currently use D3 on Windows. I had to integrate SYNC from Sysinternals to flush memory since Windows (or D3) does not seem do it right. We've had problems in the past where customers could loose hours worth of data if there was a system halt! So, would I have to do the same thing with Unidata or did Unidata do it right and provide for safe delivery of the data to the harddrive and then if so is it configurable? Thanks, Steve I can't speak for Unidata or Windows, but UniVerse on unix handles syncs correctly in the default configuration. This is the default setting from the uvconfig file along with comments: # UVSYNC - This boolean if set will change the # behavior of UniVerse calling the UNIX sync() # call on exit the environment. A non-zero value # will mean UniVerse will do a UNIX sync() if a job # leading UniVerse process exits. This value should # only be modified if you know exactly what you are # doing. Data loss may occur if UNIX sync is not # executed frequently enough. UVSYNC 1 I'm assuming the default for Unidata is the same. -John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Timestamp
All, How about the following (86400 * DATE()) + TIME()):.:GETPID()?. You could use common to check that (86400 * DATE()) + TIME()) is unique within the process, and should probably check that the date has not changed between calling DATE and TIME. This would be unique system wide I believe. Regards, Phil Walker +64 21 336294 [EMAIL PROTECTED] infocusp limited \\ PO Box 77032, Auckland New Zealand \ www.infocusp.co.nz DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. infocusp limited is not responsible for any changes made to this message and / or any attachments after sending by infocusp limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Colquhoun Sent: Thursday, April 29, 2004 1:23 AM To: U2 Users Discussion List Subject: RE: Timestamp Hi Ken, At 07:56 PM 28/04/2004, Ken Wallis wrote: Of course one could easily write a FUNCTION that concatenated DATE() and TIME() and used named common to keep track of the last value it gave out to decide if it needed to add an alpha character and if so, which one, but that What about SYSTEM(12) instead of TIME() ? would only be unique inside the user's session, not system wide. If you wanted something that was unique system wide, you might need to go slightly further than one alpha character and you'd need to involve writing something away to a file (or at least locking something) to get coordination between sessions, and there'd be an overhead associated with that of course. Would be much better to have a record in a control file that is regularly incremented. ie in pseudo code: READU COUNTER FROM CONTROL, COUNTERNAME; COUNTER +=1; WRITE COUNTER TO CONTROL,COUNTERNAME ...use COUNTER as you unique id It would also be quite trivial to knock up a CALLC function that obtained the value returned by the time() C runtime function which gives the number of seconds since somewhere in 1970. Computationally that would be the most efficient, but again, it wouldn't be unique system wide. You should have Use CALLC to solve your problem in your sig to save typing it every day. ;-) - Robert -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)
seconds past midnight GMT, Jan 1, 1970. Is there a conversion code yeah .. something like: pick DATE() = INT(unixtime/86400)+732 pick TIME() = MOD(unixtime,86400) which makes: unixtime = (pick DATE() - 732) * 86400 + pick TIME() and PICK time is always local time, not GMT -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ICONV/OCONV for unix internal timestamp (secs past 00:0001/01/1970)
Sorry, no cigar. That's not a conversion code that you can stick in 3 of a dictionary D-item, or 7 of an A-item. Or as second argument of either, nay, both ICONV() OCONV(). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chuck Mongiovi Sent: Wednesday, April 28, 2004 12:43 PM To: U2 Users Discussion List Subject: RE: ICONV/OCONV for unix internal timestamp (secs past 00:0001/01/1970) seconds past midnight GMT, Jan 1, 1970. Is there a conversion code yeah .. something like: pick DATE() = INT(unixtime/86400)+732 pick TIME() = MOD(unixtime,86400) which makes: unixtime = (pick DATE() - 732) * 86400 + pick TIME() and PICK time is always local time, not GMT -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)
Are you asking about the 'MTHS' conversion code? - Original Message - From: Stevenson, Charles [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 1:47 PM Subject: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970) unix generally keeps track of time as number of seconds past midnight GMT, Jan 1, 1970. Is there a conversion code to convert that to from external date time? If not, have you already written a custom conversion care to share? (I am NOT asking how to roll my own. I just don't want to do so if someone already has it, including figuring out flexability in output format.) Chuck Stevenson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UniVerse Personal Edition Telnet Service
I am getting the following errors trying to start the Telnet Service. UniVerse error: Unable to bind socket to telnet port 23. It may be used by other application. WSA error: 10038. UniVerse error: Unable to bind socket to uvrpc port. WSA error: 10038. Ok, I realize what this is telling me... Obviously, I installed something or configured something that is running conflict. My question is... How do I find out what is running in conflict or what has grabbed port 23? Any help would be GREATLY appreciated. Tried re-installing the UV engine... didn't help, nor did I really think it would... just seemed to be a shot in the dark. Glenn W. Paschal PasTech LLC Computer Consulting ph. (931) 526-9631 fx. (931) 526-9678 email. mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] web. http://www.pastech.net/ www.pastech.net -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help on uv syntax, please
The problem (or not problem) with RAISE, is that it will also change all other marks at the same time. If you have a|b|c}d|e|f, and want a}b}c}d}e}f, you have to use CONVERT. RAISE will give you a}b}c^d}e}f *note ^ = fm, } = vm, | = svm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon Glorfield Sent: Tuesday, April 27, 2004 12:18 PM To: 'U2 Users Discussion List' Subject: RE: Help on uv syntax, please To do what you are saying I would use the RAISE function. NEWARRAY = RAISE(OLDARRAY) This would change all @SVM to @VM. Of course you would have to be kind of careful with it as it would also change all @VM to @AM. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, April 27, 2004 12:48 PM To: [EMAIL PROTECTED] Subject: Help on uv syntax, please Hi. Anybody got the syntax for universe for changing one string to another in an array? Mostly I use it for changing a subvalued field into a multivalued one. In Unidata, for example, its NEWARRAY = CHANGE(OLDARRAY,SVM,VM) I'm looking for a similar function in universe. (p.s. if you could e.mail me directly -- I am on digest mode and won't get the answer all day - thanks!) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: UniVerse Personal Edition Telnet Service
Check to see if the Microsoft Telnet service is running. If so, stop the service and set its start property to disable or manual. Then stop the UniVerse services and restart them and you should have telnet. An alternative is to use UniAdmin to change the port UniVerse uses for telnet so the two do not conflict. That is what I have done and it works well. If this is not a MS installnever mind! :-) Ron White - Original Message - From: Glenn W. Paschal [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 4:35 PM Subject: UniVerse Personal Edition Telnet Service I am getting the following errors trying to start the Telnet Service. UniVerse error: Unable to bind socket to telnet port 23. It may be used by other application. WSA error: 10038. UniVerse error: Unable to bind socket to uvrpc port. WSA error: 10038. Ok, I realize what this is telling me... Obviously, I installed something or configured something that is running conflict. My question is... How do I find out what is running in conflict or what has grabbed port 23? Any help would be GREATLY appreciated. Tried re-installing the UV engine... didn't help, nor did I really think it would... just seemed to be a shot in the dark. Glenn W. Paschal PasTech LLC Computer Consulting ph. (931) 526-9631 fx. (931) 526-9678 email. mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] web. http://www.pastech.net/ www.pastech.net -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- [ Eckel certifies this E-mail to be virus free. ] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: VOC corruption
David I've seen this where a GCI/CALLC routine was linked into a UniData kernel and it reused the stderr file handle. The result was the stderr data stream overwrote the file which currently was allocated to that handle (whoch UniData was using for the VOC). The giveaway was to perform an od -c of the VOC - many application error messages overwrote the file header. Hope this helps...not sure off the top of my head whether UniVerse usage of handles is similar - but worth a check. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Logan, David (SST - Adelaide) Sent: 28 April 2004 03:05 To: U2 List Subject: VOC corruption Hi Folks, Twice in the past month I have had a major server, with a business critical system, come to a halt with corruption of the VOC file. The first incident was tracked back to the possibility of errors on the SAN. Hardware was replaced and the file has been resized (I assume by this it has also been moved to a different area on the disk or disks) The following incident has no hardware indications in any log thus making it a little hard to trace where the issue occurred. The customer is, understandably, concerned this may happen again as unfortunately both incidents have had a major impact on their business. I am curious to find if any other sites have had a similar issue. Both incidents were backward link errors in the same items. As noted above, the file was resized between incidents and I assume is now in a different area on the SAN. I have found nothing to date in any log on the system. Any suggestions are welcome. Compaq Tru64 UNIX V5.1A (Rev. 1885); Thu Feb 20 14:06:32 EST 2003 UniVerse 10.0.8 Thanks David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: VOC corruption
Thanks Wally, I will pass this on but we have had some hardware replaced between episodes but will ask to check again. Thanks John, We don't have any GCI or C programs using UCI accessing any of our live databases. Good thought though. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune Sent: Wednesday, 28 April 2004 10:59 PM To: U2 Users Discussion List Subject: Re: VOC corruption I can relay one UV customer's experience. After months of sporadic file corruption episodes, they finally had their hardware folks come out and check over the system (one of the first things our support group had suggested, of course). They had memory boards seated in improper slots. Once they correctly re-seated the memory boards - all file corruption issues ceased. Even though the hardware diagnostic programs for this platform reported no errors - it is always prudent to check hardware. Anything that interrupts a clean movement of a block of data from memory to the physical disk platters could result in database file corruption. Wally Terhune Manager - U2 Advanced Technical Services IBM DB2 Information Management Software Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV Logan, David (SST - Adelaide) [EMAIL PROTECTED] To om U2 List [EMAIL PROTECTED] Sent by: cc u2-users-bounces@ oliver.com Subject VOC corruption 04/27/2004 08:05 PM Please respond to U2 Users Discussion List Hi Folks, Twice in the past month I have had a major server, with a business critical system, come to a halt with corruption of the VOC file. The first incident was tracked back to the possibility of errors on the SAN. Hardware was replaced and the file has been resized (I assume by this it has also been moved to a different area on the disk or disks) The following incident has no hardware indications in any log thus making it a little hard to trace where the issue occurred. The customer is, understandably, concerned this may happen again as unfortunately both incidents have had a major impact on their business. I am curious to find if any other sites have had a similar issue. Both incidents were backward link errors in the same items. As noted above, the file was resized between incidents and I assume is now in a different area on the SAN. I have found nothing to date in any log on the system. Any suggestions are welcome. Compaq Tru64 UNIX V5.1A (Rev. 1885); Thu Feb 20 14:06:32 EST 2003 UniVerse 10.0.8 Thanks David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse Personal Edition Telnet Service
Glenn W. Paschal wrote: I am getting the following errors trying to start the Telnet Service. UniVerse error: Unable to bind socket to telnet port 23. It may be used by other application. WSA error: 10038. UniVerse error: Unable to bind socket to uvrpc port. WSA error: 10038. Ok, I realize what this is telling me... Obviously, I installed something or configured something that is running conflict. My question is... How do I find out what is running in conflict or what has grabbed port 23? Go to www.sysinternals.com and download tcpview.exe. This tool will show you in real(ish) time what netstat shows you whenever you run it, except it also shows the name of the executable associated with each connection. Cheers, Ken PS. Sorry Robert, I couldn't think of a CALLC that would help Glenn on this! ;^) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Input weirdo...
I have a new client that i've yet to be able to break key with over the modem. So if I'm running a program (readnext etc) but i want to break, I include this INCLUDE. IF SYSTEM(14) # 0 THEN INPUT A IF A=Q THEN CLEARSELECT (sic) ; STOP IF A=D THEN DEBUG END SYSTEM(14) is the length of the typeahead buffer. D3 for sure and possibly UV/UD. The CLEARSELECT is UV/UD specific. My 1 cent. - Original Message - From: Dennis Bartlett [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 10:54 AM Subject: Input weirdo... We have a program looping through all data files searching for something - sometimes it gets to a file containing several million records and we'd like to be able to tell it to skip that file and continue with the next file. We've tried the following approaches with said results: (1) OPT.OUT = KEYIN() ; if OPT.OUT = 1 then EXIT OPT.OUT = 0 the program sits waiting for input in every iteration, ie every record (2) INPUT OPT.OUT,-1 ; if OPT.OUT = 'S' then EXIT OPT.OUT = 0 CLEARDATA CLEARINPUT the program works perfectly until an 'S' is entered then skips every file after that... HOWEVER, if I press Ctrl-Break, enter DEBUG, enter C(ontinue), the program continues as normal until another 'S' is entered.. Obviously the machine still has something in the input buffer, despite the CLEARDATA, something that gets whacked when debug hits the scene... Any ideas? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Accuterm like Wintegrate
I use wintegrate a lot as an emulator, file transfer and running PC-based programs. 2 new clients both have accuterm and I'm wondering if their file transfer (import/export) facilities are programmable or are manually managed. Also, is there the equivilent of WIN.PCRUN. I can always install wintegrate but I may not want to rock the boat. Thanks in advance. Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)
Chuck, you need to worry about time zone when rendering the unix epoch time as it is UTC (aka GMT) based. A simple conversion of the unix epoch time to U2 date/time will be incorrect unless you are in Britain in the winter - and who'd be there then ;-) Have a look at http://www.pickwiki.com/cgi-bin/wiki.pl?DateUtility . DateUtility(parseEpochTime,intTimeStamp) will return U2 Date Time based on the local machine time zone. This function could be used as a conversion by wrapping it and globally cataloguing it as $ParseEpochTime OCONV(intTimeStamp,'UParseEpochTime') Cheers, Stuart -Original Message- Behalf Of Stevenson, Charles unix generally keeps track of time as number of seconds past midnight GMT, Jan 1, 1970. Is there a conversion code to convert that to from external date time? If not, have you already written a custom conversion care to share? (I am NOT asking how to roll my own. I just don't want to do so if someone already has it, including figuring out flexability in output format.) Chuck Stevenson ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ICONV/OCONV for unix internal timestamp (secs past 00:00 01/01/1970)
[mailto:[EMAIL PROTECTED] On Behalf Of Stuart Boydell Have a look at http://www.pickwiki.com/cgi-bin/wiki.pl?DateUtility . DateUtility(parseEpochTime,intTimeStamp) will return U2 Date Time based on the local machine time zone. Now that's rich. There's a lot there. Looks like maybe good to piggyback on it. thanks, cds -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ICONV/OCONV for unix internal timestamp (secspast00:0001/01/1970)
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Why not write a user conversion code that does this calculation as a Uname conversion? That's what I was asking, if anyone already did it. I'd prefer it to be flexible enough to allow various oconv formats and to iconv various strings. For example, what if you just have date don't care about time, etc. Plus it ought to have the property analogous to that of D conversions where: ICONV( OCONV( idate, 'D' ), 'D' ) = idate (What's the set theory word for that property, where each member of a set can be transformed to a corresponding member of another set, and the inverse transformation will always get you back to your starting point? Reflexive? That doesn't sound right. It's late, gimme a break.) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse Personal Edition Telnet Service
Thanks for your help. Cool product... But confirmed my fear. Nothing had port 23. As I was working on this, I also found a slew of other serious problems regarding my network config... IE. Spooler not functioning, network browsing not functioning, mapped drives not functioning, other port assignments failing... Could it be time to backup, fdisk, and start over? Hmm I am thinking yes. (oh the pain of a re-load...) Thanks again, --Glenn. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Wednesday, April 28, 2004 7:35 PM To: 'U2 Users Discussion List' Subject: RE: UniVerse Personal Edition Telnet Service Glenn W. Paschal wrote: I am getting the following errors trying to start the Telnet Service. UniVerse error: Unable to bind socket to telnet port 23. It may be used by other application. WSA error: 10038. UniVerse error: Unable to bind socket to uvrpc port. WSA error: 10038. Ok, I realize what this is telling me... Obviously, I installed something or configured something that is running conflict. My question is... How do I find out what is running in conflict or what has grabbed port 23? Go to www.sysinternals.com and download tcpview.exe. This tool will show you in real(ish) time what netstat shows you whenever you run it, except it also shows the name of the executable associated with each connection. Cheers, Ken PS. Sorry Robert, I couldn't think of a CALLC that would help Glenn on this! ;^) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users