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
.net provider from Raining Data
Hi, 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? We have some problem with saving a record to the uniData server. we try to write a record to the table see code snippet - connection cn; openconnection(cn); ... cn.getDatabase().getTable(Tablename).Write(record.getField(@ID).getValue (),record.ToString()); - The code does not work as expected. The call returns true but the cn seams to be destroyed after this line and nothing is written to the database. Are we using this method wrong? Are there any other ways to uppdate a table in the database? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
SV: ANTIVIRUS
Is anyone using AV software on Unix systems like Solaris? Björn Eklund Anknytning 2088 -Ursprungligt meddelande- Från: Anthony Youngman [mailto:[EMAIL PROTECTED] Skickat: den 25 mars 2004 11:52 Till: U2 Users Discussion List Ämne: RE: ANTIVIRUS We use sophos. www.sophos.com Just a dedicated AV company, and does nothing else. Plus you can get bulk licences (or could last I checked) so it is MANDATORY for all personal pcs that they be running sophos if the owner wishes to connect them to the company net. We just give them a cd and tell them they MUST install it. Cheers, Wol -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
SV: SV: Performance Discussion - Unidata
Hi Martin, excuse the late answer, we have a StorageTek D280 with 1GB cache and we see good performance after tuning the cache. Björn Eklund -Ursprungligt meddelande- Från: Martin Thorpe [mailto:[EMAIL PROTECTED] Skickat: den 26 februari 2004 13:21 Till: U2 Users Discussion List Ämne: Re: SV: Performance Discussion - Unidata Bjorn If you didnt mind me asking, what hardware are you using in terms of SAN, is it EMC Clarion, Storagetek/Sun StoreEdge etc and also how much cache have you got on those arrays? 1GB? Do you see good performance over that? Thanks Björn Eklund wrote: Hi Martin, we have equipment that looks a lot like yours, same server but with double the amount of CPU and RAM. We also have an external SAN storage(FC disks 15000 rpm) where all the unidata files resides. When we started the system for the first time everything we tried to do was very slow. After tuning the storage kabinett's cache we got an acceptable performance. After some time we started looking for other ways of improving performance and did a resize on all our files. The biggest change was from blocksizze 2 to 4 on almost every file. This made an improvement of about 50-100% perfomance on our disk intense batchprograms. I don't remeber any figures on speed regarding reads and writes but I can ask our unixadmin to dig them up if you want. It's just a guess but I do belive that Unidata rely heavily on Solaris buffers. Regards Björn -Ursprungligt meddelande- Från: Martin Thorpe [mailto:[EMAIL PROTECTED] Skickat: den 25 februari 2004 19:13 Till: [EMAIL PROTECTED] Ämne: Performance Discussion - Unidata Hi guys Hope everybody is ok! To get straight to the point, system as follows: SunFire V880 2x1.2GHZ UltaSparc3cu Processors 4GB RAM 6x68GB 10krpm FC-AL disks 96GB backplane Disks are grouped together to create volumes - as follows: Disk 1 - root, var, dev, ud60, xfer - RAID 1 (Root Volume Primary Mirror) Disk 2 - root, var, dev, ud60, xfer - RAID 1 (Root Volume Submirror) Disk 3 - /u- RAID 10 (Unidata Volume Primary Mirror - striped) Disk 4 - /u- RAID 10 (Unidata Volume Primary Mirror - striped) Disk 5 - /u- RAID 10 (Unidata Volume Submirror - striped) Disk 6 - /u- RAID 10 (Unidata Volume Sumkfs -F ufs -o nsect=424,ntrack=24,bsize=8192,fragsize=1024,cgsize=10,free=1,rps=167,nbpi= 8 275,opt=t,apc=0,gap=0,nrpos=8,maxcontig=16 /dev/md/dsk/d10 286220352 bmirror - striped) UD60 - Unidata Binary area XFER - Data output area for Unidata accounts (csv files etc) /U - Primary Unidata account/database area. If I perform tests via the system using both dd and mkfile, I see speeds of around 50MB/s for WRITES, 60MB/s for READS, however if a colleague loads a 100MB csv file using READSEQ into a Unidata file, not doing anything fancy, I see massive Average Service Times (asvc_t - using IOSTAT) and the device is usually always 100% busy, no real CPU overhead but with 15MB/s tops WRITE. There is only ONE person using this system (to test throughput). This is confusing, drilling down I have set a 16384 block interlace size on each stripe and the following info for the mounted volume: mkfs -F ufs -o nsect=424,ntrack=24,bsize=8192,fragsize=1024,cgsize=10,free=1,rps=167,nbpi= 8 275,opt=t,apc=0,gap=0,nrpos=8,maxcontig=16 /dev/md/dsk/d10 286220352 in /etc/system I have set the following parameters: set shmsys:shminfo_shmmni=1024 set shmsys:shminfo_shmmax=8388608 set shmsys:shminfo_shmseg=50 set msgsys:msginfo_msgmni=1615 set semsys:seminfo_semmni=100 set semsys:seminfo_semmns=985 set semsys:seminfo_semmnu=1218 set maxpgio=240 set maxphys=8388608 I have yet to change the throughput on the ssd drivers in order to break the 1MB barrier, however I still would have expected better performance. UDTCONFIG is as yet unchanged from default. Does anybody have any comments? Things to try in my opinion: I think I have the RAID correct, the Unidata TEMP directory I have redirected to be on the /U RAID 10 partition rather than the RAID 1 ud60 area. 1. Blocksizes should match average Unidata file size. One question I have is does Unidata perform its own file caching? can I mount filesystems using FORCEDIRECTIO or does Unidata rely heavily on the Solaris based buffers? Thanks for any information you can provide -- Martin Thorpe DATAFORCE GROUP LTD DDI: 01604 673886 MOBILE: 07740598932 WEB: http://www.dataforce.co.uk mailto: [EMAIL PROTECTED] -- 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
How to start windows programs
Hi, Is there a way of starting windowsprograms on the users PC from a Unibasic program or do I need Wintergrate or some other tool to do that? I would like to send a invoice number away to an invoice archive on MS sql-server to get a pdf copy of the invoice in an Internet Exploreror acrobat reader window. Björn Eklund -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
SV: How to start windows programs
That sounds great Stuart since we run netterm today. I'll try this out. Björn Eklund -Ursprungligt meddelande- Från: Stuart Boydell [mailto:[EMAIL PROTECTED] Skickat: den 4 mars 2004 00:49 Till: U2 Users Discussion List Ämne: RE: How to start windows programs Is there a way of starting windowsprograms on the users PC from a Unibasic program or do I need Wintergrate or some other tool to do that? You need a proficient terminal emulator. Wintegrate could be one option of many. I would like to send a invoice number away to an invoice archive on MS sql-server to get a pdf copy of the invoice in an Internet Exploreror acrobat reader window. The simplest method to open a pdf is to write the pdf to a server then send the URI of the pdf to the emulator via an escape sequence. For example, to open a pdf in your browser using ftp using Netterm: CRT CHAR(27):'[]ftp://user:[EMAIL PROTECTED]/invoice12345.pdf':CHAR(27):'[0*' My personal preference for emulators is Netterm. http://securenetterm.com. It supports the ability to open URIs, kick off programs on the client as well as more sophisticated functions. It's free to evaluate (with no expiry time) and if you decide you want to buy it it's about US$30 for 1 and gets cheaper by the dozen. Regards, Stuart ** 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
SV: Performance Discussion - Unidata
Hi Martin, we have equipment that looks a lot like yours, same server but with double the amount of CPU and RAM. We also have an external SAN storage(FC disks 15000 rpm) where all the unidata files resides. When we started the system for the first time everything we tried to do was very slow. After tuning the storage kabinett's cache we got an acceptable performance. After some time we started looking for other ways of improving performance and did a resize on all our files. The biggest change was from blocksizze 2 to 4 on almost every file. This made an improvement of about 50-100% perfomance on our disk intense batchprograms. I don't remeber any figures on speed regarding reads and writes but I can ask our unixadmin to dig them up if you want. It's just a guess but I do belive that Unidata rely heavily on Solaris buffers. Regards Björn -Ursprungligt meddelande- Från: Martin Thorpe [mailto:[EMAIL PROTECTED] Skickat: den 25 februari 2004 19:13 Till: [EMAIL PROTECTED] Ämne: Performance Discussion - Unidata Hi guys Hope everybody is ok! To get straight to the point, system as follows: SunFire V880 2x1.2GHZ UltaSparc3cu Processors 4GB RAM 6x68GB 10krpm FC-AL disks 96GB backplane Disks are grouped together to create volumes - as follows: Disk 1 - root, var, dev, ud60, xfer - RAID 1 (Root Volume Primary Mirror) Disk 2 - root, var, dev, ud60, xfer - RAID 1 (Root Volume Submirror) Disk 3 - /u- RAID 10 (Unidata Volume Primary Mirror - striped) Disk 4 - /u- RAID 10 (Unidata Volume Primary Mirror - striped) Disk 5 - /u- RAID 10 (Unidata Volume Submirror - striped) Disk 6 - /u- RAID 10 (Unidata Volume Sumkfs -F ufs -o nsect=424,ntrack=24,bsize=8192,fragsize=1024,cgsize=10,free=1,rps=167,nbpi=8 275,opt=t,apc=0,gap=0,nrpos=8,maxcontig=16 /dev/md/dsk/d10 286220352 bmirror - striped) UD60 - Unidata Binary area XFER - Data output area for Unidata accounts (csv files etc) /U - Primary Unidata account/database area. If I perform tests via the system using both dd and mkfile, I see speeds of around 50MB/s for WRITES, 60MB/s for READS, however if a colleague loads a 100MB csv file using READSEQ into a Unidata file, not doing anything fancy, I see massive Average Service Times (asvc_t - using IOSTAT) and the device is usually always 100% busy, no real CPU overhead but with 15MB/s tops WRITE. There is only ONE person using this system (to test throughput). This is confusing, drilling down I have set a 16384 block interlace size on each stripe and the following info for the mounted volume: mkfs -F ufs -o nsect=424,ntrack=24,bsize=8192,fragsize=1024,cgsize=10,free=1,rps=167,nbpi=8 275,opt=t,apc=0,gap=0,nrpos=8,maxcontig=16 /dev/md/dsk/d10 286220352 in /etc/system I have set the following parameters: set shmsys:shminfo_shmmni=1024 set shmsys:shminfo_shmmax=8388608 set shmsys:shminfo_shmseg=50 set msgsys:msginfo_msgmni=1615 set semsys:seminfo_semmni=100 set semsys:seminfo_semmns=985 set semsys:seminfo_semmnu=1218 set maxpgio=240 set maxphys=8388608 I have yet to change the throughput on the ssd drivers in order to break the 1MB barrier, however I still would have expected better performance. UDTCONFIG is as yet unchanged from default. Does anybody have any comments? Things to try in my opinion: I think I have the RAID correct, the Unidata TEMP directory I have redirected to be on the /U RAID 10 partition rather than the RAID 1 ud60 area. 1. Blocksizes should match average Unidata file size. One question I have is does Unidata perform its own file caching? can I mount filesystems using FORCEDIRECTIO or does Unidata rely heavily on the Solaris based buffers? Thanks for any information you can provide -- Martin Thorpe DATAFORCE GROUP LTD DDI: 01604 673886 MOBILE: 07740598932 WEB: http://www.dataforce.co.uk mailto: [EMAIL PROTECTED] -- 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
SV: [UV] Very slow SQL query
Hi, it sounds to me that you are not using any indexes. In UD there is CREATE.INDEX and BUILD.INDEX commands you need to run. Björn Eklund -Ursprungligt meddelande- Från: Cesar Riba [mailto:[EMAIL PROTECTED] Skickat: den 19 februari 2004 16:04 Till: [EMAIL PROTECTED] Ämne: [UV] Very slow SQL query Hello, I have two files one has 300.000 records and another has 200.000 records, I wante to make SQL Query whit the two files and this takes bettewn 30 seconds and 1 minute to return the result. However, I have a program with BASIC to obtime the same result and it takes less than one second, I have heard that other DB Systems like SQL Server, Oracle, etc... are very fast with the SQL Query. Is this posible or do have I made a mistake? Thanks César -- 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
SV: [UV] Very slow SQL query
Cesar, You need to build the index also, try BUILD.INDEX FILNAME ALL In Unidata that is. Björn Eklund -Ursprungligt meddelande- Från: Cesar Riba [mailto:[EMAIL PROTECTED] Skickat: den 19 februari 2004 17:24 Till: 'U2 Users Discussion List' Ämne: RE: [UV] Very slow SQL query -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Brian Leach Enviado el: jueves, 19 de febrero de 2004 16:22 Para: 'U2 Users Discussion List' Asunto: RE: [UV] Very slow SQL query César, I think we will need more information to help you. 1. are you running the SQL query at TCL or through ODBC or OleDB? César: I running the SQL query at TCL 2. Can you give the command you are running please. Cesar: SELECT PEDIDO,REFART,DESART,CANTIDAD,CANTMODALB FROM GCMLIAL WHERE EMPALBA = '1*05236' ORDER BY EMP, ALBA, NUMLIN; Cesar: SELECT PEDIDO, SUREF FROM GCMLIAL WHERE EMPALBA = '1*05236' GROUP BY PEDIDO, SUREF; 3. Are there any indexes on the files? (LIST.INDEX filename ALL) Cesar: There aren't indexes on the files, I create index but the result is the same. Regards, Brian Leach -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cesar Riba Sent: 19 February 2004 15:04 To: [EMAIL PROTECTED] Subject: [UV] Very slow SQL query Hello, I have two files one has 300.000 records and another has 200.000 records, I wante to make SQL Query whit the two files and this takes bettewn 30 seconds and 1 minute to return the result. However, I have a program with BASIC to obtime the same result and it takes less than one second, I have heard that other DB Systems like SQL Server, Oracle, etc... are very fast with the SQL Query. Is this posible or do have I made a mistake? Thanks César -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email was checked by MessageLabs SkyScan before entering Microgen. This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- 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
Wintegrate, UD
Hi, We are currently running an old green line GUI. I was told by IBM to look at Wintegrate to make my applications look more modern. I've downloaded the Wintegrate trial version but I don't know where to start. I've modified the coloring setting to get certain fields look like windows textboxes etc. But I'm sure that there must be another way of using Wintegrate to fullfill my needs. Anyone who knows where I should start? Should I redraw my screens in the Wintegrate dialog designer or what? I have downloaded all the manuals but can't find anything at a glance that shows me where to start my GUItilazation. TIA Björn Eklund -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
SV: [UD]LOGTO
Ok,
I've solved the menu problem you mention by setting @USER.RETURN.CODE in the
calling program and then I fixed the LOGIN voc entry so that I skip the menu if
the @USER.RETURN.CODE is equal to what I used in the calling
program.
Björn Eklund Anknytning 2088
-Ursprungligt meddelande-Från: Dianne Ackerman
[mailto:[EMAIL PROTECTED]Skickat: den 2 februari 2004
17:31Till: U2 Users Discussion ListÄmne: Re:
[UD]LOGTOI've had this work in Universe lots of times;
the only problem I've had occur has to do with any menu system or security in
the account I'm logging to. For example, if the other account has no
access to the LOGTO verb or there is a menu in the way of getting to
TCL.-Dianne[EMAIL PROTECTED] wrote:
Not sure about the logto problem; However, if you are trying
to create a file in a different account create.file will work with the full
path. Caveat, it will not create a VOC entry in the other
account.
Other possible work-arounds: Use a
named select list. Don't use a select list, put it
in an array.
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:
Björn Eklund [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 02, 2004 6:44 AM To: '[EMAIL PROTECTED]' Subject: [UD]LOGTO
Hi there, does anyone know if it's
possible to do a select followed by a logto another account and then back again with logto without loosing my
(religion) selectlist? The
select statement returns 816 records but it only loops one time.
SELECT REGISTER.REG LOOP
READNEXT ID ELSE EXIT
READV DATA FROM REGISTER.REG,
ID,1 ELSE DATA =
"">
CMD = 'LOGTO ':$UDT52
EXECUTE CMD
IF BLA THEN CREATE.FILE 'A.FILE'
DYNAMIC END
ELSE LOGTO
ACCOUNT.NAME
END REPEAT
Björn Eklund
___
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
[ud] TOADS
Hi, anyone out there who knows how I should do to make TOADS work in my newly created Unidataaccount. I have a catalogstructure like this: /data/TOADS.MASTER /data/TOADS /data/TOAD.BEGIN and my new account is in /data/data2/newaccout Björn Eklund ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
SV: [ud] TOADS
Tack så mycket, nu är jag uppe och kör! Björn Eklund Anknytning 2088 -Ursprungligt meddelande- Från: Mats Carlid [mailto:[EMAIL PROTECTED] Skickat: den 28 januari 2004 11:06 Till: U2 Users Discussion List Ämne: Re: [ud] TOADS Björn go to an account where toads is already set up, copy all file pointers that point to TOADS.MASTER or TOADS to the new account. Then - unless toads is globally cataloged - also copy all program entries that belongs to toads. How do I know wich ones belong to toads, You ask. The answer is unless they are globally cataloged their cataloged name all start with the same prefix and You find it in any toad program VOC entry e.g. MASTER.TOAD Also look in Your login paragraph for toads initialization programs in uv we have TD.SET.DIMENSIONS there. I think that is about it - but it sure is a long time Anyway try that as a start and come back with the dignosis if any adn we'll continue from there. There is/should be a shell script somewhere that initializes an account - at least for uv - can't remember it's name :-( /Mats Björn Eklund wrote: Hi, anyone out there who knows how I should do to make TOADS work in my newly created Unidataaccount. I have a catalogstructure like this: /data/TOADS.MASTER /data/TOADS /data/TOAD.BEGIN and my new account is in /data/data2/newaccout Björn Eklund ___ 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
