headers
JayHarbeston | 2 May 2010 23:03
Picon

[U2] questions about the REBUILD.FILE utility

Greetings,

I am using the REBUILD.FILE utility on a data file that is around  
4,000,000 records. I started the REBUILD 25 hours ago, and have not  
seen the timestamps for the file or any of its dat or over files since  
an hour and a half into the rebuild.

The process is still taking 20% of processor time and I am under the  
assumption that it is still working on rebuilding.

Is that a good assumption?

Any suggestions to check to see if progress is being made still?

Thanks in advance!

J
_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 3 comments |
headers
Dan Fitzgerald | 2 May 2010 23:55
Picon
Favicon

Re: [U2] questions about the REBUILD.FILE utility


Look in uvtemp.

> From: jharbestonus <at> gmail.com
> To: u2-users <at> listserver.u2ug.org
> Date: Sun, 2 May 2010 17:03:27 -0400
> Subject: [U2] questions about the REBUILD.FILE utility
> 
> Greetings,
> 
> I am using the REBUILD.FILE utility on a data file that is around 
> 4,000,000 records. I started the REBUILD 25 hours ago, and have not 
> seen the timestamps for the file or any of its dat or over files since 
> an hour and a half into the rebuild.
> 
> The process is still taking 20% of processor time and I am under the 
> assumption that it is still working on rebuilding.
> 
> Is that a good assumption?
> 
> Any suggestions to check to see if progress is being made still?
> 
> Thanks in advance!
> 
> J
> _______________________________________________
> U2-Users mailing list
> U2-Users <at> listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
(Continue reading)

Permalink | Reply | 2 comments |
headers
JayHarbeston | 3 May 2010 01:00
Picon

Re: [U2] questions about the REBUILD.FILE utility

There is only one file of interest in the /tmp directory.

It is U298412r, and it is dated yesterday with information from a  
previous operation prior to the REBUILD.FILE.

Open for more ideas.

Thanks!

On May 2, 2010, at 5:55 PM, Dan Fitzgerald wrote:

>
> Look in uvtemp.
>
>> From: jharbestonus <at> gmail.com
>> To: u2-users <at> listserver.u2ug.org
>> Date: Sun, 2 May 2010 17:03:27 -0400
>> Subject: [U2] questions about the REBUILD.FILE utility
>>
>> Greetings,
>>
>> I am using the REBUILD.FILE utility on a data file that is around
>> 4,000,000 records. I started the REBUILD 25 hours ago, and have not
>> seen the timestamps for the file or any of its dat or over files  
>> since
>> an hour and a half into the rebuild.
>>
>> The process is still taking 20% of processor time and I am under the
>> assumption that it is still working on rebuilding.
>>
(Continue reading)

Permalink | Reply | 0 comments |
headers
JayHarbeston | 3 May 2010 01:21
Picon

Re: [U2] questions about the REBUILD.FILE utility

Another thought: I was wondering, given the information below, what  
would happen if i stopped the REBUILD.FILE process?

Would that be a disaster?

If I could stop it, could I do a copy of records from it to a new file?

Thanks

On May 2, 2010, at 5:55 PM, Dan Fitzgerald wrote:

>
> Look in uvtemp.
>
>> From: jharbestonus <at> gmail.com
>> To: u2-users <at> listserver.u2ug.org
>> Date: Sun, 2 May 2010 17:03:27 -0400
>> Subject: [U2] questions about the REBUILD.FILE utility
>>
>> Greetings,
>>
>> I am using the REBUILD.FILE utility on a data file that is around
>> 4,000,000 records. I started the REBUILD 25 hours ago, and have not
>> seen the timestamps for the file or any of its dat or over files  
>> since
>> an hour and a half into the rebuild.
>>
>> The process is still taking 20% of processor time and I am under the
>> assumption that it is still working on rebuilding.
>>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Dan McGrath | 3 May 2010 07:35
Picon

[U2] <-1> and Null values

Hi all,

Hopefully I'm not going crazy, but I could have sworn in UD 7.1 that
doing a <-1> to append an empty string would not actually appended
anything. For example:

REC = 'A'

REC<-1> = ''

Would result in REC equaling 'A', not 'A': <at> AM

In fact, I even have some in-house tools I wrote that rely on <-1>
trimming out empty strings. Now, it appears in UD 7.2.5 that this is no
longer the case and it does equal 'A': <at> AM. I've been through all the
release notes and cannot see any changes that would have affected this.
I've also looked through all the UDT.OPTIONS and see nothing relevant...

Am I going crazy or has this indeed changed?

Cheers,

Dan

###########################################################################################
The information transmitted in this message and attachments (if any) is intended only
for the person or entity to which it is addressed. The message may contain confidential
and/or privileged material.  Any review, retransmission, dissemination or other use of
or taking of any action in reliance upon this information by persons or entities other
than the intended recipient is prohibited.  If you received this in error, please
(Continue reading)

