Re: [U2] New U2 BDT - V3

2012-03-16 Thread Symeon Breen
Just upgraded to v3  - I get this error whern connecting to my udt 7.2.
Build: (3865)   system on redhat

Base64 decoding on server failed. Status of ENCODE=4




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: 15 March 2012 16:59
To: U2 Users List
Subject: Re: [U2] New U2 BDT - V3

The in-product documentation for BDT has also undergone a revamp which will
be available the upcoming release.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Thursday, March 15, 2012 10:40 AM
To: U2 Users List
Subject: Re: [U2] New U2 BDT - V3

There is a Rocket BDT manual available for download.

--Bill 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley
Sent: Thursday, March 15, 2012 11:30 AM
To: U2 Users List
Subject: Re: [U2] New U2 BDT - V3

I would like to live in this tool all day long. I have experimented with BDT
some. I just installed BDT v3.0.0 so I'm anxious to learn what is new about
it.  I'm having to be able to be productive quickly, so I find myself
reverting back to WED when I have to get something done quick.
It would be helpful if there is an online tutorial, so I could
transition to BDT full time.  ? 

(I'm only interesting in learning about BDT, not any other alterative EDIs
at this time, thanks)



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Monday, March 12, 2012 2:46 PM
To: U2 Users List
Subject: Re: [U2] New U2 BDT - V3

The new BDT is version 3.0.0.

Considering that I live in this tool almost all day long, I appreciate
Rocket's updating it very much indeed.

--Bill





___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1424 / Virus Database: 2113/4871 - Release Date: 03/14/12

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Unusual code

2012-03-16 Thread Jacques G.


It isn't unusual for a multi-lingual system where the Y/N flags would be stored 
as boolean values and the text corresponding to the letters Y/N would be stored 
in a file somewhere.  Many languages have 'N' for no but have a different 
letter for Yes.  (Si, Oui, Ja for example).




 From: Wjhonson wjhon...@aol.com
To: u2-users@listserver.u2ug.org 
Sent: Thursday, March 15, 2012 1:23 PM
Subject: Re: [U2] Unusual code
 

I don't know why someone would have thought that Y equals 1 and N equals 2 
that's just odd to me.
The code is confusing enough to make me just want to say, if they entered a Y 
exit, if they entered a N continue or whatever.
That's job security right there!



-Original Message-
From: Symeon Breen syme...@gmail.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Thu, Mar 15, 2012 2:42 am
Subject: Re: [U2] Unusual code


So you can answer y or n or 1 or 2 to this pompt, and if it is n or 2 you are 
aken to ENTER.PROBLEM.CODES


Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of Wjhonson
ent: 15 March 2012 00:21
o: u2-users@listserver.u2ug.org
ubject: [U2] Unusual code

n my 25 years in Pick I have never seen a construction like this to test for Y 
r N or whatever it's doing.
hat is this doing?  What is this 1]2 and 1,1 doing ?  Why do I need this?

297: CHECK:   PRINT @(0,17): Are the problem codes correct (Y/N)?  :
298:          INPUT ANSWER
299:          LOCATE ANSWER IN '�Y�N�1�2'1,1 SETTING TEST ELSE PRINT BELL
300:          LOCATE ANSWER IN '�Y�1'1,1 SETTING TEST ELSE
301:             PRINT @(0,13):CLEAR.REST.SCREEN ; GOTO ENTER.PROBLEM.CODES
___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
-
o virus found in this message.
hecked by AVG - www.avg.com
ersion: 10.0.1424 / Virus Database: 2113/4870 - Release Date: 03/14/12
___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Unusual code

2012-03-16 Thread Allen E. Elwood
the code is so old it was before they invented the concept of zero

;-) 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Horn, John
Sent: Thursday, March 15, 2012 11:20 AM
To: U2 Users List
Subject: Re: [U2] Unusual code

Our system does the 1=Y, 2=N thing too. It is so that folks who are keying
on the keypad all day can stay on the keypad as much as possible without
having to go look for the Y or N keys. Keeps up productivity. Or at least
that is the theory.

That's my story and I'm sticking with it.

  - jmh

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Thursday, March 15, 2012 12:24 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Unusual code


I don't know why someone would have thought that Y equals 1 and N equals 2
that's just odd to me.
The code is confusing enough to make me just want to say, if they entered a
Y exit, if they entered a N continue or whatever.
That's job security right there!



-Original Message-
From: Symeon Breen syme...@gmail.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Thu, Mar 15, 2012 2:42 am
Subject: Re: [U2] Unusual code


So you can answer y or n or 1 or 2 to this pompt, and if it is n or 2 you
are aken to ENTER.PROBLEM.CODES


Original Message-
rom: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of Wjhonson
ent: 15 March 2012 00:21
o: u2-users@listserver.u2ug.org
ubject: [U2] Unusual code

n my 25 years in Pick I have never seen a construction like this to test for
Y 
r N or whatever it's doing.
hat is this doing?  What is this 1]2 and 1,1 doing ?  Why do I need this?

297: CHECK:   PRINT @(0,17): Are the problem codes correct (Y/N)?  :
298:  INPUT ANSWER
299:  LOCATE ANSWER IN ' Y N 1 2'1,1 SETTING TEST ELSE PRINT BELL
300:  LOCATE ANSWER IN ' Y 1'1,1 SETTING TEST ELSE
301: PRINT @(0,13):CLEAR.REST.SCREEN ; GOTO ENTER.PROBLEM.CODES
___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
-
o virus found in this message.
hecked by AVG - www.avg.com
ersion: 10.0.1424 / Virus Database: 2113/4870 - Release Date: 03/14/12
___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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 or otherwise protected by law. 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
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] New U2 BDT - V3

2012-03-16 Thread Daniel McGrath
Hi Symeon,



This means that BDT doesn't have permission to update XTOOLSUB in 
$UDTHOME/sys/SYS_BP. All of our eclipse tools will try to automatically update 
XTOOLSUB to make them easier to use with earlier U2 databases. You can try 
setting up a connection using a user that has sufficient privileges or you can 
follow the old process using the public technote for updating XTOOLSUB.



Engineering has also already addressed the error message to make it more 
meaningful in the next release.



Regards,

Dan





-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Friday, March 16, 2012 5:55 AM
To: 'U2 Users List'
Subject: Re: [U2] New U2 BDT - V3



Just upgraded to v3  - I get this error whern connecting to my udt 7.2.

Build: (3865)   system on redhat



Base64 decoding on server failed. Status of ENCODE=4









-Original Message-

From: 
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-boun...@listserver.u2ug.org]
 On Behalf Of Daniel McGrath

Sent: 15 March 2012 16:59

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



The in-product documentation for BDT has also undergone a revamp which will be 
available the upcoming release.



-Original Message-

From: 
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-boun...@listserver.u2ug.org]
 On Behalf Of Bill Brutzman

Sent: Thursday, March 15, 2012 10:40 AM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



There is a Rocket BDT manual available for download.



--Bill



-Original Message-

From: 
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-boun...@listserver.u2ug.org]
 On Behalf Of Bobby Worley

Sent: Thursday, March 15, 2012 11:30 AM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



I would like to live in this tool all day long. I have experimented with BDT 
some. I just installed BDT v3.0.0 so I'm anxious to learn what is new about it. 
 I'm having to be able to be productive quickly, so I find myself reverting 
back to WED when I have to get something done quick.

It would be helpful if there is an online tutorial, so I could

transition to BDT full time.  ?



(I'm only interesting in learning about BDT, not any other alterative EDIs at 
this time, thanks)







-Original Message-

From: 
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-boun...@listserver.u2ug.org]
 On Behalf Of Bill Brutzman

Sent: Monday, March 12, 2012 2:46 PM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



The new BDT is version 3.0.0.



Considering that I live in this tool almost all day long, I appreciate Rocket's 
updating it very much indeed.



--Bill











___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

-

No virus found in this message.

Checked by AVG - www.avg.comhttp://www.avg.com

Version: 10.0.1424 / Virus Database: 2113/4871 - Release Date: 03/14/12



___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] New U2 BDT - V3

2012-03-16 Thread Sunny Matharoo
Where can we get V3 as everywhere it is V1.2.4 BDT

Sunny

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel
McGrath
Sent: 16 March 2012 15:11
To: U2 Users List
Subject: Re: [U2] New U2 BDT - V3

Hi Symeon,



This means that BDT doesn't have permission to update XTOOLSUB in
$UDTHOME/sys/SYS_BP. All of our eclipse tools will try to automatically
update XTOOLSUB to make them easier to use with earlier U2 databases.
You can try setting up a connection using a user that has sufficient
privileges or you can follow the old process using the public technote
for updating XTOOLSUB.



Engineering has also already addressed the error message to make it more
meaningful in the next release.



Regards,

Dan





-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Friday, March 16, 2012 5:55 AM
To: 'U2 Users List'
Subject: Re: [U2] New U2 BDT - V3



Just upgraded to v3  - I get this error whern connecting to my udt 7.2.

Build: (3865)   system on redhat



Base64 decoding on server failed. Status of ENCODE=4









-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Daniel McGrath

Sent: 15 March 2012 16:59

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



The in-product documentation for BDT has also undergone a revamp which
will be available the upcoming release.



-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Bill Brutzman

Sent: Thursday, March 15, 2012 10:40 AM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



There is a Rocket BDT manual available for download.



--Bill



-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Bobby Worley

Sent: Thursday, March 15, 2012 11:30 AM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



