Yes Lizette, I am well aware of the SMP/E connection, but it is more than that. MSM loads APARs into itself from SupportConnect when you update a product's maintenance status. That does not mean they are in SMP/E. In fact, they aren't automatically applied to your installed products until you say so. And, once in SMP/E, unless you restrict your view to 1 zone, or choose to view the APARs from an ALL zones perspective, you have to interrogate each APAR individually to find out what zones an APAR has applied to.
What I want is a list of the APARs that are available in MSM to be received and/or applied via SMP/E. Furthermore, I want to be able to see, in one display, the APAR, whether it is in MSM or not, whether it has been received or not, what zone or zones it has been applied to and, if it had been accepted, what zones it has been accepted to. This is not available anywhere in MSM all at one time, only on an APAR by APAR basis *if* you drill down to it. So, I need to be able to extract from the MSM database all APARs and their titles that are available for a product. I already have the SMP/E extract portion. Chuck Charles (Chuck) Hardee Senior Systems Engineer Database Administration Information Technology Services Thermo Fisher Scientific Pittsburgh, PA 15275 [email protected] -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Lizette Koehler Sent: Friday, September 07, 2012 5:12 PM To: [email protected] Subject: Re: Reading the CA MSM database The apar is still plain old SMPE. All you need is the Global zone names to get the listing. Lizette -----Original Message----- >From: "Hardee, Chuck" <[email protected]> >Sent: Sep 7, 2012 1:57 PM >To: [email protected] >Subject: Re: Reading the CA MSM database > >Thanks Mary Anne, >What I'm looking for is a simple report that shows the APAR number and short >description or title. > > >Charles (Chuck) Hardee >Senior Systems Engineer >Database Administration >Information Technology Services >Thermo Fisher Scientific >300 Industry Drive >Pittsburgh, PA 15275 >Direct: 724-517-2633 >FAX: 412-490-9230 >[email protected] > >-----Original Message----- >From: IBM Mainframe Discussion List [mailto:[email protected]] On >Behalf Of Mary Anne Matyaz >Sent: Friday, September 07, 2012 4:33 PM >To: [email protected] >Subject: Re: Reading the CA MSM database > >Chuck, >Here's one that just does an sql call...what are you looking for? >Mary Anne > >STEP05A EXEC PGM=DBSQLPR, >// PARM='PRTWIDTH=1500,INPUTWIDTH=72' >//STEPLIB DD DSN=CAMSM.V50.RUN.CUSLIB,DISP=SHR >// DD DSN=CAMSM.V50.RUN.CAAXLOAD,DISP=SHR >//CXX DD DSN=CAMSM.V50.RUN.CXX,DISP=SHR >//SYSUDUMP DD SYSOUT=* >//SYSPRINT DD SYSOUT=* >//STDERR DD SYSOUT=* >//STDOUT DD SYSOUT=* >//OPTIONS DD * >AUTHID=CASWMGT >/* >//SYSIN DD * >SELECT * FROM MOUNTPOINT; >/* > >It shows you your mountpoints: > >MOUNTPOINTID, <8>, INT NOT NULL >MP_PATH, < /msmserv/mpm/scroot/DatabaseM/CA/MAINTENANCE>, VARC >MP_DATASET, < OMVS.CAMSM.MSMT5>, VARCHAR(16/45) >MP_TYPE, <*> (NULL), VARCHAR(20) >MP_OPTIONS, < ZFS>, VARCHAR(3/2000) > >MOUNTPOINTID, <9>, INT NOT NULL >MP_PATH, < /msmserv/mpm/scroot/DatabaseM/CA/MAINTENANCE/descri >MP_DATASET, < OMVS.CAMSM.MSMT6>, VARCHAR(16/45) >MP_TYPE, <*> (NULL), VARCHAR(20) >MP_OPTIONS, < ZFS>, VARCHAR(3/2000) > >MOUNTPOINTID, <10>, INT NOT NULL >MP_PATH, < /msmserv/mpm/scroot/DatabaseM/CA/MAINTENANCE/CA_1_T >40) >MP_DATASET, < OMVS.CAMSM.MSMT7>, VARCHAR(16/45) >MP_TYPE, <*> (NULL), VARCHAR(20) >MP_OPTIONS, < ZFS>, VARCHAR(3/2000) > >---------------------------------------------------------------------- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [email protected] with the message: INFO IBM-MAIN > >---------------------------------------------------------------------- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
