Susie just informed me that Rocket cannot respond publically until the
transaction is approved by the FTC and the deal is consummated.
Steve O'Neal
Services Sales Leader for U2 in North America,Information
Management Lab Services,IBM Software Group
All,
Just spoke with Susie and she confirmed that DataStage is not coming to
Rocket.
FYI,
Steve O'Neal
Services Sales Leader for U2 in North America,Information
Management Lab Services,IBM Software Group
From:
David Jordan da...@dacono.com.au
To:
U2 Users List
THE NATIONAL WEATHER SERVICE IN DENVER HAS ISSUED A BLIZZARD WARNING...
WHICH IS IN EFFECT FROM 6 AM THIS MORNING TO 6 AM MDT FRIDAY. THE WINTER
STORM WARNING HAS BEEN CANCELLED.
TOTAL SNOW ACCUMULATIONS BY LATE THURSDAY NIGHT WILL RANGE FROM 6 TO 12
INCHES ACROSS THE NORTHEAST PLAINS... WITH
Enough said. It's got to be bad if the office closes.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Henry,
The ODBC connection is the slowest connection into the U2 product line. If
the application will not have a lot of users on it, ODBC will be fine.
But, ODBC will not scale if you have numerous connections.
Steve O'Neal
U2 Lab Services Sales Specialist,IBM Data Management,
Announcing the Release of IBM UniVerse 10.3
In todaybs demanding IT environment, a conventional database isnbt always
enough. Developers need a high-performance, highly scalable, easy-to-use
database offering rapid deployment and a rapid return on investment.
Accordingly, the U2 team is
Don's obit: http://www.star-telegram.com/metro_news/story/1143919.html
I've known Don since the middle 1980's when PVI ran on Prime Information.
What I was always intrigued with Don, was his ability to take a complex
situation and make it look simple. We all know that it takes a tremendous
Reposted with a new title so more people may read this important entry
from Doug Averch. Thank You Doug!
= Doug's original post =
We came across this article in the Denver Post a few days ago:
(http://www.denverpost.com/search/ci_11446814)
Jewelry retailer Shane Co. attributed its
Symeon asked, Anyone any thoughts or even looked into the licensing
implications, or talked to IBM about an instance of udt or uv inside an
amazon EC2 cloud ?
I'd send an e-mail to [EMAIL PROTECTED]
U2AskUs is a great place for these kinds of questions.
At your service,
Steve O'Neal
U2
There is an immediate change to the recommended steps for backing up UV.
NEW RECOMMENDED BACKUP STEPS:
SUSPEND.FILES ON
SYNC --- This is the New Recommendation !!! The buffers must be
flushed to disk !!!
Break off mirrored set, create Flash Copy, etc.
SUSPEND.FILES OFF
Make backup from
If your site runs
UV on Linux
on an IBM System X (Blade)
with over 250 Concurrent Users, and
you are willing to be a reference for a prospect that is considering
moving onto this platform
Would you please send me an e-mail directly (and not to the U2 Users
Group)?
Would you please
Bill,
There is the Unix Kernel, which is configured via the Kernel Parameters.
In UniVerse, there is the Run Engine. You modify uvconfig to change the
parameter setting (like the width and depth of the lock table). Then you
use uvregen to generate the Run Engine object code. The Run Engine
This is discussed at U2 University during my presentation. I highly
recommend that you all attend.
Also, the description stated UniVerse and not UniData, so I changed it.
Most people are skewed to only looking at their DB of choice.
JJUser asked However, I too am curious about the Server 2003
Scott Thompson asked ... What is the best way to verify the integrity of
a file while users are accessing (if possible at all)?
Please note that Scott only asked for a single file...
Runner Up:
Karl P
was extremely close with LIST FNAME LASTATTRIBUTE. If he would have
added DET.SUP, he would
In the mean time, attend U2 University coming up this fall in Terrytown.
I'll be there speaking on HW, O/S the U2 Data Servers. Worth every
penny of the $850 tuition.
http://www-306.ibm.com/software/info/u2/university/index.jsp
Bob,
Sounds like time for you to start one. I suspect you
Charles asked A buddy of mine asked me if I knew anything about Model
204. I've never run across it, but it sure smells like a cousin of the
multi-value, or perhaps XML, model. Anyone know anything?
I studied Model 204 in 1975 in my Comparative Database class. It was a
new approach to
Louie asked, ...has anybody gone to a U2 University before? Any clues as
to its worth?
I'm taking off my IBM employee hat to answer this one... :-)
Throughout my career, User Groups and Conferences have been the mainstay
of my continuing education (outside of reading manuals). The U2 User
George asked We tried to modify the actual commands like COPY, ED, etc to
replace
them with Remote items but our software vendor uses different syntaxes
for all the commands we wanted to monitor. This we used in a limited
production test that had some less than desired results (read
catastrophic
Charles asked for a link to the 15,200 user benchmark white paper. While
there is not a white paper, there is an article:
ftp://ftp.software.ibm.com/software/data/u2/pubs/ibmdb2_3-06.pdf
Martin asked about the specifics of the benchmark. They will be presented
at U2 University around the
Register today!
Join us at one of our three U.S. locations for the first ever IBM 2007 U2
University (U2U). U2U is the premier U2 technical event for IT executives,
managers, professionals, DBAs, developers and business partners.
This event brings you speakers from across the IBM U2 team
Yes, UV initiates a sync at the time of the SUSPEND.FILES ON command is
initiated. If there are enough disk drives under the system, it should
only take between 15 and 45 seconds. After the sync completes. it will
move to the next command.
Yes, unless you add Transaction Semantics, (BEGIN
Slight correction
For both UD DBPAUSE and UV SUSPEND.FILES ON, as soon as you initiate the
command, all WRITES to the DB will stop.
So, that batch process will stop at the next WRITE, and not continue until
the process ends!
Steve
Stephen M. O'Neal
U2 Lab Services Sales
Colin Alfke asked:
Along that line - would there be anything else that may be holding up
DBPAUSE?
A cause of a slow response back from DBPAUSE is not enough disk drives
under a system. When DBPAUSE is initiated, it flushes all of the UDT disk
buffers to disk. If there is a lot of data
You can find the release of software you are looking for on the U2 Product
Availability Matrix.
From the U2 Support Website:
http://www.ibm.com/software/data/u2/support
On the right side of the page, click on ?Check for Product Availability?.
This will take you to the U2 Product Availability
Rats. Mark Baldridge informed me of this as soon as I posted. Please
contact your support provider for an update on this Case (Ticket number).
And, no, I don't know if it is flavor specific (I wouldn't think so). If
you want to hike it up higher in the list to be fixed, please let your
The COPYing of files and the failure to perform the set SET.INDEX command
after the copy, has caused numerous system failures. (One site failed
just last week.)
Jeff Fitzgerald's excellent e-mail is a must be read by all UV shops.
You may wish to consider changing every index you have on your
Adding to Brian Leach's and Bill Haskett's posts, and I fully support that
we will not get into which is better for they are different due to their
lineage as Charles stated.
Structural Differences:
High Availability - UniData's before and after image capabilities in the
Recoverable File
Please contact me off line from the list. Prospect is requesting to speak
with a few installations.
Thank You in Advance!
Steve
Stephen M. O'Neal
U2 Lab Services Sales Specialist
Information Management, IBM Software Group
---
u2-users mailing list
[EMAIL PROTECTED]
To
From Dave's original question:
How else can a BASIC program tell if it is being called from the Web or
not?
I asked some other guys in support and they came up with this idea:
If your database server is on Unix you can use @LOGNAME, since all RedBack
sessions (responders) should be owned by a
We see Mercury Load Runner, Segue, and Rational Rose on the high end for
graphical interfaces or green screen. These require a secondary server to
push the load to the primary server.
[AD]
In the middle tier, U2 Lab Services has developed a scripting language
that can Push Load to a Green
Tom Derwin asked:
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?
Alas Tom, I am currently swamped at work. The research paper mostly
written yet has to be updated with new information. I anticipate full
release to the
Richard and All,
The generic reason that multi-part file is faster than a single file is
the dividing of indexes on large files.
On a Multi-part file, there is one set of indexes files per part. When a
SELECT is invoked, it works on each index for each of the part files, then
joins them
ibm.com/training/us/savings/edpack
Cool! The IBM Education Packs are on sale!
What I like about the Ed Packs:
1) They can be used for both U2 and other classes, like AIX or LINUX
training.
2) The Ed Packs can be used to pay tuition for some conventions, like our
the Information on Demand
I use Nuance's Dragon Naturally Speaking Professional 9. I have used
versions from release 7 on, or for about 3.5 years. The accuracy was good
on 7, great on 8 and excellent on 9. It's about $99 for the SW.
http://www.nuance.com/naturallyspeaking
The software works in any Windows
Tom,
Specifically, how are the disks configured and how is UDT configured to
run? Is the cluster:
+ Two separate systems, each with their own internal drives for the O/S
Paging
+ Shared disk drives between the two systems for the data and UniData
+ only one system of the cluster owns the data
Watch the number of entries in any directory. Once a directory gets over
one thousand (or so) entries, it can really cause the system to slow down.
On some O/S, the directory is not a tree, so a sequential search
performed. Yuck! Keep names sort too if your O/S is not a tree.
---
If you are running VMWARE MS 2003, please contact me off line. We are
looking for a reference. Your company won't have to endorse it. The
prospect just wants to speak to you about it.
Thanks!
Steve
Stephen M. O'Neal
Lab Services Sales for U2
IBM SWG Information Management Lab
Brian Leach stated connection pool licensing is a new feature in UniVerse
10.2 - and so I doubt you will find that anyone has had a chance to
really prove that part of it yet.
The connection pooling portion of UO.NET has be extremely tested for one
U2 Channel Partner (what we used to call VARs)
Steve,
Proposing that the difference is in the number of digits stored verses the
number of digits displayed. Maybe the number of digits store is 5 after
the decimal verses the 2 you are rounding to. The difference displayed
may be due to the rounding that is occurring on each number BEFORE
If you run UV on Blades, please let me know (on or off line from U2UG). We
need a reference.
Thanks!
Steve
Stephen M. O'Neal
Lab Services Sales for U2
IBM SWG Information Management Lab Services
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
Great Catch Tony! Thanks!
This may be a USA problem only.
[OT]
This is one time that all of a sudden that I feel completely unaware of
how this effects our WW users. Oblivious American again :-(
[/OT]
Having spent a HUGE amount of time on this timedate stamp issue, here are
a few more
All,
I think it's pretty cool how many of us came to Tricia's help. We all saw
the predicament she was in.
From Chuck's response:
When you said 0 bytes, did you really mean zero bytes at the os? Or did
you mean zero records, i.e., an empty data file from the UV perspective?
What was the
to the group, the 'lumpy' effect may make certain items appear
'slower'.
My 1 cent.
- Original Message -
From: Stephen O'Neal [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Sunday, October 15, 2006 5:30 PM
Subject: [U2] VOCLIB and keeping VOC entries Short and Small
The intent
The intent of VOCLIB is to reduce the VOC size. One idea for speed is to
keep your VOC very small. This way the search for all items is faster.
For some VOC items, like 'PA'ragrpahs and 'PR'ocs can be sizable (like
1,000's of characters). This causes Lumpy records. (To be shocked,
sometime
After checking with U2 Product Management, this feature is planned for the
next UniData release, version 7.2. We haven't nailed down the release
date. Customers should NOT hold us to this as we haven't solidified all of
the projects for the release.
FYI,
Steve
Stephen M. O'Neal
Lab
Bummer Teri!
You've encountered a broken file with a Backward Link (blink) error. Call
your U2 support provider to find out the steps to recover.
U2 Lab Services baseline recommendation is for all systems to run UniVerse
Transaction Logging to eliminate broken files upon recovery of a down
OK Gals Guys! This has a really big feature in it... Data encryption at
rest!
Stated another way... You can encrypt individual fields of a file, like
the CREDIT CARD NUMBER, with little or no programming changes!
From the announcement UniVerse 10.2 automates encryption of data at rest,
All,
This is one that can have consequences. Here are my words of caution...
Ian Stuart asked: how would this impact on the use of rsync on frequent
(every 10 minutes) replication?
The proposed snap/rsync cycle for a valid backup:
1) quiesce the database (Functional equivalents UDT DBPAUSE or
First, let me say, that the mean time between failure has significantly
increased over the years. This reduction in failures have given many a
shop a false sense of security. Now it is rare that we see disk failure
before the system's life has lived it's normal three to four years and is
Just make sure your on the same O/S. Don't go windows to *nix for
example. We had this at one customer site and they had a Learning
Experience.:-(
Make sure you test it too, about once or twice a year, just to make sure
nothing has changed.
Only U2 OEM Partners can run Hosted systems.
The method you are talking about is valid. The fundamental problem you
have is that the installation you are speaking about does not have enough
disk drives underneath it to keep up with what you wish to do.
This problem may be exacerbated by the disk RAID the are using. What is
the RAID
UV or UDT?
Kevin King [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/07/2006 03:04 PM
Please respond to
u2-users@listserver.u2ug.org
To
u2-users@listserver.u2ug.org
cc
Subject
[U2] Program Cache Expiration
Does anyone know offhand how long a catalogued program will stay in
cache
Proposing three alternatives:
1) UniData Triggers that call a UniData EDA (Extended Data Architecture)
interface to write to MySQL. The only thing that has to be developed is
the MySQL interface for EDA. The burden here is adding triggers for the
UDT database. Hummm
2) UDT Triggers that feed
EDA is not OFS. It is a new portion of UDT 7.x. In U2 Lab Services, we
try to push new technologies rather than driving the car with our hands on
the rear view mirror!
Man, stuck both feet in my mouth. OK. My Bad...
First foot... UDT 6.x does not have EDA. It was included in 7.x. Sorry.
IBM Lotus Notes users can eliminate the ?Out of Office? auto response
problem at U2UG by doing these steps:
When in the ?Mail? view:
Click on ?Tools?
Click on ?Out of Office?
Click the tab called ?Exceptions?
In the field called ?Do not automatically reply to mail from these people
or groups:?,
This last weekend, we attained a new high number of users on a U2 database
of 15,200 on a single system running an application!
Tim Snyder, Principle Consultant of the U2 Lab Services group, performed
this formal benchmark at one of the IBM benchmark centers on an
IBM p590
+ 64 dual core CPUs
There are sites currently running IBM LPARs and UDT. From AIX 5.2, you
can allocate a whole CPU to an LPAR. AIX 5.3 supports a LPAR smaller than
a CPU.
U2 Lab Services is unaware of any Virtual Server implementations from MS.
They may be installations out there, but we have not encountered
of data after the BLINK error in he
affected group only.
Karl Pearson
Senior uniVerse DBA and one who cut his teeth fixing blinks by hand
(thanks to Mark Baldridge and Joel Yates).
quote who=Stephen O'Neal
Anmol,
...When they fix the file, the file will be truncated at
the group where this occurred
Anmol,
I don't have good news.
You have a broken file due to a mismatched backward link (blink). This
occurred when the file attempted to expand past the 2gb limit on a static
file by trying to extend an overflow block.
Any attempt to SELECT or SSELECT the file will fail when it reaches the
Call 800-729-3553 (U2 Support phone number) and tell them you have a down
system. U2 support is staffed 24X7 for stuff like this.
We'll say a prayer too. Hope it goes a well as possible considering the
circumstances.
Steve
Stephen M. O'Neal, CDP IBM U2 Certified
Services Sales
Greetings All!
http://www.emc.com/products/networking/srdf.jsp
If your installation is running this piece of software, would you please
contact me (either thru the list or off line)?
We have a client that is looking for references. On paper, looks like a
great product that should be used with
advised me very strongly not to do it.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stephen O'Neal
Sent: 02 September 2004 13:13
To: [EMAIL PROTECTED]
Subject: [U2] [UV] SRDF from EMC
Greetings All!
http://www.emc.com/products/networking/srdf.jsp
I have seen both.
One ran off the digital video card of the pc (think the biggest HDTV Plasma
Monitor you have ever seen). From the video card, there was a Y cable
splitter where one cable went to the PC's Monitor on the desk and the other
went to this massive overhead digital monitor. It was
Hans Wrote:
snip
I'm writing a basic routine to generate XML files and running into a
problem. The following CONVERT statement does work,
CONVERT TO amp; IN LINE
Does anyone know what's happening here.
snip
The CONVERT statement does a character for character replacement in the
string.
The
AIX 5.2 and 10.0.16 and higher is recommended if you are running UV
Transaction Logging. There were numerous bugs fixed.
Steve
Stephen M. O'Neal, CDP
IBM Data Management Solutions
U2 Professional Services, Special Projects
|-+--
| |
65 matches
Mail list logo