I would like to live in this tool all day long. I have experimented with
BDT some. I just installed BDT v3.0.0 so I'm anxious to learn what is
new about it.  I'm having to be able to be productive quickly, so I find
myself reverting back to WED when I have to get something done quick.

It would be helpful if there is an online tutorial, so I could

transition to BDT full time.  ?



(I'm only interesting in learning about BDT, not any other alterative
EDIs at this time, thanks)







-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Bill Brutzman

Sent: Monday, March 12, 2012 2:46 PM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



The new BDT is version 3.0.0.



Considering that I live in this tool almost all day long, I appreciate
Rocket's updating it very much indeed.



--Bill











___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

-

No virus found in this message.

Checked by AVG - www.avg.comhttp://www.avg.com

Version: 10.0.1424 / Virus Database: 2113/4871 - Release Date: 03/14/12



___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] New U2 BDT - V3

2012-03-16 Thread Daniel McGrath
Sunny, download the U2 DBTools package here: 
http://www.rocketsoftware.com/u2/resources/downloads


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sunny Matharoo
Sent: Friday, March 16, 2012 9:52 AM
To: U2 Users List
Subject: Re: [U2] New U2 BDT - V3

Where can we get V3 as everywhere it is V1.2.4 BDT

Sunny

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: 16 March 2012 15:11
To: U2 Users List
Subject: Re: [U2] New U2 BDT - V3

Hi Symeon,



This means that BDT doesn't have permission to update XTOOLSUB in 
$UDTHOME/sys/SYS_BP. All of our eclipse tools will try to automatically update 
XTOOLSUB to make them easier to use with earlier U2 databases.
You can try setting up a connection using a user that has sufficient privileges 
or you can follow the old process using the public technote for updating 
XTOOLSUB.



Engineering has also already addressed the error message to make it more 
meaningful in the next release.



Regards,

Dan





-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Friday, March 16, 2012 5:55 AM
To: 'U2 Users List'
Subject: Re: [U2] New U2 BDT - V3



Just upgraded to v3  - I get this error whern connecting to my udt 7.2.

Build: (3865)   system on redhat



Base64 decoding on server failed. Status of ENCODE=4









-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Daniel McGrath

Sent: 15 March 2012 16:59

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



The in-product documentation for BDT has also undergone a revamp which will be 
available the upcoming release.



-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Bill Brutzman

Sent: Thursday, March 15, 2012 10:40 AM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



There is a Rocket BDT manual available for download.



--Bill



-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Bobby Worley

Sent: Thursday, March 15, 2012 11:30 AM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



I would like to live in this tool all day long. I have experimented with BDT 
some. I just installed BDT v3.0.0 so I'm anxious to learn what is new about it. 
 I'm having to be able to be productive quickly, so I find myself reverting 
back to WED when I have to get something done quick.

It would be helpful if there is an online tutorial, so I could

transition to BDT full time.  ?



(I'm only interesting in learning about BDT, not any other alterative EDIs at 
this time, thanks)







-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Bill Brutzman

Sent: Monday, March 12, 2012 2:46 PM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



The new BDT is version 3.0.0.



Considering that I live in this tool almost all day long, I appreciate Rocket's 
updating it very much indeed.



--Bill











___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

-

No virus found in this message.

Checked by AVG - www.avg.comhttp://www.avg.com

Version: 10.0.1424 / Virus Database: 2113/4871 - Release Date: 03/14/12



___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] New U2 BDT - V3

2012-03-16 Thread Symeon Breen
Thanks Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: 16 March 2012 15:11
To: U2 Users List
Subject: Re: [U2] New U2 BDT - V3

Hi Symeon,



This means that BDT doesn't have permission to update XTOOLSUB in
$UDTHOME/sys/SYS_BP. All of our eclipse tools will try to automatically
update XTOOLSUB to make them easier to use with earlier U2 databases. You
can try setting up a connection using a user that has sufficient privileges
or you can follow the old process using the public technote for updating
XTOOLSUB.



Engineering has also already addressed the error message to make it more
meaningful in the next release.



Regards,

Dan





-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Friday, March 16, 2012 5:55 AM
To: 'U2 Users List'
Subject: Re: [U2] New U2 BDT - V3



Just upgraded to v3  - I get this error whern connecting to my udt 7.2.

Build: (3865)   system on redhat



Base64 decoding on server failed. Status of ENCODE=4









-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.u2ug
.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bounce
s...@listserver.u2ug.org] On Behalf Of Daniel McGrath

Sent: 15 March 2012 16:59

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



The in-product documentation for BDT has also undergone a revamp which will
be available the upcoming release.



-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.u2ug
.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bounce
s...@listserver.u2ug.org] On Behalf Of Bill Brutzman

Sent: Thursday, March 15, 2012 10:40 AM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



There is a Rocket BDT manual available for download.



--Bill



-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.u2ug
.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bounce
s...@listserver.u2ug.org] On Behalf Of Bobby Worley

Sent: Thursday, March 15, 2012 11:30 AM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



I would like to live in this tool all day long. I have experimented with BDT
some. I just installed BDT v3.0.0 so I'm anxious to learn what is new about
it.  I'm having to be able to be productive quickly, so I find myself
reverting back to WED when I have to get something done quick.

It would be helpful if there is an online tutorial, so I could

transition to BDT full time.  ?



(I'm only interesting in learning about BDT, not any other alterative EDIs
at this time, thanks)







-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.u2ug
.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bounce
s...@listserver.u2ug.org] On Behalf Of Bill Brutzman

Sent: Monday, March 12, 2012 2:46 PM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



The new BDT is version 3.0.0.



Considering that I live in this tool almost all day long, I appreciate
Rocket's updating it very much indeed.



--Bill











___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

-

No virus found in this message.

Checked by AVG - www.avg.comhttp://www.avg.com

Version: 10.0.1424 / Virus Database: 2113/4871 - Release Date: 03/14/12



___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1424 / Virus Database: 2113/4873 - Release Date: 03/15/12

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] odbc error Unable to get UCI configuration file from Registry

2012-03-16 Thread Allen Egerton
I'm running Universe clients 10.3 against a server running 10.3, and
I've done something with my configuration that I can't resolve.

When I attempt to test the connection within the Universe ODBC Data
Source Setup, I consistently get this message:
[IBM][UVODBC]90301928]Error ID: 46 Severity:  ERROR Facility: DBCAPERR -
UCI Error. Func: SQLUseCfgFileFn(); State : IA001; uniVerse code:0;
Msg:[U2][SQL Client]Unable to get UCI configuration file from Registry..

I've de-installed the driver, cleaned the registry, re-installed the
driver, removed all Universe client applications/tools, re-installed
them, loop-repeat.

I know it's not the software itself, because we're using the same tools
here on similar laptops running the same OS, (windows-7 32bit), without
issues.

I've looked through the archives, looked through Experts-Exchange, and
googled a number of times.

Has anyone seen this before - and resolved it?

Thank you.

-- 
Allen Egerton; aeger...@pobox.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] New U2 BDT - V3

2012-03-16 Thread Sunny Matharoo
Thanks Daniel

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel
McGrath
Sent: 16 March 2012 16:14
To: U2 Users List
Subject: Re: [U2] New U2 BDT - V3

Sunny, download the U2 DBTools package here:
http://www.rocketsoftware.com/u2/resources/downloads


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sunny
Matharoo
Sent: Friday, March 16, 2012 9:52 AM
To: U2 Users List
Subject: Re: [U2] New U2 BDT - V3

Where can we get V3 as everywhere it is V1.2.4 BDT

Sunny

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel
McGrath
Sent: 16 March 2012 15:11
To: U2 Users List
Subject: Re: [U2] New U2 BDT - V3

Hi Symeon,



This means that BDT doesn't have permission to update XTOOLSUB in
$UDTHOME/sys/SYS_BP. All of our eclipse tools will try to automatically
update XTOOLSUB to make them easier to use with earlier U2 databases.
You can try setting up a connection using a user that has sufficient
privileges or you can follow the old process using the public technote
for updating XTOOLSUB.



Engineering has also already addressed the error message to make it more
meaningful in the next release.



Regards,

Dan





-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Friday, March 16, 2012 5:55 AM
To: 'U2 Users List'
Subject: Re: [U2] New U2 BDT - V3



Just upgraded to v3  - I get this error whern connecting to my udt 7.2.

Build: (3865)   system on redhat



Base64 decoding on server failed. Status of ENCODE=4









-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Daniel McGrath

Sent: 15 March 2012 16:59

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



The in-product documentation for BDT has also undergone a revamp which
will be available the upcoming release.



-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Bill Brutzman

Sent: Thursday, March 15, 2012 10:40 AM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



There is a Rocket BDT manual available for download.



--Bill



-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Bobby Worley

Sent: Thursday, March 15, 2012 11:30 AM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



I would like to live in this tool all day long. I have experimented with
BDT some. I just installed BDT v3.0.0 so I'm anxious to learn what is
new about it.  I'm having to be able to be productive quickly, so I find
myself reverting back to WED when I have to get something done quick.

It would be helpful if there is an online tutorial, so I could

transition to BDT full time.  ?



(I'm only interesting in learning about BDT, not any other alterative
EDIs at this time, thanks)







-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Bill Brutzman

Sent: Monday, March 12, 2012 2:46 PM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



The new BDT is version 3.0.0.



Considering that I live in this tool almost all day long, I appreciate
Rocket's updating it very much indeed.



--Bill











___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

-

No virus found in this message.

Checked by AVG - www.avg.comhttp://www.avg.com

Version: 10.0.1424 / Virus Database: 2113/4871 - Release Date: 03/14/12



