Malcolm had a great site. A real loss the the MV world.
But *not* entirely lost, at least for now. The links I searched for on the
Wayback Machine site: http://www.archive.org/web/web.php , were available
there.
Here are the links I saved from his site a few years ago to get you started:
... :-(
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Thomas Derwin
Sent: Wednesday, July 09, 2008 1:08 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Malcolm Bull
Malcolm had a great site. A real loss the the MV world.
But *not* entirely lost, at least for now
Hi,
Note that in Bill's example, he typed list in *lower-case*. That's why
it worked.
If you're running ECLTYPE P (Pick mode) and you issue Unidata commands
in lower-case, the commands will run using ECLTYPE U, which is required
to use EVAL. This (possibly undocumented) feature is a great way to
Unidata's CREATE.FILE command allows you to specify the directory path.
So you could replace the mkdbfile commands in steps 3 and 4 with
CREATE.FILE DICT /dir/subdir/FILENAME mod,sep
and
CREATE.FILE DATA /dir/subdir/FILENAME mod,sep
In step 5, copy VOC FILENAME to the remote VOC and optionally
By using READU, you can also do fun things when your code takes the
locked clause, such as offering an inquiry-only mode (i.e. updates are
disabled), which is terribly user-friendly. And/or you can display who's
locking the record so the lockee can contact the locker, also
terribly user-friendly.
Agreed, a UD DIR-type file (called type 19 in UV) in the middle might
solve the issue nicely. Instead of an input statement, the UniBasic
program would simply read the record from the DIR-type file.
The heavy lifting involves passing the data into the DIR-type file.
Several possibilities come to
Wow! Items, attributes, multiple values, no need to pre-define
data types. And the pricing is per GB, similar to the time-share
services of long ago.
Wonder if it's based on MV, and what's under the hood? The choice of
terminology sure sounds like they used the Pick data model :-)
Thanks,
Tom
Hi Brenda,
I'd recommend you at least have the option of RAID 0+1.
We use a combination of RAID 0+1 and RAID 5. The data that's heavily
accessed goes on RAID 0+1 volumes and the less-busy stuff goes on RAID
5.
Other things to consider are the amount of RAM installed (systems fly
when entire
Thanks for the donation, Don. It's easy to forget that these things cost
$$$.
Tom Derwin
[EMAIL PROTECTED] 11/26/07 7:55 PM
Let me rephrase that. I donated the funds for the domain name and
registered it. U2UG owns the domain in whole.
I love whois..I should have paid for that privacy
I got an Editing Denied screen from Keith's link.
This link works:
http://www.pickwiki.com/cgi-bin/wiki.pl?GetKey
Looks like a nice piece of code. Thanks, Keith.
Enjoy,
Tom Derwin
[EMAIL PROTECTED] 11/26/07 11:19 PM
However, this brings up a good practice thing to note. The seperator
must
Looks like Majordomo sorts the list by domain, then by user.
That would put advantos at the beginning of the list with
correspondingly fast turnaround.
My former domain started with d; now it's l and takes about 30
minutes longer.
Regards,
Tom
[EMAIL PROTECTED] 11/26/07 10:35 PM
Scott:
I'm
I thought it depended on whether you were near the beginning or the end
of the recipient list.
Under my former e-mail address (imported from Clif's server), the
turnaround was about 30 minutes.
When the company changed our addresses, turnaround became an hour or so,
which I presumed was because
Hi Doug,
Since your variable is delimited by value marks, just use
CRT VAR11,1
No OCONV is required.
If you're using characters other than @AM, @VM, or @SM, then OCONV with
the G option (group extraction) is your friend.
For instance, if VAR1 = SAM*TRUDY, then
CRT OCONV(VAR1,'G0*1') will print
Hi Karl,
We ran into this too, and the Unix xargs command took care of it
nicely.
Example:
The following purge will delete the files for a single month (assuming
you don't keep more than a year's worth, in which case you'll need to
check the year, too).
This string will prompt before purging
I bet Tony will be back Monday, July 9. He's in Australia, where the
DD/MM/YY date format is used.
This is why the U.S. military has used DD MMM (e.g. 9 Jul 2007) for
decades to avoid confusion.
Regards,
Tom Derwin
[EMAIL PROTECTED] 07/05/07 10:25 AM
Dear Mr. Admin,
Please unsubscribe
Hi Kevin,
On our UD system, we test @USER.TYPE.
Try changing line 3 to:
IF @USER.TYPE = 0 THEN WW.SB.RB
That way, only interactive users (@USER.TYPE = 0) run the routine and
phantoms (@USER.TYPE=1) skip it.
Hope this helps,
Tom Derwin
[EMAIL PROTECTED] 05/17/07 7:01 PM
I have a site that
Last I looked, Dynamic Connect was bundled with the PE editions. It was
included in the clients zip file, rather than the pe zip file.
[EMAIL PROTECTED] 05/10/07 11:24 AM
Adding an emulator is a great idea, however it should be an IBM product.
snip
Karl
quote who=[EMAIL PROTECTED]
Is there a
Very well said, Dave. And thanks for your generous offers.
The incubator is a great idea and hopefully IBM will be as lenient
with the PE licensing and expiration terms as they are with their free
DB2 Express-C database.
The installer is going to be an amazing piece of code, considering all
Hi Gabe,
Some quick thoughts:
The Internet has dramatically reduced the need for printed materials,
especially on fast-changing technical subjects. Even PC Magazine is a
fraction of its former size.
In the late '80s - early '90's (what I'd consider the heyday of Pick /
MV so far), there were
Hi Mike,
This is a good one.
Some ideas:
1) A semaphore your programs test before running list; either:
a) READU WRITE an update in progress record, or
b) simply READU (but don't write) the update in progress record,
which will automatically clear when the update program terminates.
2)
Nestli Waters North America (Perrier), Greenwich, CT
Sent: Friday, April 27, 2007 9:29 AM
Hi, all. My sales group has a need to convince some prospects that real
companies do, indeed, use UniVerse.
snip
Dave Liesse
Quality Manager
SSC Technologies, Inc.
Well said, Mark.
Your simple 5-step example could save a newcomer hours of trial and
error.
Until the full-blown Incubator and Learning Pack is available, this
would be a perfect addition to the U2UG web site. Maybe there are some
draft pieces already written that could be posted.
Perhaps other
Hi Bill,
Unidata's P-type (Pick flavor) ECL may be just the answer for you:
:ECLTYPE P
:ECLTYPE
2 U_PSTYLEECL ON
Pick commands work as we're accustomed to, and when you do want the
features of U-type (Unidata flavor) ECL, just type the verb in
lower-case. You'll need lower-case for
Hi Steve,
When you do have the time, could you enlighten us and/or point us to
some resources on the subject of SAN tuning for U2?
We upgraded our UD system to new Alpha servers and an HP SAN last
summer, and it runs 5 times faster on the new hardware, so everybody's
happy.
But now I'm curious
Hi Noah,
When a PC crashes, the telnet client isn't able to tell the UD server to
terminate the session, so the telnet process on the server just sits and
waits. As you discovered, the server process will hold any locks it has
set until its Unix PID is killed.
Couple of solutions (we use both)
Here's our routine (an external subroutine we've used for years, first
on Sequoia, then on Unidata):
:ED BP AGE.CALC
Top of AGE.CALC in BP, 38 lines, 1,384 characters.
001: SUBROUTINE AGE.CALC (BIRTH.DATE , AS.OF.DATE , AGE)
002:
003: *Author : Tom Derwin
Hi Brian,
Could it be DNS configuration rather than Active Directory?
Telnet does a reverse-DNS lookup when it initiates a session, and if
there's no response from DNS, telnet waits about 50 seconds before it
times out, connects, and displays the login prompt.
After the user gets the login
*Thanks* to all the volunteers who keep the U2 lists up and running.
As this showed, it's not always easy. Remarkable how much more you
appreciate something when it's not there anymore.
[EMAIL PROTECTED] 12/12/06 3:47 PM
Hey, it's a complement from where I see itloosing this list for 6
Wow! Nice work. This is a breakthrough for U2.
[EMAIL PROTECTED] 11/08/06 1:49 PM
This is a WONDERFUL idea.
snip
--
Dave Walker
-Original Message-
From: [EMAIL PROTECTED] On Behalf Of Charles Barouch
Sent: Wednesday, November 08, 2006 10:47 AM
snip
U2
Incubator Proposal
Did you try stopud -f? That will force UD to stop even if it thinks
users still have Unidata sessions running.
If that doesn't work, sounds like you need to reboot the server.
Note that these suggestions are only recommended as a last resort, as
you run the risk of corrupting your data.
Good
Well said, Mark.
My opportunity to really learn about Pick performance was circa 1985 on
an ADDS 1500, a PC XT clone with 256K RAM, a 10MB hard drive and a port
of the ADDS Mentor Pick O/S.
We ported some code from an ADDS 4000 to it and I was shocked to see how
slowly a 3-column screen of
Hi Jeff,
Couple of ideas:
-1-
Try WRITESEQ instead of WRITESEQF so the system will buffer your output
in memory and write it to disk in more efficient chunks. According to
HELP WRITESEQF, your command forces UniData to immediately write the
data to the disk so you're taking an I/O hit.
-2-
Hi Kevin,
What O/S?
_PH_ is a DIR-type file, so your issue could be O/S-related.
Also, could you confirm that your VOC _PH_ is in fact a DIR-type? If a
record reaches 3MB in a hashed file, every multivalued database I've
worked with gets cranky.
Hope this helps,
Tom
[EMAIL PROTECTED]
Hi Bill,
It's strange behavior with an easy fix:
BPIOCP (all by itself)
For example:
156: IF OUTPUT = 'SCREEN' THEN
157: BPIOCP ;* ALLOWS HEADERS PAGING TO WORK
158: END ELSE
159: PRINTER ON
160: END
HELP BPIOCP tells all.
Hope this helps,
Tom Derwin
[EMAIL PROTECTED] 09/23/06 11:41 AM
Hi Steven,
We did a similar upgrade just over a month ago, and things run 5 times
faster now. Disk writes had been a limitation for us, too.
We went to an HP EVA 8000 SAN cabinet from a Compaq ESA 12000 box that
had an HSZ 80 (SCSI) controller. Also upgraded the servers from DEC
Alpha 4100 to
Hi Tom,
The index says the K-type for your PRIM.BIN.NUM is Txt, so looks
like the dict it's based on is left-justified (e.g. 3L) rather than
right-justified (e.g. 3R).
That would suggest the select is using a string compare rather than a
numeric one. Given that, I'm surprized the first select
Hi,
For starters, you might check the features of your AIX filesystem. Does it have
any kind of snapshot feature? If it does, you might only need to dbpause
while the snapshot command executes.
On DEC Tru64, we use the Advanced filesystem (AdvFS). It has a awesome
feature called clone
Unidata on Unix has this issue, too (at least the DEC Tru64 flavor) -- it holds
onto the file lock after CLOSESEQ of a file OPENSEQed with the Unix path.
Don't know if it's been fixed in newer UD releases, but not likely a priority
since OPENSEQ of a VOC pointer doesn't have the problem.
Matt Stern at Comprehensive Computer Services does Pick training. He's on Long
Island.
Comprehensive Computer Services Inc
560 Broadhollow Road
Melville, NY 11747
631-755-2250
[EMAIL PROTECTED] 10/04/05 11:50 AM
Hey all,
We've got a new employee at my company with no PICK experience at all
IBM announced this morning that it's agreed to buy software maker
Ascential Software Corp. for $1.1 billion to bolster its information
integration business, the companies said on Monday.
For those interested in the details, there's a Reuters story at:
Is BASICTYPE set the same on both? UD supports 4 different parsers: U,
P, R or M. From the ECL prompt, BASICTYPE by itself will tell
you which flavor the account is set to.
If that's OK, I'd compare the UDT.OPTIONS settings. From the ECL prompt,
UDT.OPTIONS by itself will display them all for
For those who don't get the IBM DB2 newsletter, this arrived today:
--
U2 PE and wIntegrate Downloads to be Temporarily Removed from the Web
The personal editions (PE) of UniData and UniVerse have been
temporarily removed from their location on the U2TechConnect
website. We are
You'll use more disk space (8K minimum per record on Tru64 Unix by
default; if the record is larger than 8K, then disk will be used in
increments of 8K).
It's also possible, but unlikely, to use up all the namespace that Tru64
allocates for record ID's in the Unix filesystem. We found this when a
This works for me:
1) .S200 to expand the stack size to 200 lines.
2) .P to turn off the proc commands i.e. anything not typed at TCL.
Note: can be helpful to toggle it back on during debugging to get a
detailed list of exactly what got run during a job stream.
.Q (not listed below) displays your
Hi Al,
Are you getting a Unidata error message? If so, which one?
There's the UniBasic DIR function and the Windows-level dir command, which work
quite differently.
The UniBasic DIR function works file-by-file, so it expects you to specify the full
path to _HOLD_ and the hold file name.
Gotta look at the disk specs. All things may not be so equal. Disks are getting
faster and smarter as they get larger.
Latest disk speeds are 15,000 RPM vs. 8k or 10k. Faster SCSI buses, bigger caches and
smarter access algorithms on both the drives and the controller cards boost I/O
doesn't mean that you can't fix it
Stu Pickles
-Original Message-
From: Thomas Derwin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 03, 2004 11:29 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UV] Primary:Index (mis)matching.
FWIW, I learned the hard way that UD keeps a flag in the file
There's no proc manual for Unidata, but Universe has one (and calls it ProVerb).
The UV 10.1 doc set is here:
http://www-306.ibm.com/software/data/u2/pubs/library/100univ/univ_101.html
The UniVerse Guide to ProVerb, Version 10.1 direct link is:
48 matches
Mail list logo
