Re: Web Admin Interface

Lisa,

Our DB is 22 GB of actual data.

I have an Excel spreadsheet with about 25 worksheets in it. Each worksheet is a particular table in the TSM database like "volumes" or "occupancy". Therefore, each query grabs just that one table.

On our 2-CPU F50, a query of all volumes in the system normally takes about 3-5 seconds. If the system is real busy it might take as long as 30 seconds but so what?

The one thing I DON'T do is query the backup or archive tables because of their size. Excel (we're using '97') holds 64K rows and there are a LOT more rows in those tables.

We had to stop using the old 3.1 GUI because it sometimes returned errors on normal operations.

Thanks.

Tab

Lisa Cabanas <cabanl AT MODOT DOT NET>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

08/13/2002 07:00 AM
Please respond to "ADSM: Dist Stor Manager"

To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: Re: Web Admin Interface - grrr

Tab,

how big is your db? I have tried to do this in the past, and the amount of
time it took to get the link to "fill" the spreadsheet (or Access db, for
that matter) was WAY too long. My db at that time was about 50,000 MB.

-lisa

(p.s.-- I still use the old GUI too!! We all asked these same questions
when the interface was removed, and we never heard back from the listening
developers (that I remember) that addressed why it went away, and why it
would not be resurrected. I say we should submit a SHARE requirement to
bring it back!!)

Tab Trepagnier
<Tab. To: ADSM-L AT VM.MARIST DOT EDU
Trepagnier@LAITRA cc:
M.COM> Subject: Re: Web Admin Interface - grrr
Sent by: "ADSM:
Dist Stor
Manager" <ADSM-
L AT VM.MARIST DOT EDU>

08/12/2002 07:48
PM
Please respond to
"ADSM: Dist Stor
Manager"

Wanda,

Yeah, the Web Admin client is pretty lame.

That's why I use Excel and an ODBC link to the database. It's read only,
but I have full filtering, searching, sorting, etc. of Excel to work with
what comes back from the queries.

I have a spreadsheet called GUI_ODBC and it includes the embedded Microsoft
Query queries. I just select the page of info I'm interested in (like
"volumes") and click the Refresh icon. In about three seconds I have a new
list of volumes with all fields displayed.

If I have to do something with a particular volume, I usually resort to the
command line.

Tab Trepagnier
TSM Administrator
Laitram Corporation

"Prather, Wanda"
<Wanda.Prather@J To: ADSM-L AT VM.MARIST DOT EDU
HUAPL.EDU> cc:
Sent by: "ADSM: Subject: Re: Web Admin
Interface - grrr
Dist Stor
Manager"
<[email protected]
T.EDU>

08/12/2002 11:53
AM
Please respond
to "ADSM: Dist
Stor Manager"

I STILL run the old 3.1 GUI.
The bigger your TSM gets (We are at 550 clients on the largest server),
the more impossible it becomes to use the web admin
because of the lack of filtering and sorting capability.
************************************************************************
Wanda Prather
The Johns Hopkins Applied Physics Lab
443-778-8769
wanda_prather AT jhuapl DOT edu

"Intelligence has much less practical application than you'd think" -
Scott Adams/Dilbert
************************************************************************

-----Original Message-----
From: Rupp Thomas (Illwerke) [mailto:thomas.rupp AT ILLWERKE DOT AT]
Sent: Monday, August 12, 2002 12:45 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Web Admin Interface - grrr

Hi TSM-ers,

Our Network Storage Manager (NSM - 3466) was just upgraded from 4.2.1 to
4.2.2.8.
Now the format of the QUERY SESSION from the lefthand tree OBJECT VIEW /
SERVER /
SESSION has changed from FORMAT=STANDARD to FORMAT=DETAILED.

Instead of one line per session I get now 12 lines. That makes it
impossible
to see what's
going on (§$%&?)

How can we convince Tivoli to create a useful administration interface (be
it GUI or a Java Applet).
Am I the only one who has problems with the admin interface and still
running the old
3.1 Windows GUI?

Kind regards
Thomas Rupp
Vorarlberger Illwerke AG
MAIL: thomas.rupp AT illwerke DOT at
TEL: ++43/5574/4991-251
FAX: ++43/5574/4991-820-8251

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

--------------
Dieses eMail wurde auf Viren geprueft.

Vorarlberger Illwerke AG
----------------------------------------------------------------------------

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