___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org

Re: [U2] odbc error Unable to get UCI configuration file from Registry

2012-03-16 Thread Colin Alfke
Sorry, haven't seen it. Are you sure your UCI config file is OK? In my UCI
config file editor I have options to Get Registry and Reset Registry
under File. Perhaps that will help

hth
Colin

-Original Message-
From: Allen Egerton
Sent: March 16, 2012 10:29 AM
To: .U2 List
Subject: [U2] odbc error Unable to get UCI configuration file from
Registry

I'm running Universe clients 10.3 against a server running 10.3, and I've
done something with my configuration that I can't resolve.

When I attempt to test the connection within the Universe ODBC Data Source
Setup, I consistently get this message:
[IBM][UVODBC]90301928]Error ID: 46 Severity:  ERROR Facility: DBCAPERR - UCI
Error. Func: SQLUseCfgFileFn(); State : IA001; uniVerse code:0; Msg:[U2][SQL
Client]Unable to get UCI configuration file from Registry..

I've de-installed the driver, cleaned the registry, re-installed the driver,
removed all Universe client applications/tools, re-installed them,
loop-repeat.

I know it's not the software itself, because we're using the same tools here
on similar laptops running the same OS, (windows-7 32bit), without issues.

I've looked through the archives, looked through Experts-Exchange, and
googled a number of times.

Has anyone seen this before - and resolved it?

Thank you.

--
Allen Egerton 


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] New U2 BDT - V3

2012-03-16 Thread Woodward, Bob
We're using Unidata 6.1 and I don't see us upgrading any time soon.
Will V3 of the DBTools work for us?

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel
McGrath
Sent: Friday, March 16, 2012 9:14 AM
To: U2 Users List
Subject: Re: [U2] New U2 BDT - V3

Sunny, download the U2 DBTools package here:
http://www.rocketsoftware.com/u2/resources/downloads


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sunny
Matharoo
Sent: Friday, March 16, 2012 9:52 AM
To: U2 Users List
Subject: Re: [U2] New U2 BDT - V3

Where can we get V3 as everywhere it is V1.2.4 BDT

Sunny

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel
McGrath
Sent: 16 March 2012 15:11
To: U2 Users List
Subject: Re: [U2] New U2 BDT - V3

Hi Symeon,



This means that BDT doesn't have permission to update XTOOLSUB in
$UDTHOME/sys/SYS_BP. All of our eclipse tools will try to automatically
update XTOOLSUB to make them easier to use with earlier U2 databases.
You can try setting up a connection using a user that has sufficient
privileges or you can follow the old process using the public technote
for updating XTOOLSUB.



Engineering has also already addressed the error message to make it more
meaningful in the next release.



Regards,

Dan





-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Friday, March 16, 2012 5:55 AM
To: 'U2 Users List'
Subject: Re: [U2] New U2 BDT - V3



Just upgraded to v3  - I get this error whern connecting to my udt 7.2.

Build: (3865)   system on redhat



Base64 decoding on server failed. Status of ENCODE=4









-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Daniel McGrath

Sent: 15 March 2012 16:59

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



The in-product documentation for BDT has also undergone a revamp which
will be available the upcoming release.



-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Bill Brutzman

Sent: Thursday, March 15, 2012 10:40 AM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



There is a Rocket BDT manual available for download.



--Bill



-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Bobby Worley

Sent: Thursday, March 15, 2012 11:30 AM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



I would like to live in this tool all day long. I have experimented with
BDT some. I just installed BDT v3.0.0 so I'm anxious to learn what is
new about it.  I'm having to be able to be productive quickly, so I find
myself reverting back to WED when I have to get something done quick.

It would be helpful if there is an online tutorial, so I could

transition to BDT full time.  ?



(I'm only interesting in learning about BDT, not any other alterative
EDIs at this time, thanks)







-Original Message-

From:
u2-users-boun...@listserver.u2ug.orgmailto:u2-users-bounces@listserver.
u2ug.org

[mailto:u2-users-boun...@listserver.u2ug.org]mailto:[mailto:u2-users-bo
un...@listserver.u2ug.org] On Behalf Of Bill Brutzman

Sent: Monday, March 12, 2012 2:46 PM

To: U2 Users List

Subject: Re: [U2] New U2 BDT - V3



The new BDT is version 3.0.0.



Considering that I live in this tool almost all day long, I appreciate
Rocket's updating it very much indeed.



--Bill











___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

-

No virus found in this message.

Checked by AVG - www.avg.comhttp://www.avg.com

Version: 10.0.1424 / Virus Database: 2113/4871 - Release Date: 03/14/12



___

U2-Users mailing list

U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] odbc error Unable to get UCI configuration file from Registry

2012-03-16 Thread Allen Egerton
Hi Colin,

Sorry, I wish it was that simple.  After I went through the exercise a
couple of times, I got our tech support involved.  He's done at least
several dozen of these installs, (if not more), and he couldn't resolve
it either.

We've opened a ticket with Rocket, I figured I'd try here because if
it's happening to me, it's probably happened to someone else here, and I
might be able to get this resolved reasonably quickly.

And of course, it's not that I need ODBC access in and of itself, but
rather that I need it to test something I'm developing...

Thanks.



On 3/16/2012 12:53 PM, Colin Alfke wrote:
 Sorry, haven't seen it. Are you sure your UCI config file is OK? In my UCI
 config file editor I have options to Get Registry and Reset Registry
 under File. Perhaps that will help
 
 hth
 Colin
 
 -Original Message-
 From: Allen Egerton
 Sent: March 16, 2012 10:29 AM
 To: .U2 List
 Subject: [U2] odbc error Unable to get UCI configuration file from
 Registry
 
 I'm running Universe clients 10.3 against a server running 10.3, and I've
 done something with my configuration that I can't resolve.
 
 When I attempt to test the connection within the Universe ODBC Data Source
 Setup, I consistently get this message:
 [IBM][UVODBC]90301928]Error ID: 46 Severity:  ERROR Facility: DBCAPERR - UCI
 Error. Func: SQLUseCfgFileFn(); State : IA001; uniVerse code:0; Msg:[U2][SQL
 Client]Unable to get UCI configuration file from Registry..
 
 I've de-installed the driver, cleaned the registry, re-installed the driver,
 removed all Universe client applications/tools, re-installed them,
 loop-repeat.
 
 I know it's not the software itself, because we're using the same tools here
 on similar laptops running the same OS, (windows-7 32bit), without issues.
 
 I've looked through the archives, looked through Experts-Exchange, and
 googled a number of times.
 
 Has anyone seen this before - and resolved it?
 
 Thank you.
 
 --
 Allen Egerton 
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] odbc error Unable to get UCI configuration file from Registry

2012-03-16 Thread Colin Alfke
It was worth a shot - sometimes people miss the easy stuff because they're
concentrating too hard on the complicated stuff.

It's been close to 10 years since I've really looked at ODBC/OLE access to
UD. I see it's as cryptic as it ever was. I seem to recall an old issue that
required the UCI file to have a blank line at the end - but I'm pretty sure
it had a different error. I remember it worked well once you had the right
driver (I had one that would work with Access but not Excel?!?!?) and you
pedantically followed all of the steps (even so far as casing on a windows
box which is normally case insensitive).

Good luck!
Colin

-Original Message-
From: Allen Egerton
Sent: March 16, 2012 11:07 AM
To: U2 Users List
Subject: Re: [U2] odbc error Unable to get UCI configuration file from
Registry

Hi Colin,

Sorry, I wish it was that simple.  After I went through the exercise a
couple of times, I got our tech support involved.  He's done at least
several dozen of these installs, (if not more), and he couldn't resolve it
either.

We've opened a ticket with Rocket, I figured I'd try here because if it's
happening to me, it's probably happened to someone else here, and I might be
able to get this resolved reasonably quickly.

And of course, it's not that I need ODBC access in and of itself, but rather
that I need it to test something I'm developing...

Thanks.



On 3/16/2012 12:53 PM, Colin Alfke wrote:
 Sorry, haven't seen it. Are you sure your UCI config file is OK? In my 
 UCI config file editor I have options to Get Registry and Reset
Registry
 under File. Perhaps that will help
 
 hth
 Colin
 
 -Original Message-
 From: Allen Egerton
 Sent: March 16, 2012 10:29 AM
 To: .U2 List
 Subject: [U2] odbc error Unable to get UCI configuration file from 
 Registry
 
 I'm running Universe clients 10.3 against a server running 10.3, and 
 I've done something with my configuration that I can't resolve.
 
 When I attempt to test the connection within the Universe ODBC Data 
 Source Setup, I consistently get this message:
 [IBM][UVODBC]90301928]Error ID: 46 Severity:  ERROR Facility: DBCAPERR 
 - UCI Error. Func: SQLUseCfgFileFn(); State : IA001; uniVerse code:0; 
 Msg:[U2][SQL Client]Unable to get UCI configuration file from Registry..
 
 I've de-installed the driver, cleaned the registry, re-installed the 
 driver, removed all Universe client applications/tools, re-installed 
 them, loop-repeat.
 
 I know it's not the software itself, because we're using the same 
 tools here on similar laptops running the same OS, (windows-7 32bit),
without issues.
 
 I've looked through the archives, looked through Experts-Exchange, and 
 googled a number of times.
 
 Has anyone seen this before - and resolved it?
 
 Thank you.
 
 --
 Allen Egerton


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Turn a device and inode into file name

2012-03-16 Thread Wjhonson

Anyone have an easy way to do this?
In the past I've run a batch routine to just query each and every Universe file 
for it's inode and device and build a table of these

