reconciling CA1, OAM, and 3494-B10

[McKown, John]

Is there any way to reconcile CA1, OAM, and the 3494-B10's view of tape volumes? I'm not talking about using CTSSYNC. I can write a report in EARL which will list each volume and whether it is scratch ro not. I can do a LISTC on the TCDB (SYS1.VOLCAT.VGENERAL et al.) and then write a program to read that to produce a similar report. But I cannot figure out any way to unload the 3494-B10's internal database of tape volumes and their statuses.

Why do I want to do this? Because all hell has broken loose here with our 3494-B10. I use its Web interface to do an Inventory, then do a "Request Inventory Upload". After doing this a D SMS,LIB(...),DETAIL shows over 12,000 scratches. I had been around 400. This is what I expect. Within 5 minutes, it is back to 400. I cannot figure out what the hell is going on. Yes, IBM hardware support has been called. My boss did that last night. I don't yet know the results, except that it cannot be fixed yet because the scratch count is still wrong.

The 3494-B10 is attached to a 3854. The 3854 is shared between z/OS and the distributed platform. It has been, IMO, a piece of diseased excrement from day one.

John McKown
Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)

9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john....@healthmarkets.com * www.HealthMarkets.com

Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM

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

[Vernooij, CP - SPLXM]

"McKown, John" <John....@HEALTHMARKETS.COM> wrote in message
news:<A6B9336CDB62BB46B9F87...@NRHMMS8P02.uicnrh.dom>.
..

> Is there any way to reconcile CA1, OAM, and the 3494-B10's view of
tape volumes? I'm not talking about using CTSSYNC. I can write a report
in EARL which will list each volume and whether it is scratch ro not. I
can do a LISTC on the TCDB (SYS1.VOLCAT.VGENERAL et al.) and then write
a program to read that to produce a similar report. But I cannot figure
out any way to unload the 3494-B10's internal database of tape volumes
and their statuses.
>
> Why do I want to do this? Because all hell has broken loose here with
our 3494-B10. I use its Web interface to do an Inventory, then do a
"Request Inventory Upload". After doing this a D SMS,LIB(...),DETAIL
shows over 12,000 scratches. I had been around 400. This is what I
expect. Within 5 minutes, it is back to 400. I cannot figure out what
the hell is going on. Yes, IBM hardware support has been called. My boss
did that last night. I don't yet know the results, except that it cannot
be fixed yet because the scratch count is still wrong.
>
> The 3494-B10 is attached to a 3854. The 3854 is shared between z/OS
and the distributed platform. It has been, IMO, a piece of diseased
excrement from day one.
>
> John McKown

Search for the BVIR utility, Bulk Volume Information Retrieval. I have
the TS7700 information, but I know this utility was already available
for the B10/B12.
It has o.a. a physical volume to logical volume mapping report.

Kees.
**********************************************************************
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain
confidential and privileged material intended for the addressee
only. If you are not the addressee, you are notified that no part
of the e-mail or any attachment may be disclosed, copied or
distributed, and that any other action related to this e-mail or
attachment is strictly prohibited, and may be unlawful. If you have
received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message.

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries
and/or its employees shall not be liable for the incorrect or
incomplete transmission of this e-mail or any attachments, nor
responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
Dutch Airlines) is registered in Amstelveen, The Netherlands, with
registered number 33014286
**********************************************************************

[Vernooij, CP - SPLXM]

Kees.

Another report that you might want to check is the Volume Status
Information reort, with detailed information about each logical volume.

[McKown, John]

Many thanks! I'll go search for that right now.

--

John McKown
Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)

9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john....@healthmarkets.com * www.HealthMarkets.com

Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM

> -----Original Message-----
> From: IBM Mainframe Discussion List
> [mailto:IBM-...@bama.ua.edu] On Behalf Of Vernooij, CP - SPLXM
> Sent: Friday, December 18, 2009 7:36 AM
> To: IBM-...@bama.ua.edu
> Subject: Re: reconciling CA1, OAM, and 3494-B10
>
>
>

