1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

TSM 6 Conversion Progress / Duration

Discussion in 'TSM Server' started by GregE, May 22, 2013.

  1. GregE

    GregE Senior Member

    Joined:
    May 12, 2006
    Messages:
    2,100
    Likes Received:
    31
    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.  
  3. tsm_dude

    tsm_dude Senior Member

    Joined:
    Dec 12, 2007
    Messages:
    329
    Likes Received:
    20
    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.
     
    GregE likes this.

Share This Page