Every week
Seems like a great amount of overkill to me.
You could also mod the CREATE-FILE command to sniff it and make an xref entry 
but 

Any suggestions?
This is NOT for the case where you know the file and want to find the inode and 
device
It's for the case where you know the inode and device (only) and want to find 
the file.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread Martin Phillips
Hi,

There is no trivial way to do this because a single inode may correspond to 
multiple file names if there are links.

A useful trick if you run ACCOUNT.FILE.STATS from time to time is to look at 
the data file that it generates. This includes the
inode numbers.

Of course, a better solution is to write a little program to build a file that 
relates file names to inode numbers. You can then do
queries against this. Or you could add a VOC entry that finds the inode number 
for each F-type entry and query against this.


Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England
+44 (0)1604-709200



-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: 16 March 2012 19:24
To: u2-users@listserver.u2ug.org
Subject: [U2] Turn a device and inode into file name


Anyone have an easy way to do this?
In the past I've run a batch routine to just query each and every Universe file 
for it's inode and device and build a table of these

Every week
Seems like a great amount of overkill to me.
You could also mod the CREATE-FILE command to sniff it and make an xref entry 
but 

Any suggestions?
This is NOT for the case where you know the file and want to find the inode and 
device It's for the case where you know the inode
and device (only) and want to find the file.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread George Gallen
What about doing a df, then loop through each filesystem that is a universe 
directory, and run ls -i (looping through each directory)
   Then index the resulting ls's ?

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, March 16, 2012 3:24 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Turn a device and inode into file name


Anyone have an easy way to do this?
In the past I've run a batch routine to just query each and every Universe file 
for it's inode and device and build a table of these

Every week
Seems like a great amount of overkill to me.
You could also mod the CREATE-FILE command to sniff it and make an xref entry 
but 

Any suggestions?
This is NOT for the case where you know the file and want to find the inode and 
device
It's for the case where you know the inode and device (only) and want to find 
the file.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread George Gallen
Or loop through df with 'cd filesystemname ; find . -ls -depth | awk {print 
$x $y}'  where $x and $y are the
   Column numbers for the inode number and the filename

Of course, this would be for unix only

George 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, March 16, 2012 3:37 PM
To: U2 Users List
Subject: Re: [U2] Turn a device and inode into file name

What about doing a df, then loop through each filesystem that is a universe 
directory, and run ls -i (looping through each directory)
   Then index the resulting ls's ?

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, March 16, 2012 3:24 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Turn a device and inode into file name


Anyone have an easy way to do this?
In the past I've run a batch routine to just query each and every Universe file 
for it's inode and device and build a table of these

Every week
Seems like a great amount of overkill to me.
You could also mod the CREATE-FILE command to sniff it and make an xref entry 
but 

Any suggestions?
This is NOT for the case where you know the file and want to find the inode and 
device
It's for the case where you know the inode and device (only) and want to find 
the file.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread George Gallen
[george@alpha]$ find . -depth -ls | awk '{print $1,$11}' | pg
16390568 ./IP.KEYS.HOLD/OVER.30
16390570 ./IP.KEYS.HOLD/.Type30
16390569 ./IP.KEYS.HOLD/DATA.30
16390567 ./IP.KEYS.HOLD
15795741 ./VME-ADV-FILE/OVER.30
15795743 ./VME-ADV-FILE/.Type30
15795742 ./VME-ADV-FILE/DATA.30
15795740 ./VME-ADV-FILE
16847470 ./RATE-SHEE000/OVER.30
16847472 ./RATE-SHEE000/.Type30
16847471 ./RATE-SHEE000/DATA.30
16847469 ./RATE-SHEE000
15738624 ./D_NA0500-HOLD
15738846 ./D_BPA.SUMMA000
16847200 ./NA0028/OVER.30
16847202 ./NA0028/.Type30
16847201 ./NA0028/DATA.30
16847199 ./NA0028

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, March 16, 2012 3:46 PM
To: U2 Users List
Subject: Re: [U2] Turn a device and inode into file name

Or loop through df with 'cd filesystemname ; find . -ls -depth | awk {print 
$x $y}'  where $x and $y are the
   Column numbers for the inode number and the filename

Of course, this would be for unix only

George 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread Don Robinson
Try ls -li |grep inode# in the directory where the file is likley to be or
ls -liR / |grep inode# to look everythere.
 
You may need root permissions to check some files.
 
NO warranty!
 
Don Robinson

From: Wjhonson wjhon...@aol.com
To: u2-users@listserver.u2ug.org 
Sent: Friday, March 16, 2012 3:23 PM
Subject: [U2] Turn a device and inode into file name


Anyone have an easy way to do this?
In the past I've run a batch routine to just query each and every Universe file 
for it's inode and device and build a table of these

Every week
Seems like a great amount of overkill to me.
You could also mod the CREATE-FILE command to sniff it and make an xref entry 
but 

Any suggestions?
This is NOT for the case where you know the file and want to find the inode and 
device
It's for the case where you know the inode and device (only) and want to find 
the file.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] odbc error Unable to get UCI configuration file from Registry

2012-03-16 Thread Allen Egerton
How about I had to download the latest version of the driver?  Despite
the fact that everyone else in my organization is using the one that I
was trying to use?

That was Rocket's recommendation, and it worked.  Can't argue too much
with that.



On 3/16/2012 1:23 PM, Colin Alfke wrote:
 It was worth a shot - sometimes people miss the easy stuff because they're
 concentrating too hard on the complicated stuff.
 
 It's been close to 10 years since I've really looked at ODBC/OLE access to
 UD. I see it's as cryptic as it ever was. I seem to recall an old issue that
 required the UCI file to have a blank line at the end - but I'm pretty sure
 it had a different error. I remember it worked well once you had the right
 driver (I had one that would work with Access but not Excel?!?!?) and you
 pedantically followed all of the steps (even so far as casing on a windows
 box which is normally case insensitive).
 
 Good luck!
 Colin
 
 -Original Message-
 From: Allen Egerton
 Sent: March 16, 2012 11:07 AM
 To: U2 Users List
 Subject: Re: [U2] odbc error Unable to get UCI configuration file from
 Registry
 
 Hi Colin,
 
 Sorry, I wish it was that simple.  After I went through the exercise a
 couple of times, I got our tech support involved.  He's done at least
 several dozen of these installs, (if not more), and he couldn't resolve it
 either.
 
 We've opened a ticket with Rocket, I figured I'd try here because if it's
 happening to me, it's probably happened to someone else here, and I might be
 able to get this resolved reasonably quickly.
 
 And of course, it's not that I need ODBC access in and of itself, but rather
 that I need it to test something I'm developing...
 
 Thanks.
 
 
 
 On 3/16/2012 12:53 PM, Colin Alfke wrote:
 Sorry, haven't seen it. Are you sure your UCI config file is OK? In my 
 UCI config file editor I have options to Get Registry and Reset
 Registry
 under File. Perhaps that will help

 hth
 Colin

 -Original Message-
 From: Allen Egerton
 Sent: March 16, 2012 10:29 AM
 To: .U2 List
 Subject: [U2] odbc error Unable to get UCI configuration file from 
 Registry

 I'm running Universe clients 10.3 against a server running 10.3, and 
 I've done something with my configuration that I can't resolve.

 When I attempt to test the connection within the Universe ODBC Data 
 Source Setup, I consistently get this message:
 [IBM][UVODBC]90301928]Error ID: 46 Severity:  ERROR Facility: DBCAPERR 
 - UCI Error. Func: SQLUseCfgFileFn(); State : IA001; uniVerse code:0; 
 Msg:[U2][SQL Client]Unable to get UCI configuration file from Registry..

 I've de-installed the driver, cleaned the registry, re-installed the 
 driver, removed all Universe client applications/tools, re-installed 
 them, loop-repeat.

 I know it's not the software itself, because we're using the same 
 tools here on similar laptops running the same OS, (windows-7 32bit),
 without issues.

 I've looked through the archives, looked through Experts-Exchange, and 
 googled a number of times.

 Has anyone seen this before - and resolved it?

 Thank you.

 --
 Allen Egerton
 
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread Wjhonson
Are inodes unique across all devices?  I was under the impression that they 
were not, and therefore you need both for a unique correspondence



-Original Message-
From: Don Robinson donr_w...@yahoo.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Fri, Mar 16, 2012 12:58 pm
Subject: Re: [U2] Turn a device and inode into file name


Try ls -li |grep inode# in the directory where the file is likley to be or
ls -liR / |grep inode# to look everythere.

ou may need root permissions to check some files.

O warranty!

on Robinson
From: Wjhonson wjhon...@aol.com
o: u2-users@listserver.u2ug.org 
ent: Friday, March 16, 2012 3:23 PM
ubject: [U2] Turn a device and inode into file name

nyone have an easy way to do this?
n the past I've run a batch routine to just query each and every Universe file 
or it's inode and device and build a table of these
Every week
eems like a great amount of overkill to me.
ou could also mod the CREATE-FILE command to sniff it and make an xref entry 
ut 
Any suggestions?
his is NOT for the case where you know the file and want to find the inode and 
evice
t's for the case where you know the inode and device (only) and want to find 
he file.
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread George Gallen
As far as I understood, no, they are unique only to their device, so you could 
have multiple files
With the same inode in different filesystems.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, March 16, 2012 4:44 PM
To: donr_w...@yahoo.com; u2-users@listserver.u2ug.org
Subject: Re: [U2] Turn a device and inode into file name

