Migration of RACF db to Open source

2011-05-05 Thread jagadishan perumal 
Hi,

We have a task of migrating the RACF users to Open source(Wintel or Unix).
For this migration I need to know the structure of RACF db so that we can go
ahead with the migration plans. Could anyone please suggest some advise to
carry on. Is there a utility to extract the entire structure of RACF
database.

Regards,
Jags

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Re: Migration of RACF db to Open source

2011-05-06 Thread גדי בן אבי 
The best way would be to 'flatten' the RACF database using IRRDBU00.

The structure of the resulting file is documented in the RACF documentation.
There are even scripts to create a DB2 database and load it from the file.

Gadi


From: IBM Mainframe Discussion List [IBM-MAIN@bama.ua.edu] On Behalf Of 
jagadishan perumal [jagadish...@gmail.com]
Sent: 06 May 2011 09:12
To: IBM-MAIN@bama.ua.edu
Subject: Migration of RACF db to Open source

Hi,

We have a task of migrating the RACF users to Open source(Wintel or Unix).
For this migration I need to know the structure of RACF db so that we can go
ahead with the migration plans. Could anyone please suggest some advise to
carry on. Is there a utility to extract the entire structure of RACF
database.

Regards,
Jags

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

לשימת לבך, בהתאם לנהלי החברה וזכויות החתימה בה, כל הצעה, התחייבות או מצג מטעם 
החברה, מחייבים מסמך נפרד וחתום על ידי מורשי החתימה של החברה, הנושא את לוגו 
החברה או שמה המודפס ובצירוף חותמת החברה. בהעדר מסמך כאמור (לרבות מסמך סרוק) 
המצורף להודעת דואר אלקטרוני זאת, אין לראות באמור בהודעה אלא משום טיוטה לדיון,
ואין להסתמך עליה לביצוע פעולה עסקית או משפטית כלשהי.


Please note that in accordance with Malam's signatory rights, no offer, 
agreement, concession or representation is binding on the company,
unless accompanied by a duly signed separate document (or a scanned version 
thereof), affixed with the company's seal.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Re: Migration of RACF db to Open source

2011-05-06 Thread Chris Mason 
Jags

I appreciate I have suggested that this list be renamed JAGS-MAIN or 
something like that - at the time when you were initiating just about every 
thread - but you do have a chance to use another list here. Not only that, 
this is a request perfectly suited to this list unlike very many vaguely 
security-
related ones/queries which get dumped there with which the resident gurus 
with deep sighs manfully (for the most part I think) (try to) deal.

http://listserv.uga.edu/archives/racf-l.html

Chris Mason

On Fri, 6 May 2011 11:42:30 +0530, jagadishan perumal 
 wrote:

>Hi,
>
>We have a task of migrating the RACF users to Open source(Wintel or Unix).
>For this migration I need to know the structure of RACF db so that we can go
>ahead with the migration plans. Could anyone please suggest some advise to
>carry on. Is there a utility to extract the entire structure of RACF
>database.
>
>Regards,
>Jags

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Re: Migration of RACF db to Open source

2011-05-06 Thread jagadishan perumal 
Hi,

Yes I accept my mistake for posting Racf related issue here. Apology for the
inconvenience.

Regards,
Jags

On Fri, May 6, 2011 at 4:28 PM, Elardus Engelbrecht <
elardus.engelbre...@sita.co.za> wrote:

> jagadishan perumal wrote:
>
> >We have a task of migrating the RACF users to Open source(Wintel or Unix).
> For this migration I need to know the structure of RACF db so that we can
> go
> ahead with the migration plans. Could anyone please suggest some advise to
> carry on. Is there a utility to extract the entire structure of RACF
> database.
>
> Consider using IRRDBU00 for extracting the RACF database' contents. You
> will
> NOT get any sensitive fields, like passwords.
>
> You could perhaps use ICETOOL to extract selected entries for further
> review.
> Look in SYS1.SAMPLIB(RACINSTL) for RACICE to get a good start.
>
> While the structure of the RACF DB is document, it is recommended that you
> rather use only supplied utilities to extract the contents.
>
> Perhaps you should ask future RACF questions in RACF-L. Chris Mason already
> gave you some hints.
>
> HTH!
>
> Groete / Greetings
> Elardus Engelbrecht
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
> Search the archives at http://bama.ua.edu/archives/ibm-main.html
>

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Re: Migration of RACF db to Open source

2011-05-06 Thread Elardus Engelbrecht 
jagadishan perumal wrote:

>We have a task of migrating the RACF users to Open source(Wintel or Unix).
For this migration I need to know the structure of RACF db so that we can go
ahead with the migration plans. Could anyone please suggest some advise to
carry on. Is there a utility to extract the entire structure of RACF database.

Consider using IRRDBU00 for extracting the RACF database' contents. You will 
NOT get any sensitive fields, like passwords.

You could perhaps use ICETOOL to extract selected entries for further review. 
Look in SYS1.SAMPLIB(RACINSTL) for RACICE to get a good start.

While the structure of the RACF DB is document, it is recommended that you 
rather use only supplied utilities to extract the contents.

Perhaps you should ask future RACF questions in RACF-L. Chris Mason already 
gave you some hints.

HTH!

Groete / Greetings
Elardus Engelbrecht

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Re: Migration of RACF db to Open source

2011-05-06 Thread Tony Harminc 
On 6 May 2011 02:12, jagadishan perumal  wrote:

> We have a task of migrating the RACF users to Open source(Wintel or Unix).

When did Windows become open source?

If you want UNIX, it's already a part of z/OS, so why migrate?

Tony H.

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Re: Migration of RACF db to Open source

2011-05-08 Thread Shmuel Metz (Seymour J.) 
In , on 05/06/2011
   at 04:31 PM, jagadishan perumal  said:

>Yes I accept my mistake for posting Racf related issue here.

There's nothing wrong with posting RACF questions here. Posting to
RACF-L will give you a more targeted audience, but also a smaller one.
 
-- 
 Shmuel (Seymour J.) Metz, SysProg and JOAT
 ISO position; see  
We don't care. We don't have to care, we're Congress.
(S877: The Shut up and Eat Your spam act of 2003)

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html