UNCLASSIFIED Performance tuning UV on Windows2003
Folks, I notice that when I do two concurrent processes (like ANALYZE.FILE from one window and SELECT from another window) on the same large (3GB,64-bit) file, the 'Pages/sec' count in Win2K3 goes through the roof, even though the 'memory commit charge' is only 176MB out of 2465MB. Maybe the 'Pages/sec' count is not measuring what I expect it to, but it seems odd to me for the system to be paging (i.e. swapping program code segments in and out of memory) in this situation. I'd except the disk system to be getting a thrashing as the two processes want to read different bits of the same file, but not paging. Can anyone tell me 1) Do I understand correctly what is happening? If not, what _is_ going on? 2) Are there any UV configuration tunables which could improve the situation? If so, which one(s)? 3) Are there any Windows configuration tunables which could improve the situation? If so, which one(s)? Oh, it's UV 10.0.15, but I don't think that's terribly relevant Thanks Mike The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED [UV] RESIZE Access Violation
Folks, Our Systems Admin reports that whenever he tries to RESIZE a DYNAMIC file, he gets this error message:- __ RESIZE filename * * * Unhandled exception raised at address 0x00405CF7 : Access violation Attempted to read from address 0x10309044 Aborting UniVerse... ___ He is logged on as Administrator, running UV 10.0.15 on Windows 2003. Any ideas, please? I can't see anything obviously relevant in U2 TechConnect. I get the same error when Thanks Mike The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED Interface to from Microsoft Biztalk Server
Hi All, We are moving towards Microsoft BizTalk Server as the standard 'glue' between our disparate systems. [Yes, I know that the U2 products now talk to IBM's MQ-series products natively, but we don't have any IBM infrastructure, we're mostly an MS shop. Another big advantage is that BizTalk provides as standard a link to and from our SAP Enterprise R/3 ERP system, which is otherwise, umm, not quite the easiest thing to talk to. ;-) ] At the moment, I imagine we will write some VB.Net components using UniObjects to talk to UniBasic routines embodying the business logic and doing the actual UV database updates. Is this a great / good / adequate / poor / really awful idea? Anyone 'been there, done that, still got the scars'? Thanks Mike -- Mike Henderson Senior Analyst / Programmer, Corporate Applications Communications Information Systems Branch NZ Defence Force The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Unclassified RE: (no subject)
Steve, Is the U2 database UD or UV? This might be a 'flavour' issue, if it's UD try substituting sELECT for SELECT. if it's UV try WITH LAST NAME LIKE SMI... or WITH LAST NAME LIKE \SMI...\ HTH Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Mayo Sent: Friday, 2 April 2004 05:52 To: [EMAIL PROTECTED] Subject: (no subject) Greetings one and all, I am trying to put together a demo application using UniObject for Java. I would like to be able to create a statement that selects names that start with SMI. In Unibasic I would use the following statement: SELECT UBFMSTR WITH LAST.NAME = SMI] The Java statement I used is: uCommand.setCommand (SELECT UBFMSTR WITH LAST.NAME = SMI]) and uCommand.setCommand (SELECT UBFMSTR WITH LAST.NAME = 'SMI]') and uCommand.setCommand (SELECT UBFMSTR WITH LAST.NAME = \SMI]\) all to no avail. The first two get syntax errors and the last one seems to run be it returns nothing. There are over 300 records that start with SMI. Any help would be sincerely appreciated. TIA, Steve Mayo Software Engineer -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Unclassified RE: The lists are closing
Like Wol and a couple of others, my participation as a listener and occasional poster will stop if the medium changes from email to web or news-group. My employer does not permit desktop internet access - we do have a large and rich intranet - for reasons of security, of cost (we pay for TRAFFIC here!), and perhaps also of wanting employees to do the work they're paid for rather than surfing all day. So yes, I'm very sad at the prospect of the lists going away and being replaced by an inaccessible alternative. My general opinion is definitely that the lists should continue. I'm fairly indifferent as to who hosts them, though I must say that the U2UG.ORG web site looks very nice, I had a quick glance from home last night. If U2UG wants to host the lists, I'll gladly subscribe, or if acm.org wants to do it, I'm up for that. If it's a web- or newsgroup-based service, then I'll look by only very occasionally, or when I'm in need of help. My $NZ0.02 Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Leitner Sent: Tuesday, 30 March 2004 04:03 To: U2 Users Discussion List Subject: RE: The lists are closing [snip] Is there a general opinion that the email lists should continue? [snip] Lee The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Unclassified RE: What are embedded databases
Hmm ... I thought that what IBM mean by 'embedded database' is the database you didn't even know you had. [8 words!] I.E., there's a database 'embedded' in the software package you bought / use, but you may have no idea that there is a database in there, and even if you do understand that fact, you've no idea which DBMS is actually 'under the hood'. ;-) Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, 30 March 2004 09:35 To: [EMAIL PROTECTED] Subject: RE: What are embedded databases Well, not sure about 10 words or less, but here's my effort: An embedded database is a technology that is deployed as the component responsible for data management within a business application. Dave -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 3/29/2004 2:18 PM Subject: Re: What are embedded databases In a message dated 3/29/2004 11:55:51 AM Eastern Standard Time, [EMAIL PROTECTED] writes: embedded data base support The other day, someone asked me if I used an embedded database. And I was like ... what? Can someone give ten words or less of what an embedded database is? And then maybe an example of a database that is NOT embedded? Thanks Will -- The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED RE: UV on W2K3 - trying to add to path
Sara, [@PATH seems to have nothing to do with the DOS Path, by the way!] You can change the DOS Path in the ENV of your Telnet session (see below), but this doesn't seem to stick if you DOS out from your UniVerse session [ I end up with Path=C:\Program! - note abrupt truncation at first space, path was Path=C:\Program Files\Support Tools\; ... before I DOS'ed !! :- ] Oh dear, this seems like another manifestation of the problem of passing spaces into the DOS environment. Denver say this is fixed in 10.0.21 (which we haven't seen yet), so I guess probably in 10.1.1 as well Holding / setting / saving your DOS Path * You'd need a Basic Program, run in your LOGIN paragraph * The program would - EXECUTE 'ENV' CAPTURING Env.Stuff, then - parse out the Path=... line from Env.Stuff into, say, Env.Path, then - Env.Path := ';c:\ibm\uv\bin', then - EXECUTE 'ENV SET PATH=':Env.Path: CAPTURING Env.Stuff * This will change your DOS path * I'd be inclined to save the Env.Path in COMMON somewhere so you can re-set it later if you need to Nasty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Thursday, 25 March 2004 17:59 To: '[EMAIL PROTECTED]' Subject: UV on W2K3 - trying to add to path We are starting our evaluation of running UniVerse on W2K3. To get a feel of what it will be like and to scope the learning we need to do we have set up a totally isolated W2K3 server (PDC) and have installed the personal version of UniVerse while we wait for an NT version from IBM. I added to the System Environment variables an extension to the PATH = c:\IBM\UV\BIN Problem - we do not get this in our telnet session. It is fine in a cmd session from the server but is missing from the telnet session. Can anyone explain how we add this on an NT platform. Universe was installed as Administrator and we have even tried using Administrator as the user in the telnet session but that did not show the extra path. Our personal user accounts are in the Admin group. I can add this within my session as PATH=%path%;c:\ibm\uv\bin and it works. However this is lost next time. I can see this is going to be an interesting learning curve for our DBAs (Oracle and UniVerse) who have UNIX skills but little exposure to NT apart from using a desktop. I will be on leave tomorrow (Friday) so I will see if I can get the digest sent to me at home. Thank you in anticipation Sara Burns Sara Burns (SEB) Development Team Leader Public Trust Phone: +64 (04) 474-3841 (DDI) Mobile: 027 457 5974 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED RE: [UV] LISTU and USERS
Hmm... On my Win2K3 / UV 10.0.15 system * LISTU says '3 users logged on the system.' * USERS says '5 users logged on the system.' * UniAdmin says '# of Users: 1', and * uvlictool report_lic reports '5 license seats are in use.' ? UniAdmin is only counting the Telnet user, it's not counting the 'uvdlock' or its own 'uvcs' session. OK, so I ran uvlictool clean_lic -a And now * LISTU still says '3 users logged on the system.' * USERS now says '2 users logged on the system.' * UniAdmin still says '# of Users: 1', and * uvlictool report_lic now reports '2 license seats are in use.' Now I can believe that, obviously the 'uvdlock' is not consuming a license Pity that UniAdmin can't agree with either of them, though! Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Tuesday, 23 March 2004 06:25 To: U2 list (E-mail) Subject: [UV] LISTU and USERS On my system (9.6.1.3 NT) LISTU and USERS always shows a different user count. It appears that LISTU includes phantoms and system processes like uvdlock while USERS does not. Hopefully, the count shown by USERS is what UV uses when looking at license count limits. My docs don't indicate a difference. Can anyone shed some light on this? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UNCLASSIFIED RE: Unidata Flashbasic
Ah yes, RAID :-( Unfortunately you have to get the program into BEBUG state before you can start the process of profiling, then enter a $ or # at the ever-popular user-friendly :: prompt, then C, then when the program executes a STOP it goes back to :: again and you have to enter C again to get back to TCL. At least 3 user interactions and the user has to have TCL access by the look of it (I haven't tested that). And you couldn't do it at all in a PHANTOM. Whereas for the UD model, to get coarse-level timings, you just change your menu program (or your UniObjects host?) to add a -G to the RUN ... statements it emits, or even put one in the LOGIN Paragraph. 'Look Ma, no hands!', the user doesn't even have to be aware of what's going on, and you can profile a PHANTOM job. I have found very-low-level profiling useful in a development or test environment, but often only after coarse-level profiling in Production has identified which little beastie is soaking up all the CPU! HTH Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leroy Dreyfuss Sent: Saturday, 20 March 2004 08:56 To: U2 Users Discussion List Subject: Re: UNCLASSIFIED RE: Unidata Flashbasic Mike, UniVerse does have some capabilities you may have forgotten about. Using RAID, you can generate program/subroutine timings (#) and instruction counting ($). Take a look at the RAID information in the BASIC book to see if they help. Regards, LeRoy F. Dreyfuss Advanced Technical Services - UniVerse IBM U2 Data Management Solutions Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 External email: [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED RE: D3 Automatic Faxing
Mark, The last time I did this (it was quite a few years ago) we used an old PC running some free (or very cheap) software that acted as a fax gateway. The software may even have been called 'faxgate'. We created a text file in a directory the gateway could see, it found the file, set up the fax from the information in the text file and pre-stored templates, and sent it. We used it to send out purchase orders and payment advices. I'll forward this to the person who actually did all the work, he may be able to cast a little more light on it. I don't work there anymore so my memory is a bit rusty! :-) HTH Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Wednesday, 17 March 2004 07:41 To: [EMAIL PROTECTED] Subject: D3 Automatic Faxing Dear All: One of my clients, D3, unix Terian Whitebox Pick server (?) would like to have his system generate roughly 100 faxes per day for invoices and purchase orders. I would be interested what the off-the-shelf approach would be. He has a US Robotics Modem connected to a serial port and all of his users are PC's running Accuterm. One thought is the user-level Blat-like approach whereby the document is downloaded to the user's PC and that PC has a Fax setup as a printer, blah, blah, blah. I'm open for suggestions. Thanks in advance. Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UNCLASSIFIED RE: How to safely kill a runaway UniVerse (was u nidata) process
Sorry LeRoy, I have confused you! I don't have any problem killing a UniVerse task, I prefer to try this sequence LOGOUT pid, then ...\uv\bin\kill pid, a couple of times - almost always works, then ...\uv\bin\kill -2 pid, then ...\uv\bin\kill -9 pid, then ONLY AS A LAST RESORT Task manager Kill What I can't do is chuck the process into the debugger, because the 'debug' option in the task manager right-button menu is greyed out. When I have a mysteriously-stuck program in the development environment, being able to throw it into the UniVerse debugger would be really useful: at least I could find out where it is and what it thinks it is doing. Maybe a debugger has to be registered for /associated with the process in some way to make this menu option visible? Since Wol said he _does_ see 'debug' in UniData, and I don't in UniVerse, maybe there's something you guys could do in the UV product to make it happen for us too? Please :-) Thanks Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leroy Dreyfuss Sent: Wednesday, 10 March 2004 12:49 a.m. To: U2 Users Discussion List Subject: Re: UNCLASSIFIED RE: How to safely kill a runaway UniVerse (was unida ta) process Actually, at release 10+, it should be successful via Windows Task Manager's kill option. UV 10 and higher use detached processes by default, and KeepAlive (for tl_server processes) was added as well. If it really becomes necessary to kill a process that for some reason has ignored its KeepAlive setting (assuming the telnet client has been disconnected from the socket), the kill.exe in uv\bin was updated in 10 to do a better job at killing processes, though it could take a few seconds to come back to the DOS prompt. I cannot recall when it hasn't work at 10.x. When all else fails, download the sysinternals.com Process Explorer and use its kill option. Remember that if you have updates pending, your open files may be at some risk. Regards, LeRoy F. Dreyfuss Advanced Technical Services - UniVerse IBM U2 Data Management Solutions Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2/support The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED RE: UV on Itanium
Bill, In my entirely unqualified opinion, I think IBM would be absolutely mad to spend any time or money on an Itanium port. The Itanic looks sure to be consigned to the trash-heap of history fairly quickly now that Intel have admitted defeat and adopted the AMD64 instruction set. I'd sit tight and wait until there's an Opteron Xeon IA32e 64-bit port. You'll be able to buy Opteron boxes from HP, Sun, IBM and maybe even Dell by the middle of next quarter. BTW, I wonder what's happened to the UV porting effort? There have been very few (none at all for Windows, in fact) new postings to the Product Availability Matrix since before Christmas. ? Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, 10 March 2004 7:44 a.m. To: 'U2 Users Discussion List' Subject: UV on Itanium We need to buy a new server. Perhaps we should chill for a few months... I gather that HP-Ux runs on Itanium now. What is IBM's timetable for rolling out Itanium servers with AIX? When is UV targeted to run on Itanium? The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED RE: How to safely kill a runaway UniVerse (was unida ta) process
Hmm When I do that on my W2K3 / UV 10 server, the right-button click menu has debug greyed out. Is that a UV 'feature', or have I got something configured wrong? I am an Administrator of the server, and I installed UV on it, so I should be fully enabled for this kind of work. TIA Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Monday, 8 March 2004 11:54 p.m. To: U2 Users Discussion List Subject: RE: How to safely kill a runaway unidata process My experience is that the standard techniques don't work! The way I kill rogue processes like this is, on the server, go into task manager. Right-click the process. Do NOT select kill process, it won't work. Instead, select the other, attach debugger, option. The process will promptly do a Dr Watson and die. Cheers, Wol The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED RE: U2 hardware conversion inquiry
Tom, Some aspects you haven't mentioned: You are considering going to an 'IBM system', but which of the four platforms are you thinking about? Power/AIX? Power/Linux? x86/Linux? x86/Windows? We moved from HP-UX to IBM x86/Windows, it was no particular drama. More details off-line if you want Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Downey, Thomas A 454 Sent: Tuesday, 9 March 2004 6:01 a.m. To: '[EMAIL PROTECTED]' Subject: U2 hardware conversion inquiry We are a UniVerse shop that is investigating moving off our DEC/COMPAQ/HP hardware. Our company is a heavy user of IBM equipment and I am inquiring on folks' experience with moving UniVerse from the DEC/COMPAQ/HP to an IBM system. I am looking for very high level information. I know that most of the time, the devil is in the details but I have worked with PICK on various hardware platforms in the past without any real troubles and just need some general information c/o DEC/COMPAQ/HP to IBM to present to our team. Thanks, Tom Downey Universe 10.0.3 Digital UNIX The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED RE: UV - Database backup
Tim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder Sent: Tuesday, 9 March 2004 6:58 a.m. To: U2 Users Discussion List Subject: Re: UV - Database backup [snip] If you're doing it from the O/S level, you may want to use the uv -admin -L option, which performs the same thing as SUSPEND.FILES ON. uv -admin -U will turn it off. Where are these commands documented? The 10.0.15 Admin.pdf manual mentions only uv -admin -start, uv -admin -stop, and uv -admin -c Are there any other really useful uv -admin ... subcommands like -L and -U that you can share with us? Thanks Mike This is a fairly common practice. I'm not aware of any gotchas. Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UNCLASSIFIED RE: UV - Database backup
Afraid not, Glenn - E:\IBM\UV\binuv -admin E:\IBM\UV\bin - Nothing at all, I'm afraid :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert Sent: Tuesday, 9 March 2004 9:45 a.m. To: U2 Users Discussion List Subject: Re: UNCLASSIFIED RE: UV - Database backup I believe (since I wrote all that stuff) that issuing uv -admin will display all your available options. Since that original version, I've added additional (DataStage engine only) options for displaying things like engine status, active users, etc, as well as allowing you to start and stop multiple versions (yes, more than one can run on a system now), allowing you to enable/disable autostartup at system boot, changing administer name, etc At 03:37 PM 03/08/2004, you wrote: Tim -Original Message- Are there any other really useful uv -admin ... subcommands like -L and -U that you can share with us? The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED RE: [UV] Ever wondered how something works...
Barry, Got neither of these verbs in my VOC We run INFORMATION flavour, which one do you use? But I've seen that error message before, when a program tried to execute the DOS command, but the user didn't have the correct rights to cmd.exe. Your UV users (a local group on the server, normally) need read execute rights on 'cmd.exe' [in C:\WINNT\System32\] in order for the DOS command to work. So ... I'd guess that LD is a program which includes an EXECUTE DOS /c 'DOS command', and you don't have rights to cmd.exe HTH Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Thursday, 4 March 2004 3:34 p.m. To: U2 list (E-mail) Subject: [UV] Ever wondered how something works... One day, I stumbled across an interesting behavior; at TCL, if I type 'L', it results in my current SELECT list being cleared. You get an error message, but it does not seem to hurt anything. This is great, because I hate typing in CLEARSELECT. But ever since, I've been wondering what it's really doing. Turns out that 'L' is one of only two similar VOC entries, the other being 'LD'. It looks like this: 0001: V 0002: L 0003: PR The error message you get reads: Unable to create new process. Will try again. Create Process failed (2). This is on NT. IIRC, on unix the message is different. Anybody know what this is doing, or if it is safe? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED [UV] System Error Message 100102
Folks, Our system administrators have recently seen a few examples of System Error Message 100102 get_expbuf: illegal level 0, current level 0. appearing in the UV ERRLOG. Can anyone tell me what this means, and what (if anything) we can do about it? UV 10.0.15 on Windows 2003 Server Thanks Mike Henderson --- Senior Analyst / Programmer, Corporate Applications Communications Information Systems Branch New Zealand Defence Force DDI: +64 4 2371 828 Fax: +64 4 2371 807 Mob: +64 21 300 654 The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UNCLASSIFIED [UV] System Error Message 100102
Gwen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gwen Buck Sent: Friday, 20 February 2004 9:26 a.m. To: U2 Users Discussion List Subject: RE: UNCLASSIFIED [UV] System Error Message 100102 snip Mike, I can't tell you what your error means but I just noticed your version. We had some problems implementing this version of UniVerse on Win2000 server. We were told we should not go 'live' with it and we moved up to 10.0.17. There was some list discussion on this release a while back and someone said UV 10.0.15 was something that should have never made it out to the field. By the time the problems with 10.0.15 were made public, we had had it on our development system for five or six weeks, and in production for a fortnight. Since the production upgrade from UV9.6 had also been a platform change from HP-UX to Win2K3, we couldn't go back to anything, and 10.0.17 was then not yet available. We were stuck on 10.0.15 :-( Fortunately we have not had any of the problems some others have experienced with this release, but we are eagerly looking forward to 10.1! Maybe someone out there will know whether the version is connected to your error message or whether a UV upgrade would fix the problem. Gwen Buck -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED RE: version control software
Jeff, Someone in Oz - maybe PRISM www.pri.com.au IIRC - does a U2 integration with Microsoft Source Safe. And someone on this list has created and sells a U2-specifi product. Check the list archives. HTH Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Steinmetz Sent: Thursday, 19 February 2004 3:20 p.m. To: [EMAIL PROTECTED] Subject: version control software I am looking for a version control application for U2 software development. Ideally it would have a check-out/check-in function, ability to track changes, migration dates, etc Does anyone have any suggestions? Jeff Steinmetz Vice President, Store Systems Guitar Center, Inc 5795 Lindero Canyon Road Westlake Village, CA 91362 818-735-8800 ext 2248 [EMAIL PROTECTED] The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
unclassified RE: COUNT modifying Unix timestamp
David, I see the same effect on UV 10.0.15 on Win2K3 for Dynamic files, also for Dictionaries (type 3). LIST a file: no change to Windows file timestamp. COUNT the same file: Windows file timestamp is updated. ! Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eves, David Sent: Tuesday, February 17, 2004 9:40 AM To: U2 Users Discussion List Subject: COUNT modifying Unix timestamp We have a client running UV 10.0.16 on HPUX 11i who has noted that a Universe COUNT will modify the Unix timestamp of a file. Has this always been the case? Why does a supposedly read-only operation like COUNT modify the timestamp but others such as LIST, SORT, etc. don't? Cheers, David Eves The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED RE: UV secondary index
Margus, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, 9 February 2004 10:23 p.m. To: [EMAIL PROTECTED] Subject: UV secondary index Hello, I have distributed UV file with total size about 2.5Gb. I made secondary index CREATE. INDEX file field1 ... field6 BUILD.INDEX file field1 ... field6 This syntax creates builds six separate secondary index files, so that inserting a row in the main file will create probably between six and eighteen additional I/O operations to the multiple indices. Is this what you intended? If you actually wanted to create a single secondary index based on a concatenation of the first six fields, you need to create an I-type which does the concatenation, then index on the I-type. If you do need six separate secondary indices, maybe you need to look at where the index files are placed (different disk channel from main file,etc.) Another possibility is that the data is very 'clumpy' on one or more index fields, so that a large proportion of the records share the same value for that index. When UV comes to add a value to the index, it has to scan through a huge set of identical values and then put the new occurrence at the end: this gets exponentially slower. If the shared value is null, then re-creating your index/indices with NO.NULLS will help. If it's not null (maybe it's a month number, so all records fall into only twelve distinct values?), then you need to find some way of creating a more-unique (e.g. month and day) indexable value. HTH Mike After that, rows inserting takes very long time. (4000 rows. Server so busy, that other users can't do anything. If I removed index then inserting process is OK, but I need this index for reporting) Is it normal in UniVerse? How to avoid this problem? I use UniVerse 9.5.2 on AIX 5.2 Thanks, Margus Kandelin The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