Are inodes unique across all devices?  I was under the impression that they 
were not, and therefore you need both for a unique correspondence



-Original Message-
From: Don Robinson donr_w...@yahoo.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Fri, Mar 16, 2012 12:58 pm
Subject: Re: [U2] Turn a device and inode into file name


Try ls -li |grep inode# in the directory where the file is likley to be or
ls -liR / |grep inode# to look everythere.

ou may need root permissions to check some files.

O warranty!

on Robinson
From: Wjhonson wjhon...@aol.com
o: u2-users@listserver.u2ug.org 
ent: Friday, March 16, 2012 3:23 PM
ubject: [U2] Turn a device and inode into file name

nyone have an easy way to do this?
n the past I've run a batch routine to just query each and every Universe file 
or it's inode and device and build a table of these
Every week
eems like a great amount of overkill to me.
ou could also mod the CREATE-FILE command to sniff it and make an xref entry 
ut 
Any suggestions?
his is NOT for the case where you know the file and want to find the inode and 
evice
t's for the case where you know the inode and device (only) and want to find 
he file.
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread Wjhonson

It seems like an on the fly scan across all possible filesystems would be 
really slow.
I can't see how you can escape having a cross reference that gets rebuilt 
periodically.
No one is going to want to wait a minute in interactive mode for a response.
No one else has encountered the issue that you can't tell what file a lock is 
being set on?
Some people can tell from the key I suppose, at time, but many files can share 
a similar key.
It seems odd to me, that after twenty years, we still have this issue in 
Universe.



-Original Message-
From: George Gallen ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Fri, Mar 16, 2012 1:46 pm
Subject: Re: [U2] Turn a device and inode into file name


As far as I understood, no, they are unique only to their device, so you could 
ave multiple files
ith the same inode in different filesystems.

Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of Wjhonson
ent: Friday, March 16, 2012 4:44 PM
o: donr_w...@yahoo.com; u2-users@listserver.u2ug.org
ubject: Re: [U2] Turn a device and inode into file name
Are inodes unique across all devices?  I was under the impression that they 
were 
ot, and therefore you need both for a unique correspondence

-Original Message-
rom: Don Robinson donr_w...@yahoo.com
o: U2 Users List u2-users@listserver.u2ug.org
ent: Fri, Mar 16, 2012 12:58 pm
ubject: Re: [U2] Turn a device and inode into file name

ry ls -li |grep inode# in the directory where the file is likley to be or
s -liR / |grep inode# to look everythere.
ou may need root permissions to check some files.
O warranty!
on Robinson
rom: Wjhonson wjhon...@aol.com
: u2-users@listserver.u2ug.org 
nt: Friday, March 16, 2012 3:23 PM
bject: [U2] Turn a device and inode into file name
nyone have an easy way to do this?
 the past I've run a batch routine to just query each and every Universe file 
r it's inode and device and build a table of these
very week
ems like a great amount of overkill to me.
u could also mod the CREATE-FILE command to sniff it and make an xref entry 
t 
ny suggestions?
is is NOT for the case where you know the file and want to find the inode and 
vice
's for the case where you know the inode and device (only) and want to find 
e file.
_
-Users mailing list
-us...@listserver.u2ug.org
tp://listserver.u2ug.org/mailman/listinfo/u2-users
_
-Users mailing list
-us...@listserver.u2ug.org
tp://listserver.u2ug.org/mailman/listinfo/u2-users
___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread George Gallen
I did a couple tests using:

find (device) -xdev -inode # -print

And it wasn't too much of a delay (instant to few seconds)

George


Other than that I just ran the following (for xref method)

cd /data2 ; find . -depth -ls | awk '{print $1,$11}'   /tmp/inodelist   and it 
ran fairly fast, so if you were to 
   create a xref, cron could probably run that every 30 mins without taking up 
too much processing time.  

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, March 16, 2012 5:03 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Turn a device and inode into file name


It seems like an on the fly scan across all possible filesystems would be 
really slow.
I can't see how you can escape having a cross reference that gets rebuilt 
periodically.
No one is going to want to wait a minute in interactive mode for a response.
No one else has encountered the issue that you can't tell what file a lock is 
being set on?
Some people can tell from the key I suppose, at time, but many files can share 
a similar key.
It seems odd to me, that after twenty years, we still have this issue in 
Universe.



-Original Message-
From: George Gallen ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Fri, Mar 16, 2012 1:46 pm
Subject: Re: [U2] Turn a device and inode into file name


As far as I understood, no, they are unique only to their device, so you could 
ave multiple files
ith the same inode in different filesystems.

Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of Wjhonson
ent: Friday, March 16, 2012 4:44 PM
o: donr_w...@yahoo.com; u2-users@listserver.u2ug.org
ubject: Re: [U2] Turn a device and inode into file name
Are inodes unique across all devices?  I was under the impression that they 
were 
ot, and therefore you need both for a unique correspondence

-Original Message-
rom: Don Robinson donr_w...@yahoo.com
o: U2 Users List u2-users@listserver.u2ug.org
ent: Fri, Mar 16, 2012 12:58 pm
ubject: Re: [U2] Turn a device and inode into file name

ry ls -li |grep inode# in the directory where the file is likley to be or
s -liR / |grep inode# to look everythere.
ou may need root permissions to check some files.
O warranty!
on Robinson
rom: Wjhonson wjhon...@aol.com
: u2-users@listserver.u2ug.org 
nt: Friday, March 16, 2012 3:23 PM
bject: [U2] Turn a device and inode into file name
nyone have an easy way to do this?
 the past I've run a batch routine to just query each and every Universe file 
r it's inode and device and build a table of these
very week
ems like a great amount of overkill to me.
u could also mod the CREATE-FILE command to sniff it and make an xref entry 
t 
ny suggestions?
is is NOT for the case where you know the file and want to find the inode and 
vice
's for the case where you know the inode and device (only) and want to find 
e file.
_
-Users mailing list
-us...@listserver.u2ug.org
tp://listserver.u2ug.org/mailman/listinfo/u2-users
_
-Users mailing list
-us...@listserver.u2ug.org
tp://listserver.u2ug.org/mailman/listinfo/u2-users
___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread George Gallen
Just thinking, you could also add a modification time to the find, (if your 
doing xrefs), and only
Reindex those files that have been changed (or created) since the last time you 
ran it?  If you
Use the device and inode as key in your xref, it will overwrite any deleted 
files where the inode
Is re-used.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, March 16, 2012 5:23 PM
To: U2 Users List
Subject: Re: [U2] Turn a device and inode into file name

I did a couple tests using:

find (device) -xdev -inode # -print

And it wasn't too much of a delay (instant to few seconds)

George


Other than that I just ran the following (for xref method)

cd /data2 ; find . -depth -ls | awk '{print $1,$11}'   /tmp/inodelist   and it 
ran fairly fast, so if you were to 
   create a xref, cron could probably run that every 30 mins without taking up 
too much processing time.  

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread LeRoy Dreyfuss
A program that uses either the FILEINFO() function or the STATUS statement will 
produce what you need, and should work cross-platform. Select against the VOC 
and filter out what you don't need, i.e. remote files, Q-pointers etc.

Regards,

LeRoy
Sent from my iPhone 4

On Mar 16, 2012, at 3:23 PM, Wjhonson wjhon...@aol.com wrote:

 
 Anyone have an easy way to do this?
 In the past I've run a batch routine to just query each and every Universe 
 file for it's inode and device and build a table of these
 
 Every week
 Seems like a great amount of overkill to me.
 You could also mod the CREATE-FILE command to sniff it and make an xref entry 
 but 
 
 Any suggestions?
 This is NOT for the case where you know the file and want to find the inode 
 and device
 It's for the case where you know the inode and device (only) and want to find 
 the file.
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread John Hester
I have a utility named FLIST.READU that replaces the inode from the
standard LIST.READU output with the file name.  It uses ls -i, so it's
limited to files in the account you run the command from, though.  Works
fine for us because all of our users work out of the same account.  This
is the relevant part of the code:

 INODE.NO = TRIM(READU.ARRAYI,3)
 EXECUTE 'SH -c ls -i | grep ':INODE.NO:'', OUT  FILENAME
 IF FILENAME1,1,1 # '' THEN
   FILENAME = FIELD(TRIM(FILENAME1,1,1),' ',2) 'L#8'

It's also pretty resource intensive because it re-lists the entire
account for every inode.  Probably not much of an issue if your hardware
is fairly new.

-John

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, March 16, 2012 12:24 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Turn a device and inode into file name


Anyone have an easy way to do this?
In the past I've run a batch routine to just query each and every
Universe file for it's inode and device and build a table of these

Every week
Seems like a great amount of overkill to me.
You could also mod the CREATE-FILE command to sniff it and make an xref
entry but 

Any suggestions?
This is NOT for the case where you know the file and want to find the
inode and device It's for the case where you know the inode and device
(only) and want to find the file.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread Wjhonson
The file could be in any account, so you'd have to expand this to select every 
file in every account



-Original Message-
From: LeRoy Dreyfuss lfd...@gmail.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Fri, Mar 16, 2012 3:00 pm
Subject: Re: [U2] Turn a device and inode into file name


A program that uses either the FILEINFO() function or the STATUS statement will 
roduce what you need, and should work cross-platform. Select against the VOC 
nd filter out what you don't need, i.e. remote files, Q-pointers etc.
Regards,
LeRoy
ent from my iPhone 4
On Mar 16, 2012, at 3:23 PM, Wjhonson wjhon...@aol.com wrote:
 
 Anyone have an easy way to do this?
 In the past I've run a batch routine to just query each and every Universe 
