Date:         Mon, 25 Jul 2011 13:34:53 -0400
Reply-To:     "Teed, Lionel" <Lionel.Teed@TD.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Teed, Lionel" <Lionel.Teed@TD.COM>
Subject:      Re: size of db2 database on mainframe
In-Reply-To:  <CADb28==YGsuKhsb4T5-NMpD6+PW=sj669VFewu8vPwb1Y8HYBw@mail.gmail.com>
content-type: text/plain; charset="ISO-8859-1"

Hello Pradeep.

Do you know how you are accessing your DB2 database on the mainframe? Is it via SAS Access, and then via a defined view, or simply a SQL passthrough?
It has been a while since I ahd to peek and poke at a DB2 file on the Big Iron, and my skills are a touch wrinkly on this, so I cannot immediatley answer, but I believe that part of the answer will lie in how you are retrieing the data.






Lionel Teed | Senior Manager, TD Waterhouse Financial Planning | T: 416.982.6763 | C: 647.965.9237


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Pradeep
Sent: Monday, July 25, 2011 11:49 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: size of db2 database on mainframe

Hi All,

I need to determine size of db2 database on mainframe. I tried to query on mainframe as well as using PC SAS with dictionary tables and get the file size but it would return me just zero for some reason.
Mainframes doesnot show values for some fields like nvar, filesize etc.

Can anyone help me out with this problem? Is there something that can be done using command prompt like ISPF etc?



cheers,
P

NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to www.td.com/legal for instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière d'aller au www.td.com/francais/avis_juridique pour des instructions.