Permalink | Reply | 6 comments |
headers
Kate Stanton | 3 May 2010 07:53
Favicon

Re: [U2] <-1> and Null values

Hi Dan,

You are not the crazy one.  It changed some years ago (UniVerse anyway) - we 
found out the hard way.

That and the user number not being the user number for phantom (ie client) 
users have caused a great deal of heartache for us.

Scary thing is what else might change!  We avoid use of NOT() when data 
might be alpha, in case that changes to give runtime error.

Kate Stanton
Walstan Systems Ltd
4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand
Ph: +64 9 360 5310  Fax: +64 9 376 0750  Mobile: +64 21 400 486
Email: Kate <at> Walstan.com

----- Original Message ----- 
From: "Dan McGrath" <dmcgra <at> imb.com.au>
To: "U2 Users List" <u2-users <at> listserver.u2ug.org>
Sent: Monday, May 03, 2010 5:35 PM
Subject: [U2] <-1> and Null values

> Hi all,
>
>
>
> Hopefully I'm not going crazy, but I could have sworn in UD 7.1 that
> doing a <-1> to append an empty string would not actually appended
> anything. For example:
(Continue reading)

Permalink | Reply | 4 comments |
headers
Dan McGrath | 3 May 2010 08:12
Picon

Re: [U2] <-1> and Null values

Actually, I think I've just remembered part of it, but not the rest.

Appends an empty string:

REC = "A"
REC<-1> = ""

Doesn't append an empty string:

REC = ""
REC<-1> = ""

Sets REC<2> to an empty string:

REC = "A"
REC<2,-1> = ""

Doesn't append an empty string:

REC = ""
REC<1,-1> = ""

I think my mind hasn't returned from vacation yet... Interesting that it
changed in UniVerse though, Kate.

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Kate Stanton
Sent: Monday, May 03, 2010 3:53 PM
To: U2 Users List
(Continue reading)

Permalink | Reply | 3 comments |
headers
Symeon Breen | 3 May 2010 09:18
Picon

Re: [U2] <-1> and Null values

I think it depends on what flavour you are in as well - a number of the
older pickies I work with keep forgetting this behaviour so i assume it is
newer rather than older...  it is rather annoying when you are building up
some associated arrays and for some reason a null pops up in the data
somewhere - it throws the arrays out of synch

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: 03 May 2010 07:13
To: U2 Users List
Subject: Re: [U2] <-1> and Null values

Actually, I think I've just remembered part of it, but not the rest.

Appends an empty string:

REC = "A"
REC<-1> = ""

Doesn't append an empty string:

REC = ""
REC<-1> = ""

Sets REC<2> to an empty string:

REC = "A"
REC<2,-1> = ""
(Continue reading)

Permalink | Reply | 2 comments |
headers
Mecki Foerthmann | 3 May 2010 11:59
Picon

Re: [U2] <-1> and Null values

Well, I always thought this was an inconsistency.
After all unlike SQL in Pick Null is a valid value.
I've never used <-1> to suppress the writing of null values into
multi-valued fields because I hoped they would eventually fix that bug.
And for populating attributes I wouldn't use it anyway.
If I don't want to write nulls I test for it (IF VALUE # "" THEN...).
I think otherwise it's just lazy programming.
And isn't it just the opposite to what Symeon is saying?
Not putting nulls in gets associated arrays out of sync and therefore
you couldn't use <X,-1> before to populate them.
You needed to keep track of the position and use code like "VAR<C-1> =
VALUE1; POS = DCOUNT(VAR<C>, <at> VM);VAR<X,POS> = VALUE to make sure your
array stays in sync if VALUE could be null.
If your controlling attribute contains product codes for instance and
dependent attributes contain colour codes, serial or lot numbers or bin
locations you would want nulls in there if those are optional, or
wouldn't you?

just my 2 pennies

Mecki

Symeon Breen wrote:
> I think it depends on what flavour you are in as well - a number of the
> older pickies I work with keep forgetting this behaviour so i assume it is
> newer rather than older...  it is rather annoying when you are building up
> some associated arrays and for some reason a null pops up in the data
> somewhere - it throws the arrays out of synch
>
> -----Original Message-----
(Continue reading)

Permalink | Reply | 1 comment |
headers
Brian Leach | 3 May 2010 12:49
Picon

Re: [U2] <-1> and Null values

In UniVerse this is configurable via the $OPTIONS EXTRA.DELIM flag as well
as being flavor dependent.

But also in UniVerse, there is a specific null value ( <at> NULL) as opposed to
an empty string which is logically different.

Brian

_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Permalink | Reply | 0 comments |

Gmane