ile for it's inode and device and build a table of these
 
 Every week
 Seems like a great amount of overkill to me.
 You could also mod the CREATE-FILE command to sniff it and make an xref entry 
ut 
 
 Any suggestions?
 This is NOT for the case where you know the file and want to find the inode 
nd device
 It's for the case where you know the inode and device (only) and want to find 
he file.
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread Wjhonson
This only works if you have a single device, since the inode is not unique 
cross-device, only unique on a device



-Original Message-
From: John Hester jhes...@momtex.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Fri, Mar 16, 2012 3:25 pm
Subject: Re: [U2] Turn a device and inode into file name


I have a utility named FLIST.READU that replaces the inode from the
tandard LIST.READU output with the file name.  It uses ls -i, so it's
imited to files in the account you run the command from, though.  Works
ine for us because all of our users work out of the same account.  This
s the relevant part of the code:
 INODE.NO = TRIM(READU.ARRAYI,3)
EXECUTE 'SH -c ls -i | grep ':INODE.NO:'', OUT  FILENAME
IF FILENAME1,1,1 # '' THEN
  FILENAME = FIELD(TRIM(FILENAME1,1,1),' ',2) 'L#8'
It's also pretty resource intensive because it re-lists the entire
ccount for every inode.  Probably not much of an issue if your hardware
s fairly new.
-John
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
ent: Friday, March 16, 2012 12:24 PM
o: u2-users@listserver.u2ug.org
ubject: [U2] Turn a device and inode into file name

nyone have an easy way to do this?
n the past I've run a batch routine to just query each and every
niverse file for it's inode and device and build a table of these
Every week
eems like a great amount of overkill to me.
ou could also mod the CREATE-FILE command to sniff it and make an xref
ntry but 
Any suggestions?
his is NOT for the case where you know the file and want to find the
node and device It's for the case where you know the inode and device
only) and want to find the file.
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread Buss, Troy (Logitek Systems)
We use the following subroutine.   Pass in the filename in variable FNAME.   In 
the mainline is 'THIS.ACCOUNT' and of course the F.FILESTATS.XREF file variable.

We then use this information in our expanded record locks display so that we 
can show real file names.

UPDATE.XREF: *;*
*
CRT Building item lock xref... :
*
OPEN FNAME TO F.CHECK ELSE
  CRT CANNOT OPEN: :FNAME
  RETURN
END
*
STATUS STATUS.INFO FROM F.CHECK THEN
  DEVICE = STATUS.INFO11
  XREF.ITEM = AM:THIS.ACCOUNT:*:FNAME
  WRITE XREF.ITEM ON F.FILESTATS.XREF, DEVICE
END
*
CLOSE F.CHECK
*
RETURN

*


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, March 16, 2012 12:24 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Turn a device and inode into file name


Anyone have an easy way to do this?
In the past I've run a batch routine to just query each and every Universe file 
for it's inode and device and build a table of these

_
Scanned by IBM Email Security Management Services powered by MessageLabs. For 
more information please visit http://www.ers.ibm.com

This email is intended only for the use of the party to which it is addressed 
and may contain information that is privileged, confidential, or protected by 
law.  If you are not the intended recipient you are hereby notified that any 
dissemination, copying or distribution of the email or its contents is strictly 
prohibited.  If you have received this message in error, please notify us 
immediately, by replying to the message and deleting it from your computer.

WARNING: Internet communications are not assured to be secure or clear of 
inaccuracies as information could be intercepted, corrupted, lost, destroyed, 
arrive late or incomplete, or contain viruses.  Therefore, we do not accept 
responsibility for any errors or omissions that are present in this email, or 
any attachment, that have arisen as a result of e-mail transmission.
_
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread dianne
I swear I wrote a new version of LIST.READU at one time where I dealt with this
and listed the file where the item was locked, but I can't find it anywhere. 
And now, of course, I'm obsessed with finding it.  If I find it I'll post it.
-Dianne


Quoting Wjhonson wjhon...@aol.com:

 
 It seems like an on the fly scan across all possible filesystems would be
 really slow.
 I can't see how you can escape having a cross reference that gets rebuilt
 periodically.
 No one is going to want to wait a minute in interactive mode for a response.
 No one else has encountered the issue that you can't tell what file a lock is
 being set on?
 Some people can tell from the key I suppose, at time, but many files can
 share a similar key.
 It seems odd to me, that after twenty years, we still have this issue in
 Universe.
 
 
 
 -Original Message-
 From: George Gallen ggal...@wyanokegroup.com
 To: U2 Users List u2-users@listserver.u2ug.org
 Sent: Fri, Mar 16, 2012 1:46 pm
 Subject: Re: [U2] Turn a device and inode into file name
 
 
 As far as I understood, no, they are unique only to their device, so you
 could 
 ave multiple files
 ith the same inode in different filesystems.
 
 Original Message-
 rom: u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] 
 n Behalf Of Wjhonson
 ent: Friday, March 16, 2012 4:44 PM
 o: donr_w...@yahoo.com; u2-users@listserver.u2ug.org
 ubject: Re: [U2] Turn a device and inode into file name
 Are inodes unique across all devices?  I was under the impression that they
 were 
 ot, and therefore you need both for a unique correspondence
 
 -Original Message-
 rom: Don Robinson donr_w...@yahoo.com
 o: U2 Users List u2-users@listserver.u2ug.org
 ent: Fri, Mar 16, 2012 12:58 pm
 ubject: Re: [U2] Turn a device and inode into file name
 
 ry ls -li |grep inode# in the directory where the file is likley to be or
 s -liR / |grep inode# to look everythere.
 ou may need root permissions to check some files.
 O warranty!
 on Robinson
 rom: Wjhonson wjhon...@aol.com
 : u2-users@listserver.u2ug.org 
 nt: Friday, March 16, 2012 3:23 PM
 bject: [U2] Turn a device and inode into file name
 nyone have an easy way to do this?
  the past I've run a batch routine to just query each and every Universe file
 
 r it's inode and device and build a table of these
 very week
 ems like a great amount of overkill to me.
 u could also mod the CREATE-FILE command to sniff it and make an xref entry 
 t 
 ny suggestions?
 is is NOT for the case where you know the file and want to find the inode and
 
 vice
 's for the case where you know the inode and device (only) and want to find 
 e file.
 _
 -Users mailing list
 -us...@listserver.u2ug.org
 tp://listserver.u2ug.org/mailman/listinfo/u2-users
 _
 -Users mailing list
 -us...@listserver.u2ug.org
 tp://listserver.u2ug.org/mailman/listinfo/u2-users
 ___
 2-Users mailing list
 2-us...@listserver.u2ug.org
 ttp://listserver.u2ug.org/mailman/listinfo/u2-users
 __
 2-Users mailing list
 2-us...@listserver.u2ug.org
 ttp://listserver.u2ug.org/mailman/listinfo/u2-users
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 




___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread Wjhonson

In my case, you do not know the filename.
The only thing you know is the Inode and Device.
The task is to *find* the filename based on knowing only the Inode and Device



-Original Message-
From: Buss, Troy (Logitek Systems) (Logitek Systems) 
troy.b...@nordsonasymtek.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Fri, Mar 16, 2012 3:47 pm
Subject: Re: [U2] Turn a device and inode into file name


We use the following subroutine.   Pass in the filename in variable FNAME.   In 
he mainline is 'THIS.ACCOUNT' and of course the F.FILESTATS.XREF file variable.
We then use this information in our expanded record locks display so that we 
can 
how real file names.
UPDATE.XREF: *;*

RT Building item lock xref... :

PEN FNAME TO F.CHECK ELSE
 CRT CANNOT OPEN: :FNAME
 RETURN
ND

TATUS STATUS.INFO FROM F.CHECK THEN
 DEVICE = STATUS.INFO11
 XREF.ITEM = AM:THIS.ACCOUNT:*:FNAME
 WRITE XREF.ITEM ON F.FILESTATS.XREF, DEVICE
ND

LOSE F.CHECK

ETURN
*

Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of Wjhonson
ent: Friday, March 16, 2012 12:24 PM
o: u2-users@listserver.u2ug.org
ubject: [U2] Turn a device and inode into file name

nyone have an easy way to do this?
n the past I've run a batch routine to just query each and every Universe file 
or it's inode and device and build a table of these
_
canned by IBM Email Security Management Services powered by MessageLabs. For 
ore information please visit http://www.ers.ibm.com
This email is intended only for the use of the party to which it is addressed 
nd may contain information that is privileged, confidential, or protected by 
aw.  If you are not the intended recipient you are hereby notified that any 
issemination, copying or distribution of the email or its contents is strictly 
rohibited.  If you have received this message in error, please notify us 
mmediately, by replying to the message and deleting it from your computer.
WARNING: Internet communications are not assured to be secure or clear of 
naccuracies as information could be intercepted, corrupted, lost, destroyed, 
rrive late or incomplete, or contain viruses.  Therefore, we do not accept 
esponsibility for any errors or omissions that are present in this email, or 
ny attachment, that have arisen as a result of e-mail transmission.

__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread John Hester
It works fine if you have multiple devices because you can only run it
against one account and one device at a time.  ls -i doesn't span
directory hierarchies or devices.  You do at least have to know what
device the file in question is on, but if you don't know that there's no
tool that will reliably work for you.

-John 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, March 16, 2012 3:43 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Turn a device and inode into file name

This only works if you have a single device, since the inode is not
unique cross-device, only unique on a device



