Results 1 to 2 of 2
  1. #1
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default TSM 6 Conversion Progress / Duration

    Solaris 10

    Does the TSM 6 DB conversion process give a summary of duration without my having to monitor it and time it manually?

  2. #2
    Senior Member
    Join Date
    Dec 2007
    Posts
    330
    Thanks
    1
    Thanked 19 Times in 19 Posts

    Default

    Oh yeah lots of output and timings. Here is example output from AIX but Solaris would be same;


    EXTRACT
    ANR1444W EXTRACTDB: Database upgrade may not be supported for this server
    because it uses backup sets.
    ANR4029I EXTRACTDB: Database checkpoint started.
    ANR4030I EXTRACTDB: Database checkpoint completed.
    ANR0610I EXTRACTDB started by ADMINISTRATOR as process 1.




    ANR8340I FILE volume /tsm2/primary/db/13478208.ost mounted.
    ANR1360I Output volume /tsm2/primary/db/13478208.ost opened (sequence number
    1).
    ANR1392I EXTRACTDB: Extracted 75,412,864 database entries in 2,483,123 pages
    and wrote 4,155,994,572 bytes in 0:05:00 (47556.00 megabytes per hour).
    ANR1392I EXTRACTDB: Extracted 153,841,543 database entries in 5,179,236 pages
    and wrote 10,176,326,401 bytes in 0:10:00 (58224.00 megabytes per hour).
    ANR1392I EXTRACTDB: Extracted 247,712,180 database entries in 7,559,764 pages
    and wrote 17,913,210,998 bytes in 0:15:00 (68332.00 megabytes per hour).
    ANR1392I EXTRACTDB: Extracted 381,939,340 database entries in 9,563,046 pages
    and wrote 28,171,386,672 bytes in 0:20:00 (80598.00 megabytes per hour).
    ANR1392I EXTRACTDB: Extracted 420,739,115 database entries in 11,403,069 pages
    and wrote 36,488,029,548 bytes in 0:25:00 (83512.80 megabytes per hour).
    ANR1392I EXTRACTDB: Extracted 444,966,295 database entries in 13,147,276 pages
    and wrote 44,122,057,773 bytes in 0:30:00 (84156.00 megabytes per hour).
    ANR1392I EXTRACTDB: Extracted 444,966,295 database entries in 13,147,276 pages
    and wrote 44,122,057,773 bytes in 0:30:00 (84156.00 megabytes per hour).
    ANR1392I EXTRACTDB: Extracted 469,976,056 database entries in 14,869,138 pages
    and wrote 51,696,495,675 bytes in 0:35:00 (84516.00 megabytes per hour).
    ANR1392I EXTRACTDB: Extracted 496,347,158 database entries in 16,561,035 pages
    and wrote 59,281,407,886 bytes in 0:40:00 (84802.50 megabytes per hour).
    ANR1361I Output volume /tsm2/primary/db/13478208.ost closed.
    ANR1380I EXTRACTDB: Output stream 1 used volume /tsm2/primary/db/13478208.ost.
    ANR1382I EXTRACTDB: Process 1, database extract, has completed.
    ANR1383I EXTRACTDB: Found 191 database objects.
    ANR1384I EXTRACTDB: Processed 159 database objects.
    ANR1385I EXTRACTDB: Skipped 32 empty database objects.
    ANR1386I EXTRACTDB: Failed to process 0 database objects.
    ANR1387I EXTRACTDB: Processed 508,008,827 database records.
    ANR1388I EXTRACTDB: Read 17,354,810 database pages.
    ANR1389I EXTRACTDB: Wrote 62,790,355,896 bytes.
    ANR1390I EXTRACTDB: Elapsed time was 0:42:20.
    ANR1391I EXTRACTDB: Throughput was 84870.71 megabytes per hour. (DEFRAGED DB)
    ~




    ANR1361I Output volume /tsm2/primary/db/15977961.ost closed.
    ANR1380I EXTRACTDB: Output stream 1 used volume /tsm2/primary/db/15977961.ost.
    ANR1382I EXTRACTDB: Process 1, database extract, has completed.
    ANR1383I EXTRACTDB: Found 191 database objects.
    ANR1384I EXTRACTDB: Processed 159 database objects.
    ANR1385I EXTRACTDB: Skipped 32 empty database objects.
    ANR1386I EXTRACTDB: Failed to process 0 database objects.
    ANR1387I EXTRACTDB: Processed 510,483,749 database records.
    ANR1388I EXTRACTDB: Read 24,210,218 database pages.
    ANR1389I EXTRACTDB: Wrote 63,552,984,191 bytes.
    ANR1390I EXTRACTDB: Elapsed time was 1:16:01.
    ANR1391I EXTRACTDB: Throughput was 47837.93 megabytes per hour. (UNDEFRAGED DB)
    ~


    INSERT;


    nohup /opt/tivoli/tsm/server/bin/dsmserv insertdb
    manifest=./manifest.txt >insert.out 2>&1 &




    Example output;




    ANR7800I DSMSERV generated at 13:23:41 on Aug 5 2009.


    Tivoli Storage Manager for AIX
    Version 6, Release 1, Level 2.0


    Licensed Materials - Property of IBM


    (C) Copyright IBM Corporation 1990, 2009.
    All rights reserved.
    U.S. Government Users Restricted Rights - Use, duplication or disclosure
    restricted by GSA ADP Schedule Contract with IBM Corporation.


    ANR7801I Subsystem process ID is 995330.
    ANR0900I Processing options file /home/tsminst1/tsminst1/dsmserv.opt.
    ANR7811I Using instance directory /home/tsminst1/tsminst1.
    ANR4726I The ICC support module has been loaded.
    ANR0990I Server restart-recovery in progress.
    ANR0152I Database manager successfully started.
    ANR1380I The buffer pool monitor switch is enabled.
    ANR1636W The server machine GUID changed: old value (), new value (00.00.00.01-
    .70.e7.11.de.92.32.08.63.0a.53.11.0c).
    ANR8340I FILE volume /tsm2/primary/db/15977961.ost mounted.
    ANR1363I Input volume /tsm2/primary/db/15977961.ost opened (sequence number 1).ANR1377I Analyst authority has been revoked for a
    dministrator id 54.
    ANR1377I Analyst authority has been revoked for administrator id 107.
    ANR8200I TCP/IP Version 4 driver ready for connection with clients on port
    3500.
    ANR1337I A DBBACKUP trigger has been removed.
    ANR1379I INSERTDB: Read 1,755,173,215 bytes and inserted 13,732,925 database
    entries in 0:05:00 (20076.00 megabytes per hour).
    ANR1379I INSERTDB: Read 3,526,348,414 bytes and inserted 28,442,376 database
    entries in 0:10:00 (20172.00 megabytes per hour).
    ANR1379I INSERTDB: Read 5,252,257,659 bytes and inserted 43,130,734 database
    entries in 0:15:01 (20009.77 megabytes per hour).
    ANR1379I INSERTDB: Read 6,881,814,499 bytes and inserted 57,064,911 database
    entries in 0:20:01 (19672.61 megabytes per hour).






    ANR1379I INSERTDB: Read 8,606,410,480 bytes and inserted 70,402,605 database
    entries in 0:25:01 (19683.68 megabytes per hour).
    ANR1379I INSERTDB: Read 10,246,003,487 bytes and inserted 84,057,112 database
    entries in 0:30:01 (19531.15 megabytes per hour).
    ANR1379I INSERTDB: Read 11,894,366,377 bytes and inserted 97,711,878 database
    entries in 0:35:01 (19435.89 megabytes per hour).
    ANR1379I INSERTDB: Read 13,547,213,643 bytes and inserted 110,773,869 database
    entries in 0:40:01 (19370.43 megabytes per hour).
    ANR1379I INSERTDB: Read 15,217,077,796 bytes and inserted 123,589,349 database
    entries in 0:45:01 (19342.17 megabytes per hour).
    ANR1379I INSERTDB: Read 17,261,258,150 bytes and inserted 136,273,589 database
    entries in 0:50:01 (19746.62 megabytes per hour).
    ANR1379I INSERTDB: Read 18,937,327,781 bytes and inserted 149,529,502 database
    entries in 0:55:01 (19695.85 megabytes per hour).
    ANR1379I INSERTDB: Read 20,559,470,245 bytes and inserted 163,528,694 database
    entries in 1:00:01 (19601.56 megabytes per hour).
    ANR1379I INSERTDB: Read 23,935,257,188 bytes and inserted 189,840,137 database
    entries in 1:10:01 (19560.49 megabytes per hour).
    ANR1379I INSERTDB: Read 27,255,437,512 bytes and inserted 215,659,386 database
    entries in 1:20:01 (19489.94 megabytes per hour).
    ANR1379I INSERTDB: Read 30,958,261,785 bytes and inserted 242,608,854 database
    entries in 1:30:01 (19679.02 megabytes per hour).
    ANR1379I INSERTDB: Read 34,286,714,447 bytes and inserted 269,447,806 database
    entries in 1:40:01 (19615.53 megabytes per hour).
    ANR1379I INSERTDB: Read 37,647,276,122 bytes and inserted 295,895,572 database
    entries in 1:50:01 (19580.49 megabytes per hour).
    ANR1379I INSERTDB: Read 41,060,024,004 bytes and inserted 322,791,358 database
    entries in 2:00:01 (19575.78 megabytes per hour).
    ANR1379I INSERTDB: Read 44,430,948,927 bytes and inserted 349,497,120 database
    entries in 2:10:01 (19553.80 megabytes per hour).
    ANR1379I INSERTDB: Read 47,705,465,939 bytes and inserted 377,131,077 database
    entries in 2:20:01 (19495.54 megabytes per hour).
    ANR1379I INSERTDB: Read 50,951,828,564 bytes and inserted 404,183,335 database




    entries in 2:30:01 (19434.24 megabytes per hour).
    ANR1379I INSERTDB: Read 54,221,297,120 bytes and inserted 430,730,690 database
    entries in 2:40:01 (19388.86 megabytes per hour).
    ANR1379I INSERTDB: Read 57,427,543,075 bytes and inserted 457,719,469 database
    entries in 2:50:01 (19327.63 megabytes per hour).
    ANR1379I INSERTDB: Read 60,674,538,233 bytes and inserted 485,190,479 database
    entries in 3:00:01 (19285.88 megabytes per hour).
    ANR1526I INSERTDB: Building indices and checking table integrity.
    ANR1364I Input volume /tsm2/primary/db/15977961.ost closed.
    ANR1527I INSERTDB: Checked 156 of 159 database objects in 0:10:57.
    ANR1527I INSERTDB: Checked 158 of 159 database objects in 0:30:57.
    ANR1527I INSERTDB: Checked 158 of 159 database objects in 0:50:57.
    ANR1527I INSERTDB: Checked 158 of 159 database objects in 1:10:58.
    ANR1527I INSERTDB: Checked 158 of 159 database objects in 1:30:58.
    ANR1527I INSERTDB: Checked 158 of 159 database objects in 1:50:58.
    ANR1527I INSERTDB: Checked 159 of 159 database objects in 2:05:19.
    ANR0136I Table updating statistics performed successfully for 4 of 4.
    ANR1524I INSERTDB: Beginning database update phase.
    ANR1525I INSERTDB: Updated 729,841 of 166,208,438 database entries in 0:08:05.
    ANR1525I INSERTDB: Updated 729,841 of 166,208,438 database entries in 0:28:05.
    ANR1525I INSERTDB: Updated 729,841 of 166,208,438 database entries in 0:48:05.
    ANR1525I INSERTDB: Updated 729,841 of 166,208,438 database entries in 1:08:05.
    ANR1525I INSERTDB: Updated 729,841 of 166,208,438 database entries in 1:38:05.
    ANR1525I INSERTDB: Updated 729,841 of 166,208,438 database entries in 2:08:05.
    ANR1525I INSERTDB: Updated 166,208,438 of 166,208,438 database entries in
    2:12:24.
    ANR1395I INSERTDB: Process 1, database insert, has completed.
    ANR1397I INSERTDB: Found 159 database objects.
    ANR1398I INSERTDB: Processed 159 database objects.
    ANR1399I INSERTDB: Failed to process 0 database objects.
    ANR1517I INSERTDB: Processed 510,483,749 database records.
    ANR1518I INSERTDB: Read 63,552,984,339 bytes.
    ANR1519I INSERTDB: Elapsed time was 8:04:22.
    ANR1445I INSERTDB: Throughput was 7507.70 megabytes per hour.
    ANR1446I RUNSTATS: Table updating statistics started.
    ANR0136I Table updating statistics performed successfully for 116 of 116.
    ANR1528I RUNSTATS: Table updating statistics completed in 0:17:15.
    ANR0369I Stopping the database manager because of a server shutdown.

  3. The Following User Says Thank You to tsm_dude For This Useful Post:

    GregE  (05-28-2013)

Similar Threads

  1. TSM Server AIX to Windows Conversion
    By BAdams in forum TSM Server
    Replies: 1
    Last Post: 10-26-2010, 02:18 PM
  2. Get backup duration from TSM 6.1
    By scottgassTSM in forum Scripting
    Replies: 0
    Last Post: 05-13-2010, 04:11 PM
  3. TSM 5.4 Database Conversion - Part 2
    By gmoores11 in forum TSM Server
    Replies: 1
    Last Post: 05-08-2008, 10:08 AM
  4. TSM v5.4 Database Conversion
    By gmoores11 in forum TSM Server
    Replies: 5
    Last Post: 05-05-2008, 02:46 PM
  5. AIX Kernel bit conversion on TSM Server
    By unixgeek in forum TSM Server
    Replies: 4
    Last Post: 03-29-2007, 05:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •