ADSM-L

Re: MVS-Server/SQL table volumeusage wrong contents

1998-06-10 10:31:39
Subject: Re: MVS-Server/SQL table volumeusage wrong contents
From: Michael Hartmann <Michael_Hartmann AT TRINKAUS DOT DE>
Date: Wed, 10 Jun 1998 15:31:39 +0100
Hello,

Heinz Flemming told me that tere is an APAR for the
select * from volumeusage problem, but no PTF.
See APAR below.

Thank you for your very fast response
__________________________________________
Michael Hartmann
System development
Bankhaus Trinkaus & Burkhardt
Koenigsallee 21-23   40212 Duesseldorf     Germany
Phone: ++49+211 910 2364
E-Mail: michael_hartmann AT trinkaus DOT de
__________________________________________
  APAR NUMBER: IX76472            RESOLVED AS: PROGRAM ERROR
  ABSTRACT:
  IX76472: <SELECT> * FROM <VOLUMEUSAGE> DOES NOT LIST ALL VOLUMES
  WHICH CONTAIN DATA.
  ORIGINATING DETAILS:
  '<select> * from <volumeusage>' only gives the first filespace by
  ascii alphabeticle order (EBCDIC for MVS ??) for each node.
  RESPONDER SUMMARY:
  ****************************************************************
  * USERS AFFECTED:                                              *
  all ADSM server users
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  entries are missing from '<select> * from <volumeusage>' output
  ****************************************************************
  * RECOMMENDATION:                                              *
  apply fixing ptf when available
  ****************************************************************
  Multiple nodes had data in multiple filespaces, which was
  backed up and archived on multiple volumes.  '<select> *
  from <volumeusage>' displayed info for the first filespace
  only.
  RESPONDER CONCLUSION:
  Modifications were made to the logic that builds the <VOLUMEUSAGE>
  SQL table.


Mit freundlichen Gruessen
Heinz Flemming
-----------------------------------------------------------------------
Heinz Flemming                             flemming AT rz.uni-karlsruhe DOT de
Heinz Flemming                             flemming AT rz.uni-karlsruhe DOT de
Computing Center, University of Karlsruhe
Zirkel 2, P.O.Box 6980
D-76128 Karlsruhe
Germany
phone 0721 - 608 6427                                  fax 0721 - 37550
-----------------------------------------------------------------------
___________________________________________________________________________
___________________________________________________________________________
                                         _____
 Der Austausch von Nachrichten mit Trinkaus & Burkhardt via E-Mail dient
ausschliesslich Informationszwecken. Rechtsgeschaeftliche Erklaerungen
duerfen ueber dieses Medium nicht ausgetauscht werden.

Correspondence with Trinkaus & Burkhardt via e-mail is only for information
purposes. This medium is not to be used for the exchange of legally-binding
communications.
<Prev in Thread] Current Thread [Next in Thread>