-Original Message-
From: John Hester jhes...@momtex.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Fri, Mar 16, 2012 3:25 pm
Subject: Re: [U2] Turn a device and inode into file name


I have a utility named FLIST.READU that replaces the inode from the
tandard LIST.READU output with the file name.  It uses ls -i, so it's
imited to files in the account you run the command from, though.  Works
ine for us because all of our users work out of the same account.  This
s the relevant part of the code:
 INODE.NO = TRIM(READU.ARRAYI,3)
EXECUTE 'SH -c ls -i | grep ':INODE.NO:'', OUT  FILENAME
IF FILENAME1,1,1 # '' THEN
  FILENAME = FIELD(TRIM(FILENAME1,1,1),' ',2) 'L#8'
It's also pretty resource intensive because it re-lists the entire
ccount for every inode.  Probably not much of an issue if your hardware
s fairly new.
-John
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
ent: Friday, March 16, 2012 12:24 PM
o: u2-users@listserver.u2ug.org
ubject: [U2] Turn a device and inode into file name

nyone have an easy way to do this?
n the past I've run a batch routine to just query each and every niverse
file for it's inode and device and build a table of these Every week
eems like a great amount of overkill to me.
ou could also mod the CREATE-FILE command to sniff it and make an xref
ntry but 
Any suggestions?
his is NOT for the case where you know the file and want to find the
node and device It's for the case where you know the inode and device
only) and want to find the file.
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread Wjhonson

The provided code does not specify a device, so how can you select a device  
even if you know it?
It doesn't seem to be changing devices



-Original Message-
From: John Hester jhes...@momtex.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Fri, Mar 16, 2012 4:41 pm
Subject: Re: [U2] Turn a device and inode into file name


It works fine if you have multiple devices because you can only run it
gainst one account and one device at a time.  ls -i doesn't span
irectory hierarchies or devices.  You do at least have to know what
evice the file in question is on, but if you don't know that there's no
ool that will reliably work for you.
-John 
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
ent: Friday, March 16, 2012 3:43 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] Turn a device and inode into file name
This only works if you have a single device, since the inode is not
nique cross-device, only unique on a device

-Original Message-
rom: John Hester jhes...@momtex.com
o: U2 Users List u2-users@listserver.u2ug.org
ent: Fri, Mar 16, 2012 3:25 pm
ubject: Re: [U2] Turn a device and inode into file name

 have a utility named FLIST.READU that replaces the inode from the
andard LIST.READU output with the file name.  It uses ls -i, so it's
mited to files in the account you run the command from, though.  Works
ne for us because all of our users work out of the same account.  This
 the relevant part of the code:
INODE.NO = TRIM(READU.ARRAYI,3)
   EXECUTE 'SH -c ls -i | grep ':INODE.NO:'', OUT  FILENAME
   IF FILENAME1,1,1 # '' THEN
 FILENAME = FIELD(TRIM(FILENAME1,1,1),' ',2) 'L#8'
t's also pretty resource intensive because it re-lists the entire
count for every inode.  Probably not much of an issue if your hardware
 fairly new.
John
Original Message-
om: u2-users-boun...@listserver.u2ug.org
ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
nt: Friday, March 16, 2012 12:24 PM
: u2-users@listserver.u2ug.org
bject: [U2] Turn a device and inode into file name
nyone have an easy way to do this?
 the past I've run a batch routine to just query each and every niverse
ile for it's inode and device and build a table of these Every week
ems like a great amount of overkill to me.
u could also mod the CREATE-FILE command to sniff it and make an xref
try but 
ny suggestions?
is is NOT for the case where you know the file and want to find the
ode and device It's for the case where you know the inode and device
nly) and want to find the file.
_
-Users mailing list
-us...@listserver.u2ug.org
tp://listserver.u2ug.org/mailman/listinfo/u2-users
_
-Users mailing list
-us...@listserver.u2ug.org
tp://listserver.u2ug.org/mailman/listinfo/u2-users
___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread John Hester
If you execute ls -i from within UV, it's going to list the files in
the directory where the account you're sitting in resides.  My code
example isn't written to be able to switch devices because that's of no
use to me in the context of listing locked production files in our
environment.  If you want to write a utility that executes ls -i on
any device, that's fairly trivial and there are numerous ways you could
do it.  Just write some code to get the correct path into a variable by
whatever means you prefer and tack it on to the end of the command.

-John

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, March 16, 2012 4:47 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Turn a device and inode into file name


The provided code does not specify a device, so how can you select a
device  even if you know it?
It doesn't seem to be changing devices



-Original Message-
From: John Hester jhes...@momtex.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Fri, Mar 16, 2012 4:41 pm
Subject: Re: [U2] Turn a device and inode into file name


It works fine if you have multiple devices because you can only run it
gainst one account and one device at a time.  ls -i doesn't span
irectory hierarchies or devices.  You do at least have to know what
evice the file in question is on, but if you don't know that there's no
ool that will reliably work for you.
-John
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
ent: Friday, March 16, 2012 3:43 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] Turn a device and inode into file name This only works
if you have a single device, since the inode is not nique cross-device,
only unique on a device

-Original Message-
rom: John Hester jhes...@momtex.com
o: U2 Users List u2-users@listserver.u2ug.org
ent: Fri, Mar 16, 2012 3:25 pm
ubject: Re: [U2] Turn a device and inode into file name

 have a utility named FLIST.READU that replaces the inode from the
andard LIST.READU output with the file name.  It uses ls -i, so it's
mited to files in the account you run the command from, though.  Works
ne for us because all of our users work out of the same account.  This
the relevant part of the code:
INODE.NO = TRIM(READU.ARRAYI,3)
   EXECUTE 'SH -c ls -i | grep ':INODE.NO:'', OUT  FILENAME
   IF FILENAME1,1,1 # '' THEN
 FILENAME = FIELD(TRIM(FILENAME1,1,1),' ',2) 'L#8'
t's also pretty resource intensive because it re-lists the entire count
for every inode.  Probably not much of an issue if your hardware  fairly
new.
John
Original Message-
om: u2-users-boun...@listserver.u2ug.org
ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
nt: Friday, March 16, 2012 12:24 PM
: u2-users@listserver.u2ug.org
bject: [U2] Turn a device and inode into file name nyone have an easy
way to do this?
 the past I've run a batch routine to just query each and every niverse
ile for it's inode and device and build a table of these Every week
ems like a great amount of overkill to me.
u could also mod the CREATE-FILE command to sniff it and make an xref
try but 
ny suggestions?
is is NOT for the case where you know the file and want to find the ode
and device It's for the case where you know the inode and device
nly) and want to find the file.
_
-Users mailing list
-us...@listserver.u2ug.org
tp://listserver.u2ug.org/mailman/listinfo/u2-users
_
-Users mailing list
-us...@listserver.u2ug.org
tp://listserver.u2ug.org/mailman/listinfo/u2-users
___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread Wjhonson

The lock table spans all accounts.
To list the file associated with any particular lock, you have to span all 
devices, not just a device.
You can't assume that you know the account in which a locked inode resides.



-Original Message-
From: John Hester jhes...@momtex.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Fri, Mar 16, 2012 5:10 pm
Subject: Re: [U2] Turn a device and inode into file name


If you execute ls -i from within UV, it's going to list the files in
he directory where the account you're sitting in resides.  My code
xample isn't written to be able to switch devices because that's of no
se to me in the context of listing locked production files in our
nvironment.  If you want to write a utility that executes ls -i on
ny device, that's fairly trivial and there are numerous ways you could
o it.  Just write some code to get the correct path into a variable by
hatever means you prefer and tack it on to the end of the command.
-John
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
ent: Friday, March 16, 2012 4:47 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] Turn a device and inode into file name

he provided code does not specify a device, so how can you select a
evice  even if you know it?
t doesn't seem to be changing devices

-Original Message-
rom: John Hester jhes...@momtex.com
o: U2 Users List u2-users@listserver.u2ug.org
ent: Fri, Mar 16, 2012 4:41 pm
ubject: Re: [U2] Turn a device and inode into file name

t works fine if you have multiple devices because you can only run it
ainst one account and one device at a time.  ls -i doesn't span
rectory hierarchies or devices.  You do at least have to know what
vice the file in question is on, but if you don't know that there's no
ol that will reliably work for you.
John
Original Message-
om: u2-users-boun...@listserver.u2ug.org
ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
nt: Friday, March 16, 2012 3:43 PM
: u2-users@listserver.u2ug.org
bject: Re: [U2] Turn a device and inode into file name This only works
f you have a single device, since the inode is not nique cross-device,
nly unique on a device
-Original Message-
om: John Hester jhes...@momtex.com
: U2 Users List u2-users@listserver.u2ug.org
nt: Fri, Mar 16, 2012 3:25 pm
bject: Re: [U2] Turn a device and inode into file name
 have a utility named FLIST.READU that replaces the inode from the
ndard LIST.READU output with the file name.  It uses ls -i, so it's
ited to files in the account you run the command from, though.  Works
e for us because all of our users work out of the same account.  This
he relevant part of the code:
   INODE.NO = TRIM(READU.ARRAYI,3)
  EXECUTE 'SH -c ls -i | grep ':INODE.NO:'', OUT  FILENAME
  IF FILENAME1,1,1 # '' THEN
FILENAME = FIELD(TRIM(FILENAME1,1,1),' ',2) 'L#8'
's also pretty resource intensive because it re-lists the entire count
or every inode.  Probably not much of an issue if your hardware  fairly
ew.
ohn
---Original Message-
m: u2-users-boun...@listserver.u2ug.org
ilto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
t: Friday, March 16, 2012 12:24 PM
 u2-users@listserver.u2ug.org
