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 k

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. -

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 To: U2 Users List Sent: Fri, Mar

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

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 To: U2 Users List Sent: Fri, Mar 16, 2012 4:41 pm Subject: Re: [U2] Turn a device and inode into file name

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 rel

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

2012-03-16 Thread Wjhonson
Oops I misread your reply. So you select all the files and run this, and you loop that on every account I suppose. How do you deal with files which are not referenced as "F" types ? -Original Message- From: Buss, Troy (Logitek Systems) (Logitek Systems) To: U2 Users List Sent: Fri,

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) To: U2 Users List Sent: Fri, Mar 16, 2012 3

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 : > > It seems like an "on the fly

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 "Buildin

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 To: U2 Users List Sent: Fri, Mar 16, 2012 3:25 pm Subject: Re: [U2] Turn a device and inode into file name I have a utility named FLI

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 To: U2 Users List 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 FILE

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 relev

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,

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: [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

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

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

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 To: U2 Users List Sent: Fri, Mar 16, 2012 12:58 pm Subject: Re: [U2] Turn a device and inode into file na

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 wo

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 To: u2-users@listserver.u2ug.org Sent: Friday, March 16, 2012 3:23 PM Subjec

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-FI

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:

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]

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

[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

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

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 becau

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

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: [

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.rocke

[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: ERRO

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 upd

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 Lis

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, Thi

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 privi

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 c

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). _

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