dbTalk Databases Forums  

Universe: How to list all accounts

comp.databases.pick comp.databases.pick


Discuss Universe: How to list all accounts in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ed Sheehan
 
Posts: n/a

Default Universe: How to list all accounts - 01-16-2007 , 03:06 PM






Not having to ever do time as a Uni Admin, I never found out how to get a
list of all account names in Universe. Is there a way from TCL to do it or
do I have to drop down to Unix and play with those files?

Thanks,

Ed



Reply With Quote
  #2  
Old   
Chandru Murthi
 
Posts: n/a

Default Re: Universe: How to list all accounts - 01-16-2007 , 03:27 PM






SORT UV.ACCOUNT

UV.ACCOUNT
0001 Q
0002 uv
0003 UV.ACCOUNT

Chandru
"Ed Sheehan" <NOedsSPAM (AT) xmission (DOT) com> wrote

Quote:
Not having to ever do time as a Uni Admin, I never found out how to get a
list of all account names in Universe. Is there a way from TCL to do it or
do I have to drop down to Unix and play with those files?

Thanks,

Ed




Reply With Quote
  #3  
Old   
Ed Sheehan
 
Posts: n/a

Default Re: Universe: How to list all accounts - 01-16-2007 , 03:47 PM



Chandru,

Does there have to be a voc entry 'uv' which paths to wherever the uv
account is? I got this to work on my box, but a friend has no such entry in
his voc and cannot list uv.account.

Thanks!

Ed

"Chandru Murthi" <cmur_xyz_thi (AT) xyz_seeinggree_xyz_n (DOT) net> wrote

Quote:
SORT UV.ACCOUNT

UV.ACCOUNT
0001 Q
0002 uv
0003 UV.ACCOUNT

Chandru
"Ed Sheehan" <NOedsSPAM (AT) xmission (DOT) com> wrote in message
news:eojep3$7l4$1 (AT) news (DOT) xmission.com...
Not having to ever do time as a Uni Admin, I never found out how to get a
list of all account names in Universe. Is there a way from TCL to do it
or do I have to drop down to Unix and play with those files?

Thanks,

Ed






Reply With Quote
  #4  
Old   
Chandru Murthi
 
Posts: n/a

Default Re: Universe: How to list all accounts - 01-16-2007 , 05:11 PM



Not in VOC, uv needs to be an account in UV.ACCOUNT (like SYSTEM)

Try:
UV.ACCOUNT
0001 F
0002 /usr/lpp/uv/UV.ACCOUNT
0003 D_VOC

where /usr/lpp/uv is the path to where your uv is installed.

Chandru


"Ed Sheehan" <NOedsSPAM (AT) xmission (DOT) com> wrote

Quote:
Chandru,

Does there have to be a voc entry 'uv' which paths to wherever the uv
account is? I got this to work on my box, but a friend has no such entry
in his voc and cannot list uv.account.

Thanks!

Ed

"Chandru Murthi" <cmur_xyz_thi (AT) xyz_seeinggree_xyz_n (DOT) net> wrote in message
news:Fqbrh.8645$Wz.8097 (AT) trndny06 (DOT) ..
SORT UV.ACCOUNT

UV.ACCOUNT
0001 Q
0002 uv
0003 UV.ACCOUNT

Chandru
"Ed Sheehan" <NOedsSPAM (AT) xmission (DOT) com> wrote in message
news:eojep3$7l4$1 (AT) news (DOT) xmission.com...
Not having to ever do time as a Uni Admin, I never found out how to get
a list of all account names in Universe. Is there a way from TCL to do
it or do I have to drop down to Unix and play with those files?

Thanks,

Ed








Reply With Quote
  #5  
Old   
dbvlangley@gmail.com
 
Posts: n/a

Default Re: Universe: How to list all accounts - 01-17-2007 , 08:45 AM



Log to the 'UV' account, escape from the menu that runs and run 'SORT
UV.ACCOUNT' from the TCL line.


Chandru Murthi wrote:
Quote:
Not in VOC, uv needs to be an account in UV.ACCOUNT (like SYSTEM)

Try:
UV.ACCOUNT
0001 F
0002 /usr/lpp/uv/UV.ACCOUNT
0003 D_VOC

where /usr/lpp/uv is the path to where your uv is installed.

Chandru


"Ed Sheehan" <NOedsSPAM (AT) xmission (DOT) com> wrote in message
news:eojh7p$228$1 (AT) news (DOT) xmission.com...
Chandru,

Does there have to be a voc entry 'uv' which paths to wherever the uv
account is? I got this to work on my box, but a friend has no such entry
in his voc and cannot list uv.account.

Thanks!

Ed

"Chandru Murthi" <cmur_xyz_thi (AT) xyz_seeinggree_xyz_n (DOT) net> wrote in message
news:Fqbrh.8645$Wz.8097 (AT) trndny06 (DOT) ..
SORT UV.ACCOUNT

UV.ACCOUNT
0001 Q
0002 uv
0003 UV.ACCOUNT