ject: [U2] Turn a device and inode into file name nyone have an easy
ay to do this?
the past I've run a batch routine to just query each and every niverse
le for it's inode and device and build a table of these Every week
ms like a great amount of overkill to me.
 could also mod the CREATE-FILE command to sniff it and make an xref
ry but 
y suggestions?
s is NOT for the case where you know the file and want to find the ode
nd device It's for the case where you know the inode and device
ly) and want to find the file.

Users mailing list
us...@listserver.u2ug.org
p://listserver.u2ug.org/mailman/listinfo/u2-users

Users mailing list
us...@listserver.u2ug.org
p://listserver.u2ug.org/mailman/listinfo/u2-users
__
-Users mailing list
-us...@listserver.u2ug.org
tp://listserver.u2ug.org/mailman/listinfo/u2-users
_
-Users mailing list
-us...@listserver.u2ug.org
tp://listserver.u2ug.org/mailman/listinfo/u2-users
___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
__
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Turn a device and inode into file name

2012-03-16 Thread John Hester
*I* can assume because in our environment there is one production
account on one device.  I wasn't suggesting that this specific utility
would be of any use in any other environments, only that the underlying
OS-level command could be used in a similar way to translate an inode
into a file name.

-John

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, March 16, 2012 5:14 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Turn a device and inode into file name


The lock table spans all accounts.
To list the file associated with any particular lock, you have to span
all devices, not just a device.
You can't assume that you know the account in which a locked inode
resides.



-Original Message-
From: John Hester jhes...@momtex.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Fri, Mar 16, 2012 5:10 pm
Subject: Re: [U2] Turn a device and inode into file name


If you execute ls -i from within UV, it's going to list the files in
he directory where the account you're sitting in resides.  My code
xample isn't written to be able to switch devices because that's of no
se to me in the context of listing locked production files in our
nvironment.  If you want to write a utility that executes ls -i on ny
device, that's fairly trivial and there are numerous ways you could o
it.  Just write some code to get the correct path into a variable by
hatever means you prefer and tack it on to the end of the command.
-John
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
ent: Friday, March 16, 2012 4:47 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] Turn a device and inode into file name

he provided code does not specify a device, so how can you select a
evice  even if you know it?
t doesn't seem to be changing devices

-Original Message-
rom: John Hester jhes...@momtex.com
o: U2 Users List u2-users@listserver.u2ug.org
ent: Fri, Mar 16, 2012 4:41 pm
ubject: Re: [U2] Turn a device and inode into file name

t works fine if you have multiple devices because you can only run it
ainst one account and one device at a time.  ls -i doesn't span
rectory hierarchies or devices.  You do at least have to know what vice
the file in question is on, but if you don't know that there's no ol
that will reliably work for you.
John
Original Message-
om: u2-users-boun...@listserver.u2ug.org
ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
nt: Friday, March 16, 2012 3:43 PM
: u2-users@listserver.u2ug.org
bject: Re: [U2] Turn a device and inode into file name This only works f
you have a single device, since the inode is not nique cross-device, nly
unique on a device -Original Message-
om: John Hester jhes...@momtex.com
: U2 Users List u2-users@listserver.u2ug.org
nt: Fri, Mar 16, 2012 3:25 pm
bject: Re: [U2] Turn a device and inode into file name  have a utility
named FLIST.READU that replaces the inode from the ndard LIST.READU
output with the file name.  It uses ls -i, so it's ited to files in
the account you run the command from, though.  Works e for us because
all of our users work out of the same account.  This he relevant part of
the code:
   INODE.NO = TRIM(READU.ARRAYI,3)
  EXECUTE 'SH -c ls -i | grep ':INODE.NO:'', OUT  FILENAME
  IF FILENAME1,1,1 # '' THEN
FILENAME = FIELD(TRIM(FILENAME1,1,1),' ',2) 'L#8'
's also pretty resource intensive because it re-lists the entire count
or every inode.  Probably not much of an issue if your hardware  fairly
ew.
ohn
---Original Message-
m: u2-users-boun...@listserver.u2ug.org
ilto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
t: Friday, March 16, 2012 12:24 PM
 u2-users@listserver.u2ug.org
ject: [U2] Turn a device and inode into file name nyone have an easy ay
to do this?
the past I've run a batch routine to just query each and every niverse
le for it's inode and device and build a table of these Every week
ms like a great amount of overkill to me.
 could also mod the CREATE-FILE command to sniff it and make an xref ry
but 
y suggestions?
s is NOT for the case where you know the file and want to find the ode
nd device It's for the case where you know the inode and device
ly) and want to find the file.

Users mailing list
us...@listserver.u2ug.org
p://listserver.u2ug.org/mailman/listinfo/u2-users

Users mailing list
us...@listserver.u2ug.org
p://listserver.u2ug.org/mailman/listinfo/u2-users
__
-Users mailing list
-us...@listserver.u2ug.org
tp://listserver.u2ug.org/mailman/listinfo/u2-users
_
-Users mailing list
-us...@listserver.u2ug.org
tp://listserver.u2ug.org/mailman/listinfo/u2-users
___
2-Users 

Re: [U2] Turn a device and inode into file name

2012-03-16 Thread Wjhonson

Only if you run it on the device to which that inode refers.
If you run it on another device, you won't get a valid response.
In order to know how to get *to* the device in question, you have to already 
know to what account it refers.
That's circular.

The point is, in the List Locks you do not know the account to which a device 
refers, or the account to which an inode refers.
All you know is, the device and the inode.
So how do you know how to access the device on which to run the process, when 
all you have is the device number, and you do not know in what account to run 
your process?


-Original Message-
From: John Hester jhes...@momtex.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Fri, Mar 16, 2012 5:25 pm
Subject: Re: [U2] Turn a device and inode into file name


*I* can assume because in our environment there is one production
ccount on one device.  I wasn't suggesting that this specific utility
ould be of any use in any other environments, only that the underlying
S-level command could be used in a similar way to translate an inode
nto a file name.
-John
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
ent: Friday, March 16, 2012 5:14 PM
o: u2-users@listserver.u2ug.org
ubject: Re: [U2] Turn a device and inode into file name

he lock table spans all accounts.
o list the file associated with any particular lock, you have to span
ll devices, not just a device.
ou can't assume that you know the account in which a locked inode
esides.

-Original Message-
rom: John Hester jhes...@momtex.com
o: U2 Users List u2-users@listserver.u2ug.org
ent: Fri, Mar 16, 2012 5:10 pm
ubject: Re: [U2] Turn a device and inode into file name

f you execute ls -i from within UV, it's going to list the files in
e directory where the account you're sitting in resides.  My code
ample isn't written to be able to switch devices because that's of no
e to me in the context of listing locked production files in our
vironment.  If you want to write a utility that executes ls -i on ny
evice, that's fairly trivial and there are numerous ways you could o
t.  Just write some code to get the correct path into a variable by
atever means you prefer and tack it on to the end of the command.
John
Original Message-
om: u2-users-boun...@listserver.u2ug.org
ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
nt: Friday, March 16, 2012 4:47 PM
: u2-users@listserver.u2ug.org
bject: Re: [U2] Turn a device and inode into file name
he provided code does not specify a device, so how can you select a
vice  even if you know it?
 doesn't seem to be changing devices
-Original Message-
om: John Hester jhes...@momtex.com
: U2 Users List u2-users@listserver.u2ug.org
nt: Fri, Mar 16, 2012 4:41 pm
bject: Re: [U2] Turn a device and inode into file name
t works fine if you have multiple devices because you can only run it
inst one account and one device at a time.  ls -i doesn't span
ectory hierarchies or devices.  You do at least have to know what vice
he file in question is on, but if you don't know that there's no ol
hat will reliably work for you.
ohn
---Original Message-
m: u2-users-boun...@listserver.u2ug.org
ilto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
t: Friday, March 16, 2012 3:43 PM
 u2-users@listserver.u2ug.org
ject: Re: [U2] Turn a device and inode into file name This only works f
ou have a single device, since the inode is not nique cross-device, nly
nique on a device -Original Message-
m: John Hester jhes...@momtex.com
 U2 Users List u2-users@listserver.u2ug.org
t: Fri, Mar 16, 2012 3:25 pm
ject: Re: [U2] Turn a device and inode into file name  have a utility
amed FLIST.READU that replaces the inode from the ndard LIST.READU
utput with the file name.  It uses ls -i, so it's ited to files in
he account you run the command from, though.  Works e for us because
ll of our users work out of the same account.  This he relevant part of
he code:
  INODE.NO = TRIM(READU.ARRAYI,3)
 EXECUTE 'SH -c ls -i | grep ':INODE.NO:'', OUT  FILENAME
 IF FILENAME1,1,1 # '' THEN
   FILENAME = FIELD(TRIM(FILENAME1,1,1),' ',2) 'L#8'
s also pretty resource intensive because it re-lists the entire count
r every inode.  Probably not much of an issue if your hardware  fairly
w.
hn
--Original Message-
: u2-users-boun...@listserver.u2ug.org
lto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
: Friday, March 16, 2012 12:24 PM
u2-users@listserver.u2ug.org
ect: [U2] Turn a device and inode into file name nyone have an easy ay
o do this?
he past I've run a batch routine to just query each and every niverse
e for it's inode and device and build a table of these Every week
s like a great amount of overkill to me.
could also mod the CREATE-FILE command to sniff it and make an xref ry
ut 
 suggestions?
 is NOT for the case where you know the file and want to find the ode
d device It's