Re: [U2] B2B
Ross, Ross Ferris wrote: Secure implies SSL, which as you identify means using well known ports. I'd think it would take a lot more work to bastardise a solution using encrypted traffic on non-standard ports (I don't think you want to encrypt ALL traffic, so 80 won't do the trick) than changing your proxy to include SSL ports HTTP proxying should work regardless of the proxy port -- you certainly can configure a proxy with different ports for http/https but I don't believe you need to (the proxy just has to understand the HTTP CONNECT method AFIK). If callHTTP allows you to use a proxy, it should send all traffic there regardless of the destination port. To confirm this was the problem, you could try using callHTTP to access a site on some non-standard port (eg: 8080) via the proxy and see if that works. Craig --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OT: Ardent.com
holy miss molly - its the vice president of ascential :-)) Claus Derlien edb-afdelingen direkte : 63 13 86 69 email : [EMAIL PROTECTED] -Original Message- From: Chuck Mongiovi [mailto:[EMAIL PROTECTED] Sent: Friday, August 06, 2004 8:42 PM To: [EMAIL PROTECTED] Subject: RE: [U2] OT: Ardent.com www.ardentsoftware.com. Someone's slip is showing... OK - i'll bite .. Who's the photo of? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ** ** Denne mail er blevet scannet af http://www.virus112.com ** ** Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse - www.f-f.dk *** Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der kun er beregnet for adressaten, og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse modtaget denne email, bedes De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak. *** This email and any files transmitted with it may contain confidential information intended for the addressee(s) only. The information is not to be surrendered or copied to unauthorised persons. If you have received this communication in error, please notify us immediately by telephone: +45 6313 8550. Thank you. *** --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OT: Ardent.com
Name of jpg file is Bob_Zurek.jpg s :-) Claus Derlien edb-afdelingen direkte : 63 13 86 69 email : [EMAIL PROTECTED] -Original Message- From: Chuck Mongiovi [mailto:[EMAIL PROTECTED] Sent: Friday, August 06, 2004 8:42 PM To: [EMAIL PROTECTED] Subject: RE: [U2] OT: Ardent.com www.ardentsoftware.com. Someone's slip is showing... OK - i'll bite .. Who's the photo of? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ** ** Denne mail er blevet scannet af http://www.virus112.com ** ** Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse - www.f-f.dk *** Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der kun er beregnet for adressaten, og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse modtaget denne email, bedes De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak. *** This email and any files transmitted with it may contain confidential information intended for the addressee(s) only. The information is not to be surrendered or copied to unauthorised persons. If you have received this communication in error, please notify us immediately by telephone: +45 6313 8550. Thank you. *** --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] euro sign
Euro symbol support came in at 6. It used to be that the Euro symbol varied according to font set used... So you had to check each one. It's Alt+128 on the character map in Windows XP and is a Unicode item - U+20AC. Hope that helps? Robert Paterson Technology Support Manager www.epicor.com Tel.: +44 (1344) 468231 Cell: +44 (7799) 348513 Fax: +44 (1344) 468050 E-Mail: [EMAIL PROTECTED] 1 The Arena, Downshire Way, Bracknell, Berks, UK, RG12 1PU This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
SV: [U2] euro sign
ok, thanks Robert. I guess we'll have to upgrade to version 6 then. Bjvrn Eklund -Ursprungligt meddelande- Fren: Robert Paterson [mailto:[EMAIL PROTECTED] Skickat: den 9 augusti 2004 14:29 Till: '[EMAIL PROTECTED]' Dmne: RE: [U2] euro sign Euro symbol support came in at 6. It used to be that the Euro symbol varied according to font set used... So you had to check each one. It's Alt+128 on the character map in Windows XP and is a Unicode item - U+20AC. Hope that helps? Robert Paterson Technology Support Manager www.epicor.com Tel.: +44 (1344) 468231 Cell: +44 (7799) 348513 Fax: +44 (1344) 468050 E-Mail: [EMAIL PROTECTED] 1 The Arena, Downshire Way, Bracknell, Berks, UK, RG12 1PU This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Question on Unidata tables access speeds
It is indexed on the key column, even then if I run the run the job (query) 4 times in parallel, I am not getting advange of the parallel query. Is Unidata not good for the parallel query ?, or is there any tuning method ? thanks Kevin King [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: Subject: RE: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/08/2004 06:09 PM Please respond to u2-users Is anything indexed? Sounds like you could probably benefit from adding some indexes on fields used for the selection. That would make a BIG difference. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, August 08, 2004 3:57 PM To: [EMAIL PROTECTED] Subject: [U2] Question on Unidata tables access speeds Hi , Project data warehouse, Sources are Unidata tables, tool Datastage. Performance issue, while dumping in to hash file(Allowing stage write cash). It is searching 5.5 million rows and fetching 2.6 million rows and taking 2.5 hours. There is only one key column in the ouput. When I remove select caluse(I mean select all rows) and put that filter in my tool, it is ok, but not great. After that When I run parallel jobs , I mean select the data by 4 jobs for different ranges(all at the same time), it is taking 4 times than normal time . In other words, I am not getting performance like Oracle or other data bases. I am new to Unidata, is there any method where I can get good access speeds on Unidata.Any help will be highly appreciated. thanks pbr -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation.
RE: [U2] Question on Unidata tables access speeds
What fields are you using to select with? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, August 09, 2004 8:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Question on Unidata tables access speeds It is indexed on the key column, even then if I run the run the job (query) 4 times in parallel, I am not getting advange of the parallel query. Is Unidata not good for the parallel query ?, or is there any tuning method ? thanks Kevin King [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: Subject: RE: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/08/2004 06:09 PM Please respond to u2-users Is anything indexed? Sounds like you could probably benefit from adding some indexes on fields used for the selection. That would make a BIG difference. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, August 08, 2004 3:57 PM To: [EMAIL PROTECTED] Subject: [U2] Question on Unidata tables access speeds Hi , Project data warehouse, Sources are Unidata tables, tool Datastage. Performance issue, while dumping in to hash file(Allowing stage write cash). It is searching 5.5 million rows and fetching 2.6 million rows and taking 2.5 hours. There is only one key column in the ouput. When I remove select caluse(I mean select all rows) and put that filter in my tool, it is ok, but not great. After that When I run parallel jobs , I mean select the data by 4 jobs for different ranges(all at the same time), it is taking 4 times than normal time . In other words, I am not getting performance like Oracle or other data bases. I am new to Unidata, is there any method where I can get good access speeds on Unidata.Any help will be highly appreciated. thanks pbr -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Paragraphs in Files Other Than VOC
Simple create a file to contain your paragraphs create voc entries that then refer to that file and item(s) 0001. R 0002. paragraph.filename 0003. paragraph.itemname Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _ The quality of a person's life is in direct proportion to their commitment to excellence regardless of their chosen field of endeavor vince lombardi _ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor Sent: Monday, August 09, 2004 11:04 AM To: U2-Users List Subject: [U2] Paragraphs in Files Other Than VOC Is it possible to store paragraphs in files other than the VOC? I'm looking for a way to not clutter up the VOC with paragraphs... something like can be done with PROCs. Thanks. Perry Taylor Zirmed, Inc. CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Paragraphs in Files Other Than VOC
another option voc PETES.PROC 0001: PQ 0002: [PETE.BP PETES.PROC --+ +- | | | +- PROC NAME | +--- PROG LIB. 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] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Paragraphs in Files Other Than VOC
Use VOCLIB, a standard file, with a type R record in the VOC. Here is an example: R VOCLIB MY.PARAGRAPH.OR.PROGRAM.OR.VERB OPTIONAL.SECURITY.PROGRAM - Original Message - From: Perry Taylor [EMAIL PROTECTED] To: U2-Users List [EMAIL PROTECTED] Sent: Monday, August 09, 2004 11:04 AM Subject: [U2] Paragraphs in Files Other Than VOC Is it possible to store paragraphs in files other than the VOC? I'm looking for a way to not clutter up the VOC with paragraphs... something like can be done with PROCs. Thanks. Perry Taylor Zirmed, Inc. CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Paragraphs in Files Other Than VOC
Put the paragraph in another file, VOCLIB for example is provided. Then in the VOC put a remote pointer that has an R on line one, the file name on two, and the record ID in that file on line three. ID: MONTH_END 01: R 02: VOCLIB 03: MONTH_END See the System Description Manual for more details and examples. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Aug 9, 2004, at 8:04, Perry Taylor wrote: Is it possible to store paragraphs in files other than the VOC? I'm looking for a way to not clutter up the VOC with paragraphs... something like can be done with PROCs. Thanks. Perry Taylor Zirmed, Inc. CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Paragraphs in Files Other Than VOC
You can store them in the VOCLIB file, but you'll still need a remote pointer to it from within the VOC. VOCLIB record (named MY.REPORT for example): 0001: PA 0002: SETPTR 0003: SELECT... 0004: LIST 0005: etc. VOC record (MY.REPORT or other shortcut name you want to use): 0001: R 0002: VOCLIB 0003: MY.REPORT (points to the record in VOCLIB) The nice thing is it cuts down some clutter, although requires an additional read by UniVerse. |-+-- | | Perry Taylor | | | [EMAIL PROTECTED]| | | Sent by: | | | [EMAIL PROTECTED]| | | er.u2ug.org| | | | | | | | | 08/09/2004 11:04 AM| | | Please respond to | | | u2-users | | | | |-+-- | | | | To: U2-Users List [EMAIL PROTECTED] | | cc: | | Subject: [U2] Paragraphs in Files Other Than VOC | | Is it possible to store paragraphs in files other than the VOC? I'm looking for a way to not clutter up the VOC with paragraphs... something like can be done with PROCs. Thanks. Perry Taylor Zirmed, Inc. CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Paragraphs in Files Other Than VOC
You can create a remote pointer in the voc but you'll still have to have a minimal voc entry. It does cut down on the number of lines in the voc. The format is 001: R 002: PP 003: PA.ID Line 1, the letter R, means a remote pointer Line 2 is your other filename, PP was a default file used for such things in years past) Line 3 is the record id of your paragraph -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor Sent: Monday, August 09, 2004 11:04 AM To: U2-Users List Subject: [U2] Paragraphs in Files Other Than VOC Is it possible to store paragraphs in files other than the VOC? I'm looking for a way to not clutter up the VOC with paragraphs... something like can be done with PROCs. Thanks. Perry Taylor Zirmed, Inc. CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Question on Unidata tables access speeds
I am doing select with BRANCH = 0616 0844 AND LEASE_TYPE # RA Also What is AFAIK, how do we set it up for multiple connections ? thanks Brian Leach [EMAIL PROTECTED]To: [EMAIL PROTECTED] o.uk cc: Sent by: Subject: Re: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/09/2004 10:18 AM Please respond to u2-users That might explain why one query takes so long, but not the time for the four queries (unless he is out of resource). UniData can run multiple queries concurrently, but AFAIK only one per connection. So I guess the question is how DataStage is connecting to UniData, as it looks like DataStage is scheduling these sequentially. Brian On Mon, 9 Aug 2004 10:35:01 -0400 [EMAIL PROTECTED] wrote: You may want to try FILE.STAT and see if your file is properly sized. If not, then use the RESIZE command. Just my $0.001 worth. Grant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 10:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Question on Unidata tables access speeds It is indexed on the key column, even then if I run the run the job (query) 4 times in parallel, I am not getting advange of the parallel query. Is Unidata not good for the parallel query ?, or is there any tuning method ? thanks Kevin King [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: Subject: RE: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/08/2004 06:09 PM Please respond to u2-users Is anything indexed? Sounds like you could probably benefit from adding some indexes on fields used for the selection. That would make a BIG difference. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, August 08, 2004 3:57 PM To: [EMAIL PROTECTED] Subject: [U2] Question on Unidata tables access speeds Hi , Project data warehouse, Sources are Unidata tables, tool Datastage. Performance issue, while dumping in to hash file(Allowing stage write cash). It is searching 5.5 million rows and fetching 2.6 million rows and taking 2.5 hours. There is only one key column in the ouput. When I remove select caluse(I mean select all rows) and put that filter in my tool, it is ok, but not great. After that When I run parallel jobs , I mean select the data by 4 jobs for different ranges(all at the same time), it is taking 4 times than normal time . In other words, I am not getting performance like Oracle or other data bases. I am new to Unidata, is there any method where I can get good access speeds on Unidata.Any help will be highly appreciated. thanks pbr -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and
RE: [U2] Question on Unidata tables access speeds
AFAIK = acronym for As Far As I Know -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 11:30 AM To: [EMAIL PROTECTED] Subject: Re: [U2] Question on Unidata tables access speeds I am doing select with BRANCH = 0616 0844 AND LEASE_TYPE # RA Also What is AFAIK, how do we set it up for multiple connections ? thanks Brian Leach [EMAIL PROTECTED]To: [EMAIL PROTECTED] o.uk cc: Sent by: Subject: Re: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/09/2004 10:18 AM Please respond to u2-users That might explain why one query takes so long, but not the time for the four queries (unless he is out of resource). UniData can run multiple queries concurrently, but AFAIK only one per connection. So I guess the question is how DataStage is connecting to UniData, as it looks like DataStage is scheduling these sequentially. Brian On Mon, 9 Aug 2004 10:35:01 -0400 [EMAIL PROTECTED] wrote: You may want to try FILE.STAT and see if your file is properly sized. If not, then use the RESIZE command. Just my $0.001 worth. Grant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 10:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Question on Unidata tables access speeds It is indexed on the key column, even then if I run the run the job (query) 4 times in parallel, I am not getting advange of the parallel query. Is Unidata not good for the parallel query ?, or is there any tuning method ? thanks Kevin King [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: Subject: RE: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/08/2004 06:09 PM Please respond to u2-users Is anything indexed? Sounds like you could probably benefit from adding some indexes on fields used for the selection. That would make a BIG difference. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, August 08, 2004 3:57 PM To: [EMAIL PROTECTED] Subject: [U2] Question on Unidata tables access speeds Hi , Project data warehouse, Sources are Unidata tables, tool Datastage. Performance issue, while dumping in to hash file(Allowing stage write cash). It is searching 5.5 million rows and fetching 2.6 million rows and taking 2.5 hours. There is only one key column in the ouput. When I remove select caluse(I mean select all rows) and put that filter in my tool, it is ok, but not great. After that When I run parallel jobs , I mean select the data by 4 jobs for different ranges(all at the same time), it is taking 4 times than normal time . In other words, I am not getting performance like Oracle or other data bases. I am new to Unidata, is there any method where I can get good access speeds on Unidata.Any help will be highly appreciated. thanks pbr -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- --- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the
Re: [U2] Question on Unidata tables access speeds
Sorry it's a regular acronym not a product name: AFAIK = As Far As I Know Though it would make a good name for a data mining tool. There are some DataStage guys hanging around this list though I'm not sure of their time zone - any of you want to answer? Are you doing the select from within a datastage process, or could you run them off line and fetch a select list of the results? You might want to look up the following facilities of the database: PHANTOM - runs a command in the background e.g. PHANTOM SELECT MYFILE SAVE.LIST - this saves a list of record keys assembled by a selection under a specified name. GET.LIST - retrieves the list of record keys, as a prelude to further processing. e.g. SELECT MYFILE WITH MYFIELD = MYCRITERIA SAVE.LIST MYLIST (some time later) GET.LIST MYLIST I'm just wondering whether you could PHANTOM off the four selections outside of DataStage (e.g. from a cron or other scheduled job), and then pick up the resulting select lists in your DataStage process at a later point, once you know those have completed. I'm finishing up here for the day, but the others on the list can help you with select lists and phantoms. Regards Brian On Mon, 9 Aug 2004 11:29:45 -0500 [EMAIL PROTECTED] wrote: I am doing select with BRANCH = 0616 0844 AND LEASE_TYPE # RA Also What is AFAIK, how do we set it up for multiple connections ? thanks Brian Leach [EMAIL PROTECTED]To: [EMAIL PROTECTED] o.uk cc: Sent by: Subject: Re: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/09/2004 10:18 AM Please respond to u2-users That might explain why one query takes so long, but not the time for the four queries (unless he is out of resource). UniData can run multiple queries concurrently, but AFAIK only one per connection. So I guess the question is how DataStage is connecting to UniData, as it looks like DataStage is scheduling these sequentially. Brian On Mon, 9 Aug 2004 10:35:01 -0400 [EMAIL PROTECTED] wrote: You may want to try FILE.STAT and see if your file is properly sized. If not, then use the RESIZE command. Just my $0.001 worth. Grant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 10:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Question on Unidata tables access speeds It is indexed on the key column, even then if I run the run the job (query) 4 times in parallel, I am not getting advange of the parallel query. Is Unidata not good for the parallel query ?, or is there any tuning method ? thanks Kevin King [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: Subject: RE: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/08/2004 06:09 PM Please respond to u2-users Is anything indexed? Sounds like you could probably benefit from adding some indexes on fields used for the selection. That would make a BIG
RE: [U2] Question on Unidata tables access speeds
AFAIK = As Far As I Know You should be indexed on BRANCH and/or LEASE_TYPE, and based on the data a cascading select may a better way to get at the information quicker. I'm no expert on the index optimizer, so cascading selects may not be necessary, but it sure seems logical that if you index even on BRANCH and then select like this (below) you might get better responses: SELECT filename WITH BRANCH = 0616 0844 SELECT filename WITH LEASE_TYPE # RA Also, are BRANCH and LEASE_TYPE actual data fields or translates from another file? If these are translates it could seriously impact your select performance. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, August 09, 2004 10:30 AM To: [EMAIL PROTECTED] Subject: Re: [U2] Question on Unidata tables access speeds I am doing select with BRANCH = 0616 0844 AND LEASE_TYPE # RA Also What is AFAIK, how do we set it up for multiple connections ? thanks Brian Leach [EMAIL PROTECTED]To: [EMAIL PROTECTED] o.uk cc: Sent by: Subject: Re: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/09/2004 10:18 AM Please respond to u2-users That might explain why one query takes so long, but not the time for the four queries (unless he is out of resource). UniData can run multiple queries concurrently, but AFAIK only one per connection. So I guess the question is how DataStage is connecting to UniData, as it looks like DataStage is scheduling these sequentially. Brian On Mon, 9 Aug 2004 10:35:01 -0400 [EMAIL PROTECTED] wrote: You may want to try FILE.STAT and see if your file is properly sized. If not, then use the RESIZE command. Just my $0.001 worth. Grant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 10:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Question on Unidata tables access speeds It is indexed on the key column, even then if I run the run the job (query) 4 times in parallel, I am not getting advange of the parallel query. Is Unidata not good for the parallel query ?, or is there any tuning method ? thanks Kevin King [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: Subject: RE: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/08/2004 06:09 PM Please respond to u2-users Is anything indexed? Sounds like you could probably benefit from adding some indexes on fields used for the selection. That would make a BIG difference. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, August 08, 2004 3:57 PM To: [EMAIL PROTECTED] Subject: [U2] Question on Unidata tables access speeds Hi , Project data warehouse, Sources are Unidata tables, tool Datastage. Performance issue, while dumping in to hash file(Allowing stage write cash). It is searching 5.5 million rows and fetching 2.6 million rows and taking 2.5 hours. There is only one key column in the ouput. When I remove select caluse(I mean select all rows) and put that filter in my tool, it is ok, but not great. After that When I run parallel jobs , I mean select the data by 4 jobs for different ranges(all at the same time), it is taking 4 times than normal time . In other words, I am not getting performance like Oracle or other data bases. I am new to Unidata, is there any method where I can get good access speeds on Unidata.Any help will be highly appreciated. thanks pbr - - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. = = --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit
RE: [U2] Question on Unidata tables access speeds
Presumably BRANCH and LEASE_TYPE are indexed.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 09 August 2004 17:30 To: [EMAIL PROTECTED] Subject: Re: [U2] Question on Unidata tables access speeds I am doing select with BRANCH = 0616 0844 AND LEASE_TYPE # RA Also What is AFAIK, how do we set it up for multiple connections ? thanks Brian Leach [EMAIL PROTECTED]To: [EMAIL PROTECTED] o.uk cc: Sent by: Subject: Re: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/09/2004 10:18 AM Please respond to u2-users That might explain why one query takes so long, but not the time for the four queries (unless he is out of resource). UniData can run multiple queries concurrently, but AFAIK only one per connection. So I guess the question is how DataStage is connecting to UniData, as it looks like DataStage is scheduling these sequentially. Brian On Mon, 9 Aug 2004 10:35:01 -0400 [EMAIL PROTECTED] wrote: You may want to try FILE.STAT and see if your file is properly sized. If not, then use the RESIZE command. Just my $0.001 worth. Grant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 10:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Question on Unidata tables access speeds It is indexed on the key column, even then if I run the run the job (query) 4 times in parallel, I am not getting advange of the parallel query. Is Unidata not good for the parallel query ?, or is there any tuning method ? thanks Kevin King [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: Subject: RE: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/08/2004 06:09 PM Please respond to u2-users Is anything indexed? Sounds like you could probably benefit from adding some indexes on fields used for the selection. That would make a BIG difference. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, August 08, 2004 3:57 PM To: [EMAIL PROTECTED] Subject: [U2] Question on Unidata tables access speeds Hi , Project data warehouse, Sources are Unidata tables, tool Datastage. Performance issue, while dumping in to hash file(Allowing stage write cash). It is searching 5.5 million rows and fetching 2.6 million rows and taking 2.5 hours. There is only one key column in the ouput. When I remove select caluse(I mean select all rows) and put that filter in my tool, it is ok, but not great. After that When I run parallel jobs , I mean select the data by 4 jobs for different ranges(all at the same time), it is taking 4 times than normal time . In other words, I am not getting performance like Oracle or other data bases. I am new to Unidata, is there any method where I can get good access speeds on Unidata.Any help will be highly appreciated. thanks pbr -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- --- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner.
RE: [U2] Paragraphs in Files Other Than VOC
Looks like an R VOC record is the ticket! Thanks to all who responded! Perry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor Sent: Monday, August 09, 2004 9:04 AM To: U2-Users List Subject: [U2] Paragraphs in Files Other Than VOC Is it possible to store paragraphs in files other than the VOC? I'm looking for a way to not clutter up the VOC with paragraphs... something like can be done with PROCs. Thanks. Perry Taylor Zirmed, Inc. CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: U2 Users Digest V1 #175
2 Canadian cents. I use the local dictionaries to build a datastore I use to see if there are any relationships between Table A and Table B. Invaluable to learn table relationships and the use of primary and foreign keys on new sites. Also shows any interaction with interim tables while building the Foreign Key. Saves time setting up redundant translates, code reviews, debugging, etc. It sure would be nice to have a 'Best Utility' competition in the Universe world and present something at the International Spectrum conference. Maybe there is but I haven't heard about it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, August 08, 2004 1:05 AM To: [EMAIL PROTECTED] Subject: U2 Users Digest V1 #175 U2 Users Digest Sunday, August 8 2004 Volume 01 : Number 175 In this issue: Re: [U2] Adding D-Descriptors -- Date: Sat, 7 Aug 2004 13:33:57 -0400 From: Mark Johnson [EMAIL PROTECTED] Subject: Re: [U2] Adding D-Descriptors I'll toss out my 2 cents on this. I place a high degree on the accuracy of dict items. That is, they represent a consistent representation of the file layouts between MV flavours and different applications. Whether Eclipse, SB+, other 4GL's or green screen, they all hve this common denominator. Balancing many clients with their differnet environments, the dicts are my friend. I have a utility that I use against any file to match up the 'natural' dict items to their values and produce a 2 colum 40 field 'Form View' of any file. THis assist me greatly to learn and maintain a file outside of the app. We all know that field 39 on the screen isn't necessarily attr 39. Thus I have a bone to pick with any previous programmers who place data into a field without some dict item helping me. Sure the app works with REC39 but trying to locate within the programs how field 39 gets populated or what it stands for is a challenge. Dates are pretty obvious but that's about it. For VAR-level systems, I would consider it negligent to install a system with data in fields that have no dict items. I'm not talking temp-like files. I'm talking CUSTOMER, PRODUCT etc files. One in particular has 001=NAME and 004=CITY with nothing on 002 or 003. Sometimes it's obvious and other times it's not. What I dislike are multiple use files like RESULTS PRODUCT or SAS SR.CF where there truly more than one data design sharing the same file, depending on the key. Thus the dict items are dependent on which record they are using. Then and now there are 4GL's that use the dict items either directly or indirectly to hold parameters. This is a step towards the SQL based systems that require data definitions. Sure, we can exist without dict items. But it's a lot harder and goes against the original purpose and design of our beloved 'post-relational' database. My 2 cents. - - Original Message - From: Mike Randall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 07, 2004 1:02 AM Subject: RE: [U2] Adding D-Descriptors I guess it depends on who was at the controls at design time. I've seen some systems where the dictionaries were like bibles in their exactness. I've also seen the flipside of that. It all comes down to design and coding standards. I had the good fortune of starting my pick career with a software company (wy back in the prehistoric days) who emphasized standards and controls and it sort of stuck with me. Sometimes the only way to figure that stuff out is to do what you suggest and write utilities and manually go through code. Hopefully, you get some good code to look at. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Friday, August 06, 2004 6:42 AM To: [EMAIL PROTECTED] Subject: Re: [U2] Adding D-Descriptors Mike: Do you recommend a utility to 'scan' an application (progs procs) for the definitions. I use the dicts as they're all in one place and I can depend on it probably 85-90% of the time. I agree it isn't perfect like a 'normal' db would be for definitions. I remember older programs that would produce a summary of the WRITES, READS, DELETES etc on all the programs with filenames. Any clue. Unfortunately, the dicts are the best offering from the MV database, albiet with flaws. my 1 cent. - Original Message - From: Mike Randall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 12:33 PM Subject: RE: [U2] Adding D-Descriptors The records can have varying numbers of fields. From your comment about flaky data, my guess would be that you are using fields that are being written to someplace else other than what you added. Dictionaries have no impact on what Basic programs do. Fields may be written to a particular file and there doesn't have to be any dictionary present or the dict says the
RE: [U2] Question on Unidata tables access speeds
These are data fields. I found these fields are alternate keys too. My main problem is , I am not getting speeds for multiple query sppeds on the same table. Instead of parallesing, it is searilising. I am only wondering will there be any restrictions on the tables for the multiple queries ?, set up by Sys admin/DBA's . I will try out studying the Phantom also. thanks Kevin King [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: Subject: RE: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/09/2004 12:06 PM Please respond to u2-users AFAIK = As Far As I Know You should be indexed on BRANCH and/or LEASE_TYPE, and based on the data a cascading select may a better way to get at the information quicker. I'm no expert on the index optimizer, so cascading selects may not be necessary, but it sure seems logical that if you index even on BRANCH and then select like this (below) you might get better responses: SELECT filename WITH BRANCH = 0616 0844 SELECT filename WITH LEASE_TYPE # RA Also, are BRANCH and LEASE_TYPE actual data fields or translates from another file? If these are translates it could seriously impact your select performance. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, August 09, 2004 10:30 AM To: [EMAIL PROTECTED] Subject: Re: [U2] Question on Unidata tables access speeds I am doing select with BRANCH = 0616 0844 AND LEASE_TYPE # RA Also What is AFAIK, how do we set it up for multiple connections ? thanks Brian Leach [EMAIL PROTECTED]To: [EMAIL PROTECTED] o.uk cc: Sent by: Subject: Re: [U2] Question on Unidata tables access speeds [EMAIL PROTECTED] er.u2ug.org 08/09/2004 10:18 AM Please respond to u2-users That might explain why one query takes so long, but not the time for the four queries (unless he is out of resource). UniData can run multiple queries concurrently, but AFAIK only one per connection. So I guess the question is how DataStage is connecting to UniData, as it looks like DataStage is scheduling these sequentially. Brian On Mon, 9 Aug 2004 10:35:01 -0400 [EMAIL PROTECTED] wrote: You may want to try FILE.STAT and see if your file is properly sized. If not, then use the RESIZE command. Just my $0.001 worth. Grant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 10:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] Question on Unidata tables access speeds It is indexed on the key column, even then if I run the run the job (query) 4 times in parallel, I am not getting advange of the parallel query. Is Unidata not good for the parallel query ?, or is there any tuning method ? thanks Kevin King [EMAIL PROTECTED]To: [EMAIL PROTECTED]
Re: [U2] Paragraphs in Files Other Than VOC
In a message dated 8/9/04 10:27:30 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: Is it possible to store paragraphs in files other than the VOC? I'm looking for a way to not clutter up the VOC with paragraphs... something like can be done with PROCs. Thanks. Perry Taylor Zirmed, Inc. Yes there is and no you don't need a remote pointer. A hundred remote pointers to VOCLIB still constitute one hundred cluttering objects in your VOC. This is not necessary, if you are still interested in a simple solution that does not require pointers of this sort, let me know. Will Johnson Fast Forward --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniData Upgrade on AIX
I am going to upgrade an IBM RS/6000 with AIX 4.2.2 and UniData 5.1 to AIX 5.2.3 with UniData 6.0.8. While I have upgraded to UniData 6.0.X on AIX before, it has only been on AIX 4.3.3. I do know that AIX needs to be upgraded first to 4.3.3 and then to 5.2.3, however, I don't know if I need to be concerned with anything else. Any issues I may need to address? Is there anything significantly different with AIX 5.2.3 that needs more attention? Thanks. Regards, Jim --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData Upgrade on AIX
We did a similar upgrade not too long ago and these are the only notes I have from it: In @udthome/sys/UDTSPOOL.CONFIG the nhead option needs to be set to U_IGNORE instead of -o to stop it from using -o nobanner You can enter SETPTR 0 to see which options it is using. However, we use SB+ which pretty much eliminates the need to use setptr so this may not be a surprise for you Colin Alfke Support Specialist Thomson Elite 450, 800 - 6th Ave. S.W. Calgary, AB T2P 3G3 Tel: 403-237-7095 Fax: 403-237-7080 Email: [EMAIL PROTECTED] -Original Message- From: James Canale, Jr. [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 3:02 PM To: U2-Users List Subject: [U2] UniData Upgrade on AIX I am going to upgrade an IBM RS/6000 with AIX 4.2.2 and UniData 5.1 to AIX 5.2.3 with UniData 6.0.8. While I have upgraded to UniData 6.0.X on AIX before, it has only been on AIX 4.3.3. I do know that AIX needs to be upgraded first to 4.3.3 and then to 5.2.3, however, I don't know if I need to be concerned with anything else. Any issues I may need to address? Is there anything significantly different with AIX 5.2.3 that needs more attention? Thanks. Regards, Jim --- --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] U2 PE and which version of Linux
Hello, I have just downloaded the Universe and Unidata PE versions for Linux. However, I am not sure which version of Redhat Linux is required. Does anyone know. Thanks Eugene --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] AIX printers direct
Forwarded on behalf of a non-member ([EMAIL PROTECTED]): We have approximately 600 printers that will be attached to UniVerse 10.1.2 on AIX 5.2.3. We do not want to use the Unix spooler, but want to keep the spooled files in UniVerse so they can be managed by the SP commands. Every time we us lp driver the file ends up in the Unix spooler and we have lost control through the SP commands. These printers are HP type printers connected through our network. Does any one know of a Unix driver that will allow us to print to these devices without going through the Unix spooler (lp)? Thanks for you help Tom Dodds --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] UOJ/linux multivalue problem
David Beahm wrote: John- Sounds like the gotcha I ran into a few weeks ago, where the LANG environment variable has to be set to C when compiling and running Java. Unfortunately, changing this breaks other things in RedHat (desktop icons, etc.), so I ended up renaming java and javac and making bash script wrappers for them that set LANG=C. Thanks for pointing me in the right direction. At U2 support's suggestion I set LANG=en_US.iso885915. I changed the LANG variable setting in /etc/sysconfig/i18n on both the WebSphere app server and the UV server, then rebooted both. That took care of the problem. -John --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] AIX printers direct [AD]
Tom, How about the best of both worlds? Extended SPooler (ESP) keeps your jobs in UniVerse (or Unidata) for all management. Then you can print it through the Unix spooler so as to take advantage of all of those features if you want to. Contact information in the sig line below. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Aug 9, 2004, at 17:15, Moderator wrote: Forwarded on behalf of a non-member ([EMAIL PROTECTED]): We have approximately 600 printers that will be attached to UniVerse 10.1.2 on AIX 5.2.3. We do not want to use the Unix spooler, but want to keep the spooled files in UniVerse so they can be managed by the SP commands. Every time we us lp driver the file ends up in the Unix spooler and we have lost control through the SP commands. These printers are HP type printers connected through our network. Does any one know of a Unix driver that will allow us to print to these devices without going through the Unix spooler (lp)? Thanks for you help Tom Dodds --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] AIX printers direct
Here are 2 ways to connect the UV spooler
directly to your 600 network printers.
1. use hpnptyd to make a pseudo serial port device
(/dev/pt...) for each printer. This would usually
be done at boot time, with a separate hpnptyd
process for each port, and you must wait until
after all of those 600 processes have started,
before you start your 2 spoolers (AIX and uv).
2. use universe spooler driver scripts that set
the PRINTERNAME environment variable and that
then call a common driver script that does
something like
cat | hpnpf -x ${PRINTERNAME} -w 2${PRINTERNAME}.logfile
(you'll probably want some other stuff - - see the scripts
that get installed on AIX when you install jetadmin.)
***
My advice is to avoid both of the above methods.
Don't connect your 600 printers
directly to the UniVerse spooler.
You'll save time and money if you get a dedicated
Novell Netware print server.
Netware 6 isn't as simple as good old Netware 3, but,
for 600 printers, it would be your least cumbersome solution.
The Netware server could handle all of your print jobs, not
just the ones from UniVerse, but also the ones from other unix
applications, and the ones from Windows workstations and
Windows servers.
If not Netware, then get a Windows 2003 server (or you might
need a Windows server cluster) as a dedicated print server
for all Windows and Unix applications, including UniVerse.
Either way, using a Netware server or a Windows server (or
Windows cluster), is going to make print job management
easier than using the UniVerse and/or AIX spoolers.
***
The information contained in this e-mail message may be privileged
and confidential information and is intended only for the use of
the individual and/or entity identified in the alias address of
this message. If the reader of this message is not the intended
recipient, or an employee or agent responsible to deliver it to the
intended recipient, you are hereby requested not to distribute or
copy this communication. If you have received this communication in
error, please notify us immediately by telephone or return e-mail and
delete the original message from your system.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
