RE: [U2] Size of key question
Has this file always had 2 parts? Just wondering as I saw that if the other half of the file was around the same size, then the full file is well under 1Gb so, reducing the mod bringing into 1 part would eliminate overhead of distributing data into 2 files call to your routine on every read/write operation Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of roy Sent: Wednesday, 17 October 2007 11:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Size of key question _ From: Roy Beard [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 16, 2007 10:33 PM To: 'u2-users@listserver.u2ug.org' Subject: File key question Wow! I got so many ideas from this group that I thought I would give some more Information. This file is a distributed file in 2 parts The 3rd field (separated by *) determines which partfile with 1 going to the file I sent before and the rest going to this file There are no triggers on the file. The system was 'fast' until recently when tens of thousands of new records were added. I agree the file is poorly sized, it was an attempt to solve one problem but created another. The keys, I believe, are an issue Here is a sample SUMMARY*PRO*1*SUMMARY*CDJ*9876***WS 407*BAR*1*498*GLU*2274***SUMMARY 491*BAR*1*498*GLU*2274***SUMMARY SUMMARY*BAR*1*498*GLU*2274***SUMMARY 1896*BAR*1*498*GLU*2274***SUMMARY 460*BAR*1*498*GLU*2274***SUMMARY 1199*SUMMARY*1*465*432**** 1185*SUMMARY*1*412*ABE*SUMMARY***BLIN 3281*SUMMARY*1*412*ABE*SUMMARY***BLIN SUMMARY*SUMMARY*1*412*ABE*SUMMARY***BLIN SUMMARY*SUMMARY*1*450*HIR*SUMMARY***AMEL 3558*SUMMARY*1*450*HIR*SUMMARY***AMEL 3811*SUMMARY*1*450*HIR*SUMMARY***AMER SUMMARY*SUMMARY*1*450*HIR*SUMMARY***AMER 3558*SUMMARY*1*450*HIR*SUMMARY***AMER SUMMARY*CAG*1*429*LOR*1810***BURN 252*PON*1*640*SHE*FRT*** 2177*CS1*1*491*ABE*SUMMARY*** 590*PRO*1*491*JOR*SUMMARY***WW8RHH 3715*PRO*1*491*JOR*SUMMARY***WW8RHH Press any key to continue... Here is the file stat from the other half of the file File name = SALES-HIST-BRS File type = 18 Number of groups in file (modulo) = 317 Separation = 1 Number of records = 2071678 Number of physical bytes= 1894588928 Number of data bytes= 356514112 Average number of records per group = 0.6906 Average number of bytes per group = 118.8374 Minimum number of records in a group= 0 Maximum number of records in a group= 18032 Average number of bytes per record = 172.0895 Minimum number of bytes in a record = 64 Maximum number of bytes in a record = 2704 Average number of fields per record = 25.7575 Minimum number of fields per record = 11 Maximum number of fields per record = 41 Groups 25% 50% 75%100%125%150%175%200% full 2789365 44352 31348 23325 3311192219893 59402 Press any key to continue... I'll be working on this for a while. Any resize, copy etc. has such an impact on the system that my access is limited. Thanks for the input so far. Roy Roy C. Beard Distributor Solutions Inc P.O. Box 110520 Palm Bay, FL 32911-0520 321-956-6500 501-642-8698 Fax --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexing Optimization
FYI... This link has a nice summary of what the major RDBMS offer for the EXPLAIN output: http://www.aquafold.com/docs-ep-plan.html It would be nice to have a version of Aquafold (or one of the many similar multi-OS and multi-database 'aware' toolsets) available for UniVerse too...ah, one day - perhaps! Although there is a Generic ODBC/JDBC option (like similar tools). Although, I wouldn't say they'd be a huge demand for this sort of tool in the U2 environment. Regards, David --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] and PDF
What products are available to be able to create and manage Adobe pdf documents in a world of UniVerse, HP-Ux, and wIntegrate and Dynamic Connect clients? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] and PDF
htmldoc or html2ps with ghostscript. I use html2ps with gs on Linux to generate nearly all of our business paperwork and correspondence. HTML is an easy to maintain source format, IMO. Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: [EMAIL PROTECTED] Web: http://www.all-spec.com Blog: http://blog.all-spec.com -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, October 18, 2007 12:03 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] and PDF What products are available to be able to create and manage Adobe pdf documents in a world of UniVerse, HP-Ux, and wIntegrate and Dynamic Connect clients? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] and PDF
Here is a couple of products that come to mind. http://www.brianleach.co.uk/mvpdf.htm and http://www.cross.net.au/pdf.asp There a many others that are not mv aware such as http://www.acrosoftware.com/Index.htm http://www.versiontracker.com/dyn/moreinfo/win/23562 http://www.fineprint.com/ http://www.activepdf.com/products/serverproducts/toolkit/ http://www.verypdf.com/ If you google pdf you will get a basket load of hits. Ron White Brutzman, Bill wrote: What products are available to be able to create and manage Adobe pdf documents in a world of UniVerse, HP-Ux, and wIntegrate and Dynamic Connect clients? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] and PDF [not-secure]
For quite sometime I've gotten good results with letting the UV spooler hand off to a unix script. I convert the text to postscript using postprint, then use ps2pdf to distill the PDF. Total software cost = $0... Great for reports, etc. The real question is, do you want to take what you are producing NOW and convert them to PDF format, or do you want to start producing nice, glitzy things that become PDFs? Mark Hennessey -Original Message- What products are available to be able to create and manage Adobe pdf documents in a world of UniVerse, HP-Ux, and wIntegrate and Dynamic Connect clients? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] and PDF
We create postscript output, use a perl app in the DEVICE driver and use ghostscript Perl example $gs = gs -q -dNOPAUSE -dBATCH -sDEVICE=pdfwrite \-sOutputFile=$dest_path/$pdf\ -c .setpdfwrite -f \$src_path/$psfile\; -Vance - Original Message - From: Brutzman, Bill [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, October 18, 2007 12:03 PM Subject: [U2] and PDF What products are available to be able to create and manage Adobe pdf documents in a world of UniVerse, HP-Ux, and wIntegrate and Dynamic Connect clients? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
AD[U2] Timeout and the break key.
We can disable the break key for the normal users and log them out if the hit an error conditions, but we want something to control the idle time associated with the developers as well. AD This may not be what you wanted to hear, but we wrote/sell a product called LOGMON to handle your situation. It runs at the Unix level and monitors the CPU usage of all your users (and their child processes). Logmon can then log off idle users using criteria that you control. You can vary the inactivity time by user, time of day, etc. You can control how the user is logged off. And since it's at the Unix level, it can handle all users, whether Universe or Unidata or ... an ancient COBOL program ;-) For details, send an email to [EMAIL PROTECTED] or visit http://www.logmon.com Thanks! /AD --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] and PDF
On Thu, 18 Oct 2007, Brutzman, Bill wrote: What products are available to be able to create and manage Adobe pdf documents in a world of UniVerse, HP-Ux, and wIntegrate and Dynamic Connect clients? Print Wizard (our product) can do that. A key question for any of these products is this: how easy is it to specify what goes into the PDF? Print Wizard gives you these options: 1. Plain text (with CRs, LFs, maybe tabs, maybe even backspace-underlining and backspace-bolding) will be auto-fit to the page. Even print jobs without formfeeds will generally be paginated correctly. 2. PCL-5 files will be interpreted and rendered to PDF. This includes HP/GL, color, images, fonts, character sets, and emulation of cartridges with barcode and Chinese capabilities. If you have a PCL file that Print Wizard DOESN'T render correctly, please email it. 3. HTML. Print Wizard handles some, but not all, HTML files. 4. Print Wizard Markup Language (PWML). This is our version, based on HTML, plus control of many things HTML doesn't address, including orientation, paper size, barcodes, precise placement, rotated text, and more. With all of these, it is also possible to add a form image (an overlay or background), in any of several file formats. Note that Print Wizard runs on a Windows platform. However, we support several protocols for routing Unix/Linux jobs to the Windows PC where PW is running. See website for more. Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: [EMAIL PROTECTED] company e-mail: [EMAIL PROTECTED] voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] and PDF
On 10/18/07, Brutzman, Bill [EMAIL PROTECTED] wrote: What products are available to be able to create and manage Adobe pdf documents in a world of UniVerse, HP-Ux, and wIntegrate and Dynamic Connect clients? The perl module pdf::api2 is pretty easy to use once you get past the lack of documentation. You can do some pretty slick things with the different boxes. I feed data documents built by a BP program to a perl script which formats a nifty PDF for invoices, order confirmations and the like. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/