Re: [ADSM-L] V6.1.2.0 server has arrived

Note to development - thanks for putting the updated 6.1.2.0 ITM Reporting
function in the maintenance directory of the ftp site. This way many more
people can start experimenting with the Tivoli Common Reporting function.

I have just upgraded my Windows TSM server to 6.1.2.0 - very successful,
clean upgrade. A bunch of the schema changes took place which I interpret
to be an equivalent of UPGRADEDB. I also re-installed scripts.smp. I have
some questions about the tables in TSM 6.1.2.0 . The Q_TABLES script now
produced nice, concise output.  If I compare the Q_TABLES script output
from v5 to v6, the following tables do not show up in the v6 output:

AUDITOCC
CLIENTOPTS
CLOPTSETS
COLLOCGROUP
DATAMOVERS
DOMAINS
DRMEDIA
DRMMACHINE
DRMMACHINECHARS
DRMMACHINENODE
DRMMACHINERECINST
DRMMACHINERECMEDIA
DRMRECOVERYMEDIA
DRMSRPF
DRMSTANZA
DRMTRPF
LICENSE_DETAILS
LOG
MGMTCLASSES
PATHS
PROCESSES
PROFILES
RECLAIM_ANALYSIS
RESTORES
SCRIPT_NAMES
SHREDSTATUS
STATUS
STGSPACETRIGGER
SUBSCRIPTIONS
VFSMAPPINGS

SUMMARY  seems to have become ACTIVITY_SUMMARY
SERVER_GROUP has become SERVERGROUP

Even though these tables in the list don't show up in the output of run
Q_TABLES, they seem to exist. For example, select * from drmedia works
fine. Since I operate TSM environments, I am particularly interested in the
DRMEDIA table to get a quick summary status of DR tapes, so a long time ago
I created a script called drmstate which contains

select state, count(*) as TAPES from drmedia group by state
select state, volume_name, voltype from drmedia order by state, volume_name

Both select statements fail on v6:

tsm: VISTA1>ru drmstate5
ANR2944E The reference 'SELECT' is an unknown SQL scalar function name.

         |
         V..............................................................
         select state , count ( * ) as TAPES from drmedia group by state

ANR2944E The reference 'ORDER' is an unknown SQL scalar function name.

                                                           |
         ..................................................V............
         select state , volume_name , voltype from drmedia order by stat

ANR1463E RUN: Command script DRMSTATE5 completed in error.
ANS8001I Return code 3.

I ended up having to use where clauses:

tsm: VISTA1>q scr drmstate f=r
select count(*) as vaultretrieve from drmedia where state='VAULTRETRIEVE'
select count(*) as mountable from drmedia where state='MOUNTABLE'
select count(*) as vault from drmedia where state='VAULT'
select count(*) as courier from drmedia where state='COURIER'
select count(*) as courierretrieve from drmedia where
state='COURIERRETRIEVE
select state,volume_name,voltype from drmedia where state='VAULTRETRIEVE'
select state,volume_name,voltype from drmedia where state='MOUNTABLE'
select state,volume_name,voltype from drmedia where state='VAULT'
select state,volume_name,voltype from drmedia where state='COURIER'
select state,volume_name,voltype from drmedia where state='COURIERRETRIEVE'

If anyone has any ideas on how to make this new level of functionality a
bit more elegant, I would appreciate hearing about it.

Thanks.

Joerg Pohlmann
250-245-9863


"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2009-08-12
09:09:08:

> Hi All,
>
>      The README's for server fix-pack 6.1.2.0 are delayed by a few
days...
> We expect they will be available on Friday 8/14.
>
> Thanks,
> Colin
>
> -----------------------------------------------------
> Colin Dawson
> TSM Server Development
> colind AT us.ibm DOT com
>
>
>
>   From:       Zoltan Forray/AC/VCU <zforray AT VCU DOT EDU>
>
>   To:         ADSM-L AT VM.MARIST DOT EDU
>
>   Date:       08/12/2009 06:48 AM
>
>   Subject:    Re: [ADSM-L] V6.1.2.0 server has arrived
>
>   Sent by:    "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
>
>
>
>
>
> Yeah, some readme's would be nice. I guess they will get around to
posting
> the page, soon.
>
> I just installed it and the README.html file that appears points to pages
> that don't exist.
>
>
>
> From:
> Timothy Hughes <Timothy.Hughes AT OIT.STATE.NJ DOT US>
> To:
> ADSM-L AT VM.MARIST DOT EDU
> Date:
> 08/12/2009 07:53 AM
> Subject:
> Re: [ADSM-L] V6.1.2.0 server has arrived
> Sent by:
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
>
>
> Are Backup Sets enabled? I can't find any readme information
>
> regards
>
> Zoltan Forray/AC/VCU wrote:
>
> >In case folks haven't noticed...................
> >
> >Look under the "Maintenance" folder on the FTP site
> >service.boulder.ibm.com,  i.e.
> >/storage/tivoli-storage-management/maintenance/server/v6r1/Linux/6.1.2.0
> >
> >Here's hoping we can finally start to use V6.1 as a production server.
> >
> >