> Search for the BVIR utility, Bulk Volume Information Retrieval. I have
> the TS7700 information, but I know this utility was already available
> for the B10/B12.
> It has o.a. a physical volume to logical volume mapping report.
>
> Kees.
>

----------------------------------------------------------------------

[Vernooij, CP - SPLXM]

I think this is your version:

http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP100430

Kees.

"McKown, John" <John....@HEALTHMARKETS.COM> wrote in message
news:<A6B9336CDB62BB46B9F87...@NRHMMS8P02.uicnrh.dom>.
..

**********************************************************************
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain
confidential and privileged material intended for the addressee
only. If you are not the addressee, you are notified that no part
of the e-mail or any attachment may be disclosed, copied or
distributed, and that any other action related to this e-mail or
attachment is strictly prohibited, and may be unlawful. If you have
received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message.

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries
and/or its employees shall not be liable for the incorrect or
incomplete transmission of this e-mail or any attachments, nor
responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
Dutch Airlines) is registered in Amstelveen, The Netherlands, with
registered number 33014286
**********************************************************************

----------------------------------------------------------------------

[McKown, John]

many thanks, again. I think I've got the PDFs and software.

--
John McKown
Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)

9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john....@healthmarkets.com * www.HealthMarkets.com

Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM

> -----Original Message-----
> From: IBM Mainframe Discussion List
> [mailto:IBM-...@bama.ua.edu] On Behalf Of Vernooij, CP - SPLXM
> Sent: Friday, December 18, 2009 8:04 AM
> To: IBM-...@bama.ua.edu
> Subject: Re: reconciling CA1, OAM, and 3494-B10
>

> I think this is your version:
>
> http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP100430
>
> Kees.

----------------------------------------------------------------------

[Vernooij, CP - SPLXM]

There's no software involved here, except IEBGENER.
The trick is to trigger the VTS to generate the reports.

Kees.

"McKown, John" <John....@HEALTHMARKETS.COM> wrote in message
news:<A6B9336CDB62BB46B9F87...@NRHMMS8P02.uicnrh.dom>.
..

**********************************************************************
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain
confidential and privileged material intended for the addressee
only. If you are not the addressee, you are notified that no part
of the e-mail or any attachment may be disclosed, copied or
distributed, and that any other action related to this e-mail or
attachment is strictly prohibited, and may be unlawful. If you have
received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message.

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries
and/or its employees shall not be liable for the incorrect or
incomplete transmission of this e-mail or any attachments, nor
responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
Dutch Airlines) is registered in Amstelveen, The Netherlands, with
registered number 33014286
**********************************************************************

----------------------------------------------------------------------

[McKown, John]

Apparently our level of VTS does not support the VOLUME STATUS. I can do a VOLUME MAP and a CACHE STATUS. I'm royally PO'ed with this box. I've hated it from day one. And now some <elided> in hardware support says that the scratch status of the virtual tapes is kept only on the mainframe. I.e. the VTS itself does not keep any sort of tape status information other than that it exists, so this must be a host software failure.

--
John McKown
Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)

9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john....@healthmarkets.com * www.HealthMarkets.com

Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM

> -----Original Message-----
> From: IBM Mainframe Discussion List
> [mailto:IBM-...@bama.ua.edu] On Behalf Of Vernooij, CP - SPLXM
> Sent: Friday, December 18, 2009 9:09 AM
> To: IBM-...@bama.ua.edu
> Subject: Re: reconciling CA1, OAM, and 3494-B10
>

> There's no software involved here, except IEBGENER.
> The trick is to trigger the VTS to generate the reports.
>
> Kees.
>

----------------------------------------------------------------------

[McKown, John]

Latest data is that the 3494 library manager has the correct number of scratches. That is, category 0002 tapes. It also has the correct number of non-scratch tapes (category 000F). Doing a LISTC on the SYS1.VOLCAT.VGENERAL shows that there are the correct number of VOLUME ENTRY records with a USAGE-CATEGORY of SCRATCH. But the LIBRARY ENTRY for the 3494-B10 contains the __WRONG__ number of MEDIA2 scratches.

This has now been referred to IBM software defect support.

--
John McKown
Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)

9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john....@healthmarkets.com * www.HealthMarkets.com

Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM

