Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to select multiple systems in AFOLIBR -SEL statement

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
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    Post subject: How to select multiple systems in AFOLIBR -SEL statement
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: 7908
Location: Bellevue, IA

PostPosted: Sat Feb 14, 2015 4:23 am    Post subject:
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    Post subject:
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: 7908
Location: Bellevue, IA

PostPosted: Sun Feb 15, 2015 8:32 pm    Post subject:
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    Post subject:
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: 7908
Location: Bellevue, IA

PostPosted: Tue Feb 17, 2015 4:10 am    Post subject:
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    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Thu Mar 12, 2015 11:11 pm    Post subject: Reply to: How to select multiple systems in AFOLIBR -SEL statement
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: 7908
Location: Bellevue, IA

PostPosted: Fri Mar 13, 2015 12:17 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts -913/-911 Deadlock during UPDATE stat... NoSleep319 DB2 5 Fri Nov 18, 2016 12:37 am
No new posts Two Selects in a single select query Rohit Umarjikar DB2 1 Fri Nov 04, 2016 8:46 pm
No new posts COBOL DB2 - CALL statement - high CPU... TS70363 DB2 15 Sun Sep 11, 2016 6:07 am
No new posts Converting multiple VB files to FB fi... Viswanath Reddy JCL & VSAM 6 Mon Aug 08, 2016 11:49 pm
No new posts Converting NULL column into NOT NULL ... Raghu navaikulam DB2 5 Sat Aug 06, 2016 3:45 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us