EC
Change permissions on / and /var/spool
Install
Change permissions back
t
-Original Message-
From: Evgenios Charalambus [mailto:[EMAIL PROTECTED]
Sent: 15 March 2004 3:11 pm
To: Discussion Universe
Hi All,
We are working for purging of old data from the database. But we are facing
performance problems in this.
We are using select query which is created dynamically on the basis of number of
records. We want to know if there is any limit for size of query in Universe.
Although in
Hi Wol,
The scenario is that-
We have a master file having more than 3-4 million records and have corresponding
reference file which contains reference data for this master file.
Now we start our purge program which selects records from master file on the basis of
date. Corresponding data
Great points from Wol, as always.
What kind of /tmp disk space do you have on this system?
(Assuming that /tmp is where UV does some of it's SELECT
scratch pad intermediate writing when processing large queries,
consult your sites actual uvconfig for all of your actual values...).
If this /tmp
Folks,
It's a real nightmare when you have to purge +2gig files, eh? They can run for weeks
and have your users complaining that entire week too. Nag.. nag..nag...
Simple solution:
Backup entire data file to media. Select what you want to KEEP and move those records
to a temp file. Clearfile
Oh, by the way
Don't forget to use fuser in unix or the equalivant on Bill Gates' machines in order
to verify that you truly do have exclusive access rights; otherwise, no worky.
- Original Message -
From: Mike Masters
To: U2 Users Discussion List
Sent: Monday, March 15,
I have a client that needs roughly 250,000 items removed monthly from a file
containing 5-6 million records.
Since there is no need to use the keys (records) for any other purpose
except for deleting because they are old, a standard data/basic SELECT
statement is just about as fast as you can
On Mon, Mar 15, 2004 at 03:45:39PM +1300, Phil Walker wrote:
All,
I know this question has been asked before, but is UniVerse supported on
versions of Linux other than Redhat, such as Debian, SUSE etc? I imagine it
is not hard to get working, but would IBM then regard it as being certified?
Trying to run the command
SORT FILE WITH ACTION-CODE = NAG BY WEB-IND BREAK-ON WEB-IND TOTAL
CRED.AMT TOTAL COUNT DET.SUPP ID.SUPP
via a vb6 program using Uniobjects.
objCommand.Text = SORT DTA WITH ACTION-CODE = 'NAG' BY WEB-IND
BREAK-ON WEB-IND TOTAL CRED.AMT TOTAL COUNT DET.SUPP ID.SUPP
Have You tried with DET.SUP ?
Just idea, synonyms.
Lembit Pirn
7+7 Software
Tondi 1
Tallinn 11313
Estonia
+372 65 66 232
[EMAIL PROTECTED]
- Original Message -
From: Nick Southwell [EMAIL PROTECTED]
To: U2 Users Discussion List [EMAIL PROTECTED]
Sent: Monday, March 15, 2004 6:15 PM
Sounds like your ECL type is set differently for your login and Objects
sessions.
Remember, UniObjects doesn't run LOGIN.
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Nick Southwell
Sent: 15 March 2004 16:15
To: U2 Users Discussion
It produces output with just ID.SUPP but same error
with DET.SUPP on its own.
Thanks
Nick
-Original Message-
From: Lembit Pirn [mailto:[EMAIL PROTECTED]
Sent: 15 March 2004 16:31
To: U2 Users Discussion List
Subject: Re: Suppressing detail in UniObjects command
Have You tried with
Sooo..
Coming from a very small Unidata background
sounds like you're saying I need to set my
ECL type within the Uniobjects session?
Thanks
Nick
-Original Message-
From: Brian Leach [mailto:[EMAIL PROTECTED]
Sent: 15 March 2004 16:30
To: 'U2 Users Discussion List'
Subject: RE:
I've found that when installing UniVerse on Linux, you have to edit a few
things before it's happy. Others have mentioned the uv.load and cpio
issue, I've also found that you should look in the following files and make
sure they have the right info.
.unishared -- This is at the root level of
Do you have a source for pg. Our admin guy couldn't find one.
Stu Glancy
Asset Management Outsourcing, Inc.
Senior Analyst/DBA
770-792-3907
I think on linux they're different programs, and pg may not be installed
(but
it can be installed)
[EMAIL PROTECTED] john]$ ls -shil `which more less`
Hi all,
How do I go about copying a file that is 2 gig? I had no idea that this would be a
problem when I decided to let one of my data files extend beyond the 2 gig limit with
the 64 bit option. The man pages for cp do not mention any size limitations. What
am I missing?
As always,
Yes, it sounds like you use the Pick style by either turning UDT.OPTIONS 2
ON or with ECLTYPE P for your regular sessions. I believe UniObjects
defaults to ECLTYPE U. I haven't tried in a UniObjects session to change the
ECLTYPE - you just need to learn the U type syntax which is somewhat
Cheers, I'll give that a try!
Nick
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 15 March 2004 17:16
To: [EMAIL PROTECTED]
Subject: RE: Suppressing detail in UniObjects command
Yes, it sounds like you use the Pick style by either turning
UDT.OPTIONS 2 ON
what about using tar?
cd destination ; tar cvf - /sourcetreename | tar xvf -
I think the above will work.
George
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 15, 2004 12:14 PM
To: [EMAIL PROTECTED]
Subject: How do I copy Unix files 2 gig
There's a files area?
-Original Message-
From: Ray Wurlod [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 13, 2004 4:53 AM
To: U2 Users Discussion List
Subject: RE: Universe Sockets Interface
However, the attachment gets stripped. How about sending it to the
moderator to put into the
There should be a file under /etc somewhere (/etc/security/limits on AIX)
named limits, or something similar, in which a parameter (on AIX, it's
fsize) defines that limit. Change it to a larger number, or on many unices a
-1 means no limit.
Our greatest duty in this life is to help others.
Actually, you don't really INSTALL as non-root. The idea of uvadm is that
it is an ADMINISTRATOR, thus, your initial root install sets the product up
so that internally uvadm can administer all facets of the product without
the need of su-ing to root. The fact remains that you still need to
UV 10.0.8
I am trying to create an I-Descriptor that calls a subroutine. The
subroutine does a select on another file. When the select is executed I get
this error: Non-SQL re-entrant query calls are not allowed.
I'm clueless as to what is wrong. Any hints would be greatly appreciated.
Not sure what you are doing but since it's in an i-descriptor and being used
as part of another listing, I'd use numbered selects in my subroutine to
make sure it doesn't bump heads with the current listing that's using the
i-descriptor.
HTH
Mike R.
-Original Message-
From: [EMAIL
Don't do a select (or any query statement) within an I-descriptor subroutine that gets
called from query. That's what the message means.
Even if it did work it would be a dog.
If I need to do something like this in UniData I use the UniBasic index commands like
SETINDEX READFWD, etc and
Maybe creating indices on your PROV.DIR.DB file for the MAMSI field is the
way to go. Then selectindex to do your processing.
Mike R.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Dave Davis
Sent: Monday, March 15, 2004 4:40 PM
To: U2 Users
Hello group,
Does anyone know if UV 9.5.2.1r6-1 is compatible with Windows 2000 Server?
We are currently running this UV version on NT with service pack 4.
Regards,
Dan Jorgenson
SICK, Inc.
6900 West 110th Street
Bloomington, MN 55438 USA
Direct: 952-829-4732
Fax: 952-941-9287
DET.SUPP is not a valid attribute.
Any ideas? This works perfectly from the udt prompt.
Try ID.SUP DET.SUP (just one 'P').
**
This email message and any files transmitted with it are confidential
and intended
EV
Note down current permissions
chmod 777 / /var/spool
install
chmod back again
Glenn's
-Original Message-
From: Evgenios Charalambus [mailto:[EMAIL PROTECTED]
Sent: 15 March 2004 9:44 pm
To: U2 Users Discussion
(sorry about the duplication. Hit the wrong key)
EV
Note down current permissions
chmod 777 / /var/spool
install
chmod back again
Glenn's methodology seems a good one.Though I did not install it that way
(for 'historical' reasons ie I did not have root access). However, when
upgrading to
Dear all:
I'm not familiar with the following as referred to by MV: SLA and OLA metrics.
Also, what is Dataflo. My guess is it may be a 4GL or it could be a 3.5GL like Eclipse.
thanks.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
I'm on the wrong side of the world, but IIRC DataFlo is a product, like InfoFlo -
these days out of the Epicore stable
I'd imagine SLA would be a Service Level Agreement and OLA would be an Operational
Level Agreement, both relating (more or less) to the uptime availability of a system
Ross
Apologies for the delay.
Wendy I had this same problem a while back. From memory the reason it works at the
colon prompt but not from uniobjects it the umask. When you run udt it inherits it's
umask from your environment. On linux I have a unidata.sh file in /etc/profile.d
which sets it to
Hi All,
In response to a message I posted recently, many users expressed strong opinion
against the pre-assignment (or declaration) of variables at the top of a subroutine.
Although I dont normally do this in my programs I would like to understand the impact
on memory fragmentation of
Everything seems to revolve around block size. I know we've
been over
this a thousand times, but I'm trying to make sure (coz I'm
being
hounded to prove my theories)
I've been using 2k as a general rule-of-thumb (on W2k NT),
but have
now been informed (albeit wrongly perhaps) that Pick is 2k,
35 matches
Mail list logo