Re: question on select for migration statistics / summary table ?

Rainer,

>From IBM web site :

************************************************************************
*********************

IC47709: START DATE NOT INITIALIZED FOR DISK POOL MIGRATION. 

APAR status
OPEN 

Error description 
The startdate is not correctly initialized for
disk pool migration. This value then is assigned to the
startdate
in the Activity.Summary table.
"select start_time, end_time, activity from Summary" output will
look like:
                START_TIME                   END_TIME ACTIVITY
-------------------------- -------------------------- ---------
1900-01-01 00:00:00.000000 2005-10-12 01:41:13.000000 MIGRATION
The problem has been observed after applying 5.3.1.5 or 5.3.2.0
server level.
Local fix 
apply fixing PTF once available.
Problem summary 
Problem conclusion 
Temporary fix 
Comments 
APAR information 
APAR number IC47709 
Reported component name TSM SERVER 510 
Reported component ID 5698ISMSV 
Reported release 53A 
Status OPEN  
PE NoPE 
HIPER NoHIPER 
Submitted date 2005-10-24 
Closed date  
Last modified date 2005-11-10 

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros


Fix information 

Applicable component levels 
************************************************************************
*******************
 
Looks like we'll have to wait some time before getting a patch ...
I'm very frustrated from this too ! (needless to say that extracting
equivalent information from the activity log thru the use of SQL would
be a nightmare, but its IBM advice ...)
Hope this helped !
Cheers.

Arnaud 

************************************************************************
******
Panalpina Management Ltd., Basle, Switzerland, 
CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: arnaud.brion AT panalpina DOT com
************************************************************************
******

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Rainer Wolf
Sent: Tuesday, 07 February, 2006 15:24
To: ADSM-L AT VM.MARIST DOT EDU
Subject: question on select for migration statistics / summary table ?

Hello all,
we currently have tsm server 5.3.2.1 on solaris and i have difficulties
with the following select:

 select start_time, end_time,start_time-end_time as - "Elapsed Time"
,entity,processes, bytes,((cast(bytes as decimal(18,0)) / cast((end_time
-start_time)seconds as decimal(18,0))))/1024
-
"KB/second" from summary where activity='MIGRATION' and
cast((current_timestamp-end_time)minutes as decimal) >0 - and
cast((current_timestamp-start_time)hours as decimal) <168  and
cast((end_time -start_time)seconds as decimal) >0

It should give back the throughput values in kB/s on migration processes
- all migration processes of the last
7 days should be listed. The purpose is to keep an eye on the
migration-performance - knowing that the time of the whole process
including mount(wait)-times is used.

It formerly went fine but I think since one tsm-update ( 5.3.2 ? ) I got
no output anymore although migration happens.
The output is only :
        ANR2034E SELECT: No match found using this criteria.
        ANS8001I Return code 11.

The same sql-query still runs fine for 'RECLAMAION' processes instead
'MIGRATION'.

Can anyone help - I am not very firm with select It looks like the
start_time for Migrations is somewhow cummulativ in the summary table ?
Can I take some other select to get the migration performance ( in kB/s
) on the whole migration process ? Maybe not from the summary ?

Thanks in advance for any help !
Rainer



tsm: TSM1>select * from summary where activity='MIGRATION'

...

      START_TIME: 1900-01-01 00:00:00.000000
        END_TIME: 2006-02-07 07:38:57.000000
        ACTIVITY: MIGRATION
          NUMBER: 393
          ENTITY: BACKUPPOOL2
        COMMMETH:
         ADDRESS:
   SCHEDULE_NAME:
        EXAMINED: 4114238
        AFFECTED: 4114238
          FAILED: 0
           BYTES: 836764217344
            IDLE: 0
          MEDIAW: 1106
       PROCESSES: 14
      SUCCESSFUL: YES
     VOLUME_NAME:
      DRIVE_NAME:
    LIBRARY_NAME:
        LAST_USE:
       COMM_WAIT: 0
NUM_OFFSITE_VOLS:


tsm: TSM1>

For the migration-Processes the start-time looks 'normal' like

tsm: TSM1>select * from summary where activity='RECLAMATION'

...

      START_TIME: 2006-02-05 11:40:52.000000
        END_TIME: 2006-02-05 16:03:43.000000
        ACTIVITY: RECLAMATION
          NUMBER: 346
          ENTITY: DA-COPY-VBA
        COMMMETH:
         ADDRESS:
   SCHEDULE_NAME:
        EXAMINED: 203830
        AFFECTED: 203830
          FAILED: 1
           BYTES: 52093334736
            IDLE: 0
          MEDIAW: 1055
       PROCESSES: 1
      SUCCESSFUL: NO
     VOLUME_NAME:
      DRIVE_NAME:
    LIBRARY_NAME:
        LAST_USE:
       COMM_WAIT:
NUM_OFFSITE_VOLS: 68