IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to select multiple systems in AFOLIBR -SEL statement


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rabiswas

New User


Joined: 15 Oct 2008
Posts: 11
Location: India

PostPosted: Fri Feb 13, 2015 10:13 pm
Reply with quote

Hi,

Im trying to unload selected components from Librarian to a PDS. Below is my JCL that works for 'MANU' HLQ only..

//*=====================================================================
//* UNLOAD MODULES FROM LIBRARIAN TO PDS
//*====================================================================*
//* 1. GENERATE LIBRARIAN -SEL STATEMENTS WITH LIBRARIAN GPO
//* INTO TEMP. DATA SET (DDNAME=OSJOB)
//*--------------------------------------------------------------------*
//SELGPO EXEC PGM=AFOLIBR,PARM='NRJS,NJTA'
//MASTER DD DISP=SHR,DSN=SYSA.LIBRARY.TEST
//*SJOB DD DISP=(,CATLG,DELETE),DSN=BISWRX2.OSJOB1,
//OSJOB DD DISP=SHR,DSN=BISWRX2.OSJOB1,
// UNIT=SYSDA,SPACE=(TRK,(25,10),RLSE),
// DCB=(LRECL=80,BLKSIZE=6080,RECFM=FB)
//SYSPRINT DD SYSOUT=*,DCB=RECFM=FBA
//SYSIN DD *
-OPT GPO
-OPT TEMPS
-SEL NAME=/MANU/,EXEC
-END
/*
//*

====================
Now I want to have multiple HLQ-ed systems coming at 1 shot.. Ive tried the below combinations & some more.. they either failed or the 2nd line simply took a textual interpretation -

# -SEL NAME=/MANU/ & -SEL NAME=/ACPY/,EXEC

# -SEL NAME=/MANU/,EXEC
-SEL NAME=/ACPY/,EXEC

# -SEL NAME=/MANU/ & NAME=/ACPY/,EXEC

====================

Any suggestions on how to get this done, without repeating the entire step for multiple HLQs.. ofcourse : )

Thx,
Ranadhir
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Sat Feb 14, 2015 4:23 am
Reply with quote

My reading of the CA-Librarian System Services manual indicates that this syntax should work, but I don't have access to a LIBRARIAN system at this time to try it:
Code:
-SEL (NAME=/MANU/,NAME=/ACPY/),EXEC


Terminology is critical in IT, where similar terms may mean very different things. And the term "HLQ" you used refers, on a mainframe, to the High Level Qualifier(s) of a data set name -- and only to data set names. Your usage of this term to refer to Librarian member names (or part of Librarian member names) is wrong and very misleading.
Back to top
View user's profile Send private message
rabiswas

New User


Joined: 15 Oct 2008
Posts: 11
Location: India

PostPosted: Sun Feb 15, 2015 7:07 pm
Reply with quote

Robert - I tried the syntax you suggested.. didnt really work -

GPO HAS READ THE FOLLOWING RECORD(S):

-OPT TEMPS
-SEL (NAME=/MANU/,NAME=/ACPY/),EXEC

GPO HAS INTERPRETED THE BOOLEAN LOGIC IN THE FOLLOWING FORMAT: (1&2)

END OF GPO. NO MODULE(S) PASSED SELECTION CRITERIA

-----
For HLQ.. agreed & noted.

Thx,
Ranadhir
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Sun Feb 15, 2015 8:32 pm
Reply with quote

Try using a VBAR instead of the comma before the second NAME -- I misread the manual to indicate comma was an OR but it is actually AND. However, it is encouraging that GPO interpreted that syntax and processed it -- hence the VBAR most likely will work.
Back to top
View user's profile Send private message
rabiswas

New User


Joined: 15 Oct 2008
Posts: 11
Location: India

PostPosted: Mon Feb 16, 2015 11:34 pm
Reply with quote

OK.. the vbar finally worked.. although the key on mf wasnt the same on windows. below is my final jcl -

//*--------------------------------------------------------------------*
//* 1. GENERATE LIBRARIAN -SEL STATEMENTS WITH LIBRARIAN GPO
//* INTO TEMP. DATA SET (DDNAME=OSJOB)
//*--------------------------------------------------------------------*
//SELGPO EXEC PGM=AFOLIBR,PARM='NRJS,NJTA'
//MASTER DD DISP=SHR,DSN=SYSA.LIBRARY.TEST
//*SJOB DD DISP=(,CATLG,DELETE),DSN=BISWRX2.OSJOB1,
//OSJOB DD DISP=SHR,DSN=BISWRX2.OSJOB1,
// UNIT=SYSDA,SPACE=(TRK,(25,10),RLSE),
// DCB=(LRECL=80,BLKSIZE=6080,RECFM=FB)
//SYSPRINT DD SYSOUT=*,DCB=RECFM=FBA
//SYSIN DD *
-OPT GPO
-OPT TEMPS
-SEL (NAME=/MANU/|NAME=/ACPY/|NAME=/GRRA/),EXEC
-END
/*
//*
//*--------------------------------------------------------------------*
//* 2. UNLOAD ALL MEMBERS SPECIFIED IN SYSIN FILE
//* FROM LIBRARIAN TO PDS (DDNAME=OSJOB)
//*--------------------------------------------------------------------*
//UNLOAD EXEC PGM=AFOLIBR,PARM='NRJS,NJTA'
//MASTER DD DISP=SHR,DSN=SYSA.LIBRARY.TEST
//OSJOB DD DISP=OLD,DSN=DN108750.SHRMANU.AMAPS.LIBDUMP
//SYSPRINT DD SYSOUT=* DCB=RECFM=FBA
//SYSIN DD DISP=SHR,DSN=BISWRX2.OSJOB1
//**



Thanks !
Ranadhir
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Tue Feb 17, 2015 4:10 am
Reply with quote

Good to hear!
Back to top
View user's profile Send private message
rabiswas

New User


Joined: 15 Oct 2008
Posts: 11
Location: India

PostPosted: Thu Mar 12, 2015 10:59 pm
Reply with quote

Robert.. few more bends to this stuff -

1. MUST HAVE - Ive been trying all this for a test librarian region. However for the prod region, the UNLOAD now fails with access issue -

IGD103I SMS ALLOCATED TO DDNAME SYSIN
ICH408I USER(BISWRX2 ) GROUP($IT ) NAME(BISWAS,RANADHIR )
SYSA.LIBRARY.PROD CL(DATASET ) VOL(ROS017)
INSUFFICIENT ACCESS AUTHORITY
FROM SYSA.LIBRARY.PROD (G)
ACCESS INTENT(UPDATE ) ACCESS ALLOWED(READ )
IEF142I TLIBDUMP UNLOAD - STEP WAS EXECUTED - COND CODE 0008


I couldnt identify anything in the UNLOAD step that would trigger an UPDATE intent.. if thats the case, then such code will not work for any prod setup. It may not be really 'updating' anything, but even an exclusive access wont be allowed.

Any pointers here ?


2. NICE TO HAVE - As an extension of the selective include of system components, would there be a way to selective exclude some as well ? Hope I could clarify icon_smile.gif


Thanks,
Ranadhir
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Mar 12, 2015 11:11 pm
Reply with quote

please do not color your posts,

to provide better readability
for the jcl/code snippets and the messages use the CODE tags
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Fri Mar 13, 2015 12:17 am
Reply with quote

You would need to talk to the vendor about the RACF authority required to do what you are trying -- they can provide precise answers where I would have to guess. They -- or the manuals -- would also tell you about how to exclude members (and how the inclusion / exclusion rules work together).
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Grouping by multiple headers DFSORT/ICETOOL 7
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top