Chandru
"Ed Sheehan" <NOedsSPAM (AT) xmission (DOT) com> wrote in message
news:eojep3$7l4$1 (AT) news (DOT) xmission.com...
Not having to ever do time as a Uni Admin, I never found out how to get
a list of all account names in Universe. Is there a way from TCL to do
it or do I have to drop down to Unix and play with those files?

Thanks,

Ed







Reply With Quote
  #6  
Old   
Clifton Oliver
 
Posts: n/a

Default Re: Universe: How to list all accounts - 01-17-2007 , 08:13 PM



On 2007-01-16 13:06:41 -0800, "Ed Sheehan" <NOedsSPAM (AT) xmission (DOT) com> said:

Quote:
Not having to ever do time as a Uni Admin, I never found out how to get
a list of all account names in Universe. Is there a way from TCL to do
it or do I have to drop down to Unix and play with those files?

Thanks,

Ed
I see you've received several replies, but all assume the UV.ACCOUNT
file contains pointers to all the UV accounts on the system. In many
cases, this is not true. There is no requirement that the path to an
"account" (aka directory containing a VOC, D_VOC, etc.) be in the
UV.ACCOUNT file. It is only required if you want to refer to that
account by name in a Q pointer or in a LOGTO. Even then, you can "LOGTO
path" and go around the UV.ACCOUNT file.

The only sure way is to drop to Unix and using find (and perhaps grep,
depending on your system) look for pathnames ending in .../VOC.


--

Regards,

Clif

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678 Web: www.oliver.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~




Reply With Quote
  #7  
Old   
Ed Sheehan
 
Posts: n/a

Default Re: Universe: How to list all accounts - 01-18-2007 , 07:50 AM



Thanks, Cliff; I found that out yesterday, There's a whole list of accounts
ending in .PROD which aren't in the uv.account file. There are cloned
accounts there ending in .TEST which correlate with the .PRODs on another
server. Somewhere there's a map of all this because I can LOGTO a .PROD
account. Anyway, I renamed all the .TESTs (in my own list), and was able to
grab all the VOC's F-pointers (I'm doing data warehouse exporting).

Oh, for the days when all one had to do was LIST SYSTEM!

Ed

"Clifton Oliver" <wco (AT) oliver (DOT) com> wrote

Quote:
On 2007-01-16 13:06:41 -0800, "Ed Sheehan" <NOedsSPAM (AT) xmission (DOT) com> said:

Not having to ever do time as a Uni Admin, I never found out how to get a
list of all account names in Universe. Is there a way from TCL to do it
or do I have to drop down to Unix and play with those files?

Thanks,

Ed

I see you've received several replies, but all assume the UV.ACCOUNT file
contains pointers to all the UV accounts on the system. In many cases,
this is not true. There is no requirement that the path to an "account"
(aka directory containing a VOC, D_VOC, etc.) be in the UV.ACCOUNT file.
It is only required if you want to refer to that account by name in a Q
pointer or in a LOGTO. Even then, you can "LOGTO path" and go around the
UV.ACCOUNT file.

The only sure way is to drop to Unix and using find (and perhaps grep,
depending on your system) look for pathnames ending in .../VOC.


--

Regards,

Clif

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678 Web: www.oliver.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~





Reply With Quote
  #8  
Old   
Tom Phillips
 
Posts: n/a

Default Re: Universe: How to list all accounts - 01-18-2007 , 08:09 AM



Ed - there is nothing magical about the UV.ACCOUNT.
You can create your own entries with any editor or program, or if needed,
change the ones there.
The only thing that Universe wants is the correct path to an account in
attribute 11 (the other lines being null).
Tom

"Ed Sheehan" <NOedsSPAM (AT) xmission (DOT) com> wrote

Quote:
Thanks, Cliff; I found that out yesterday, There's a whole list of
accounts ending in .PROD which aren't in the uv.account file. There are
cloned accounts there ending in .TEST which correlate with the .PRODs on
another server. Somewhere there's a map of all this because I can LOGTO a
.PROD account. Anyway, I renamed all the .TESTs (in my own list), and was
able to grab all the VOC's F-pointers (I'm doing data warehouse
exporting).

Oh, for the days when all one had to do was LIST SYSTEM!

Ed

"Clifton Oliver" <wco (AT) oliver (DOT) com> wrote in message
news:2007011718130216807-wco (AT) olivercom (DOT) ..
On 2007-01-16 13:06:41 -0800, "Ed Sheehan" <NOedsSPAM (AT) xmission (DOT) com> said:

Not having to ever do time as a Uni Admin, I never found out how to get
a list of all account names in Universe. Is there a way from TCL to do
it or do I have to drop down to Unix and play with those files?

Thanks,

Ed

I see you've received several replies, but all assume the UV.ACCOUNT file
contains pointers to all the UV accounts on the system. In many cases,
this is not true. There is no requirement that the path to an "account"
(aka directory containing a VOC, D_VOC, etc.) be in the UV.ACCOUNT file.
It is only required if you want to refer to that account by name in a Q
pointer or in a LOGTO. Even then, you can "LOGTO path" and go around the
UV.ACCOUNT file.

The only sure way is to drop to Unix and using find (and perhaps grep,
depending on your system) look for pathnames ending in .../VOC.


--

Regards,

Clif

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678 Web: www.oliver.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.