Operating System - OpenVMS
1748142 Members
3748 Online
108758 Solutions
New Discussion юеВ

Re: Is SYSUAF merge possible?

 
SOLVED
Go to solution
Art Wiens
Respected Contributor

Is SYSUAF merge possible?

I'm bringing a remote cluster to our datacenter and want to make it part of one of our clusters. There are ~300 accounts on the remote system. I have checked and UIC's don't conflict (phew!). Is there an "easy" way to take SYSUAF info from the remote system disk and merge it into the existing SYSUAF? Any freeware solutions out there?

I know there are many aspects to this cluster consolidation, my question is strictly about SYSUAF info.

Remote sys: v7.1-1h1
Local sys: v7.2-2

Thanks in advance,
Art
21 REPLIES 21
Martin P.J. Zinser
Honored Contributor

Re: Is SYSUAF merge possible?

Hello,

given the fact that SYSUAF is just another indexed file, the following should work:

1.) Make backup copies of your SYSUAF files
2.) Create an FDL of SYSUAF using anal/rms/fdl
3.) Make sure nobody access your SYSUAF.
4.) edit/tpu sysuaf.dat
include all the records from the new cluster
you want to keep. Be sure to remove all the
system/tcpip/decnet whatsoever accounts.
5.) exit tpu
6.) convert/fdl of the new sysuaf file
7.) You should be fine concerning sysuaf

Things to keep in mind still:

* Rights Identifiers
* User Directories

No warranties at all!
Hein van den Heuvel
Honored Contributor

Re: Is SYSUAF merge possible?


Yes you can merge SYSUAF files,
but the 'target' UAF will accessed for
write preventing and east convert/merge.

So I'd use:
$CONVERT/SHARE/STAT/EXCEP=SYSUAF.XXX sysuaf.dat,sysuaf.extra sysuaf.tmp
$ANAL/RMS/FDL sysuaf.tmp
$EDIT/FDL/NOINT sysuaf
$CONVERT/FAST/NOSORT/STAT/FDL=sysuaf sysuaf.tmp sysuaf.new
$!Last chance to bail out.
$RENAM/LOG sysuaf.new sysuaf.dat
$RENAM/LOG sysuaf.dat;-1 sysuaf.old

1) be careful about search lists and logicals
2) yes this process might loose an (password/last-usage) update, so run it at a slow time.
3) while you are at it... give sysuaf 10 - 50 global buffers
4) The XXX file will receive duplicates like DECNET and SYSTEM and such.

No I do not like the idea of using EDIT/TPU
on the file. I'd much prefer DATATRIEVE or even a DCL READ/DELE/KEY=

Yes you need much the same process for rightslist and vmsmail_profile.

good luck,
Hein.
richard hoop_1
New Member

Re: Is SYSUAF merge possible?

hi art,

you might find what your looking for at:
www.kesu.be
look at the products / quai
its a tool to extract and insert in the uaf and saves passwords, so you dont have to reset it for all users you moved.

richard
Martin P.J. Zinser
Honored Contributor

Re: Is SYSUAF merge possible?

Hi,

passwords are not touched by either my or Heins suggestion either.

Greetings, Martin
Paul Jerrom
Valued Contributor

Re: Is SYSUAF merge possible?

Here's the routine I used earlier this year. Assumes the 2 UAFs are sysuaf_1.dat and sysuaf_2.dat, and corresponding rightslists are rightslist_1.dat and rightslist_2.dat. Order of the sort is important, duplicate records will be taken from the first of the two files specified.

$ anal/rms/fdl/out=sys$login:sysuaf.fdl -
sys$system:sysuaf.dat
$ anal/rms/fdl/out=sys$login:rightslist.fdl -
sys$system:rightslist.dat
$ create/fdl=sys$login:sysuaf.fdl -
sys$login:sysuaf_new.dat
$ create/fdl=sys$login:rightslist.fdl -
sys$login:rightslist_new.dat
$ set noon
$ sort/nodup sysuaf_1.dat,sysuaf_2.dat -
sysuaf_new.dat/overlay/indexed
$ sort/nodup -
rightslist_1.dat,rightslist_2.dat -
rightslist_new.dat/overlay/indexed

