RE: [U2] UniData 7.1 vs. MS SQL 2005 performance
IBM AS400 developed a new transaction spec that suited the strengths of their product. We should create on that suits the U2 model. Unfortunately it will not be supported by IBM when it embarrasses DB2 Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] system builder question(s)
Doug, see the IBM website. U2/SB+ trial software: http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=u2trial s Documentation including SBSolutions (Kevin King's book): http://www-306.ibm.com/software/data/u2/pubs/library/ >1. are there any "trial/restricted version of system builder available >for linux? >2. are there any good system builder books/turtorials/web sites >available ** 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 communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData 7.1 vs. MS SQL 2005 performance
I do understand the advantages to that approach, Nick. But that was also the thinking of those who prepared the current industry benchmarks by locking in on SQL. My concern was that if you specify technologies, you can make it difficult for solutions that are outside the box. --dawn On 7/16/07, Nick Cipollina <[EMAIL PROTECTED]> wrote: If the consumer of this data is going to be external, then I would definitely use web services. Using a standard format (SOAP) will make it possible for anyone to consume the data. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn Wolthuis Sent: Monday, July 16, 2007 4:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance Yes, agreed. I think if you start with user requirements for services, then have folks design for those requirements according to each environment, that would be a good start. I hesitate to say that it must be "web services" only because that might imply use of SOAP or an XML exchange that could prejudice the implementation, but otherwise defining the requirements as services makes a lot of sense. Each service implementation in different environments can then be judged and compared by a variety of measures. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData 7.1 vs. MS SQL 2005 performance
If the consumer of this data is going to be external, then I would definitely use web services. Using a standard format (SOAP) will make it possible for anyone to consume the data. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn Wolthuis Sent: Monday, July 16, 2007 4:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance Yes, agreed. I think if you start with user requirements for services, then have folks design for those requirements according to each environment, that would be a good start. I hesitate to say that it must be "web services" only because that might imply use of SOAP or an XML exchange that could prejudice the implementation, but otherwise defining the requirements as services makes a lot of sense. Each service implementation in different environments can then be judged and compared by a variety of measures. I'm starting to get that "fear of being tossed to u2-community" vibe when typing this... Time for some chocolate, perhaps. --dawn On 7/16/07, Marc Harbeson <[EMAIL PROTECTED]> wrote: > That's why I suggested a web service method - by which each db could > employ whatever methodologies they have available - where the front end > could run the same transaction sets thru different back end API sets. > > An example API might be "Book Order" or "Ship Order" for example. > > I would imagine a full suite of transaction tests would also include the > transactions to populate a "test" database with objects such as > "Customers" "Items" etc etc. > > Just a thought. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey > Mitchell > Sent: Monday, July 16, 2007 2:47 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance > > > How does not being able to know how the data is stored prohibit > empirical testing? As long as you can provide inputs to a system and > retrieve outputs you can perform empirical tests. > > -- > Geoffrey Mitchell > Programmer/Analyst > Home Decorator's Collection > 314-684-1062 > --- > 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/ > -- Dawn M. Wolthuis Tincat Group, Inc. tincat-group.com Take and give some delight today --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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. 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData 7.1 vs. MS SQL 2005 performance
phil walker wrote: > Why do that? > As long as the discussion is technical and relates to U2. Personally I agree, but there are times when some discussions fork into technical but very narrow directions. OK, proposal withdrawn, thanks. T --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData 7.1 vs. MS SQL 2005 performance
And to keep the discussion thread in the same set of archives. IMO, Clif On Jul 16, 2007, at 4:22 PM, Tom Dodds wrote: I think they should remain here to the benefit of all U2 members. Just my 2 cents worth. Tom Dodds InformCorp, LLC "Information for Corporations" [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Monday, July 16, 2007 5:54 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Dawn wrote: I'm starting to get that "fear of being tossed to u2-community" vibe when typing this... Time for some chocolate, perhaps. --dawn I don't think this is a u2-community discussion. I've been contacted by a few people who have found the discussions (benchmarks, web services, and relational data exchanges) very helpful. However, to avoid bothering people with a focused discussion about which they're not interested, I will offer to take these ongoing technical discussions to a forum on my website or a separate email list. I'll post a note here as soon as I have the forum setup. Regards, T --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData 7.1 vs. MS SQL 2005 performance
Tony, Why do that? As long as the discussion is technical and relates to U2. There is plenty of stuff a lot of people on this list are probably not interested in but it still percolates on the list/forum so to speak. Personally I just filter it out. As long as the Subject is well specified you can skip what does not interest you. This stuff is very important, as U2 will NEVER survive in a U2 only world as other products are too entrenched in the wider world. U2/PICK people can beat their drums as much as they like, but they will NEVER win that war. Rather, we must work together with the outside world and show that U2 can play an important part. Remember that you should be trying to implement business solutions not technical ones, and sometimes there are other products which may be better/or at least have more support/development happening to do a job. Just my 2c worth... Phil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Tuesday, 17 July 2007 11:31 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Dawn wrote: > I'm starting to get that "fear of being tossed to u2-community" vibe > when typing this... Time for some chocolate, perhaps. --dawn I don't think this is a u2-community discussion. I've been contacted by a few people who have found the discussions (benchmarks, web services, and relational data exchanges) very helpful. However, to avoid bothering people with a focused discussion about which they're not interested, I will offer to take these ongoing technical discussions to a forum on my website or a separate email list. I'll post a note here as soon as I have the forum setup. Regards, T --- 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] UniData 7.1 vs. MS SQL 2005 performance
I think they should remain here to the benefit of all U2 members. Just my 2 cents worth. Tom Dodds InformCorp, LLC "Information for Corporations" [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Monday, July 16, 2007 5:54 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Dawn wrote: > I'm starting to get that "fear of being tossed to u2-community" vibe > when typing this... Time for some chocolate, perhaps. --dawn I don't think this is a u2-community discussion. I've been contacted by a few people who have found the discussions (benchmarks, web services, and relational data exchanges) very helpful. However, to avoid bothering people with a focused discussion about which they're not interested, I will offer to take these ongoing technical discussions to a forum on my website or a separate email list. I'll post a note here as soon as I have the forum setup. Regards, T --- 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] UniData 7.1 vs. MS SQL 2005 performance
Dawn wrote: > I'm starting to get that "fear of being tossed to u2-community" vibe > when typing this... Time for some chocolate, perhaps. --dawn I don't think this is a u2-community discussion. I've been contacted by a few people who have found the discussions (benchmarks, web services, and relational data exchanges) very helpful. However, to avoid bothering people with a focused discussion about which they're not interested, I will offer to take these ongoing technical discussions to a forum on my website or a separate email list. I'll post a note here as soon as I have the forum setup. Regards, T --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData 7.1 vs. MS SQL 2005 performance
I agree with Geoffrey, Wol. It would not be pretty, but one could presumably build a "Nelson-Pick datamodel" on top of data stored as relational data are today (easier to put a relational model on PIck since PIck is more fully featured). There is some tight-coupling between the logical and physical data models in Pick (as there also is in RDBMS's), but I really do not think that relational theory prohibts benchmarks. Most of the zealots in the relational world would consider MV/Pick/U2 very flawed, which is why benchmarks are developed for SQL-DBMS's, ignoring all of the others. I predict (0.8) that the industry will broaden its view within the coming decade, as it has started to do so already, even if not enough. Any company that has an RDBMS tool with significant associated revenue, such as Oracle, Microsoft, and IBM, is not going to shake up this part of the industry soon, but each is making some baby steps to pull away from caring about strict relational (aka exclusively set-based) processing. Unless one of these is going to do something bold in their marketing, the impetus will need to come from outside the big 3 DB vendors. Cheers! --dawn -- Dawn M. Wolthuis Tincat Group, Inc. tincat-group.com Take and give some delight today On 7/16/07, Geoffrey Mitchell <[EMAIL PROTECTED]> wrote: > Read Codd and & Date's rules. Can't remember which, but one of them > says "the database user is not permitted to know how the database > stores the data". In other words, empirical testing is FORBIDDEN. > Seeing as empirical testing is *the* "sine qua non" of science, > relational databases are, BY DEFINITION, totally unscientific. > > So, if you want a benchmark, relational database theory explicitly > says "No way, Jose!" !!! > How does not being able to know how the data is stored prohibit empirical testing? As long as you can provide inputs to a system and retrieve outputs you can perform empirical tests. -- Geoffrey Mitchell Programmer/Analyst Home Decorator's Collection 314-684-1062 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV sentence stack
In reply to a previous question (the e-mail of which I've already deleted--oops), the current sentence stack is accessible from UV Basic in system(33). Note, however, that the documentation in both the 10.2 manual (the only one I checked) and the 10.2 online help is incorrect. It states that system(33) "Returns the last command on the command stack." In fact, the entire stack is returned using @fm as the delimiter. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ $uv UniVerse Command Language 10.2 (c) Copyright IBM Corporation 2006. All rights reserved. coliver logged on: Mon Jul 16 13:53:08 2007 DEC vt200/vt220 8 bit terminal (vt220) >.l 01 LOGIN >who 29 coliver >TIME 14:25:14 16 JUL 2007 >ED BP SYSTEM33 7 lines long. : P 0001: dyn = system(33) 0002: dynNdxLast = dcount(dyn, @fm) 0003: for dynNdx = 1 to dynNdxLast 0004: crt fmt(dynNdx, "R## ") : dyn 0005: next dynNdx 0006: stop 0007:end Bottom at line 7. : EX >RUN BP SYSTEM33 1 RUN BP SYSTEM33 2 ED BP SYSTEM33 3 TIME 4 who 5 LOGIN --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData 7.1 vs. MS SQL 2005 performance
Yes, agreed. I think if you start with user requirements for services, then have folks design for those requirements according to each environment, that would be a good start. I hesitate to say that it must be "web services" only because that might imply use of SOAP or an XML exchange that could prejudice the implementation, but otherwise defining the requirements as services makes a lot of sense. Each service implementation in different environments can then be judged and compared by a variety of measures. I'm starting to get that "fear of being tossed to u2-community" vibe when typing this... Time for some chocolate, perhaps. --dawn On 7/16/07, Marc Harbeson <[EMAIL PROTECTED]> wrote: That's why I suggested a web service method - by which each db could employ whatever methodologies they have available - where the front end could run the same transaction sets thru different back end API sets. An example API might be "Book Order" or "Ship Order" for example. I would imagine a full suite of transaction tests would also include the transactions to populate a "test" database with objects such as "Customers" "Items" etc etc. Just a thought. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey Mitchell Sent: Monday, July 16, 2007 2:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance How does not being able to know how the data is stored prohibit empirical testing? As long as you can provide inputs to a system and retrieve outputs you can perform empirical tests. -- Geoffrey Mitchell Programmer/Analyst Home Decorator's Collection 314-684-1062 --- 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/ -- Dawn M. Wolthuis Tincat Group, Inc. tincat-group.com Take and give some delight today --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV - Available memory exceeded [not-secure]
Or monster large "records," typically out of a type 1 or 19 file. Example would be trying to ED &PH& GAZILLION_LINE_FILE. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Jul 16, 2007, at 12:27 PM, Jeff Fitzgerald wrote: Mark, This is perhaps grasping at straws and likely not the cause, but... We've seen this type of behavior "available memory exceeded" with (1) aborted resizes -- resize bits are left set and can cause attempts to reopen the file in a loop, eventually filling up the stack space, and (2) damaged files with bad linkages / record headers. If there might be common files used by the dying processes it sure wouldn't hurt to run diagnostics on them (or FAST). Just a thought... Jeff Fitzgerald Fitzgerald & Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark F. Sent: Monday, July 16, 2007 12:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV - Available memory exceeded [not-secure] My apologies for my previous attempt. --- UV 10.0.8, Solaris 8... On Thursday and Friday night we've had our system grind to a halt with 'Available memory exceeded' messages... At first blush I would think I should have to increase max shared memory (shminfo_shmmax for Solaris), but I've got a fairly large value all ready (536870912, or 512mb). I am seeing errors in /var/adm/messages that coincide with the failures. However they warn of swap space deficiencies... for example: Jul 12 22:43:55 ccses genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 22440 (uvsh) Jul 12 22:43:55 ccses last message repeated 9 times I found the &PH& entry for a job that had the above PID. The job up and died with out giving any error messages. The job is not new, and had been running every night without incident. I plan on having our normal nightly processing run tonight, with the exception of the one suspect job. Any thoughts or suggestions? Mark Hennessey State of Connecticut Department of Social Services Information Technology Services Child Support Systems Voice: 860-424-5261 Fax: 860-424-4813 --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] system builder question(s)
Kevin's book is the best, although I don't think you can get it from him anymore. I think you can get it from IBM though. Steve> Date: Mon, 16 Jul 2007 12:54:16 -0500> From: [EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org> Subject: [U2] system builder question(s)> > Hey all,> I have a couple of system builder questions> > 1. are there any "trial/restricted version of system builder available > for linux?> 2. are there any good system builder books/turtorials/web sites > available ( I know that Kevin King (aka the system builder guru) may > have one out and by praising him he might be able to sell me one > > thanks in advance!> > dougc> > -- > When you are SURE that everything in your program is correct > AND your program STILL DOES NOT work, one thing you can be > sure of is that something you are sure of is wrong > - unknown> ---> 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] UniData 7.1 vs. MS SQL 2005 performance
That's why I suggested a web service method - by which each db could employ whatever methodologies they have available - where the front end could run the same transaction sets thru different back end API sets. An example API might be "Book Order" or "Ship Order" for example. I would imagine a full suite of transaction tests would also include the transactions to populate a "test" database with objects such as "Customers" "Items" etc etc. Just a thought. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey Mitchell Sent: Monday, July 16, 2007 2:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance How does not being able to know how the data is stored prohibit empirical testing? As long as you can provide inputs to a system and retrieve outputs you can perform empirical tests. -- Geoffrey Mitchell Programmer/Analyst Home Decorator's Collection 314-684-1062 --- 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] [UV] Stacker commands
It's only in the &SAVEDLISTS& file after you log out. While you are processing it is in one of the SYSTEM() fields. -Original Message- From: David Ward [mailto:[EMAIL PROTECTED] Sent: Monday, July 16, 2007 2:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Stacker commands &SAVEDLISTS& -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. Sent: Monday, July 16, 2007 1:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Stacker commands Hello, When the .L command is done at the TCL level, the last executed commands are shown. Anyone here know where those commands are stored ? Jacques G. Pinpoint customers who are looking for what you sell. http://searchmarketing.yahoo.com/ --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData 7.1 vs. MS SQL 2005 performance
Read Codd and & Date's rules. Can't remember which, but one of them says "the database user is not permitted to know how the database stores the data". In other words, empirical testing is FORBIDDEN. Seeing as empirical testing is *the* "sine qua non" of science, relational databases are, BY DEFINITION, totally unscientific. So, if you want a benchmark, relational database theory explicitly says "No way, Jose!" !!! How does not being able to know how the data is stored prohibit empirical testing? As long as you can provide inputs to a system and retrieve outputs you can perform empirical tests. -- Geoffrey Mitchell Programmer/Analyst Home Decorator's Collection 314-684-1062 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Available memory exceeded [not-secure]
Mark, This is perhaps grasping at straws and likely not the cause, but... We've seen this type of behavior "available memory exceeded" with (1) aborted resizes -- resize bits are left set and can cause attempts to reopen the file in a loop, eventually filling up the stack space, and (2) damaged files with bad linkages / record headers. If there might be common files used by the dying processes it sure wouldn't hurt to run diagnostics on them (or FAST). Just a thought... Jeff Fitzgerald Fitzgerald & Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark F. Sent: Monday, July 16, 2007 12:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV - Available memory exceeded [not-secure] My apologies for my previous attempt. --- UV 10.0.8, Solaris 8... On Thursday and Friday night we've had our system grind to a halt with 'Available memory exceeded' messages... At first blush I would think I should have to increase max shared memory (shminfo_shmmax for Solaris), but I've got a fairly large value all ready (536870912, or 512mb). I am seeing errors in /var/adm/messages that coincide with the failures. However they warn of swap space deficiencies... for example: Jul 12 22:43:55 ccses genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 22440 (uvsh) Jul 12 22:43:55 ccses last message repeated 9 times I found the &PH& entry for a job that had the above PID. The job up and died with out giving any error messages. The job is not new, and had been running every night without incident. I plan on having our normal nightly processing run tonight, with the exception of the one suspect job. Any thoughts or suggestions? Mark Hennessey State of Connecticut Department of Social Services Information Technology Services Child Support Systems Voice: 860-424-5261 Fax: 860-424-4813 --- 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] UV - Available memory exceeded [not-secure]
I apologize for the in box litter. Unless I "opt out" by placing "not-secure" in the subject line of an e-mail, our Tumbleweed secure transport e-mail server may intercept a message based upon arcane policies that re-direct seemingly innocuous messages, yet will allow a message like 'the root password for the web server is donttellanyone!' to sail right through... Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jerry Banker Sent: Monday, July 16, 2007 2:19 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV - Available memory exceeded Is this some kind of virus? -Original Message- From: mark.hennessey [mailto:[EMAIL PROTECTED] Sent: Monday, July 16, 2007 12:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV - Available memory exceeded You have received an important delivery from mark.hennessey Please pick up the package at the following Web address: https://smail.ct.gov/ime?x=4-271240-178878-SS932YZF - snipped - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] HP Risc->Itanium
We have been on Itanium with HP-Ux 11i v2 for perhaps one year. We migrated from HP-Ux v10, UniVerse 8.3.3. The only hurdle with the migration was checking that all of the applications would run. Amazingly, there is no need to re-compile UniBasic code. There were some issues with dictionaries... legacy junk in the dict SQL field <8> that we were not using anyway. Field <8> had to be purged from all of the dictionaries. If dict field <8> had contraband, retreive paragraph scripts would not run. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stevenson, Charles Sent: Monday, July 16, 2007 12:53 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV10.0.16->10.2.x; HP Risc->Itanium; hpux 11.11->11.23 Seeking advice, warnings, testimonials. We are considering moving from HP's RISC platform to their new "Itanium" hardware. This implies a unix upgrade (from HPUX 11.11 to 11.23). Our current uv10.0.16 is not certified for hpux11.23, so I must upgrade to 10.1 or 10.2. & Redback 4.2.3 to at least 4.2.6. I am thinking of going to as modern a version of UV as advisable. Any gotchas going from: - UV 10.0 to 10.2? - would you advise 10.1 instead of 10.2? - hpux 11.11 to 11.23 ? - Risc to Itanium ? - Redback (aka "WDE"): minimal to 4.2.6? Or jump to 4.4? Only 4.3? Any communication on- or off-list is welcome. Thank-you, Charles Stevenson DBA, Getronics, Inc. 714-641-5943 [EMAIL PROTECTED] --- 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] [UV] Stacker commands
@COMMAND.STACK. Yot can also use SAVE.STACK and GET.STACK commands to put them into &SAVEDLISTS& From: Jacques G. >When the .L command is done at the TCL level, the last executed > commands are shown. Anyone here know where those commands are > stored ? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Stacker commands
&SAVEDLISTS& -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. Sent: Monday, July 16, 2007 1:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Stacker commands Hello, When the .L command is done at the TCL level, the last executed commands are shown. Anyone here know where those commands are stored ? Jacques G. Pinpoint customers who are looking for what you sell. http://searchmarketing.yahoo.com/ --- 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] [UV] Stacker commands
On universe you can get at the command stack with SYSTEM(33) from basic, but I don't know that they are stored anywhere accessable from other processes. (unidata saves the stack somewhere, as does D3, but some people think that is a security hole--though no worse than TANDEM). You can purposely save them somewhere with .S and restore with .R > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. > Sent: Monday, July 16, 2007 2:35 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] [UV] Stacker commands > > > Hello, > > When the .L command is done at the TCL level, the last > executed commands are shown. Anyone here know where those > commands are stored ? > > Jacques G. > > > > __ > __ > Pinpoint customers who are looking for what you sell. > http://searchmarketing.yahoo.com/ > --- > 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/
[U2] UV - Available memory exceeded [not-secure]
My apologies for my previous attempt. --- UV 10.0.8, Solaris 8... On Thursday and Friday night we've had our system grind to a halt with 'Available memory exceeded' messages... At first blush I would think I should have to increase max shared memory (shminfo_shmmax for Solaris), but I've got a fairly large value all ready (536870912, or 512mb). I am seeing errors in /var/adm/messages that coincide with the failures. However they warn of swap space deficiencies... for example: Jul 12 22:43:55 ccses genunix: [ID 470503 kern.warning] WARNING: Sorry, no swap space to grow stack for pid 22440 (uvsh) Jul 12 22:43:55 ccses last message repeated 9 times I found the &PH& entry for a job that had the above PID. The job up and died with out giving any error messages. The job is not new, and had been running every night without incident. I plan on having our normal nightly processing run tonight, with the exception of the one suspect job. Any thoughts or suggestions? Mark Hennessey State of Connecticut Department of Social Services Information Technology Services Child Support Systems Voice: 860-424-5261 Fax: 860-424-4813 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] system builder question(s)
Hey all, I have a couple of system builder questions 1. are there any "trial/restricted version of system builder available for linux? 2. are there any good system builder books/turtorials/web sites available ( I know that Kevin King (aka the system builder guru) may have one out and by praising him he might be able to sell me one thanks in advance! dougc -- When you are SURE that everything in your program is correct AND your program STILL DOES NOT work, one thing you can be sure of is that something you are sure of is wrong - unknown --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Stacker commands
On Unix check the user's home directory. Ours are listed as .ustk_username. On Windows, they are in the c:\ibm\udversion\cmdstack directory. Dawn Janel Davis DBA II [EMAIL PROTECTED] 410-386-8058 Carroll Community College 1601 Washington Road Westminster, MD 21157 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. Sent: Monday, July 16, 2007 2:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Stacker commands Hello, When the .L command is done at the TCL level, the last executed commands are shown. Anyone here know where those commands are stored ? Jacques G. Pinpoint customers who are looking for what you sell. http://searchmarketing.yahoo.com/ --- 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] [UV] Stacker commands
Look in &SAVEDLISTS& for items beginning with && They are &&S.logname.TTY# and contain 99 lines, depending on whether the tunable is left at the default in uvconfig. HTH Karl > Hello, > > When the .L command is done at the TCL level, the last executed commands > are shown. Anyone here know where those commands are stored ? > > Jacques G. > > > > > Pinpoint customers who are looking for what you sell. > http://searchmarketing.yahoo.com/ > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 "To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it." --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Stacker commands
Hello, When the .L command is done at the TCL level, the last executed commands are shown. Anyone here know where those commands are stored ? Jacques G. Pinpoint customers who are looking for what you sell. http://searchmarketing.yahoo.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Available memory exceeded
Is this some kind of virus? -Original Message- From: mark.hennessey [mailto:[EMAIL PROTECTED] Sent: Monday, July 16, 2007 12:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV - Available memory exceeded You have received an important delivery from mark.hennessey Please pick up the package at the following Web address: https://smail.ct.gov/ime?x=4-271240-178878-SS932YZF The package will expire on Wednesday August 15, 2007 at 13:22:42 EDT4 .. Need help picking up your package? * If the Web address above is highlighted, click on it to open a browser window. You will automatically be taken to the package. * If the Web address above is not highlighted, follow these steps: - Open a Web browser window. - Copy and paste the entire Web address into the "location" or "address" bar of the browser. - Press enter. ___ Delivered with IME(TM) http://www.tumbleweed.com IME is a trademark of Tumbleweed Communications Corp. --- 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] EDI PROGRAM
Contact Dave Taylor at SysMark Information Systems - same company that provides SpoolerPlus and other products - and see their website for info. DaveT-atsign-sysmarkinfo.com HTH T Barry Rogen wrote: > Can anybody suggest a proven, top drawer EDI translator package. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV - Available memory exceeded
You have received an important delivery from mark.hennessey Please pick up the package at the following Web address: https://smail.ct.gov/ime?x=4-271240-178878-SS932YZF The package will expire on Wednesday August 15, 2007 at 13:22:42 EDT4 .. Need help picking up your package? * If the Web address above is highlighted, click on it to open a browser window. You will automatically be taken to the package. * If the Web address above is not highlighted, follow these steps: - Open a Web browser window. - Copy and paste the entire Web address into the "location" or "address" bar of the browser. - Press enter. ___ Delivered with IME(TM) http://www.tumbleweed.com IME is a trademark of Tumbleweed Communications Corp. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV10.0.16->10.2.x; HP Risc->Itanium; hpux 11.11->11.23
Seeking advice, warnings, testimonials. We are considering moving from HP's RISC platform to their new "Itanium" hardware. This implies a unix upgrade (from HPUX 11.11 to 11.23). Our current uv10.0.16 is not certified for hpux11.23, so I must upgrade to 10.1 or 10.2. & Redback 4.2.3 to at least 4.2.6. I am thinking of going to as modern a version of UV as advisable. Any gotchas going from: - UV 10.0 to 10.2? - would you advise 10.1 instead of 10.2? - hpux 11.11 to 11.23 ? - Risc to Itanium ? - Redback (aka "WDE"): minimal to 4.2.6? Or jump to 4.4? Only 4.3? Any communication on- or off-list is welcome. Thank-you, Charles Stevenson DBA, Getronics, Inc. 714-641-5943 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] EDI Program
I wrote a program that works with www.J-Com.com EDI. The end-user does his regular shipping screen in wIntegrate. When packing parts for the EDI customer, the program creates an ASCII text file (ASN) per the J-Com spec. After the truck picks up the shipment, we FTP the ASN to J-Com. J-Com has a bunch of things that are worth considering. We are also using www.AITsystems.com. I would be happy to discuss it further... Regards, Bill Brutzman Manager, IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644 973.471.7770 x145 .voice 973.471.9666 .fax [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Rogen Sent: Monday, July 16, 2007 8:44 AM To: u2-users@listserver.u2ug.org Subject: [U2] EDI PROGRAM To all, Can anybody suggest a proven, top drawer EDI translator package. We are currently on an antiquated solution that has more bandaids on it than a patient in an Army MASH. Forst choice would be a U2 based solution but this is nore required./ It really must be very capable and flexible because our (customer's) EDI demands are high and broadbased Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Unidata Printing Question
The Windows print driver would be used in this case. If you are sending control codes to the printer from Unidata then you will probably have to set the print driver up for RAW mode. Jerry -Original Message- From: Dave [mailto:[EMAIL PROTECTED] Sent: Saturday, July 14, 2007 10:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: Unidata Printing Question Unidata on Windows 2003. Jerry Banker <[EMAIL PROTECTED]> wrote: What are you running? -Original Message- From: KidFromBrooklyn [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 3:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Unidata Printing Question We tried different settings. Do you have any other ideas ? Jerry Banker wrote: > > Either your printers internal setup is different or the driver/script > you are using on your system is different from the others. All I can say > is, you have to do some changes to one or the other. > > -Original Message- > From: Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, July 13, 2007 10:32 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] Unidata Printing Question > > We have one HP printer here that is acting weird. > > When I enter "SORT CUSTOMERS LPTR" at TCL all of the printers here > format the report properly. The font is compressed. > > One HP printer does not print compressed and page breaks prematurely. > > We are also running SB + here. > > > > - > Get the Yahoo! toolbar and be alerted to new email wherever you're > surfing. > --- > 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/ > > -- View this message in context: http://www.nabble.com/Unidata-Printing-Question-tf4075390.html#a11586905 Sent from the U2 - Users mailing list archive at Nabble.com. --- 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/ - Pinpoint customers who are looking for what you sell. --- 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] EDI PROGRAM
Barry, [AD] Contact Camry Group (Todd Miller) and ask about PiE. Camry: (631) 963-0060 [/AD] I've worked with it at several clients and I've worked with Todd several times. -- Charles Barouch [EMAIL PROTECTED] - Consulting (718) 762-3884x1 Barry Rogen wrote: | Can anybody suggest a proven, top drawer EDI translator package. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] EDI PROGRAM
To all, Can anybody suggest a proven, top drawer EDI translator package. We are currently on an antiquated solution that has more bandaids on it than a patient in an Army MASH. Forst choice would be a U2 based solution but this is nore required./ It really must be very capable and flexible because our (customer's) EDI demands are high and broadbased Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData 7.1 vs. MS SQL 2005 performance
David Jordan wrote:
> Tony
>
> One thing, and I may be wrong, is that MV.Net is about accessing the
> database directly. This puts Multivalue in the same bucket as other
> RDBMS in performance.
David, mv.NET is a suite of three libraries, and there's more than one way
to run a program. Specific to your comments, we can do this:
mvAccountObject.CallProg("BASIC.program.name",arg1,arg2,...)
and that will execute any BASIC subroutine on the server just like any
server-side BASIC program doing a call. This is similar to a UniObjects
UniSubroutine call.
We can also Execute a TCL command, capturing and returning data just as we
do from server-side BASIC.
This sort of code would only be used where a client-side interface is
required. Relational databases can accept command-line queries just like
MV can, and we'd really be after server-side numbers anyway. But when
people say "how fast is it", they might want to know so that they can
extract data into some remote client - it wouldn't be good to have fast
server numbers and poor data transmission numbers, or in the case of QM to
not be accessible (natively) via ODBC/OLEDB at all. Since every MV
platform has different external interfaces, I'm suggesting mv.NET as one
possible standard by which all MV platforms can participate in
client-interface testing like this.
> An area of efficiency and capability of U2 is in the Basic programs
> within U2. We need to access those from .Net as we would a stored
> procedure in SQL Server.
A stored procedure in SQL Server is defined with:
CREATE PROCEDURE [dbo].[ProcName] (params...) AS
INSERT INTO ...
And then they do this:
SqlCommand cmd = new SqlCommand("ProcName",connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
... // set parameters
rows = cmd.ExecuteNonQuery();
We use BASIC to OPEN and WRITE files as our "stored procedures". And we
can call to BASIC subroutines using the same ADO.NET syntax that's used to
call a stored procedure in an RDBMS. That is, the mvCommand class
implements the same IDBCommand interface as the SqlCommand class. So we
can do this:
mvCommand cmd = new mvCommand("ProgName",connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
... // set parameters
rows = cmd.ExecuteNonQuery();
Look familiar? That can be coded so that a single test doesn't even know
whether the data is coming from MV or relational - it's the exact same
code.
> If you don't use the Basic programs for the business rules in a .Net
> application one loses a lot of the advantages of U2 and creates many
> of the issues in client server architecture.
I didn't want to imply that code intended to benchmark a server would be
done on a remote client, and I fully agree that server-side benching should
be done with BASIC on the server. What I'm suggesting is that of the many
tests that would need to be run in a "real world" benchmark, like a query
from Crystal Reports or other similar product, we should run through a
common interface to get an apples/apples comparison.
T
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