----------------------------------------------------------------------

[Kees Vernooy]

John,
what z/OS level are you?
Keep us posted, in case we could run into the same problem with our TS7700.

Good Luck,
Kees.

[McKown, John]

> -----Original Message-----
> From: IBM Mainframe Discussion List
> [mailto:IBM-...@bama.ua.edu] On Behalf Of Kees Vernooy
> Sent: Friday, December 18, 2009 2:40 PM
> To: IBM-...@bama.ua.edu
> Subject: Re: reconciling CA1, OAM, and 3494-B10
>

> John,
> what z/OS level are you?
> Keep us posted, in case we could run into the same problem
> with our TS7700.
>
> Good Luck,
> Kees.

z/OS 1.10. We have a 3584 and a TS3500. Old. Right now I'm running a CTSSYNC of over 25,000 tapes in SCRATCH status to CA1, but not according to ISMF. When that finishes (1.5 hours?), the IBM support person will call back with some ALTER commands to do. If that doesn't work, then we'll get with the hardware guy (currently on site) and do some more stuff.

I really hate this box.

--
John McKown
Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)

9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john....@healthmarkets.com * www.HealthMarkets.com

Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM

----------------------------------------------------------------------

[Kees Vernooy]

On Fri, 18 Dec 2009 14:46:33 -0600, McKown, John
<John....@HEALTHMARKETS.COM> wrote:

>> -----Original Message-----
>> From: IBM Mainframe Discussion List
>> [mailto:IBM-...@bama.ua.edu] On Behalf Of Kees Vernooy
>> Sent: Friday, December 18, 2009 2:40 PM
>> To: IBM-...@bama.ua.edu
>> Subject: Re: reconciling CA1, OAM, and 3494-B10
>>
>> John,
>> what z/OS level are you?
>> Keep us posted, in case we could run into the same problem
>> with our TS7700.
>>
>> Good Luck,
>> Kees.
>
>z/OS 1.10.

So are we. I am very interested in possible software causes, either in CA1 or
in z/OS.

We have a 3584 and a TS3500. Old. Right now I'm running a CTSSYNC of over
25,000 tapes in SCRATCH status to CA1, but not according to ISMF. When
that finishes (1.5 hours?), the IBM support person will call back with some
ALTER commands to do. If that doesn't work, then we'll get with the hardware
guy (currently on site) and do some more stuff.
>
>I really hate this box.

I can recommend the TS7700, I love it.

Kees.

[Mike Wood]

John, This may be a bit extreme for you, but, rmm includes EDGUTIL utility
which can cross check and report on the differences between TCDB, rmm and
the LM.
PARM='VERIFY(SMSTAPE)'

So, ok, you are not licensed to run rmm, but, you could run the conversion
tools to the point where you build the rmm CDS. Without running DFRMM
subsystem, run EDGUTIL and use the reults to show you what is mismatching.

Depending on your release you have some SYSIN options to compare just a
subset of volumes.

Mike Wood RMM Development

[McKown, John]

> -----Original Message-----
> From: IBM Mainframe Discussion List
> [mailto:IBM-...@bama.ua.edu] On Behalf Of Mike Wood
> Sent: Monday, December 21, 2009 4:33 AM
> To: IBM-...@bama.ua.edu
> Subject: Re: reconciling CA1, OAM, and 3494-B10
>

> John, This may be a bit extreme for you, but, rmm includes
> EDGUTIL utility
> which can cross check and report on the differences between
> TCDB, rmm and
> the LM.
> PARM='VERIFY(SMSTAPE)'
>
> So, ok, you are not licensed to run rmm, but, you could run
> the conversion
> tools to the point where you build the rmm CDS. Without running DFRMM
> subsystem, run EDGUTIL and use the reults to show you what is
> mismatching.
>
> Depending on your release you have some SYSIN options to
> compare just a
> subset of volumes.
>
> Mike Wood RMM Development
>

Thank you for the suggestion. I'm going to read up on the current CA1 to see if they have an equivalent function that I'm just not aware of. I'm not really all that CA1 literate. I got roped into this because, uh, because ... . I don't know why I got roped into this.