Cheers,
PJ
Have fun,

Peejay
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If it can't be done with a VT220, who needs it?
Art Wiens
Respected Contributor

Re: Is SYSUAF merge possible?

Call me an idiot (everyone shouts - "You're an idiot!") but how can I get a copy of the SYSUAF's in question? Seems I can't COPY nor BACKUP the file:

$ copy SYS$SYSTEM:SYSUAF.DAT sys$login:sysuaf.old
%COPY-E-OPENIN, error opening SYS$COMMON:[SYSEXE]SYSUAF.DAT;1 as input
-RMS-E-FLK, file currently locked by another user

$ backup SYS$SYSTEM:SYSUAF.DAT sys$login:sysuaf.old
%BACKUP-W-NOFILES, no files selected from $1$DGA31:[SYS0.][SYSEXE]SYSUAF.DAT;*
%BACKUP-E-OPENIN, error opening $1$DGA31:[SYS0.SYSCOMMON.][SYSEXE]SYSUAF.DAT;1 as input
-SYSTEM-W-ACCONFLICT, file access conflict
%BACKUP-W-NOFILES, no files selected from $1$DGA31:[SYS0.SYSCOMMON.][SYSEXE]SYSUAF.DAT;*

Kind of makes me wonder what's on my backup tape? :-O

Do I have to come up minimum or such?

Art
Martin P.J. Zinser
Honored Contributor

Re: Is SYSUAF merge possible?

Hi Art,

seems your system is really busy ;-) Either try while peopole are at home :->> or give
convert/share a go

Greetings, Martin

P.S. If you do this and work with the backup copies obviously all changes to the original done afterwards will be lost
Hein van den Heuvel
Honored Contributor

Re: Is SYSUAF merge possible?

>Call me an idiot (everyone shouts - "You're >an idiot!") but how can I get a copy of the >SYSUAF's in question? Seems I can't COPY nor >BACKUP the file:


You idiot! You ask a question in public and then you do not even have the common curtousy, or brains, to read the replies that folks are so kind to offer.

:-) :-) :-)

From my earlier reply:
> So I'd use:
> $CONVERT/SHARE/STAT/EXCEP=SYSUAF.XXX
sysuaf.dat,sysuaf.extra sysuaf.tmp

.... /SHARE ...
Do you see now :^)

to re-iterate my warning: /share will garantuee consistency inside records, but not between records. It is possibly that it will pick up an older record for user "A" but a
newer record for user "Z". Both records wil be intact. even if they, or their neighbours are just being update. Shouldn't matter, but it's good to know.
The same can not be said for the backu/ignore=interlock alternative. If someone happens to be updating the file while it is being copied the whole file may end up useless.
Unlikely, but possible. Why risk that.

Cheers,
Hein.
Art Wiens
Respected Contributor

Re: Is SYSUAF merge possible?

>You idiot! You ask a question in public and then you do not even have the common curtousy, or brains, to read the replies that folks are so kind to offer.

:-) :-) :-) /<

Wow! That's a bit harsh, I asked you to call me an idiot, not make me cry :-(

Many good suggestions/replies have been offered so far. I did read all the replies, even assigned points! (Gave you a 9!) But I must be honest, unfortunately your opening sentence "Yes you can merge SYSUAF files,
but the 'target' UAF will accessed for
write preventing and east convert/merge." was quite difficult to decipher. I also don't have any familiarity with the CONVERT command.

Anyways, being the cautious sort, I always like to do my testing/playing around away from production environment. My initial thoughts were to get copies of the files and try ALL of the methods listed ... see what might work best for me. I tried copying/backing them up at a few different times, hence my latter post about not being able to.

I do appreciate everyone's help ... I have alot of experience w/VMS, but I've been totally away from it for 4 years (got sucked into the Windows World) ... only recently back at it.

Cut me some slack,
Art