I got what I needed by using a CA1 Earl report of all tapes along with an ISMF print out of the same (ISMF option 2.3). I then downloaded this information to my Linux desktop where I have more powerful tools and don't mess with the mainframe CPU usage. I found the differences and did a SYNC on them.

--
John McKown
Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)

9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john....@healthmarkets.com * www.HealthMarkets.com

Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM

----------------------------------------------------------------------

[Vernooij, CP - SPLXM]

"McKown, John" <John....@HEALTHMARKETS.COM> wrote in message
news:<A6B9336CDB62BB46B9F87...@NRHMMS8P02.uicnrh.dom>.
..

John,

AFAIK (but that's not 100% sure), there is no such CA1 utility.

I have a job that regularly checks TMC, TCDB and VTS contents:
I use GRW for TMC data (Earl will produce the same).
I use IDCAMS, LISTC VOLENT(*), to list the TCDB (much easier I think)
I use BVIR to list the VTS contents of both clusters of our TS7700 grid
(I think a B10/20 does not have these).
Then I have a SAS job that produces a list of status differences and
other interesting information from the combined data sources.

Any news about the cause of your problems?

Kees.

**********************************************************************
For information, services and offers, please visit our web site:
http://www.klm.com. This e-mail and any attachment may contain
confidential and privileged material intended for the addressee
only. If you are not the addressee, you are notified that no part
of the e-mail or any attachment may be disclosed, copied or
distributed, and that any other action related to this e-mail or
attachment is strictly prohibited, and may be unlawful. If you have
received this e-mail by error, please notify the sender immediately
by return e-mail, and delete this message.

Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries
and/or its employees shall not be liable for the incorrect or
incomplete transmission of this e-mail or any attachments, nor
responsible for any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal
Dutch Airlines) is registered in Amstelveen, The Netherlands, with
registered number 33014286
**********************************************************************

----------------------------------------------------------------------

[McKown, John]

> -----Original Message-----
> From: IBM Mainframe Discussion List
> [mailto:IBM-...@bama.ua.edu] On Behalf Of Vernooij, CP - SPLXM
> Sent: Monday, December 21, 2009 9:25 AM
> To: IBM-...@bama.ua.edu
> Subject: Re: reconciling CA1, OAM, and 3494-B10
>

<snip>

>
> John,
>
> AFAIK (but that's not 100% sure), there is no such CA1 utility.

I didn't find one, either.

>
> I have a job that regularly checks TMC, TCDB and VTS contents:
> I use GRW for TMC data (Earl will produce the same).

I have this.

> I use IDCAMS, LISTC VOLENT(*), to list the TCDB (much easier I think)

True. I used to do that. OAM level 2 support told me, unconditionally, to never do that ever again. They said that IDCAMS with not the right way to do it and could result in errors.

> I use BVIR to list the VTS contents of both clusters of our
> TS7700 grid
> (I think a B10/20 does not have these).

BVIR on the B10 does not have the ability to list the VTS' internal database.

> Then I have a SAS job that produces a list of status differences and
> other interesting information from the combined data sources.

No SAS here any more. I run my jobs on the mainfame. I then download the information to my Linux/Intel desktop. I run a Perl script which massages that. I then use the massaged data to create two PostgreSQL tables. I then do a JOIN on that to report on the differences. Finally, I use that report to create input to CTSSYNC and submit a job to do the SYNC.

>
> Any news about the cause of your problems?

Yes. The CE caused it. We had a PC failure on the VTS (the LM console). The CE had to replace it. When she did that, she also installed some new microcode because she didn't have access to the level we had been running. That disabled the PC's modem. It also reset the EXPIRE HOLD time from 0 to 33 hours. This last is what I did not know. It is what caused the confusion. I would expire some VTS tapes, but the scratch count would not increase. Well, if I had just waited around for 33 hours, I would have seen the update from the D SMS,LIB(...),DETAIL command. Again, nobody bothered to tell us that the CE did this or what its ramifications were.

>
> Kees.

--
John McKown
Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)

9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john....@healthmarkets.com * www.HealthMarkets.com

Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM

----------------------------------------------------------------------